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:
http://homepage.mac.com
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 PROTECT
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 "
> ...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 a
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 b
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 give
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
- S
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 styl
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. I'l
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 w
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 ins
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 Pi
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
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 i
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 synci
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 w
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
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: [EMAIL
18 matches
Mail list logo