Over three years ago I asked if the official CLI tools could be compiled as a
64-bit exe.
http://sqlite.1065341.n5.nabble.com/64-bit-SQLite3-exe-tp90771.html
I thought I would ask again...
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite
]
> On Behalf Of Michael Gratton
> Sent: Wednesday, August 17, 2016 8:05 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] 64-bit SQLite3.exe
>
>
> Richard,
>
> On Thu, Aug 18, 2016 at 2:23 AM, Rousselot, Richard A <
> richard.a.rousse...@centurylink.com> wrote:
&
: Wednesday, August 17, 2016 8:05 PM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
Richard,
On Thu, Aug 18, 2016 at 2:23 AM, Rousselot, Richard A
wrote:
> I was only interested in doing these calculations quickly; that is my
> real-world. The SQL scripts I am using were
Richard,
On Thu, Aug 18, 2016 at 2:23 AM, Rousselot, Richard A
wrote:
I was only interested in doing these calculations quickly; that is my
real-world. The SQL scripts I am using were built with multiple
steps with intermediate temp tables that are used to create a final
result table.
I
-bit vs 64-bit.
Richard
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Wednesday, August 17, 2016 11:09 AM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
On 17 Aug 2016, at 4:54pm, Rousselot
On 17 Aug 2016, at 4:54pm, Rousselot, Richard A
wrote:
>PRAGMA journal_mode = Off;
This configuration is designed for cases where the resulting database will be
thrown away soon (e.g. when the application quits). It does increase speed
greatly, but a consequence is that the benchmar
16 12:20 PM
To: sqlite-users@mailinglists.sqlite.org
Cc: Rousselot, Richard A
Subject: Re: [sqlite] 64-bit SQLite3.exe
Speed improvements based on 64-bit Visual Studio build.
SQLite 3.14.0, built with MSVC 18.00.30723 for x64.
Built with VS options /O2 /Ot /Ox.
Built with SQLITE optio
Correction on description:
Test 2: 32-bit 3.13 (sqlite.org), with PRAGMA but not temp_store = 2;
-Original Message-
From: Rousselot, Richard A
Sent: Monday, August 15, 2016 12:20 PM
To: sqlite-users@mailinglists.sqlite.org
Cc: Rousselot, Richard A
Subject: Re: [sqlite] 64-bit SQLite3.exe
Speed improvements based on 64-bit Visual Studio build.
SQLite 3.14.0, built with MSVC 18.00.30723 for x64.
Built with VS options /O2 /Ot /Ox.
Built with SQLITE options of SQLITE_ENABLE_FTS3 SQLITE_ENABLE_STAT2
SQLITE_ENABLE_RTREE.
Module SQL Script (146k records)T1 Sec T2 Sec T3 Sec
gt; Sent: Saturday, August 13, 2016 12:17 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] 64-bit SQLite3.exe
>
> On Sat, Aug 13, 2016 at 8:39 AM, Rousselot, Richard A
> wrote:
>> Thanks, this does allow the library to load and process. The thing is your
>> build is by
If you use cygwin (which noone ever should) make sure you to specify
-mno-cygwin or any output is significantly slower than any other build.
(oh, I see that was deprecated several years ago, apparently now you just
get the slow code automatically in static format.)
(for instance one cause of slow
Your link says I do not have permission to open.
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Random Coder
Sent: Saturday, August 13, 2016 12:17 PM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
On Sat, Aug 13
On Sat, Aug 13, 2016 at 8:39 AM, Rousselot, Richard A
wrote:
> Thanks, this does allow the library to load and process. The thing is your
> build is by far the slowest I have received, slower even than the 32-bit
> version.
Sorry about that, it was a debug build.
https://new-bucket-2a9cf983.s
2016 9:30 am
Subject: Re: [sqlite] 64-bit SQLite3.exe
Additionally, I and others have got the Cygwin64 compiler to build 64-bit on
both SQLite3 and the math extensions. Not optional since, as far as I know I
need to install Cygwin64 on each machine that I will have running this process.
But one t
, Richard A
Sent: Saturday, August 13, 2016 10:40 AM
To: SQLite mailing list
Cc: Rousselot, Richard A
Subject: RE: [sqlite] 64-bit SQLite3.exe
Thanks, this does allow the library to load and process. The thing is your
build is by far the slowest I have received, slower even than the 32-bit
version
: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A
wrote:
> I, and others, have tried to compile this as a 64-bit library but it will not
> load from the command line (using .load) and gives the "Error: The specifie
On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A
wrote:
> I, and others, have tried to compile this as a 64-bit library but it will not
> load from the command line (using .load) and gives the "Error: The specified
> module could not be found."
>
> Anyone have tips on how to resolve this?
On Fri, Aug 12, 2016 at 12:02 PM, Warren Young wrote:
> On Aug 11, 2016, at 7:50 PM, Scott Robison
> wrote:
> >
> >> It’d be a lot of work just to avoid rebuilding for 64-bit, but maybe it
> >> would be an interesting project for someone. Like a master’s university
> >> project, maybe.
> >>
> >
On Aug 11, 2016, at 7:50 PM, Scott Robison wrote:
>
>> It’d be a lot of work just to avoid rebuilding for 64-bit, but maybe it
>> would be an interesting project for someone. Like a master’s university
>> project, maybe.
>>
>
> At first I thought to myself that a custom memory allocator for SQ
Update to my 64-bit saga.
I was able to work with some helpful mailing list members to create a 64-bit
SQLite3.exe. Far as I can tell it works fine but unfortunately I also use the
math extension library (extensions-functions.c) in my CTE queries which is also
32-bit.
I, and others, have trie
On Thu, Aug 11, 2016 at 6:37 PM, Warren Young wrote:
> On Aug 11, 2016, at 3:19 PM, Scott Robison
> wrote:
> >
> > I think you guys are just talking past each other.
>
> Well, at least one of us isn’t communicating clearly, that’s certain. I
> just don’t yet know if it’s me, him, or both of us.
some kind of overloaded information
store.
SQLite is 32-bit clean.
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Warren Young
> Sent: Thursday, 11 August, 2016 14:38
> To: SQLite mailing list
> Subject:
On Aug 11, 2016, at 3:19 PM, Scott Robison wrote:
>
> I think you guys are just talking past each other.
Well, at least one of us isn’t communicating clearly, that’s certain. I just
don’t yet know if it’s me, him, or both of us. :)
> Windows versions that
> support PAE have the Address Window
On Thu, Aug 11, 2016 at 2:37 PM, Warren Young wrote:
> On Aug 10, 2016, at 6:32 PM, Keith Medcalf wrote:
> >> You must be talking about PAE, which is an unmitigated hack, in the
> >> dirtiest sense of that word
> >
> > It is not a hack. It is how things work. I do not see where you get
> the i
On Aug 10, 2016, at 6:32 PM, Keith Medcalf wrote:
>> You must be talking about PAE, which is an unmitigated hack, in the
>> dirtiest sense of that word
>
> It is not a hack. It is how things work. I do not see where you get the
> idea that it is a hack.
Because I know how PAE works, and I hav
Thanks Ryan,
and apologies for singling your comment out from the many that suggested a
roll-your-own CLI. That last statement pretty much says it all IMHO but I
would go even further. For many it will not even be choice in future times.
There will always be those who can make their own arrangemen
On 2016/08/10 11:35 PM, Michael Falconer wrote:
...// Ryan is very
right about the relative ease of such exercises but IMHO wrong that it
suits all, or even most cases.
Just to be clear - if my post wasn't, I never advocated against the
64-bit CLI or that making it suits all, I very much supp
> On Aug 10, 2016, at 6:03 AM, Keith Medcalf wrote:
> >> Even on a 64-bit processor, there’s usually no reason to run 64-bit
> >> Windows unless you have more than 4 GB of RAM, a threshold we didn’t
> >> pass very long ago.
> > Yes, please remember to keep the "addressable memory limits" linkag
On Wed, Aug 10, 2016 at 4:35 PM, Michael Falconer <
michael.j.falco...@gmail.com> wrote:
> Great discussion, if somewhat amusing (with a hint of deja vu) for an old
> hack like myself.
>
> I remember discussions like this back in CP/M days when it was a move rom 8
> to 16bit. Oh, and it all happen
Great discussion, if somewhat amusing (with a hint of deja vu) for an old
hack like myself.
I remember discussions like this back in CP/M days when it was a move rom 8
to 16bit. Oh, and it all happened again when 32bit came along and yes now
we are into 64bit and it carries on.
Simple really, the
The issue is not simply recompiling the CLI for 64-bit; I assume you want
the tested reliability of SQLite.
"The [SQLite] project has 787 times as much test code and test scripts" as
it does source code for the executable.
https://www.sqlite.org/testing.html
Running the exact same tests would no
rease.
Regards
Andy
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Rousselot, Richard A
Sent: Wed 10 August 2016 15:43
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
First of all thanks for the discussion. Sp
w things
every day watching you guys and for that I thank you.
Richard
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Keith Medcalf
Sent: Wednesday, August 10, 2016 7:03 AM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLit
On Aug 10, 2016, at 6:03 AM, Keith Medcalf wrote:
>
>> Even on a 64-bit processor, there’s usually no reason to run 64-bit
>> Windows unless you have more than 4 GB of RAM, a threshold we didn’t pass
>> very long ago.
>
> Yes, please remember to keep the "addressable memory limits" linkage to
>
> Even on a 64-bit processor, there’s usually no reason to run 64-bit
> Windows unless you have more than 4 GB of RAM, a threshold we didn’t pass
> very long ago.
Yes, please remember to keep the "addressable memory limits" linkage to
"processor bitted-ness" is a Microsoft Only phenomenon. You
On Wed, Aug 10, 2016 at 11:47 AM, Warren Young wrote:
> On Aug 10, 2016, at 3:22 AM, J Decker wrote:
> > I'd think many of you would know 64 bit
> > mode has more general purpose registers to carry values and the default
> > calling ABI is improved to be more of a register centric model.
>
> SQL
> I agree, but now you're talking getting the amalgamation/repo and stuff (also
> not exceedingly difficult, but granted will take a lot longer), he was
> however not claiming having difficulty with that, the difficulty was only the
> "learning how to make a build script" and that (in SQLite's
On 2016/08/10 12:01 PM, Dominique Devienne wrote:
On Wed, Aug 10, 2016 at 11:52 AM, R Smith wrote:
I disagree on the second point though - it isn't false. Have you set up a
script for building SQLite yet? It really is that easy.
A non-developer downloading 100's of MBs of compiler/IDE and
On Wed, Aug 10, 2016 at 11:52 AM, R Smith wrote:
> I disagree on the second point though - it isn't false. Have you set up a
> script for building SQLite yet? It really is that easy.
>
A non-developer downloading 100's of MBs of compiler/IDE and trying to
figure it out for the very first time,
t
On 2016/08/10 11:38 AM, Dominique Devienne wrote:
On Wed, Aug 10, 2016 at 11:11 AM, R Smith wrote:
On 2016/08/10 7:39 AM, Rousselot, Richard A wrote:
I like learning as much as the next guy but I prefer to spend my time on
skills I can use in the future; compiling a 64-bit binary is not a us
On Aug 10, 2016, at 3:22 AM, J Decker wrote:
>
> I'd think many of you would know 64 bit
> mode has more general purpose registers to carry values and the default
> calling ABI is improved to be more of a register centric model.
SQLite is largely I/O bound.
_
On Wed, Aug 10, 2016 at 11:11 AM, R Smith wrote:
>
> On 2016/08/10 7:39 AM, Rousselot, Richard A wrote:
>>
>> I like learning as much as the next guy but I prefer to spend my time on
>> skills I can use in the future; compiling a 64-bit binary is not a useful
>> skill.//...
>>
>
> You spend severa
I'm actually kind of surprised more people aren't like 'ya, why isn't 64
bit just available?' ( *pounds on tables* "We Want 64 Bit!", no? )
being fairly low level developers I'd think many of you would know 64 bit
mode has more general purpose registers to carry values and the default
calling ABI i
On 2016/08/10 7:39 AM, Rousselot, Richard A wrote:
I like learning as much as the next guy but I prefer to spend my time on skills
I can use in the future; compiling a 64-bit binary is not a useful skill.//...
You spend several posts and a multitude of lines explaining how useful a
64-bit S
> On 10/08/2016, at 5:50 PM, Rousselot, Richard A
> wrote:
>
> I guess it is a matter of support. Can the people using unpatched,
> unsupported 32-bit windows instances just live with SQLite 3.13 (or whatever
> the cutover version)? Are these 32-bit windows users really actively
> updating
On Tue, Aug 9, 2016 at 10:08 PM, David Empson wrote:
>
> > On 10/08/2016, at 3:30 PM, Rousselot, Richard A centurylink.com> wrote:
> >
> > As I said, I am not a software engineer. I could spend a few hours
> figuring this out and be fine but it will be painful for me.
> >
> > I see no downsides
On Tue, Aug 9, 2016 at 4:31 PM, Rousselot, Richard A <
richard.a.rousse...@centurylink.com> wrote:
> I would like to request a SQLite official 64-bit SQLite3.exe CLI (not DLL)
> be created.
>
+1. You make a good point, and researched the issue. --DD
PS: Not sure why some want everyone to turn in
On Aug 9, 2016, at 11:39 PM, Rousselot, Richard A
wrote:
> compiling a 64-bit binary is not a useful skill
It keeps me fed pretty well. :)
> Your 32-bit Mac is not windows machine
What, you think Intel only made Core Solos for Apple?
> How long do I have to wait for everyone to upgrade? So,
, August 10, 2016 12:09 AM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
> On 10/08/2016, at 3:30 PM, Rousselot, Richard A
> wrote:
>
> As I said, I am not a software engineer. I could spend a few hours figuring
> this out and be fine but it will be painful fo
>On Aug 9, 2016, at 9:30 PM, Rousselot, Richard A
> wrote:
>
>> I could spend a few hours figuring this out and be fine but it will be
>> painful for me.
>
>Or you can spend many hours waiting for someone to build it for you. How many
>hours are you willing to wait to save yourself some pain?
> On 10/08/2016, at 3:30 PM, Rousselot, Richard A
> wrote:
>
> As I said, I am not a software engineer. I could spend a few hours figuring
> this out and be fine but it will be painful for me.
>
> I see no downsides in a 64-bit CLI. The last 32-bit Intel CPU was the PIII
> in 2004, no supp
On Aug 9, 2016, at 9:30 PM, Rousselot, Richard A
wrote:
>
> I could spend a few hours figuring this out and be fine but it will be
> painful for me.
Or you can spend many hours waiting for someone to build it for you. How many
hours are you willing to wait to save yourself some pain? (And s
om: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Donald Shepherd
Sent: Tuesday, August 09, 2016 9:28 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] 64-bit SQLite3.exe
Why don't you build it yourself as a 64 bit executable?
On Wed, 10 Au
Why don't you build it yourself as a 64 bit executable?
On Wed, 10 Aug 2016 at 00:31 Rousselot, Richard A <
richard.a.rousse...@centurylink.com> wrote:
> I would like to request a SQLite official 64-bit SQLite3.exe CLI (not DLL)
> be created.
>
> I have reviewed the prior discussions regarding 64
I would like to request a SQLite official 64-bit SQLite3.exe CLI (not DLL) be
created.
I have reviewed the prior discussions regarding 64-bit SQLite3 and the
reasoning for which why creating a 64-bit version is denied are "it does not
make a real difference", "you can just use ram disks", etc.,
55 matches
Mail list logo
