[sqlite] Null recordset in sqlite

Hi all, How do I check for a null recordset in sqlite? Regards, Anirban Sarkar

[sqlite] Pressure test of SQLite with ado.net wrapper(phase II)

Hi All, Please refer to phase I first. I used the http://sourceforge.net/projects/adodotnetsqlite to do the pressure test and see the actual performance on my PC: PIV 3.0, 1G RAM, win2003 server(Simplifed Chinese)+vs.net2003, with unicode characters: I slightly modified the official test:

Re: [sqlite] RegEx w/ sqlite, yet?

> Hello sqlite-users, > > any news on that? It's not part of the sql standard, so I would bet the answer is going to be 'you have to add that yourself'. I did for my project. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam

Re: [sqlite] time for timer...

> > SQLite version 3.1.2 > > Enter ".help" for instructions > > sqlite> select datetime('now'); > > 2005-03-26 00:44:37 > > sqlite> .quit > > zenobia # date > > Fri Mar 25 18:44:48 CST 2005 > > zenobia # > > > > Is this because I don't have the timezone set? > > select datetime('now',

[sqlite] RegEx w/ sqlite, yet?

Hello sqlite-users, any news on that? -- bye -=winne=- mailto:[EMAIL PROTECTED]

Re: [sqlite] time for timer...

On Fri, Mar 25, 2005 at 04:48:47PM -0800, Jay wrote: > SQLite version 3.1.2 > Enter ".help" for instructions > sqlite> select datetime('now'); > 2005-03-26 00:44:37 > sqlite> .quit > zenobia # date > Fri Mar 25 18:44:48 CST 2005 > zenobia # > > Is this because I don't have the timezone set?

Re: [sqlite] time for timer...

Jay wrote: > SQLite version 3.1.2 > Enter ".help" for instructions > sqlite> select datetime('now'); > 2005-03-26 00:44:37 > sqlite> .quit > zenobia # date > Fri Mar 25 18:44:48 CST 2005 > zenobia # > > Is this because I don't have the timezone set? The time you are getting from SQLite is in

[sqlite] time for timer...

SQLite version 3.1.2 Enter ".help" for instructions sqlite> select datetime('now'); 2005-03-26 00:44:37 sqlite> .quit zenobia # date Fri Mar 25 18:44:48 CST 2005 zenobia # Is this because I don't have the timezone set? __ Do You Yahoo!? Tired of

Re: [sqlite] Concurrency tutorial ( small bounty )

Marco Bambini said: > we have develop an SQLiteServer on top of sqlite3 (and sqlite2) > database engine. > Our requirements was robustness and a reasonable fast solution to be > able to serve a large amount of concurrent connections. > The server will be available in few days, when we'll

[sqlite] Concurrency tutorial ( small bounty )

Hello, I've been pulling my hair out over concurrency problems with SQLite 3. SQLITE_BUSY, SQLITE_SCHEMA, SQLITE_MISUSE, I get them all. Over the last few weeks, I've been strictly debugging SQLite problems in my application [ http://openconnector.org ]. No program logic besides fixing ( and