[sqlite] 64-bit SQLite3.exe (2019)

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/ ___

Re: [sqlite] 64-bit SQLite3.exe

] > 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: &

Re: [sqlite] 64-bit SQLite3.exe

: 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: > I was only interested in doing these calculations quickly; that is my >

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 built with multiple steps with intermediate temp tables that are used

Re: [sqlite] 64-bit SQLite3.exe

-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

Re: [sqlite] 64-bit SQLite3.exe

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,

Re: [sqlite] 64-bit SQLite3.exe

: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

Re: [sqlite] 64-bit SQLite3.exe

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

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

Re: [sqlite] 64-bit SQLite3.exe

.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, 2016 at 8:39 AM, Rousselot, Richard A > <richard.a.rousse...@centurylink.com> wrote: >> Than

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

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 far the slowest I have received, slower even than the 32-bit > version. Sorry about that, it was a debug

Re: [sqlite] 64-bit SQLite3.exe

t; To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Sent: Sat, Aug 13, 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

Re: [sqlite] 64-bit SQLite3.exe

, 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

Re: [sqlite] 64-bit SQLite3.exe

To: SQLite mailing list Subject: Re: [sqlite] 64-bit SQLite3.exe On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A <richard.a.rousse...@centurylink.com> wrote: > I, and others, have tried to compile this as a 64-bit library but it will not > load from the command line (using .loa

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 specified > module could not be found." > >

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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:

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

> 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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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,

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

. 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. Special

Re: [sqlite] 64-bit SQLite3.exe

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 SQLite3.exe > E

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

> 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.

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

> 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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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.

Re: [sqlite] 64-bit SQLite3.exe

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.//... >>

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

> 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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

, 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 > <richard.a.rousse...@centurylink.com> wrote: > > As I said, I am not a software engineer. I could spend a few hours figuring >

Re: [sqlite] 64-bit SQLite3.exe

>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

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 for me. > > I see no downsides in a 64-bit CLI. The last 32-bit

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] 64-bit SQLite3.exe

-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 Aug 2016 at 00:31

Re: [sqlite] 64-bit SQLite3.exe

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

[sqlite] 64-bit SQLite3.exe

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",