Re: [sqlite] Performance with journal_mode = off

On Wed, 27 Mar 2013 17:55:00 -0400, Jeff Archer wrote: >On Wed, Mar 27, 2013 at 5:46 PM, David King wrote: >> >> > I am populating a database with 5764 records using the exact same data set >> > each time into a newly created file. >> > When

Re: [sqlite] Timeline for full ALTER TABLE support?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/03/13 14:40, Tim Gustafson wrote: > Is there a timeline or road map anywhere that could inform us as to > when we might see that feature added? In addition to what others have said, if SQLite did implement full ALTER TABLE support it is

Re: [sqlite] Timeline for full ALTER TABLE support?

Referring to a page at http://web.archive.org/web/20020926232103/http://www.sqlite.org/omitted.html, clearly dated mid-2002, Tim Gustafson effluviated: It's not that it's surprising. The page currently says: Those features near the top of the list are likely to be added in the near future.

Re: [sqlite] Performance with journal_mode = off

On 27 Mar 2013, at 9:55pm, Jeff Archer wrote: > Which is why I expected journal_mode = off to make it faster. But it > is 3 seconds faster when I leave journaling enabled and do all writes > within a single transaction. >> When I set journal_mode = off, same

Re: [sqlite] Performance with journal_mode = off

On Wed, Mar 27, 2013 at 5:46 PM, David King wrote: > > > I am populating a database with 5764 records using the exact same data set > > each time into a newly created file. > > When I use no explicit transactions (default atomic commit) it takes 17.7 > > seconds. > > When I

Re: [sqlite] Performance with journal_mode = off

> I am populating a database with 5764 records using the exact same data set > each time into a newly created file. > When I use no explicit transactions (default atomic commit) it takes 17.7 > seconds. > When I set journal_mode = off, same operation takes 5.5 seconds. > If I do all 5764 inserts

[sqlite] Performance with journal_mode = off

Could someone please confirm if this makes sense. It is not what I expected. I have repeated several times so I believe these are the correct numbers. I am populating a database with 5764 records using the exact same data set each time into a newly created file. When I use no explicit

[sqlite] Version 3.7.16.1 bug fix release in about a week

The query optimizer enhancements that were added as part of version 3.7.15 were a little overzealous in optimizing out certain ORDER BY clauses, which means that in some cases the result rows were not being sorted and were coming out in an incorrect order. See

Re: [sqlite] Ubuntu Linking

On Wed, 27 Mar 2013 09:33:39 -0700 (PDT) "brian_f_john...@yahoo.com" wrote: > I ran: cc -O -c sqlite3.c shell.c  That created .o files after 1 > warning about function exprDup having a memset with constant zero > length. > > I compiled my program:  cc -I$HOME/lstp -O

[sqlite] NSA internal amusement magazine

Newly declassified, issues of the internal amusement magazine (i.e. this mailing list) from the NSA in the 1970s to 1990s: Largely redacted, but contains everything from a description of the speech developed in Russian prison camps to

Re: [sqlite] Timeline for full ALTER TABLE support?

> It really shouldn't be that surprising, this is pretty standard for open > source software. Somebody has to do it, which means either writing code > yourself, waiting for somebody else to get around to writing code, or > putting up $$$ so somebody else spends their time writing code for you.

Re: [sqlite] Timeline for full ALTER TABLE support?

On 27/03/2013 12:14 PM, Tim Gustafson wrote: Clemens' analysis of the likelihood of seeing ALTER TABLE anytime soon is correct. Might I suggest that the "omitted" page then be updated to unambiguously state that there is no plan to even implement the missing features, so that people aren't left

[sqlite] Ubuntu Linking

Hi,   I ran: cc -O -c sqlite3.c shell.c  That created .o files after 1 warning about function exprDup having a memset with constant zero length. I compiled my program:  cc -I$HOME/lstp -O -c lstp_sql.c and have a .o for it as well Now I am trying to figure out how to link them all together

Re: [sqlite] Timeline for full ALTER TABLE support?

