Re: [sqlite] ANN: alpha DB sqlite util for MacOS X 10.3

At 11:22 PM -0500 12/13/04, Fernando Morgan wrote: For MacOS X 10.3 users; I was going to start to using sqlite in a project, but I need first to create a skeleton of a browser to add some of my data. If someone wants to use it (disclaimer: version 0.1 software), it's here:

Re: [sqlite] absolute vs. relative path to database on Cygwin

Greg Miller wrote: You used a backslash, escaping the 'c' character. Notice that the error message refers to "c:cygwin" rather than "c:\cygwin", which isn't equivalent. Try "ls c:/cygwin" instead. I thought I had before posting... but you're right, this works! -Alan -- Alan Mead - [EMAIL

Re: [sqlite] absolute vs. relative path to database on Cygwin

amead wrote: Are you doing this at the Cygwin prompt or Window's command prompt? My installation of Cygwin doesn't recognize DOS style paths at all: $ ls c:\cygwin ls: c:cygwin: No such file or directory You used a backslash, escaping the 'c' character. Notice that the error message refers to

Re: [sqlite] Any way of using an implicit BTree ordering in SQLite?

> ...I'd like to use a table as a "pure" BTree ... If you mean a general multi-way B-Tree, I don't think there's any practical way in SQL. If you can use a binary tree, there are ways. The most convenient is Joe Celko's method, which he calls nested sets. The other design is usually called an

Re: [sqlite] Row count in database

On Tue, 14 Dec 2004, Christopher Petrilli wrote: On Tue, 14 Dec 2004 12:03:01 -0700 (MST), Ara.T.Howard <[EMAIL PROTECTED]> wrote: On Tue, 14 Dec 2004, Christopher Petrilli wrote: Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've

[sqlite] Any way of using an implicit BTree ordering in SQLite?

Normally (to my understanding), a BTree of some sort is declared on a set of columns of a table when an index (or something which requires an index) is declared on that set of columns. However, I'd like to use a table as a "pure" BTree, i.e. one in which the order is not dependent on values in

[sqlite] [ANN] QuickLite 1.5.3 is available

Hello everybody, I'm pleased to announce that QuickLite 1.5.3 is now available. What’s New in this Version -- - In-cursor data matching - Set operations on cursors: union, minus and intersection - Support for attached databases - More convenience methods in all 3 classes -

Re: [sqlite] absolute vs. relative path to database on Cygwin

Markus Hoenicka wrote: Well, that doesn't work, but the following does: sqlite c:/cygwin/usr/local/share/refdb/db/refdb i.e. absolute paths require a DOS-style drive letter. Are you doing this at the Cygwin prompt or Window's command prompt? My installation of Cygwin doesn't recognize DOS

Re: [sqlite] absolute vs. relative path to database on Cygwin

Markus Hoenicka writes: > amead writes: > > It's a bit of a long-shot, but have you tried the 'cygdrive' path syntax? > > > > $ sqite /cygdrive/c/cygwn/usr/local/share/refdb/db/refdb > > > > (assuming you installed Cygwin on C:\cygwin) > > > > Actually I did not try this yet.

Re: [sqlite] Row count in database

On Tue, 14 Dec 2004 13:54:35 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > Christopher Petrilli wrote: > > Has anyone had any experience in storing a million or more rows in a > > SQLite3 database? I've got a database that I've been building, which > > gets 250 inserts/second, roughly, and

Re: [sqlite] Row count in database

On Tue, 14 Dec 2004 12:03:01 -0700 (MST), Ara.T.Howard <[EMAIL PROTECTED]> wrote: > On Tue, 14 Dec 2004, Christopher Petrilli wrote: > > > Has anyone had any experience in storing a million or more rows in a > > SQLite3 database? I've got a database that I've been building, which > > gets 250

RE: [sqlite] synchronising two databases

Thanks, I'll look into something like that. I think there must be a neat way of doing this synchronisation besides actually copying files, but this method should get me started. I'll keep you posted if I come up with any other method. Regards, Richard. -Original Message- From: Andrew

Re: [sqlite] Row count in database

On Tue, 14 Dec 2004, Christopher Petrilli wrote: Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've been building, which gets 250 inserts/second, roughly, and which has about 3M rows in it. At that point, the CPU load is huge. Note

Re: [sqlite] Row count in database

Christopher Petrilli wrote: Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've been building, which gets 250 inserts/second, roughly, and which has about 3M rows in it. At that point, the CPU load is huge. I just ran a test case

Re: [sqlite] Row count in database

Christopher Petrilli wrote: Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've been building, which gets 250 inserts/second, roughly, and which has about 3M rows in it. At that point, the CPU load is huge. Note that I've got

[sqlite] Row count in database

Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've been building, which gets 250 inserts/second, roughly, and which has about 3M rows in it. At that point, the CPU load is huge. Note that I've got syncing turned off, because I'm

Re: [sqlite] ODBC driver?

Here: http://www.ch-werner.de/sqliteodbc/ --- Jay <[EMAIL PROTECTED]> wrote: > Good morning all, > > Is there an odbc driver for Sqlite3? > It would be useful to be able to use existing data > tools... > > = > > - > > The Castles of Dereth Calendar: a tour

RE: [sqlite] coding style

Also, the data types (in 2.8.15) do not appear to copy over into the newly created table... I had to manually create the table with SQL, then insert into it from the query. -Original Message- From: Jakub Adámek [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 3:08 PM To: