When applications reach a certain scale, the database quickly becomes a non-negotiable consideration. Strange issues start to appear when storing millions of records and processing thousands of transactions per second. This post offers a few quick pointers for addressing issues as they arise.
While a rake task or background job works fine for most data imports, they become prohibitively slow when dealing with millions of rows. PostgreSQL’s \copy command can handle these large datasets orders of magnitude faster than application-level approaches.
Iterate faster by using vim, tmux, and vim-slime to write and debug your code in a Read, Eval, Print Loop (REPL).
I read the book Shape Up by Ryan Singer, taking extensive notes about the methodology and assessing its viability for adoption by product teams.
Claude 3 is impressive in a lot of ways, and I enjoyed experimenting with it. The latest release has shown some interesting capabilities and tendencies, which I explore in this post.
A personal reflection on how I stopped caring about traditional metrics like grades and started prioritizing personal growth through challenging experiences.
Discover how polymorphic relationships in ActiveRecord can elegantly separate billing accounts from collaborative groups - a practical guide based on real-world implementation.