sqlite3?

Painless · Post by **Painless** » Wed Sep 27, 2006 11:26 pm

Hi all,

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

Regards,

Rob

judebert · Post by **judebert** » Thu Sep 28, 2006 5:23 am

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?

Painless · Post by **Painless** » Thu Sep 28, 2006 1:02 pm

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

judebert · Post by **judebert** » Fri Sep 29, 2006 4:07 am

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.

Post by **garvinhicking** » Sun Oct 01, 2006 10:42 pm

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