SQLite Settings

[FabianoLothor]

In one of his interviews @dhh mentioned that while working on Campfire he discovered a lot of SQLite nuances and settings that could be used to drastically enhance the performance of the database in comparison with its default settings.

Is there any article or alternative source discussing this settings and what a modern application using SQLite should be using in terms of configuration?

• What enable/disable?
• Which kind of tweaks should be made?

[dhh]

All these tweaks have been baked into Rails, so they're automatically being used here.

[FabianoLothor]

I know they are being used by Campfire's DB, though I was wondering if there is any article where I could read and learn what are the "good, bad and ugly" things on SQLite defaults from your point of view.

[akshayKhot]

I believe the Rails SQLite3 adapter would be a great starting point to learn about the best practices.