Creating new SQLite DBs with PDO

Question

I want to provide a setup feature in my next project and I'm wondering if it's possible to create a SQLite 3 database from scratch with PDO or I'm just stuck at connecting to existing databases via DSN?

If it isn't possible with PDO is there any way to create a new DB via PHP?

I can do that, but I want to know if there is a way to create DB by running SQL statements like CREATE DATABASE, CREATE TABLE and so on. — Alix Axel
– Alix Axel, Commented Dec 12, 2009 at 15:38

Tor Valamo · Accepted Answer · 2009-12-12 15:42:17Z

24

A new sqlite database is created when you open a connection to one that doesn't exist. You can just check if the file exists, and then if it doesn't, then just create a new database connection and insert the tables.

answered Dec 12, 2009 at 15:42

Tor Valamo

33.9k11 gold badges76 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alix Axel Over a year ago

Thanks, I didn't knew that. Also, is there a way to specify the database file permissions (chmod) upon creation?

Tor Valamo Over a year ago

No, but the default is 666, I think. And so you can change it after you've created it and closed the connection. The directory where it's created needs to be writable though.

Collectives™ on Stack Overflow

Creating new SQLite DBs with PDO

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related