In my first post about pgcollection, I introduced the collection type to address the challenge of migrating Oracle associative arrays keyed by strings to PostgreSQL. For integer-keyed associative...

To operationalize data projects, organizations need automated, orchestrated, end-to-end visibility across every stage of the data pipeline. Without a structured operationalization framework, even...

Our experience and new analysis suggest a handful of factors enable the companies that have outperformed the rest of the building materials industry since 2015.

© Laurenz Albe 2025 In a previous article, I recommended using bigint for sequence-generated primary keys (but I make an exception for lookup tables!). If you didn't heed that warning, you...

Unlock the secrets to reliable databases with primary and foreign keys! This beginner-friendly post uses engaging library metaphors and approachable SQL examples to show how keys keep your MySQL...

Cloud database security isn’t just a best practice—it's an absolute necessity. With sensitive data flowing into the cloud, protecting your business-critical assets is non-negotiable, and Oracle...

Costco’s chief information and digital officer details how technology leadership is expanding—as businesses increasingly rely on technology.

A work-around for partitioning MySQL tables with foreign keys is described in this article.

Done right, a robust hybrid cloud risk management strategy can provide elevated assurances around security, compliance and resilience. The post 3 keys to building a robust hybrid cloud risk...

It’s dangerous to go alone. Fly.io runs full-stack apps by transmuting Docker containers into Fly Machines: ultra-lightweight hardware-backed VMs. You can run all your dependencies on Fly.io, but...

TL;DR All existing API keys will continue working seamlessly. Grafana Terraform provider api_key resource has been removed in v3. Scripts or provisioning tools such as Terraform that provision...

A long time ago, I read in a medical book that One can learn about a system when things go wrong. So diseases are a good way to learn more about how the human body functions. That sentence stuck...

Relational databases provide one very essential functionality which is key to integrity, data quality and consistency: foreign keys. If you want to build a professional application that relies on...