A personal reflection on Diwali. The festival of lights, the world I grew up in, and choosing light in darker times.

A thought experiment in building Parquet-like columnar table on S3 with row-level deletes using conditional writes, tombstone files, and a single-object transaction pointer.

Eliminating PostgreSQL catalog traversal overhead with local partition calculations for up to 20x faster hash partition queries.

If AI learns from human intelligence, can it ever truly transcend its origins? Is AGI a technical milestone or philosophical mirage?

When LLM models generates clean, professional-looking code, it's tempting to stop exploring alternatives. But therein lies the risks that comes with premature closure. So what is premature closure?

At Tines, we migrated our ECS services from Fargate to EC2 to improve performance, reliability, and flexibility. Here’s what we learned.

At Tines, we have two types of on-call: daytime and out-of-hours. In this blog, we explain the daytime on-call shift, its pros and cons, and how we make it easier by using Tines.

How a seemingly straightforward DELETE query using a CTE and LIMIT returned more rows than expected due to query planner optimization.

Determine the target partition index for an integer key according to PostgreSQL's default hash strategy, without querying the database - shayonj/pg_hash_func

How to be old, for young people.

Safely leverage PostgreSQL's asynchronous commit for significant performance gains

Safely leverage PostgreSQL's asynchronous commit for significant performance gains

While these tools boost productivity, they're not a replacement for critical thinking. Taking the time to understand why something works (or breaks) and building strong mental models isn't just busy w...

Practical scaling strategies for application developers who don't have a dedicated database team

Just wanted to put this out there - cross cloud migration is validated. It is definitely possible to migrate from AWS >> Azure or vice versa, the only minor preparation step is that you need to ens...

pg_flo is a powerful PostgreSQL data replication tool that enables real-time streaming, table routing, data transformation, and secure data masking between databases.

When dealing with very large PostgreSQL tables (we're talking 15TB+), sometimes routine maintenance like archiving very old data can become surprisingly challenging

pg_flo is a powerful PostgreSQL data replication tool that enables real-time streaming, table routing, data transformation, and secure data masking between databases.

Easiest way to move and transform data between PostgreSQL databases - shayonj/pg_flo