# Database - General

Published articles for Database - General.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Postgres + ClickHouse Architectural Patterns

DevFeed: [Postgres + ClickHouse Architectural Patterns](<https://devfeed.tech/articles/postgres-clickhouse-architectural-patterns-19116.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgres-clickhouse-architectural-patterns/>)

Author: Agus Syafaat

Published: 2026-08-26T08:08:43Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Database](<https://devfeed.tech/topics/database.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>)

Tags: [acid](<https://devfeed.tech/tags/acid.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [continuous](<https://devfeed.tech/tags/continuous.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data-platforms](<https://devfeed.tech/tags/data-platforms.md>), [database](<https://devfeed.tech/tags/database.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [databases](<https://devfeed.tech/tags/databases.md>), [hybrid-operations](<https://devfeed.tech/tags/hybrid-operations.md>), [latency](<https://devfeed.tech/tags/latency.md>), [learning](<https://devfeed.tech/tags/learning.md>), [low-latency](<https://devfeed.tech/tags/low-latency.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [patterns](<https://devfeed.tech/tags/patterns.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [real-time-analytics](<https://devfeed.tech/tags/real-time-analytics.md>), [transaction](<https://devfeed.tech/tags/transaction.md>), [volumes](<https://devfeed.tech/tags/volumes.md>)

### AI overview

The excerpt presents PostgreSQL and ClickHouse as complementary databases: PostgreSQL remains the authoritative system for low-latency transactions, while ClickHouse handles large analytical queries that could strain production transaction performance. It describes continuous change data capture (CDC) synchronization as the connection between them, separating transactional and analytical workloads without complex ETL pipelines. The excerpt begins a real-time analytics pattern but cuts off before its implementation details.

### Source excerpt

The role of databases has shifted significantly as modern applications must deliver real-time analytics, dashboards, and machine learning alongside low-latency transaction processing. Handling these diverse demands with a single relational database has become unsustainable under growing data volumes. Consequently, organizations are adopting specialized database architectures where multiple engines work together based on their strengths, allowing [...] The post Postgres + ClickHouse Architectural Patterns appeared first on Severalnines.

## ClickHouse Schema Design and Data Modeling

DevFeed: [ClickHouse Schema Design and Data Modeling](<https://devfeed.tech/articles/clickhouse-schema-design-and-data-modeling-19112.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/clickhouse-schema-design-and-data-modeling/>)

Author: Agus Syafaat

Published: 2026-07-17T12:48:53Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [schema design](<https://devfeed.tech/topics/schema-design.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data-modeling](<https://devfeed.tech/topics/data-modeling.md>)

Tags: [announcement](<https://devfeed.tech/tags/announcement.md>), [article](<https://devfeed.tech/tags/article.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [concepts](<https://devfeed.tech/tags/concepts.md>), [core](<https://devfeed.tech/tags/core.md>), [cta](<https://devfeed.tech/tags/cta.md>), [data](<https://devfeed.tech/tags/data.md>), [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [database](<https://devfeed.tech/tags/database.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [design](<https://devfeed.tech/tags/design.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distribution](<https://devfeed.tech/tags/distribution.md>), [engine](<https://devfeed.tech/tags/engine.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [modeling](<https://devfeed.tech/tags/modeling.md>), [queries](<https://devfeed.tech/tags/queries.md>), [query](<https://devfeed.tech/tags/query.md>), [schema](<https://devfeed.tech/tags/schema.md>), [schema-design](<https://devfeed.tech/tags/schema-design.md>)

### AI overview

The excerpt explains ClickHouse's cluster table model: shards hold different horizontal slices of data, while replicas within a shard hold identical copies for fault tolerance. Local tables store each node's shard data; distributed tables store no data and route queries across shards, then collect and merge results. Schema changes must be applied to local tables on every node, with the distributed table definition kept in sync. The article frames schema design as an ongoing operational concern: poor decisions can contribute to slow queries, oversized partitions, and long-running mutations. The excerpt begins to discuss shard-key selection but cuts off before giving guidance.

### Source excerpt

Sometimes, we see ClickHouse queries that should normally complete in milliseconds take several seconds to finish or worse, time out entirely. When that happens, there is a good chance that the schema is the real culprit. The problem is often not the query itself, nor is it a hardware bottleneck. Instead, it can stem from [...] The post ClickHouse Schema Design and Data Modeling appeared first on Severalnines.

## Building a Modern Analytics Stack Around ClickHouse

DevFeed: [Building a Modern Analytics Stack Around ClickHouse](<https://devfeed.tech/articles/building-a-modern-analytics-stack-around-clickhouse-19109.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/building-a-modern-analytics-stack-around-clickhouse/>)

Author: Sebastian Insausti

Published: 2026-07-01T10:35:21Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [analytics stack](<https://devfeed.tech/topics/analytics-stack.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-stack](<https://devfeed.tech/tags/analytics-stack.md>), [apache](<https://devfeed.tech/tags/apache.md>), [apache-zookeeper](<https://devfeed.tech/tags/apache-zookeeper.md>), [application](<https://devfeed.tech/tags/application.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [batch](<https://devfeed.tech/tags/batch.md>), [caching](<https://devfeed.tech/tags/caching.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [column](<https://devfeed.tech/tags/column.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [cta](<https://devfeed.tech/tags/cta.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [databases](<https://devfeed.tech/tags/databases.md>), [i-o](<https://devfeed.tech/tags/i-o.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [olap](<https://devfeed.tech/tags/olap.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>), [reports](<https://devfeed.tech/tags/reports.md>), [stack](<https://devfeed.tech/tags/stack.md>)

### AI overview

ClickHouse is presented as an open-source columnar database for analytics that can take large event scans off PostgreSQL or MySQL, which are described as better suited to transactional records and point lookups. It stores columns separately, allowing queries to read only the fields they need, and uses vectorized execution to process values in batches. It can scale through sharding and replication, with a distributed table engine routing queries across shards and ZooKeeper or ClickHouse Keeper coordinating replicas. The excerpt advises starting with a single node and adding shards when query latency or ingest volume calls for it. ClickHouse is also described as supporting high-rate ingestion with data queryable almost immediately; the provided text cuts off while introducing the MergeTree engine family.

### Source excerpt

Historically, relational databases did double duty. The same PostgreSQL / MySQL instance that handled your application's writes also answered your business questions. A well-indexed schema, a few GROUP BY reports, done. And that works, right up until it doesn't: the reports get slower, the dashboards start eating the same I/O budget as the application; or, [...] The post Building a Modern Analytics Stack Around ClickHouse appeared first on Severalnines.

## Managing ClickHouse Resources in Multi-Tenant Environments

DevFeed: [Managing ClickHouse Resources in Multi-Tenant Environments](<https://devfeed.tech/articles/managing-clickhouse-resources-in-multi-tenant-environments-19115.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/managing-clickhouse-resources-in-multi-tenant-environments/>)

Author: Sucahyo Ardy Prasetiyo

Published: 2026-06-09T11:20:22Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [systems](<https://devfeed.tech/topics/systems.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cta](<https://devfeed.tech/tags/cta.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>)

### AI overview

This tutorial explains how to manage ClickHouse resources in multi-tenant environments. It discusses contention caused by shared CPU, memory, and disk resources, and describes identifying contention, scheduling workloads, and validating cluster stability.

### Source excerpt

When people first deploy ClickHouse, their initial reaction is often surprise. Queries that used to take minutes now finish in seconds. Dashboards feel instant even when reading billions of rows. To see this in action, here is a simple aggregation query running against a 200 million row events table: ClickHouse delivers exceptional speed, scanning 200 [...] The post Managing ClickHouse Resources in Multi-Tenant Environments appeared first on Severalnines.

## How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps

DevFeed: [How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps](<https://devfeed.tech/articles/how-to-migrate-from-sql-server-to-postgresql-ha-for-dockerized-apps-19114.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/how-to-migrate-from-sql-server-to-postgresql-ha-for-dockerized-apps/>)

Author: Jessie Baynas

Published: 2026-05-28T07:18:00Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [cloud-native](<https://devfeed.tech/tags/cloud-native.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [compatibility](<https://devfeed.tech/tags/compatibility.md>), [containerized](<https://devfeed.tech/tags/containerized.md>), [control](<https://devfeed.tech/tags/control.md>), [costs](<https://devfeed.tech/tags/costs.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [flexibility](<https://devfeed.tech/tags/flexibility.md>), [ha](<https://devfeed.tech/tags/ha.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [microsoft-sql-server](<https://devfeed.tech/tags/microsoft-sql-server.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [modernization](<https://devfeed.tech/tags/modernization.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operational-efficiency](<https://devfeed.tech/tags/operational-efficiency.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>)

### AI overview

The excerpt recommends separating schema conversion from bulk data movement when migrating SQL Server to PostgreSQL: use pgloader for schema conversion, BCP to export table data as CSV, and PostgreSQL COPY to import it. The article says this provides more control for troubleshooting and validation, particularly with large databases. The proposed environment uses Dockerized application services, PostgreSQL Streaming Replication, and ClusterControl for deployment, monitoring, and failover management. The excerpt does not provide the full migration procedure or discuss detailed limitations.

### Source excerpt

For many organizations, migrating from Microsoft SQL Server to PostgreSQL is no longer only about reducing licensing costs. The transition is often part of a broader modernization initiative focused on improving flexibility, scalability, and operational efficiency. PostgreSQL has evolved into one of the most mature open-source database platforms available today. It is widely adopted across [...] The post How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps appeared first on Severalnines.