How to access default Rails sqlite db?

ruby-on-rails ruby-on-rails-3 sqlite aptana
kostja picture kostja · Apr 16, 2012 · Viewed 65.5k times · Source

I would like to view the data in my DB while developing with Rails (actually in all 3 of them development, test and production). I have not touched the configs, so it should be easy, but I was not able to find any usable info.

I have no idea what the connection string could be or where to enter it, since Aptana (v.3) seems to lack the good old data source explorer view I know from Eclipse. Could someone point me into the right direction?

EDIT: I am working on linux - Mint 12

Answer

Gazler picture Gazler · Apr 16, 2012

You have neglected to mention the OS you are using.

One way is to use the sqlite3 command in your terminal.

sqlite3 db/development.sqlite3

However, for things like inspecting your rows, you would be better using a rails console.

rails c
> User.all # Where user is your model.

NOTE: Do not change your DB schema directly through sqlite3, something you may be used to if you come from a different web stack background. This is because the next time you run the migrations, the state will be different to what rails expects.

Related questions

rails install pg - Can't find the 'libpq-fe.h header

$ sudo bundle install Result Fetching gem metadata from https://rubygems.org/........... Fetching gem metadata from https://rubygems.org/.. Using rake (0.9.2.2) Using i18n (0.6.1) Using multi_json (1.3.6) Using activesupport (3.2.8) Using builder (3.0.4) Using activemodel (3.2.8) Using erubis (2.7.0) Using journey (1.0.4) Using rack (1.4.1) Using rack-cache (1.2) …

Read More
$ bundle exec rake db:reset command raising couldn't drop db/development.sqlite3

I tried to run $ bundle exec rake db:reset and found the following on console Couldn't drop db/development.sqlite3 : #<Errno::EACCES: Permission denied - c:/sample_app/db/development.sqlite3> db/development.sqlite3 already exists -- create_…

Read More
Can't get uniqueness validation test pass with shoulda matcher

I have a shoulda matcher in my avatar_parts_spec.rb and I can't get it pass: Test: require 'rails_helper' RSpec.describe AvatarPart, :type => :model do it { should validate_presence_of(:name) } it { should validate_presence_of(:type) } …

Read More