small medium large xlarge

12 Apr 2009, 02:12
Charles Eckenroed (5 posts)

footnote 6 on page 147(book)/154(pdf) says:

bq. 6. You can save yourself some keystrokes on commands like these by creating a file named .sqlite3rc and putting it in your home directory. In that file, place two lines: .mode line and ATTACH DATABASE db/development.sqlite3 AS development.

The file name should be: .sqliterc and the database path needs to be quoted (because of the embedded punctuation) and end with a semi-colon.

For example, here is my .sqliterc file:

@.mode line@ @ATTACH DATABASE “db/development.sqlite3” AS development;@

You must be logged in to comment