Where is my SQLite database?
Posted
by Brian Ramsay
on Stack Overflow
See other posts from Stack Overflow
or by Brian Ramsay
Published on 2010-04-24T12:48:13Z
Indexed on
2010/04/24
12:53 UTC
Read the original article
Hit count: 506
I have installed SQLite version 3 into a non-standard location on my dreamhost user account. I compiled it and installed it just fine, and it works with $db=new SQLiteDatabase("db.foont");
I can create tables and insert and read data with the SQLiteDatabase object just fine. However, I want to use PDO.
My problem is that PDO requires an absolute path to the database specified in the connection. e.g., 'sqlite:/path/to/db.sq3'
a) this is dumb - if the other object can figure out where the db is without an absolute path why can't PDO's sqlite driver - but that's not my question.
b) where the heck is my database being stored? I can't find it anywhere in my user filesystem, and I'm pretty sure I don't have access to anything else.
© Stack Overflow or respective owner