Connection Strings Reference

»Writing a SQLite clone from scratch in C.«

Example step-by-step guide for introducing data model changes.

»Generate PlantUML ER diagram textual description from PostgreSQL tables«

The author makes an in-depth comparison between "push" and "pull" based query engines.

Based on the TOPDB Top Database index, this post gives an overview of the most widely used DBMS since 2006.

sq is a tool to inspect, query, join, import, and export data.

To support microservice-based development, Alibaba has now launched Fescar, an open source version of its Global Transaction Service solution to the problem of distributed transactions.

Automation and a little discipline allow better testing, shorter release cycles, and reduced business risk.

Many distributed storage systems achieve high data access throughput via partitioning and replication, each system with its own advantages and tradeoffs. In order to achieve high scalability, however, today’s systems generally reduce transactional support, disallowing single transactions from spanning multiple partitions. Calvin is a practical transaction scheduling and data replication layer that uses a deterministic ordering guarantee to significantly reduce the normally prohibitive contention costs associated with distributed transactions. Unlike previous deterministic database system prototypes, Calvin supports disk-based storage, scales near-linearly on a cluster of commodity machines, and has no single point of failure. By replicating transaction inputs rather than effects, Calvin is also able to support multiple consistency levels—including Paxosbased strong consistency across geographically distant replicas—at no cost to transactional throughput.