Recent posts tagged database

Most teams think of Flyway only when they need to manage ongoing database schema changes. But what if your project already has a complete, stable schema and you’re only now introducing version control? Or what if you want to incorporate your schema i...

Introduction Yesterday, I went to a restaurant with my friends. We ordered some food, finished eating, and asked the waiter for the bill. While the waiter was preparing the bill, I started thinking about how the billing system works behind the sce...

A user scrolls through your feed. Page 1 ends with "Post 20". They tap "Next", and page 2 starts with... "Post 20" again. Another user pages through an admin table and never sees order #4817. It exists. It is in the database. It just never showed up...

If you are building a SaaS product for more than one customer, you will have to answer one early question: how do you separate each customer's data? The choice between a shared database and a database per tenant shapes security, cost, performance and...

What Are Write Concern and Read Concern? In MongoDB, write concern and read concern are configuration settings that specify the level of guarantee you require when saving or retrieving data across a distributed cluster. A write concern determines h...

A deployment can roll back cleanly while the database stays incompatible with the old application. Before shipping a schema change, check whether the previous release can still read and write the data that the new release creates. Consider a fiction...

Advanced SQL analytics for running a hospital database. Introduction Structured Query Language is essential and common in most industry sectors. In healthcare reporting, SQL plays a critical role in analytics. PostgreSQL lets data scientists take ...

A recoverable self-hosted n8n backup has four core parts: the database, the original encryption key, the deployment configuration and secrets, and any binary-data storage your executions still need. Back up the persistent .n8n volume even wh...

In software development, caching is the practice of storing frequently used data in a high-speed, temporary storage layer so future requests can be served faster. Caching strategies are the architectural patterns that dictate how your application coo...

!Abstract brand-toned data pathway backdrop for the billion-row SQL decision framework.https://unrivaled-starlight-d655be.netlify.app/blog/visuals/billion-row-sql-hero.png?v=2 A query that returns in 40 milliseconds on ten million rows can time out...

Data Modeling in Power BI Introduction At a time when data is rapidly generated by different activities ranging from experiments to business, more often do we get data in different formats and structures. The data may or may not be related dependi...

...

This is Part 2 of our technical series on building a high-speed, lightweight school marketplace. In Part 1: \Why We Ditched Frameworks for Vanilla JS & PWA,\11 we discussed how we optimized the frontend for budget mobile devices. Today, we look at th...

A lot of C/C++ developers build complex data structures as if database theory never happened. And then they spend months maintaining pointer contracts that a schema could have made obvious. Let’s take a graph structure as an example. A common patte...

There is a strange moment in every software system. At the beginning, the database feels almost too simple. There are a few tables. A handful of records. A couple of indexes. The queries are obvious. The relationships make sense. You know where a...

How a painful backend, broken assumptions, graph debugging, evidence failures, and one very long final day became CaseVera — an evidence-first fraud investigation agent built on TigerGraph. A fraud model can tell you that a transaction looks suspici...

Why Multi-Tenancy Matters Imagine you are building a SaaS application. You have 100 companies, but you don't want to deploy and maintain 100 separate applications. That's where Multi-Tenancy comes in. What is Multi-Tenancy? Multi-tenancy allow...