Love this https://antonz.org/sqlite-is-not-a-toy-database/

it's a really solid piece of software. I've been training a few people in a public institution to migrate their messy Excel workflows to SQLite + DB Browser. makes for a far more maintainable setup instead of the nightmarish

report_2020_final_v3.xlsx

files

yeah, it’s pretty poweful

If you don’t already follow Simon Willison (Co-Creator of Django Framework) - he is working on https://docs.datasette.io/en/stable/ which uses sqlite a lot - since allmost all applications create sqlite files. He explores a lot of advanced sqlite concepts https://simonwillison.net/2021/Feb/21/cross-database-queries/ Has a library/framework to get data in and out of sqlite https://sqlite-utils.datasette.io/en/stable/ This is what I am super curious about - leveraging my personal data: https://simonwillison.net/2020/Nov/14/personal-data-warehouses/ https://dogsheep.github.io/

I follow him on twitter - been interesting to see the progress!