Been using SQLite for my Node project and have absolutely no idea what I'm doing. First time I'm using either so a crack at the documentation and a lot more tinkering should get me caught up. Any resources you recommend?
I have my own biases and particular knowledge (don't really like programming webshits) so, with that said, in your position, I would first dive into SQL. SQL is in itself incredibly useful for all kinds of things and the overall relational database concepts you'll learn apply even
outside of the SQL context, as with pandas
DataFrames. I used the 2nd edition of
Learning SQL from O'Reilly quite a few years ago, and there is a 3rd edition, but
Practical SQL from No Starch Press (now in its 2nd edition) looks very promising too. Either of these two books will train you on a SQL implementation more fully featured than SQLite, which is pretty stripped down. The former uses MySQL and the latter uses the somewhat heavier PostgreSQL, but as long as you have basic command line knowledge you can set up either without any real difficulty. Also you wouldn't have to read either in its entirety. I would say up to chapter 9 or 10 is adequate for
Learning SQL and up to at least chapter 9 in
Practical SQL after which you can pick and choose certain topics. (I would definitely learn subqueries, dates and times, and text formatting and matching). Then, when you use SQLite, which has simpler administration and a reduced set of features, it'll be like you're a Roman soldier who trained with a wooden sword heavier than the real thing.