> Clemens' analysis of the likelihood of seeing ALTER TABLE anytime soon is > correct. Might I suggest that the "omitted" page then be updated to unambiguously state that there is no plan to even implement the missing features, so that people aren't left wondering? Thanks! -- Tim Gustafson

Re: [sqlite] Timeline for full ALTER TABLE support?

On Wed, Mar 27, 2013 at 12:06 PM, Dominique Devienne wrote: > On Wed, Mar 27, 2013 at 2:41 PM, Clemens Ladisch > wrote: > > > Tim Gustafson wrote: > > > That page also says that things are listed there in the order they're > > > likely to be implemented

Re: [sqlite] Timeline for full ALTER TABLE support?

On Wed, Mar 27, 2013 at 2:41 PM, Clemens Ladisch wrote: > Tim Gustafson wrote: > > That page also says that things are listed there in the order they're > > likely to be implemented in SQLite. Is there a timeline or road map > > anywhere that could inform us as to when we

Re: [sqlite] How do I get older versions of the sources?

I was failing at the clone command with a "not authorized to clone" error. I was going against http://www2.sqlite.org/cgi/src , since the download page indicated that as the closest one to me. When I go against http://www.sqlite.org/cgi/src , I can clone. Thanks

Re: [sqlite] How do I get older versions of the sources?

On Wed, Mar 27, 2013 at 3:15 PM, Wayne Bradney wrote: > Might seem like a dumb questions, but I can figure it out.fossil clone > command gives me: Not authorized to cloneHitting the URL in the browser > gives me much info about cryptic tag ids but no apparent way to get

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

The black and white of it, you're looking at something home brew then. No one is going to have anything that is plain and simple enough that does exactly what you want it to do without a lot of extra fluff, and with the additional "kind-of-a-restriction" of being under Linux, I can't offer

[sqlite] How do I get older versions of the sources?

Might seem like a dumb questions, but I can figure it out.fossil clone command gives me: Not authorized to cloneHitting the URL in the browser gives me much info about cryptic tag ids but no apparent way to get to full sources for an older version. Help?

Re: [sqlite] Timeline for full ALTER TABLE support?

Tim Gustafson wrote: > I see that full ALTER TABLE support is in position number two on the > list of things that SQLite doesn't support: > > http://www.sqlite.org/omitted.html Once Upon A Time™, that list had more entries:

Re: [sqlite] ANN: user-defined functions

... so I think you must be using a really old copy. That's correct: I downloaded this source years ago. And yes, argc for SQLite functions has a different semantics from main(). Thanks for the heads up. -- j...@antichoc.net

Re: [sqlite] Question about behavior when journal_mode = off

On Wed, Mar 27, 2013 at 8:05 AM, Jeff Archer < jsarc...@nanotronicsimaging.com> wrote: > If all connections (1 per thread) of all processes (multiple simultaneous) > issue command "PRAGMA journal_mode = off", is access to a common database > file located on the local machine still synchronized

[sqlite] Question about behavior when journal_mode = off

If all connections (1 per thread) of all processes (multiple simultaneous) issue command "PRAGMA journal_mode = off", is access to a common database file located on the local machine still synchronized correctly between the random accesses (reads and writes) occurring across all?

[sqlite] Timeline for full ALTER TABLE support?

Hi, I see that full ALTER TABLE support is in position number two on the list of things that SQLite doesn't support: http://www.sqlite.org/omitted.html That page also says that things are listed there in the order they're likely to be implemented in SQLite. Is there a timeline or road map

Re: [sqlite] ANN: user-defined functions

> At 15:46 25/03/2013, you wrote: > > > The sqrt() function takes only one argument, at least. > > It checks assert( argc==2 ); at line 503 AFAIK. Under some conventions, argc is one more than you might initially expect, so it's worth looking a little deeper. Think of main() and also C

[sqlite] Install sqlite-netFx40-setup-bundle silently

Is it possible and if so how to install sqlite-netFx40-setup-bundle in a silent mode. I would like to do the install as part of a software package but would prefer the users are not presented with the install screens. Also what would be the easiest way to determine if