Bookmarks (27) clear filters

TiDB 4.0 Released: A Hybrid, Open Source HTAP Database — TiDB is an elastic, real-time Hybrid Transactional/Analytical Processing (HTAP) database built in Go(lang) that can act like a traditional relational database, a NoSQL database, or an analytical database all out of one box.

XgeneCloud: Instant REST and GraphQL APIs on any Database — Where ‘any’ is one of MySQL, Postgres, MsSQL, SQLite, or MariaDB :-) There’s quite a lot of pieces to this and they seem to be forming a company around the tech, but it’s open source nonetheless.

TiDB 4.0: A Peek into the Future of Databases? — Everyone who’s building a database system thinks their approach is the future and PingCAP are no different proclaiming their TiDB 4.0 release candidate as “the prototype of what the future database looks like.” The core idea is that databases will continue to get more ‘intelligent’ in scaling, scheduling and adapting to unpredictable workloads.

How Container Networking Affects Database Performance — Networking has an outsized impact on database performance in most Kubernetes environments and Percona set out to run some benchmarks measuring database throughput vs network bandwidth using numerous Kubernetes container networking plugins.

Choosing the Right Databases for Shopee's Applications — It’s worth noting this article is hosted by PingCAP, creators of TiDB, but beyond that it’s a look at the process of choosing which databases best suit your use cases by two engineers at a large Asian e-commerce platform (Shopee). Unsurprisingly, TiDB features heavily here, but also Redis and MySQL.

usql: A Universal CLI for Databases — A CLI tool (written in Go) for working with Postgres, SQL Server, MySQL, SQLite3, RedShift, CockroachDB, Cassandra, and many more. This feels a bit like a database Swiss Army knife.

A Hidden Gem in MySQL: MyRocks — MyRocks is an alternative RocksDB/LevelDB-based storage engine available in MySQL and considered “a hidden gem” by the author.

Using SQL's EXISTS and NOT EXISTS — EXISTS has been part of the SQL standard since SQL:86 but it’s frequently underused.

Advanced DB Automation & Monitoring with the New ClusterControl 1.7.5 — Full Lifecycle Database Management - Now featuring full support for PostgreSQL 12, MongoDB 4.2 & MySQL 8.

tbls: A CI-Friendly Tool for Documenting Databases — Document a database automatically in GitHub Friendly Markdown format. By default you get documentation covering columns, indexes, relations, and other schema details. Written in Go.

A Beginner's Guide to SQL's CROSS JOIN — CROSS JOIN basically lets you get the Cartesian product of two sets (i.e. all the combinations of pairs of items across sets) and here it’s used to create a deck of cards and then some hands of cards.

Why a Game Company Chose a Distributed SQL Database Alongside MySQL — Yes, this is a TiDB case study, but it’s interesting to see why a company chose it over other MySQL-based and NewSQL storage solutions.

TiDB in the Browser: Running a Go-Based Database on WebAssembly — An interesting demo. If a database like TiDB written in Go can run in the browser, what about other complex Go apps or other database systems? SQLite is another database that is easily compiled to WebAssembly.

A Beginner's Guide to Database Deadlocks — Learn how deadlocks occur in a relational database system, and how Oracle, SQL Server, PostgreSQL, or MySQL recover from a deadlock situation.

An SQL Injection Tutorial for Beginners — This is not a tutorial for you to follow but more a look at what hackers will attempt to do to your systems, if you let them. The techniques used are sneaky and interesting.