The Definitive Guide to SQLite

This record preserves its author, date and source link. Open HN to read the full context.

This record preserves its author, date and source link. Open HN to read the full context.

This record preserves its author, date and source link. Open HN to read the full context.

This record preserves its author, date and source link. Open HN to read the full context.

This record preserves its author, date and source link. Open HN to read the full context.

This record preserves its author, date and source link. Open HN to read the full context.

…gnored as noise that detracts from conversation. ObRelational: For people who want to learn about the relational model, two of the better presentations I've read are: 1. The Definitive Guide to SQLite by Mike Owens -- short, non-academic, theoretical enough to be useful. Focuses on SQLite, which is nice, because that way you don't take MySQL's flaws for granted. 2. An Introduction to Database Systems by C. J. Date -- academically thorough; it's a textbook, so the previous edition is pennies on the dollar. Mostly covers the relational model itself, rather than SQL, which is somewhat like comparing the pure untyped lambda calculus to Scheme. Once you understand the big ideas, though, everything else is just syntax and performance tuning (which are often implementation-specific anyway).

I actually recommend playing with sqlite. It's fast and easy to setup. You can work with it via command line or use a web browser plugin. I can also recommend Mike Owens' book Definitive Guide to SQLite http://www.amazon.com/Definitive-Guide-SQLite-Mike-Owens/dp/...