[sqlite] marketing - The world's most popular open source database

I was reminded today that MySQL still prominently advertises themselves as "The world's most popular open source database", on their website and in their product announcements etc. However, isn't that claim clearly wrong, given that SQLite for one has way more installations than MySQL does,

Re: [sqlite] marketing - The world's most popular open source database

Darren Duncan wrote: > I was reminded today that MySQL still prominently advertises themselves > as "The world's most popular open source database", on their website > and in their product announcements etc. > > However, isn't that claim clearly wrong, given that SQLite for one has > way more

Re: [sqlite] Possible inaccuracy in "Isolation In SQLite" paper

I think the documentation's good. I think you're missing the whole point of a deferred transaction: that it doesn't start a "transaction" until it needs to. You can run "begin deferred transaction" then walk away for 3 months without upsetting anything. If you need the precise timing then why

Re: [sqlite] Possible inaccuracy in "Isolation In SQLite" paper

Gerry, David, you are both right. The possibility of a bug is thus eliminated for good. And https://www.sqlite.org/isolation.html is, strictly speaking, accurate, even if it another document is needed to avoid any interpretation doubt

Re: [sqlite] Possible inaccuracy in "Isolation In SQLite" paper

"Deferred means that no locks are acquired on the database until the database is first accessed. Thus with a deferred transaction, the BEGIN statement itself does nothing to the filesystem. Locks are not acquired until the first read or write operation." On Jul 18, 2017 6:10 AM, "Gwendal Roué"

Re: [sqlite] Summarising (missing) values

Paul Sanderson wrote: > What I would like is a single query that summarises the values that are > present in (or missing from) a table. A row is the start of a range if there is no previous row: WITH ranges(first) AS ( SELECT _id FROM messages WHERE _id - 1 NOT IN (SELECT _id FROM

Re: [sqlite] Summarising (missing) values

That simple - I was over thinking it cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional

[sqlite] Summarising (missing) values

I have a table which includes a numeric "ID" column, values in the column generally increment but there are some gaps. I use the following query to get a list of all "missing" values WITH RECURSIVE cte(x) AS (SELECT (SELECT Min(messages._id) FROM messages) UNION ALL SELECT cte.x + 1

Re: [sqlite] marketing - The world's most popular open source database

On 18 Jul 2017, at 8:37am, Donald Shepherd wrote: > I think that there's no real definition for "popular" leaves it as a > massively ambiguous claim. Agreed. In addition to this, in which court would the claim be judged and why ? There’s no such thing as a world

Re: [sqlite] marketing - The world's most popular open source database

I was drafting a "don't confuse `popular` [a collective human bias] with `most-used` or `most widely deployed` [value statements]" response, but I see others have already done so... I would like to add that often if I mention "SQLite" in conversation with random people (even technical

[sqlite] Version 3.20.0 coming soon...

The tab completion in the sqlite3 shell works, which is nice, but it seems to shadow readline's normal file name completion when hitting tab at for example sqlite> .read "sq which is not so nice... (i.e. no file name completion any more for .read , .attach and the like...) /Stephan

[sqlite] Possible inaccuracy in "Isolation In SQLite" paper

Hello all, The following sentence in https://www.sqlite.org/isolation.html does not exactly describe the behavior of SQLite (since many versions): > In WAL mode, SQLite exhibits "snapshot isolation". When a read transaction > starts, that reader continues to see an unchanging "snapshot" of the

Re: [sqlite] marketing - The world's most popular open source database

On Tue, 18 Jul 2017, R Smith wrote: I wouldn't dispute MySQL's claim as most popular, neither SQLite's claim as most widely deployed - both seem quite accurate, or at a minimum, plausible. Sqlite likely has the longest anticipated future support out of available databases. The anticipated

[sqlite] Version 3.20.0 coming soon...

The command history (Ctrl-R) of the shell is still intact with the new tab completion, but I had experienced it often as way too short (too few lines). So I have searched now in the source code, the line in shell.c is if( zHistory ){ shell_stifle_history(100); ... in case

Re: [sqlite] Possible inaccuracy in "Isolation In SQLite" paper

I notice that “read_uncommitted pragma” is spelled “PRAGMA read_uncommitted” in one place. The links all match. This small inconsistency is probably a mistake. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Version 3.20.0 coming soon...

On 07/18/17 16:37 , Stephan Buchert wrote: > The command history (Ctrl-R) of the shell is still intact with the new tab > completion, but I had experienced it often as way too short (too few > lines). So I have searched now in the source code, the line in shell.c is > > if( zHistory ){ >