Vim & Vision

You searched for articles tagged with SQLite.

Make Firefox Faster? Permalink

SQLite, OSX, Firefox Added more than a year ago and last edited less than a year ago

The SQLite doco says that:

The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure.

Firefox uses sqlite. On OSX, try this:

$ cd ~/Library/Application\ Support/Firefox/Profiles/
$ for f in */*.sqlite; do sqlite3 $f 'vacuum'; done

This requires having the sqlite client installed, and firefox should NOT be running.

Advantage of Using SQLite Permalink

Git, SQLite Added more than a year ago and last edited more than a year ago

I am using SQLite 3 as the storage backend for this blog. I am finding that the major advantage to this is that your DB gets carried around in your codebase.

If I deploy, make some changes to production (eg. add some blog entries) then I can just do this from my production shell:

$ git add .
$ git commit -m "* DB from production"
$ git push

... and then this in my development environment:

$ git pull

and my development environment has the updated production database! Nice.

Now, because I used git add ., the codebase will also include all the UGC, including uploaded images and such. Very nice.

(Nothing Older) ... (Nothing Newer)

Colophon

Django Python 960.gs Git Vim NetBSD Nginx

The Author

The author is a software engineer living in Australia. He sux at guitar, loves camping, doesn't like cake, does like coffee and is a lazy home brewer.

Links

ChoppingBoard, Project365, RageQuit

Vim & Vision

Make Firefox Faster? Permalink

Advantage of Using SQLite Permalink

Colophon

The Author

Meta

Recent Entries

Links

♥ Actors/Artists/Characters