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

2010-03-28 Thread Roy Tam
2010/3/29 P Kishor : > On Sun, Mar 28, 2010 at 10:50 PM, Dan Kennedy wrote: >> >> On Mar 29, 2010, at 10:48 AM, P Kishor wrote: >> >>> On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns >>> wrote: -BEGIN PGP SIGNED

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 wrote: > > On Mar 29, 2010, at 10:48 AM, P Kishor wrote: > >> On Sun, Mar 28, 2010 at 10:45 PM, Roger Binns >> wrote: >>> -BEGIN PGP SIGNED MESSAGE- >>> Hash: SHA1 >>> >>> sub sk79 wrote: How

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

2010-03-28 Thread Roy Tam
2010/3/29 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. > Confirmed.

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

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

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 Kees Nuyt
On Sun, 28 Mar 2010 14:59:15 -0400, sub sk79 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

Re: [sqlite] rtree in DBD::SQLite

2010-03-28 Thread P Kishor
for anyone else seeking the same answer -- On Sun, Mar 28, 2010 at 11:40 AM, P Kishor wrote: > I hadn't upgraded my DBD in a while, so looked at CPAN today. First, > what an amazing job the DBD maintainers have done, with all sorts of > goodness available to the users. The

[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

[sqlite] rtree in DBD::SQLite

2010-03-28 Thread P Kishor
I hadn't upgraded my DBD in a while, so looked at CPAN today. First, what an amazing job the DBD maintainers have done, with all sorts of goodness available to the users. The collations and the action codes will be very helpful. What I need for now is, to compile DBD::SQLite with FTS3 and R*Tree.

[sqlite] Unwanted CLI CR-LF to LF conversion

2010-03-28 Thread Tomáš Szépe
Hi, cat << EOF| sqlite3 x.sqlite3 create table foo(bar text); insert into foo values(' baz x'); EOF The literal written as a C string is "\r\r\rbaz\r\nx". However, the string actually stored turns out to be "\r\r\rbaz\nx". $ echo .dump| sqlite3 x.sqlite3 PRAGMA foreign_keys=OFF; BEGIN