The Definitive Guide to SQLite
by Mike Owens · first published 2006
71% recommend29% neutral
Why HN recommends it
Short, accessible introduction that takes readers from basic SELECT statements to an overview of SQLite internals; a primer on SQL for small application developers and a practical entry to the relational model.
Summarised by Claude from recommending comments
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
Mentions per year
What Hacker News says
Related books
2009–2023SQL puzzles & answers
Joe Celko
Recommended by 3 · mentioned by 43 recommend · 4 mention3 recommend · 43 recommend
2009–2020Joe Celko's SQL for Smarties
Joe Celko
Recommended by 10 · mentioned by 1310 recommend · 13 mention10 recommend · 1310 recommend
2009–2024An introduction to database systems
C. J. Date
Recommended by 14 · mentioned by 2314 recommend · 23 mention14 recommend · 2314 recommend
2009–2023The Manga Guide to Databases
Mana Takahashi, Mana Takahashi; Shōko Azuma; Ōmusha.
Recommended by 11 · mentioned by 1711 recommend · 17 mention11 recommend · 1711 recommend
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/...
on “Ask HN: Best Book for learning SQL?” ↗…voting here is, at best, ignored 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…
on “SQL Databases Are An Overapplied Solution” ↗Michael Owens's _The Definitive Guide to SQLite_ is good, too. It's a couple years old, but provides a good overview of both SQLite (standalone, its C API, and a couple wrappers) and the relational model. SQLite's biggest change since its publication…
on “Ask HN: I want to start learning about databases, where should I start?” ↗While not exactly what you're looking for, The Definitive Guide to SQLite takes you from writing a SELECT statement all the way to an overview of SQLite internals. O'Reilly also published a booklet called Inside SQLite that goes a bit deeper into the subject. I suggest SQLite…
on “My Most Important Project Was a Bytecode Interpreter” ↗I found the book "The Definitive Guide to SQLite" to also be an excellent primer on SQL, especially for small application developers. It doesn't cover the variants used in big databases, but handles the basics quite well, along with giving lots of…
on “Is there a K&R for SQL?” ↗…that point most popular stuff has at least one good published book on it explaining it in an accessible way. William S. Vincent's Django for Beginners, Robin Wieruch's Road to React, (a little older) The Definitive Guide to SQLite, and (a little heavier) Haskell Programming From First Principles are all excellent examples of this that I've read cover to cover. Maybe the only strange thing about my approach is that I generally…
on “Share Your Experience of Learning a New Library” ↗They are The Definitive Guide to SQLite by Mike Owens and Using SQLite by Jay A. Kreibich. I am quite sure they are more book than I needed, I only plumbed a fraction of SQLite's immense capabilities.
on “SQLite Is Serverless” ↗I love SQLite and am currently working on a project that makes extensive use of it. In the book "The Definitive Guide to SQLite" it says that SQLite can scale to 2TB of data Looking at the website it says An SQLite database is limited in size to 140 terabytes (247 bytes, 128 tibibytes). That's ludicrous. I wonder if anyone…
on “Appropriate Uses for SQLite” ↗