Comment by polyrand

https://ricardoanderegg.com/posts/

A mix of tutorials and interesting things I learn or discover. Most of the posts involve Python, SQLite or both.

Some of my favourite posts.

- Extending SQLite with Rust. The basics of writing a SQLite extension in Rust.

https://ricardoanderegg.com/posts/extending-sqlite-with-rust...

- Building a remote SQLite explorer. TL;DR: SSH tricks to turn SQLite into a networked DB.

https://ricardoanderegg.com/posts/sqlite-remote-explorer-gui...

- Using SQLite for logging and ad-hoc profiling (SQLite is a powerful JSON database!)

https://ricardoanderegg.com/posts/sqlite-logging-profiling-p...

- Learning about Bloom Filters by creating one. There are a ton of posts about implementing a bloom filter, but it was super fun to write one from scratch.

https://ricardoanderegg.com/posts/understanding-bloom-filter...

And my favourite one:

- Heroku-style deployments with Docker and git tags. I tried to create a deployment system where I could just `git push production`. It covers a bit of everything, git, docker, Caddy, blue-green deployments, git hooks, curl, etc.

https://ricardoanderegg.com/posts/git-push-deployments-docke...