Post ATsZDmhVB95cbsBCgy by joeldrapper@ruby.social
 (DIR) More posts by joeldrapper@ruby.social
 (DIR) Post #ATsYJbZbMaETskhDJg by joeldrapper@ruby.social
       2023-03-22T09:53:24Z
       
       0 likes, 0 repeats
       
       Does anyone have book recommendations for SQLite?
       
 (DIR) Post #ATsYJcFQr3h1yUGcW8 by hansv@todon.nl
       2023-03-22T16:08:55Z
       
       0 likes, 0 repeats
       
       @joeldrapper maybe @simon has some tips.
       
 (DIR) Post #ATsYJcqIdzBRopW3yy by simon@fedi.simonwillison.net
       2023-03-22T16:10:16Z
       
       0 likes, 0 repeats
       
       @hansv @joeldrapper I don't think anyone has published a new SQLite book in quite a few years - the old books are still relevant because SQLite has excellent backwards compatibility, but I don't know if there are any that cover new features like window functions (or maybe even older stuff like CTEs)
       
 (DIR) Post #ATsYYDG62wxYocXQhM by simon@fedi.simonwillison.net
       2023-03-22T16:11:50Z
       
       0 likes, 0 repeats
       
       @hansv @joeldrapper most of what I know about SQLite is baked into my sqlite-utils libraru which has very thorough documentation: https://sqlite-utils.datasette.ioPlus I have a bunch of TIL posts: https://til.simonwillison.net/sqlite
       
 (DIR) Post #ATsZDmhVB95cbsBCgy by joeldrapper@ruby.social
       2023-03-22T16:17:24Z
       
       0 likes, 0 repeats
       
       @simon @hansv thank you. 🙏