How to create the sqlite database?

Having trouble installing serendipity?
Post Reply
BarryK
Regular
Posts: 6
Joined: Wed Aug 16, 2017 8:17 pm

How to create the sqlite database?

Post by BarryK » Wed Aug 16, 2017 8:35 pm

Hi,
This is a newbie question.

I have previously installed a couple of cms apps that use sqlite, and they came with pre-created sqlite databases. They were Batflat and Quick.cms

However, Serenditpity requires the sqlite database to be created beforehand.

But, how do I create it?

I run Linux, on my laptop, and have the 'sqlite3' binary executable. Could someone tell me how to use that to create the database file?

I looked around, can't find documentation how to do that. Any help will be appreciated.

Regards,
Barry

BarryK
Regular
Posts: 6
Joined: Wed Aug 16, 2017 8:17 pm

Re: How to create the sqlite database?

Post by BarryK » Thu Aug 17, 2017 11:09 am

Ha ha, that was a dumb post, my apologies :oops:

What happened, is I was evaluatiing Dotclear blog at almost the same time, and my brain is not very good at multitasking.

Got them mixed up. Dotclear is the one that requires the sqlite database file to be manually created.

Serendipity, though, I have just now installed it, and so easy! Works with sqlite. My host is omnis.com, shared account.

One question though, for anyone reading this who might know: installation shows a list of database choices, including "PDO::SQlite" and "SQlite3 (OO) (preferably use PDO-SQlite".

I choose the first one. Is that OK? Seems to work ok.

User avatar
onli
Regular
Posts: 2254
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: How to create the sqlite database?

Post by onli » Thu Aug 17, 2017 11:29 am

PDO::SQlite is the right choice. The others, well, a developer went on a tangent there :) More for supporting additional setups.

Post Reply