Hacker News Reader

Is SQLite a good choice for learning SQL? Most of the SQL books out there use MySQL as the primary vehicle but it seems like overkill to install on my laptop just to run through a few examples from a textbook.

On the other hand, if SQLite's flavor of SQL is missing some important stuff (I have no idea what) then maybe I should stick with MySQL.

View on HN

I found it to be a great way to learn SQL.

As a rule of thumb, it should be fine if your goal is to learn the basics of SQL, and not-so-fine if you're looking to learn database administration.

I would not use it to learn how to alter tables, or even how to create and enforce a schema, as it doesn't do either quite like some of the other popular dbs out there.

I'd add to this that SQLite is a great choice for learning the basics of an orm like sqlalchemy.

Reply on news.ycombinator.com