home garden / databases
- dope overview of different SQL joins
- SQL is a sneaky useful language. and doesn’t require much overhead to learn.
- the writer also seems to have a lot of sql and DB related posts so they’re probably a good resource if you’re interested in diving into DB world https://blog.moertel.com/posts/2024-08-23-sampling-with-sql.html
- i never thought about using SQL itself to sample datasets. that probably is very useful for speedy statistical analyses though. combine that with the in browser DuckDB tool and you can do some robust stuff without too much hassle
https://challahscript.com/what_i_wish_someone_told_me_about_postgres
- fun postgres tips, the swiss army knife of RDBMSs