Chillibear
A place for notes about stuff

Database

Simple Oracle command line

Since I’m forever forgetting my Oracle command line stuff, a note to myself for the most common things: Logging in sqlplus database_user@host Will then be prompted for the password. Oracle being more user orientated than databases like MySQL where the separation from user and database is very distinct. Exporting to a file Saving the output [...]

Rails test database migrations

One problem it took me ages to spot was that my test database wasn’t up to date with my migrations and therefore my tests kept failing for no obvious reason! So remember to: rake db:test:prepare To ensure the test database is up to date with migrations, etc.