Location of Sqlite databases in OSX

Question

Im learning Ruby on Rails 3 and would like to see the db structures created by various Scaffold commands in Sqlite3 in order to understand more the process.

In OSX Snow Leopard, entering:

which sqlite3

yields:

"/usr/local/bin/sqlite3"

However cant seem to find the databases! Pointing to that location merely yields the following error message:

connection failed. file is encrypted or is not a database

To view the dbs im using:

Navicat for Sqlite

anyone enlighten me where the dbs actually reside? "/usr/local/bin/sqlite3" seems to be an symlink to: /usr/local/Cellar/sqlite/3.7.10/bin/sqlite3s

`which` tells you where the binary is, nothing of configuration or data. — Reactormonk, Apr 26 '12 at 08:50

score 12 · Answer 1 · edited Apr 26 '12 at 08:48

12

SQLite is actually serverless, so the DB files by default reside in your rails directory.

For example:

/db/development.sqlite3

You can check where all your sqlite environment databases are on config/database.yml

edited Apr 26 '12 at 08:48

Andión

1,103
15
26

answered Apr 26 '12 at 00:42

Alex Marchant

2,490
27
49

I'd add that you should check out 'Base' to crack open the .sqlite3 file and browse / edit it – Kevin Davis Apr 26 '12 at 01:40

Location of Sqlite databases in OSX

1 Answers1