Hi all,
How do I check for a null recordset in sqlite?
Regards,
Anirban Sarkar
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: the
> 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 protec
> > 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', 'localtime
Hello sqlite-users,
any news on that?
--
bye
-=winne=- mailto:[EMAIL PROTECTED]
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?
selec
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 GMT.
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 sp
Marco Bambini wrote:
Don't know if my mail can help you but my advice is to create a custom
solution if you really need to have many simultaneous accesses to your
sqlite database.
Hello Marco,
Thanks for your reply. Would you mind describing
your concurrency solution further? I guess you have
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 finish
Fri, Mar 25, 2005 at 09:20:16AM -0500: Kervin L. Pierre wrote:
> ...
> I've been pulling my hair out over
> concurrency problems with SQLite 3.
> SQLITE_BUSY, SQLITE_SCHEMA,
> SQLITE_MISUSE, I get them all.
> Basically it should be something of
> a 'mini-cookbook' still approach at
> SQLite 3 concu
On Mar 25, 2005, at 3:20 PM, Kervin L. Pierre wrote:
Hello,
I've been pulling my hair out over
concurrency problems with SQLite 3.
SQLITE_BUSY, SQLITE_SCHEMA,
SQLITE_MISUSE, I get them all.
...
Basically it should be something of
a 'mini-cookbook' still approach at
SQLite 3 concurrency.
Hi,
we have
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 appare
13 matches
Mail list logo