---
title: "#199: An Introduction to EdgeDB"
publication: "DB Weekly"
issue: 199
published_at: "2018-04-13"
canonical_url: "https://dbweekly.com/issues/199"
---

This week's database news       

#199 — April 13, 2018 

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

Database Weekly  

[EdgeDB: A New Beginning](https://edgedb.com/blog/edgedb-a-new-beginning/) — An introduction to EdgeDB, a new open-source object-relational database, which will have its first public tecnhology preview in a few weeks. 

Yury Selivanov and Elvis Pranskevichus   

[When Using Bind Variables Isn't Enough: Dynamic 'IN' Lists](https://blog.jooq.org/2018/04/13/when-using-bind-variables-is-not-enough-dynamic-in-lists/) — Using bind variables is nearly always a good idea when working with SQL but sometimes they don’t always hit the mark, as demonstrated here. 

Lukas Eder   [![\](https://copm.s3.amazonaws.com/107cab3d.png)](https://learn.percona.com/cp-ebook-practical-mysql-performance-optimization-section-3) 

[Learn MySQL Tuning From the Experts with Percona’s eBook Series](https://learn.percona.com/cp-ebook-practical-mysql-performance-optimization-section-3) — With direction from the experts at Percona, you will be empowered to tune your MySQL settings and parameters to improve application response time and optimize overall database performance. 

Percona sponsor   

[GPU Databases Are Coming of Age](http://www.zdnet.com/article/gpu-databases-are-coming-of-age/) — GPUs are powering a new generation of databases. What’s so special about them and can they come into their own? 

ZDNet   

[My Favorite Postgres Queries and Why They Matter](https://severalnines.com/blog/my-favorite-postgresql-queries-and-why-they-matter) — An interesting combination of queries the author has found to be interesting/engaging to explore, study, and learn from. 

Joshua Otwell   

[Things You Cannot Say on Facebook, SQL Edition](http://blog.koehntopp.info/index.php/3122-things-you-cannot-say-on-facebook-sql-edition/) — If you want to share SQL queries over Facebook at Work, you might encounter problems. 

Kristian Köhntopp   

[Fast-Paced Authoritative MMO Data-Models](https://hackernoon.com/authoritative-mmo-data-models-5dc4c1aa30fa) — A look at state synchronization across connected virtual-worlds which moves into explaining why [Yugabyte](https://github.com/YugaByte/yugabyte-db) is a good choice for the task. 

Pritam Roy (Yugabyte)  

📢 News, Articles and Tutorials  

[Apache Hadoop 3.1.0 Released](https://blogs.apache.org/hadoop/entry/announce-apache-hadoop-3-1) 

Apache Foundation   

[Convince Your Boss to Send You to Postgres Vision in Boston](http://postgresvision.com/) — Get your justification letter and register today. 

Postgres Vision 2018 sponsor   

[Why SQL Bind Variables are Important for Performance](https://blog.jooq.org/2018/04/12/why-sql-bind-variables-are-important-for-performance/) 

Lukas Eder   

[Full Text Searching Linux Man Pages with Elasticsearch and Ruby](https://iridakos.com/tutorials/2018/04/12/elasticsearch-linux-man-pages) 

Lazarus Lazaridis   

[Garbage Collection Tuning for Apache Cassandra](http://thelastpickle.com/blog/2018/04/11/gc-tuning.html) 

Jon Haddad   

[Whitepaper: Design Highly Available Open Source Database Environments](https://severalnines.com/resources/whitepapers/how-design-highly-available-open-source-database-environments?utm_campaign=Infrastructure_Campaign_APR_2018&utm_content=db_weekly&utm_medium=Paid_Search&utm_source=banner) 

Severalnines sponsor   

[The Cure for Chaos: Automating Your Data Pipeline](https://www.datanami.com/2018/04/12/the-cure-for-chaos-automating-your-data-pipeline/) 

Datanami   

[The 'Ultimate' Postgres vs MySQL Blog Post](https://di.nmfay.com/postgres-vs-mysql) 

Dian M Fay  

🛠 Code and Tools  

[TextQL: Execute SQL Against Structured Text Like CSV or TSV](https://github.com/dinedal/textql) — Under the hood it pulls in a CSV to SQLite and runs queries against that. 

Paul Bergeron   

[Updated SQL Server Extension for Visual Studio Code](https://blogs.technet.microsoft.com/dataplatforminsider/2018/04/10/celebrating-1m-installations-milestone-for-mssql-extension-for-vs-code-with-another-update/) — Turns VS Code into a powerful T-SQL development environment. It’s also celebrating 1 million installs overall. 

Microsoft   

[OmniDB 2.7 Released: A Browser-Based Database Management Tool](https://www.2ndquadrant.com/en/about/news/omnidb-27-released-now-supporting-mysql-and-mariadb-databases-postgresql-graphic-interface-management-tool/) — Originally just for Postgres, MySQL, MariaDB, and Oracle support has been introduced. 

2ndQuadrant   

[js-mysql: Execute JavaScript Within SQL Queries on MySQL](https://github.com/ayoubserti/js-mysql) — A shared library you can pull into MySQL at run-time to execute JavaScript from queries. 

Ayoub Serti   

[IOWOW: A C11 Skiplist-Based Persistent Key/Value Storage Engine](http://iowow.io/) 

Softmotions Ltd   

[Hazelcast Jet 0.6: The Embeddable, Stream and Batch Processing Engine](https://blog.hazelcast.com/announcing-jet-0-6/) — Embeds the Hazelcast In-Memory Data Grid for high performance distributed data processing on the JVM. 

Can Gencer   

[Redi/S: A Redis Server Implementation in Swift, using SwiftNIO](https://github.com/NozeIO/redi-s) — Only supports about a third of Redis’ functionality so far. 

The Noze Consortium         

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