51 ms·
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 ju
by hudibras 12y ago
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.
- johnhess 12y agoI 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.
- ianamartin 12y agoI'd add to this that SQLite is a great choice for learning the basics of an orm like sqlalchemy.