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: 485

Filed under:
|
|
|

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

Related posts about php

Related posts about pdo