[sqlite] What software is deployed more than SQLite?

On 3 May 2015, at 9:48pm, Yahoo! Mail wrote: > How about curl? Hmm. curl is part of webkit (well, part of webcore which is part of webkit) too. It would definitely seem to be in the running. Simon.

[sqlite] Multiple instances of the same program accessing the same db file

On 3 May 2015, at 9:09pm, Scott Doctor wrote: > Hmm, one for doing my own locking, one against it. As this seems to be an > obvious issue in any network, I wonder why the network developers have not > appropriately addressed this issue. They've tried. With modern operating systems locking

[sqlite] What software is deployed more than SQLite?

On Sun, May 3, 2015 at 8:18 PM, Richard Hipp wrote: > There are multiple competing implementation of libc, and (unless I am > mistaken) Android and MacOS/iOS use completely independent libc > implementations. You could argue that various implementations of libc > are collectively more widely

[sqlite] Multiple instances of the same program accessing the same db file

On Sun, 03 May 2015 13:09:43 -0700 Scott Doctor wrote: > I wonder why the network developers have not appropriately addressed > this issue. Looks like I need to research this problem more before > implementing. >From one perspective -- a common use case -- they *have* addressed this issue.

[sqlite] Multiple instances of the same program accessing the same db file

I googled file locking issues. Sheesh, The horror stories of programs like Quickbooks corrupting data files. Files getting locked when nobody is using them (A windows 7 bug that supposedly was fixed) and endless information about what not to do, or what does not work. Very little about what

[sqlite] What software is deployed more than SQLite?

On 3 May 2015, at 7:18pm, Richard Hipp wrote: > There are multiple competing implementation of libc Is there a C library for understanding the FAT filesytem ? Countless devices (phone/tablet/GPS/TV/game console) have slots for PCI express/mini/micro cards and need them formatted in FAT. Is

[sqlite] What software is deployed more than SQLite?

Richard, Every copy of iPhoto, Aperture and Photos as well. Photo?s is the new replacement for IPhoto and Aperture. I?ve just checked a couple of the libraries and they open as SQLite. I can?t speak for the iOS versions of these. In reference to the png library I would assume that that is

[sqlite] Possible bug with locking/retying

On Sun, 3 May 2015 01:18:11 +0100 Simon Slavin wrote: > In searching for something else I came across this: > > > > I don't like the fact that it's undated. For all I know this is > about a three year old bug which has long since been

[sqlite] What software is deployed more than SQLite?

On 5/3/15, Scott Doctor wrote: > OK, here is merciless. Thanks for the input. The page has been rewritten in active voice. And the text was restructured and softened in response to another anonymous critique. Please press "Reload" or revisit https://www.sqlite.org/draft/mostdeployed.html and

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

This link lists five SQLite "management tools": 1. SQLite Expert 2. SQLite Administrator 3. SQLite Database Browser 4. SQLite Spy 5. SQLite Manager (Firefox plug-in) http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/ Also there is the Spatialite project which builds a

[sqlite] What software is deployed more than SQLite?

Hi Dr. Hipp, On 3 May 2015 at 11:18, Richard Hipp wrote: > Any input you can provide is appreciated! Congratulations to you and your team on SQLite's achievement and I wish you continued success. "Most Widely Deployed And Used Database Engine" I don't think the A in and needs capitalization.

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Hello, I've started yet another awesome collection about - surprise, surprise - SQLite - inspired by the awesome- trend on GitHub that collects links on a single page - in Markdown e.g. README.md - in a git repo. What?s news? The awesome-sqlite repo collects SQLite goodies, tools, scripts,

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

To reply to Mr. Slavin > In any properly working system even integrity-check (more thorough than quick-check) never fails, and > neither should be necessary in anything except a rarely-used maintenance procedure. They are both > diagnostic tools for faults, not part of a smoothly running

[sqlite] What software is deployed more than SQLite?

On 5/3/15, Richard Hipp wrote: > I'm trying to update the "Most Deployed Database" page > (https://www.sqlite.org/mostdeployed.html) in the SQLite documentation > (which has not been touched in close to a decade)... I invite merciless criticism of the draft revision at

[sqlite] Segfault during FTS index creation from huge data

On Thu, 30 Apr 2015 12:47:57 -0600 Scott Robison wrote: > Perhaps you are correct and "sigsegv" is not the literal signal that > is triggered in this case. I don't care, really. The fact is that an > apparently valid pointer was returned from a memory allocation > function yet can result in an

