Page 1 of 1

sqlite3?

Posted: Wed Sep 27, 2006 11:26 pm
by Painless
Hi all,

Just wondering, does serendipity support sqlite3 as well as sqlite?

Regards,

Rob

Posted: Thu Sep 28, 2006 5:23 am
by judebert
You'll probably have to wait for Garvin for that one. It's not mentioned anywhere in the code, so it's not specifically supported. How different is it from sqlite?

Posted: Thu Sep 28, 2006 1:02 pm
by Painless
Hi,

Thanks for the reply.

I'm no expert, but I understand that sqlite3 has improved concurrency and a different file format which uses less space, as well as a bunch of other improvements which I don't really understand the benefits of.

Regards,

Rob

Posted: Fri Sep 29, 2006 4:07 am
by judebert
If you've got the time, give it a try. If it works, let us know. I it doesn't work, let us know why.

Posted: Sun Oct 01, 2006 10:42 pm
by garvinhicking
Hi!

For SQLite support, serendipity simply relies on the PHP sqlite* function calls.

Thus, if PHP on your server supports SQLite3 (which I think it does in recent versions), then s9y will automatically support it. I believe that the SQLite functions even take care of converting SQLite2 to SQLite3 databases when opening.

HTH,
Garvin