Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-04-01 Thread Jean-Denis Muys
On 4/1/10 4:12 , Neville Franks sql...@surfulater.com wrote: Thursday, April 1, 2010, 12:16:13 PM, you wrote: JJD On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski JJD bardzotajneko...@interia.pl wrote: There were many problems with that approach: ... (3) Each table and index is in a

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-04-01 Thread Florian Weimer
* sub sk: Somehow no one seems to have mentioned it on this mailing list so far!? Here is the scoop... On March 23, Oracle announced the latest release of Oracle® Berkeley DB - 11g Release 2 - which introduces a new SQL API, based on lo and behold, SQLite v3 API. What this means is that

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-31 Thread Wiktor Adamski
There were many problems with   that approach: ... (3) Each table and index is in a   separate file so your database was a directory full of files instead   of a single file This one is not a problem. Actually I don't see how 1 file is better than 1 directory. For example mac application is

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-31 Thread Jim Jed Dodgen
On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski bardzotajneko...@interia.pl wrote: There were many problems with that approach: ... (3) Each table and index is in a separate file so your database was a directory full of files instead of a single file This one is not a problem. Actually I

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-31 Thread Neville Franks
Thursday, April 1, 2010, 12:16:13 PM, you wrote: JJD On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski JJD bardzotajneko...@interia.pl wrote: There were many problems with that approach: ... (3) Each table and index is in a separate file so your database was a directory full of files instead

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-31 Thread Nicolas Williams
On Wed, Mar 31, 2010 at 06:16:13PM -0700, Jim Jed Dodgen wrote: On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski (3) Each table and index is in a separate file so your database was a directory full of files instead of a single file This one is not a problem. Actually I don't see how 1

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 P Kishor wrote: thanks for the clarification, but how does the above statement reconcile with the btree/paging layer is replaced with BDB? Does that refer to a different version of SQLite being offered by Oracle that includes BDB for storage? I

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread P Kishor
On Mon, Mar 29, 2010 at 3:23 AM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 P Kishor wrote: thanks for the clarification, but how does the above statement reconcile with the btree/paging layer is replaced with BDB? Does that refer to a different

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread Jay A. Kreibich
On Mon, Mar 29, 2010 at 09:15:45AM +0530, Roger Binns scratched on the wall: I believe the btree/paging layer is replaced with BDB. Didn't SQLite 1 use a dbm library for the storage layer? The more things change -j -- Jay A. Kreibich J A Y @ K R E I B I.C H Our opponent

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread D. Richard Hipp
On Mar 29, 2010, at 12:03 PM, Jay A. Kreibich wrote: On Mon, Mar 29, 2010 at 09:15:45AM +0530, Roger Binns scratched on the wall: I believe the btree/paging layer is replaced with BDB. Didn't SQLite 1 use a dbm library for the storage layer? The more things change SQLite

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread Alexey Pechnikov
Hello! On Monday 29 March 2010 20:22:36 D. Richard Hipp wrote: SQLite version 1 used gdbm for storage. There were many problems with that approach: (1) gdbm is a hash-based system so it could not do range queries (2) gdbm is GPL, (3) Each table and index is in a separate file so your

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread D. Richard Hipp
On Mar 29, 2010, at 1:56 PM, Alexey Pechnikov wrote: Hello! On Monday 29 March 2010 20:22:36 D. Richard Hipp wrote: SQLite version 1 used gdbm for storage. There were many problems with that approach: (1) gdbm is a hash-based system so it could not do range queries (2) gdbm is GPL,

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-29 Thread Alexey Pechnikov
Hello! On Monday 29 March 2010 22:26:41 D. Richard Hipp wrote: I can come up with additional reasons why replacing the existing SQLite backend with TC is not a good idea, but perhaps the above will suffice. But how about insert/update performance on big indices? When index size is more

[sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread sub sk79
Hi, Somehow no one seems to have mentioned it on this mailing list so far!? Here is the scoop... On March 23, Oracle announced the latest release of Oracle® Berkeley DB - 11g Release 2 - which introduces a new SQL API, based on lo and behold, SQLite v3 API. What this means is that all tools

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread Kees Nuyt
On Sun, 28 Mar 2010 14:59:15 -0400, sub sk79 subs...@gmail.com wrote: Hi, Somehow no one seems to have mentioned it on this mailing list so far!? Here is the scoop... On March 23, Oracle announced the latest release of Oracle® Berkeley DB - 11g Release 2 - which introduces a new SQL API,

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: How So? Is SQLite getting a high concurrency module from BDB in exchange for its SQL API? I believe the btree/paging layer is replaced with BDB. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread P Kishor
On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: How So? Is SQLite getting a high concurrency module from BDB in exchange for its SQL API? I believe the btree/paging layer is replaced with BDB. How

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread Dan Kennedy
On Mar 29, 2010, at 10:48 AM, P Kishor wrote: On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: How So? Is SQLite getting a high concurrency module from BDB in exchange for its SQL API? I believe

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread Roy Tam
2010/3/29 Roger Binns rog...@rogerbinns.com: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: How So? Is SQLite getting a high concurrency module from BDB in exchange for its SQL API? I believe the btree/paging layer is replaced with BDB. Confirmed.

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread P Kishor
On Sun, Mar 28, 2010 at 10:50 PM, Dan Kennedy danielk1...@gmail.com wrote: On Mar 29, 2010, at 10:48 AM, P Kishor wrote: On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: How So? Is SQLite getting a

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

2010-03-28 Thread Roy Tam
2010/3/29 P Kishor punk.k...@gmail.com: On Sun, Mar 28, 2010 at 10:50 PM, Dan Kennedy danielk1...@gmail.com wrote: On Mar 29, 2010, at 10:48 AM, P Kishor wrote: On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub