#194 — March 9, 2018 |
Database Weekly |
Anna: A Key-Value Store For Any Scale — A look at an interesting key/value database out of Berkeley promising “phenomenal speed and buttery smooth scaling” and an “unprecedented range of consistency guarantees”. Joseph M. Hellerstein |
Translate SQL From One Dialect to Another — While SQL has been standardized numerous times, its implementation does tend to vary, so this tool provides an interesting way to see the differences on your own queries. Lukas Eder |
MongoDB Tutorial Series: How to Develop an Effective Indexing Strategy — Performance tuning a dark art? Not with us. Grab your free MongoDB tutorial on high-speed indexing strategies from Studio 3T. Learn the fast way how you can prevent slow and long-running queries. Studio 3T sponsor |
Distributed Transactions and Why You Should Care — An interesting explanation of what distributed transactions are about, why they matter, and some techniques that make them possible. Pritam Roy |
MarketStore, a Financial Time-Series Database, Now Open Source — A database server optimized for financial time-series data written in Go. GitHub repo. Alpaca |
Hops Hadoop: Hadoop, but with Distributed Metadata — A new distribution of Hadoop that adds a scale-out distributed metadata layer to remove the metadata bottleneck in HDFS. GitHub repo. Logical Clocks AB |
|
A Comparison of Window Functions and CTEs in MySQL vs MariaDB — How two new technologies compare in the MySQL family of databases. Shree Nair |
Choosing a MySQL High Availability Solution Percona sponsor |
How the Ties.DB Database Uses Blockchain Technology insideBIGDATA |
Postgres 10: A Great New Version for a Great Database Reuven M. Lerner |
db.vim: A Modern Database Interface for Vim — A Vim plugin for interacting with MongoDB, MySQL, Postgres, Redis and SQLite. You can also build your own adapters. Tim Pope |
▶ Let's Talk Database Optimizers — A brief 15-minute talk from Vicentiu Ciorbaru, a software engineer at the MariaDB Foundation, looking at new developments in optimizers. FOSDEM 2018 |