https://ricardoanderegg.com/posts/ https://ricardoanderegg.com/posts/ A mix of tutorials and interesting things I learn or discover. Most of the posts involve

https://ricardoanderegg.com/posts/ 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/ 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/ 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-programs/ 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-filters-by-building-one/ 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-docker-tags/ https://ricardoanderegg.com/posts/git-push-deployments-docke...