#205 — May 25, 2018
Database Weekly
MariaDB TX 3.0: An Oracle-Compatible 'Enterprise Open Source' Database — A major release from MariaDB, the company originally organized around a fork of MySQL. TX 3.0 brings an Oracle-compatible open source database to the enterprise, including temporal features. MariaDB’s goal is to offer an open source database existing Oracle/Microsoft/IBM customers can migrate to without giving up features. The Register has a nice write up too.
Shane Johnson (MariaDB)
PostgreSQL 11 Beta 1 Released — Introduces SQL stored procedures, JIT compilation for queries, and major improvements to partitioning and parallelism. For a bulleted list of the new features, see the draft release notes.
PostgreSQL Global Development Group
Get Optimised MongoDB Query Performance with Studio 3T — Read the latest article in our new tutorial series on MongoDB performance with a piece on the powerful Profiler, and also discover how the explain method can be an indispensable tool to improve queries and commands.
Studio 3T sponsor
First Release Candidate of MongoDB 4.0 Released — The first release candidate of MongoDB 4.0 is here for testing with the headline feature being support for multi-document ACID transactions, a huge step forward for the popular NoSQL database. P.S. We have a MongoDB newsletter if you’re interested :-)
Kelsey Schubert
An Introduction to Redis Streams — Streams are a powerful new data type coming to Redis in version 5 (first RC expected next week).
Redis Official Documentation
Understanding Deadlocks in MySQL and Postgres — A look at what deadlocks are, why they happen, and some suggestions on how to manage them.
Sebastian Insausti
Preparing Your Multi-Tenant App for Scale — Three key steps worth taking to ensure you won’t waste time when/if your database needs to scale.
Craig Kerstiens
Free Webinar: Migrating to Galera Cluster for MySQL & MariaDB — Join us May 29 to learn how to turn your MySQL instances into a clustered HA solution.
Severalnines sponsor
Simple Tips for PostgreSQL Query Optimization — "How to speed up your database performance 100x" Well, some queries at least.
Pavel Tiunov
Mapping Oracle Datatypes to PostgreSQL — A table to help you map Oracle datatypes to Postgres ones.
Hans-Jürgen Schönig
Looking Under The Hood of Eventbrite's Data Pipeline
Ed Presz (Eventbrite)
Datasette, an Instant Web UI and JSON API for SQLite Data, Gains 'Facets' — Faceted navigation brings a lot of new ways to explore data through this fantastic tool.
Simon Willison
Linux Cloud Hosting Starting at 1GB of RAM for 5ドル/mo
Linode Cloud Hosting sponsor