# data-modelling Published articles for data-modelling. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## When JSONB columns create schema, consistency, and performance problems DevFeed: [When JSONB columns create schema, consistency, and performance problems]() Original publisher: [Read original article]() Author: hello@ankit-rana.com Published: 2026-09-01T00:00:00Z Content type: article Language: en Sources: [Ankit Rana | Mechanical Sympathy]() Topics: [data](), [Structured-data](), [JSON]() Tags: [data-modelling](), [indexing](), [jsonb](), [migration](), [outage](), [postgres](), [postgresql](), [query](), [schema](), [schema-design](), [toast]() ### AI overview The article explains why using JSONB to avoid recurring migrations can create hidden schema and data-consistency problems. It discusses runtime failures from inconsistent keys and types, difficulty identifying dependencies across consumers, and the storage and update costs of large PostgreSQL JSONB documents. ### Source excerpt JSONB is a good fit for genuinely open-ended data and a poor one for schema you did not want to commit to yet. Without a schema there is no NOT NULL, no type, no foreign key and no way to know which keys are load bearing, so every read becomes a parse and a cast that can fail at runtime. Large documents are stored out of line and compressed, which means reading one key can require fetching and decompressing the whole document, and updating one key rewrites all of it. ## Soft deletes affect database constraints, indexes, and application queries DevFeed: [Soft deletes affect database constraints, indexes, and application queries]() Original publisher: [Read original article]() Author: hello@ankit-rana.com Published: 2026-08-20T00:00:00Z Content type: opinion Language: en Sources: [Ankit Rana | Mechanical Sympathy]() Topics: [data-processing](), [Database](), [MySQL]() Tags: [data-modelling](), [database-design](), [foreign-keys](), [indexes](), [indexing](), [mysql](), [orm](), [postgresql](), [predicate](), [schema](), [schema-design](), [soft-delete]() ### AI overview The article explains how soft deletion affects database design beyond adding a deleted_at column. It discusses duplicate-key failures, foreign-key behavior, queries that may return deleted rows, and index inefficiency, noting that PostgreSQL partial indexes help while MySQL requires a workaround. ### Source excerpt A deleted_at column turns every future query into a conditional one, and the cost is not the extra predicate. Unique constraints stop working because the deleted row still occupies the key, foreign keys start pointing at rows the application considers gone, and any query written by someone who does not know about the column silently returns deleted data. Soft delete is a data lifecycle decision, and treating it as a boolean column is what makes it expensive. ## A quick introduction to data modeling in real world applications DevFeed: [A quick introduction to data modeling in real world applications]() Original publisher: [Read original article]() Author: Pranshu Raj Published: 2025-04-13T15:22:00Z Content type: tutorial Language: en Sources: [Pranshu Raj - blog on backend systems, performance and sidequests]() Topics: [data-modeling](), [data-architecture](), [Databases](), [MongoDB]() Tags: [data-modeling](), [data-modelling](), [database](), [mongodb](), [relationships](), [schema]() ### AI overview An introductory tutorial on data modeling: identifying relevant entities, attributes, relationships, application requirements, and workload before designing a schema. It contrasts relational tables with document-database collections using Postgres and MongoDB as examples. ### Source excerpt What data modeling is, why it's so useful, how can we do it effectively to get the best results for our use case.