I'm trying to find the sqlite database file that rails creates.
Sorry if this is a dumb question but which folder is this file stored in?
I've looked in all of the folders in my Rails project and can't find it.
My database.yml
:
development:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000
The database configuration file is in config/database. yml . If you're using sqlite , the database itself is in db/ folder. You may want to read Getting Started with Rails for more info.
The Android SDK provides dedicated APIs that allow developers to use SQLite databases in their applications. The SQLite files are generally stored on the internal storage under /data/data/<packageName>/databases.
There should be a database file with sqlite extension on db directory of the app. On DB Browser, select Open Database option and choose that file and you should be able to view the data. Save this answer.
Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
It's in RAILS_ROOT/db/development.sqlite3
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With