A tool to translate SQL queries between dialects, and some other great releases

This week's database news

#194 — March 9, 2018 Read on the Web 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". It's only an academic prototype for now, but a new version called Bedrock is underway and will, eventually, be open sourced. When it is, we'll let you know. 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 And a few news items.. Confluent Adds KSQL Support to Kafka Platform Datanami Postgres in The Cloud Front and Center. Register Now — Boston, June 5 & 6 Postgres Vision 2018 sponsor Ben Lorica on What to Expect at the Strata Data Conference — The popular data-oriented O'Reilly conference is back in San Jose this month. Themes will include the growth of Spark, machine learning, and privacy and ethics. Datanami IBM's Experimental Geospatial Analytics Service — For capturing the value of place and time with geospatial-temporal insights. IBM Research Introducing SQL Information Protection for Azure SQL Database — Advanced capabilities for discovering, classifying, labeling, and protecting sensitive data in your databases. Microsoft 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 Vicentiu Ciorbaru talking about query optimization ▶  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

A Cooperpress publication. Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom