Hello sten,
you could try SQLiteDb Query Analyzer from
http://www.terrainformatica.com/sqlitedb
(it's included in the SQLiteDb install package).
It's not much right now but it's going to be improved alot in the next
weeks.
Best regards,
George Ionescu
Hello sten,
you could try SQLiteDb Query Analyzer from
http://www.terrainformatica.com/sqlitedb
(it's included in the SQLiteDb install package).
It's not much right now but it's going to be improved alot in the next
weeks.
Best regards,
George Ionescu
Hello Sten. Please see www.sqliteplus.com for an excellent tool, and also a COM
DLL wrapper that you can use from VB, C++ and .NET.
Quoting Sten Larsson <[EMAIL PROTECTED]>:
> Is there any free or commercial DB admin tool that works with sqlite 3.08 and
> runs under Windows.
>
> (No webbased to
Is there any free or commercial DB admin tool that works with sqlite 3.08 and
runs under Windows.
(No webbased tool.)
thanks!
-sten
Hi Tito,
It now doesn't crash immediately after a null
and you can re-download it from:
http://homepage.mac.com/fernandoluis/.cv/fernandoluis/Public/
SquidSQL.zip-link.zip
this might be a little off-topic but I have also started on a 10g
"SquidSQL" for Oracle. TOra is having some problems a
On Tue, Dec 14, 2004 at 09:16:35PM -0600, Kurt Welgehausen wrote:
> > ...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'
On Wed, 15 Dec 2004, Christopher Petrilli wrote:
One thing I've noticed is that if I turn of synchronous, the
filesystem slowly slows down, which is fun, but it doesn't do so
enough that it's a major issue.
I'm using the APSW wrapper for Python, which is basically a very thin
wrapper over the basic
Is there any chance of implementing a weekday name in strftime()?
The microsoft/dos version returns:
%a
Abbreviated weekday name
%A
Full weekday name
It should be pretty easy to implement.
=
-
The Castles of Dereth Calendar: a tour of that art and archite
On Wed, 15 Dec 2004 08:47:34 -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
Yes, the problem was with a NULL value, I think. That's the curse of
SQL-based RDBMS :-)
I am using a "sqlite3_get_table" to get the table data to fill out the
right side NSTableView, but I am going to change it. SquidSQL is
holding the table data in a NSMutableArray to allow for users t
Humm. At start, it does a "select name from sqlite_master where type =
'table'" to fill out the left table view.
Do you have any tables there in the db? Actually you can create a new
table pressing the + button under the left browser. But all columns
create are type Text -
- Another thing
Hello Steve,
Visiting the link I posted with my post would have answered your
question :-)
QuickLite is a Cocoa wrapper for SQLite.
-- Tito
On Dec 15, 2004, at 13:24, Steve Frierdich wrote:
What is QuickLite 1.5.3 ?
Tito Ciuro wrote:
Hello everybody,
I'm pleased to announce that QuickLite 1.5.3 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.
The other thing to remem
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
Kenneth McDonald wrote:
This cannot be done efficiently (at least not elegantly) with
explicit indexes. For example, let's say I'm using integer
indexes to define the order, and I have a table with one
million records. If I insert a new record halfway through
the table, then I have to update the in
bert hubert wrote:
My question is: can sqlite3_step return SQLITE_BUSY, without ever calling my
handler? It certainly does so in my application, which is written in single
threaded c++ and runs under linux 2.6.10-rc2, Debian sid, with sqlite
3.0.8. It happens with 3.0.7 as well.
SQLite will return
What is QuickLite 1.5.3 ?
Tito Ciuro wrote:
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
- M
Hi sqlite people!
I haven't yet had the chance to say so but I want to thank Richard and all
other contributors - sqlite has truly changed the way I'm able to write
software. It rocks. Thank you.
Ok, on to my question. I have two programs, one that fills an sqlite
database, one that displays the
Hi Jeff,
Works for me...
By the way, SquidSQL crashed with my data:
Date/Time: 2004-12-15 10:10:16 +0100
OS Version: 10.3.6 (Build 7R28)
Report Version: 2
Command: SquidSQL
Thread 0 Crashed:
0 libSystem.B.dylib 0x90006e40 strlen + 0x20
1 com.apple.CoreFoundation 0x
> You might search the list archive and also try a
> Google search on 'celko nested set' and 'adjacency
> list' -- or even just 'sql tree'.
Try also http://www.dbazine.com/tropashko4.shtml
Hugh
I have tried opening some existing sqlite3 files, but the browser shows
nothing. Perhaps i am doing something wrong?
it sounds like a great tool!
I am on 10.3.6 of OSX
Thanks
Jeff Edwards
On 14/12/2004, at 12:22 PM, Fernando Morgan wrote:
For MacOS X 10.3 users;
I was going to start to using sq
21 matches
Mail list logo