[sqlite] Multiple instances of the same program accessing the same db file

On Sat, 02 May 2015 19:24:19 -0700 Scott Doctor wrote: > Each computer has its own copy of the program, but may > share the database file which may be located on any of the computers. > So I am wondering whether I should implement my own locking logic in > my program. Yes, you need to arrange

[sqlite] Segfault during FTS index creation from huge data

One, you should remove sqlite-users at sqlite.org from your To list. I keep bouncing email when I reply to you. Not a big deal, just an FYI. Two: On Sun, May 3, 2015 at 2:13 PM, James K. Lowden wrote: > On Thu, 30 Apr 2015 12:47:57 -0600 > Scott Robison wrote: > > > Perhaps you are correct

[sqlite] Multiple instances of the same program accessing the same db file

> Hmm, one for doing my own locking, one against it. As this seems to be > an obvious issue in any network, I wonder why the network developers > have not appropriately addressed this issue. They have. In the early 80's when network filesystems were invented they were incredibly slow. So

[sqlite] What software is deployed more than SQLite?

OK, here is merciless. The grammar police. Starting a sentence with 'There' is not proper. I suggest the following Rewrite: /There are likely more copies of SQLite in use than all other database engines combined./ As: More copies of SQLite are in use than all other databases combined. Rewrite:

[sqlite] What software is deployed more than SQLite?

I'm trying to update the "Most Deployed Database" page (https://www.sqlite.org/mostdeployed.html) in the SQLite documentation (which has not been touched in close to a decade) and I began to wonder what other software libraries (database or otherwise) might be deployed more than SQLite. SQLite is

[sqlite] What software is deployed more than SQLite?

OpenSSL and/or libeay and derivatives. On every device which does any type of SSL/TLS/encryption/hash functions from pocket calculators, control systems, phones, mini-computers, mainframes, satellites (as in orbiting the earth), submarines, and on and on ... Another candidate is the original

[sqlite] Possible bug with locking/retying

> I think it's a misuse of Sqlite and not a real bug. He adds code to ensure > only one thread access the database in a multithread application. For the > description, I infer he uses -DSQLITE_THREADSAFE=2 (multithread), where a > -DSQLITE_THREADSAFE=1 (serialized) solve the problem better

[sqlite] What software is deployed more than SQLite?

Last time I asked myself this question, I ended up in the same place you did: zlib, libpng and libjpeg may be the only candidates in the same ballpark as SQLite. See also: https://news.ycombinator.com/item?id=4616740 -- E On Sun, May 3, 2015 at 1:18 PM, Richard Hipp wrote: > I'm trying to

[sqlite] Multiple instances of the same program accessing the same db file

Hmm, one for doing my own locking, one against it. As this seems to be an obvious issue in any network, I wonder why the network developers have not appropriately addressed this issue. Looks like I need to research this problem more before implementing. I dislike probability games of designs

[sqlite] What software is deployed more than SQLite?

On Sun, May 3, 2015 at 12:18 PM, Richard Hipp wrote: > I'm trying to update the "Most Deployed Database" page > (https://www.sqlite.org/mostdeployed.html) in the SQLite documentation > (which has not been touched in close to a decade) and I began to > wonder what other software libraries

[sqlite] Multiple instances of the same program accessing the same db file

On 3 May 2015, at 3:24am, Scott Doctor wrote: > My program runs on windows and mac with a local area network connecting the > computers. Each computer has its own copy of the program, but may share the > database file which may be located on any of the computers. So I am wondering > whether

[sqlite] Multiple instances of the same program accessing the same db file

On 3 May 2015, at 2:03am, Scott Doctor wrote: > To review, after opening the database, issue the PRAGMA busy_timeout = x, > with x being however long I want to wait before aborting. Yes. Since you have two copies of one program, I don't need to say this for you, but for other people, the

[sqlite] Possible bug with locking/retying

In searching for something else I came across this: I don't like the fact that it's undated. For all I know this is about a three year old bug which has long since been patched. I understand the description, but not what SQLite does

[sqlite] Multiple instances of the same program accessing the same db file

On 3 May 2015, at 12:55am, J Decker wrote: > Yes, it really requires only a little additional work on application side. > The native open will open it in read/write share allow, and handle > interlocking. > > if you get a result of SQLITE_BUSY you need to retry the operation after a > short