---
title: "A tool to translate SQL queries between dialects, and some other great releases"
publication: "DB Weekly"
issue: 194
published_at: "2018-03-09"
canonical_url: "https://dbweekly.com/issues/194"
---

This week's database news       

#194 — March 9, 2018 

[Read on the Web](https://dbweekly.com/issues/194)   

Database Weekly  

[Anna: A Key-Value Store For Any Scale](https://databeta.wordpress.com/2018/03/09/anna-kvs/) — 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](https://www.jooq.org/translate/) — 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   [![\](https://copm.s3.amazonaws.com/f3668ebb.png)](https://studio3t.com/whats-new/mongodb-index-strategy/?utm_source=newsletter&utm_medium=dbweekly&utm_campaign=march2018) 

[MongoDB Tutorial Series: How to Develop an Effective Indexing Strategy](https://studio3t.com/whats-new/mongodb-index-strategy/?utm_source=newsletter&utm_medium=dbweekly&utm_campaign=march2018) — 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](https://towardsdatascience.com/distributed-transactions-and-why-you-should-care-116b6da8d72) — 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](https://hackernoon.com/marketstore-the-financial-time-series-database-is-now-open-source-fd04343f439) — A database server optimized for financial time-series data written in Go. [GitHub repo.](https://github.com/alpacahq/marketstore) 

Alpaca   

[Hops Hadoop: Hadoop, but with Distributed Metadata](http://www.logicalclocks.com/introducing-hops-hadoop/) — A new distribution of Hadoop that adds a scale-out distributed metadata layer to remove the metadata bottleneck in HDFS. [GitHub repo.](https://github.com/hopshadoop/hops) 

Logical Clocks AB     

**_And a few news items.._**  

[Confluent Adds KSQL Support to Kafka Platform](https://www.datanami.com/2018/03/07/confluent-adds-ksql-support-to-new-kafka-platform/) 

Datanami   

[Postgres in The Cloud Front and Center.
Register Now — Boston, June 5 & 6](http://postgresvision.com/) 

Postgres Vision 2018 sponsor   

[Ben Lorica on What to Expect at the Strata Data Conference](https://www.datanami.com/2018/03/05/ben-lorica-expect-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](https://www.ibm.com/blogs/research/2018/03/geospatial-temporal-insights/) — For capturing the value of place and time with geospatial-temporal insights. 

IBM Research   

[Introducing SQL Information Protection for Azure SQL Database](https://azure.microsoft.com/en-us/blog/introducing-sql-information-protection-for-azure-sql-database-and-on-premises-sql-server/) — 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](http://blog.sqlyog.com/window-functions-common-table-expressions-mysql-8-mariadb/) — How two new technologies compare in the MySQL family of databases. 

Shree Nair   

[Choosing a MySQL High Availability Solution](https://learn.percona.com/cp-choosing-mysql-high-availability-solution-recording) 

Percona sponsor   

[How the Ties.DB Database Uses Blockchain Technology](https://insidebigdata.com/2018/03/04/ties-db-database-uses-blockchain-technology/) 

insideBIGDATA   

[Postgres 10: A Great New Version for a Great Database](http://www.linuxjournal.com/content/postgresql-10-great-new-version-great-database) 

Reuven M. Lerner   

[db.vim: A Modern Database Interface for Vim](https://github.com/tpope/vim-db) — A Vim plugin for interacting with MongoDB, MySQL, Postgres, Redis and SQLite. You can also build your own adapters. 

Tim Pope   [![\](https://res.cloudinary.com/cpress/image/upload/w_800/vps0mnulc3kvt6pkklot.jpg)](https://www.youtube.com/watch?v=DO3wO7OYkwU) 

Vicentiu Ciorbaru talking about query optimization   

▶[Let's Talk Database Optimizers](https://www.youtube.com/watch?v=DO3wO7OYkwU) — 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](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom