---
title: "MySQL and SQL Server are the most popular databases in use.."
publication: "DB Weekly"
issue: 195
published_at: "2018-03-16"
canonical_url: "https://dbweekly.com/issues/195"
---

(and other insights from the Stack Overflow Survey)       

#195 — March 16, 2018 

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

Database Weekly  

[Top 10 SQL Dialect Emulations Implemented in jOOQ](https://blog.jooq.org/2018/03/13/top-10-sql-dialect-emulations-implemented-in-jooq/) — An interesting look at 10 ways various database implementations deviate from the SQL standard including `WITH TIES`, `FETCH`, and `DISTINCT`. 

JOOQ   

[3 Database Modelling Anti-Patterns](https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/) — Looking into some classic anti-patterns: entity attribute values, multiple values in a single column, and how using UUIDs can be an anti-pattern too. 

Dimitri Fontaine   [![\](https://copm.s3.amazonaws.com/cc98744f.png)](https://www.jackdb.com/) 

[JackDB: A Modern Database Client](https://www.jackdb.com/) — JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today. 

JackDB, Inc. sponsor   

[Stack Overflow Users' Database Preferences](https://insights.stackoverflow.com/survey/2018/#technology-databases) — Stack Overflow’s 2018 survey results are out with MySQL and SQL Server being the most popular databases in use, [Redis the most _loved_](https://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases), IBM Db2 the most ‘dreaded’, and MongoDB the one most non-users want to learn _next_. 

Stack Exchange   [![\](https://res.cloudinary.com/cpress/image/upload/w_800/cn0obg4zfj9wiwcrhixo.jpg)](https://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases) 

The most loved databases as voted by Stack Overflow users   

▶[The Time Series Database Lectures](http://db.cs.cmu.edu/seminar2017/) — Fascinating set of 6 lectures from the end of 2017 covering [InfluxDB](https://www.youtube.com/watch?v=2SUBRE6wGiA&list=PLSE8ODhjZXjY0GMWN4X8FIkYNfiu8_Wl9&index=1), [time series analytics](https://www.youtube.com/watch?v=AiGdfmxEP68&index=4&list=PLSE8ODhjZXjY0GMWN4X8FIkYNfiu8_Wl9), [TimescaleDB](https://www.youtube.com/watch?v=IaZ4hJ3G7wc&index=6&list=PLSE8ODhjZXjY0GMWN4X8FIkYNfiu8_Wl9) & more. 

Carnegie Mellon University   

[HeidiSQL: A Native Windows App for Database Work](https://www.heidisql.com/) — If you’re on Windows and use MySQL, SQL Server, or PostgreSQL, HeidiSQL is a handy, open source database management tool. 

Ansgar Becker   

[Using the Serverless Cloud for ETL Scenarios](https://blog.jeremylikness.com/use-the-serverless-cloud-for-etl-scenarios-bb7f967edde5) — An amazingly thorough walkthrough / tutorial covering a real world scenario of using Azure Functions to process a CSV file and import data into Azure SQL. 

Jeremy Likness   

[ClickHouse: Open-Source Distributed Column-Oriented DBMS](https://clickhouse.yandex/) — An open-source column-oriented database management system that allows generating analytical data reports in real time. [GitHub repo.](https://github.com/yandex/ClickHouse) 

Yandex   

[Top 3 New Features in Apache Spark 2.3](https://www.datanami.com/2018/03/14/top-3-new-features-in-apache-spark-2-3/) — Continuous streaming, Kubernetes support, and Python support for vectorized user defined functions. 

Alex Woodie   

[SelectStar: Turn Database Monitoring Information into Actionable Insight](https://selectstar.io/better-insights/?utm_source=CooperPress&utm_medium=Brief+Link&utm_campaign=Database+Weekly+Brief+Link+Mar16) 

SelectStar sponsor   

[Introducing MongoDB Weekly](https://mongodb.email/) — We've got a new newsletter covering the vast ecosystem surrounding the most popular non-relational database. 

Cooperpress   

[Updating a 50 Terabyte PostgreSQL Database](https://medium.com/adyen/updating-a-50-terabyte-postgresql-database-f64384b799e7) 

Reinier Haasjes   

[MySQL Security for Real Users](http://datacharmer.blogspot.com/2018/03/mysql-security-for-real-users.html) 

Giuseppe Maxia  

🛠 Tips & Tutorials  

[Loading Terabytes of Data from Postgres into BigQuery](https://statsbot.co/blog/postgres-to-bigquery-etl/) 

Statsbot   

[Detect Sensitive Information in NoSQL Documents Automatically with Couchbase Functions](https://blog.couchbase.com/detect-sensitive-information-nosql-documents-automatically-couchbase-functions/) — Uses a new ‘Eventing’ service in the latest Couchbase Server 5.5. 

Nic Raboy   

[Creating a Data Redaction Capability to Meet GDPR Requirements](https://medium.com/enterprisedb/creating-a-data-redaction-capability-to-meet-gdpr-requirements-using-edb-postgres-30f06b59d425) — The _General Data Protection Regulation_ is a new EU law for data protection. 

Marc Linster and Renee Deger   

[All The Ways You Can Corrupt an SQLite Database File](https://sqlite.org/howtocorrupt.html) 

SQLite   

[Database Normalization and Primary Keys](https://tapoueh.org/blog/2018/03/database-normalization-and-primary-keys/) 

Dimitri Fontaine  

🔧 Tools & Code  

[Beaker: A Distributed, Transactional Key-Value Store](https://github.com/ashwin153/beaker) — Written in Scala. 

Ashwin Madavan   

[redis-cell: A Redis Module That Provides Rate Limiting Functionality](https://github.com/brandur/redis-cell) 

Brandur   

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-brief) 

Linode Cloud Hosting sponsor   

✨ Golden Oldies  

▶[SQLite: The Database at the Edge of the Network](https://www.youtube.com/watch?v=Jib2AmRb_rk) — A great view into SQLite’s history and situations where it shines. 
Dr. Richard Hipp   

▶[How Modern SQL Databases Come Up with Algorithms You Never Dreamed Of](https://www.youtube.com/watch?v=wTPGW1PNy_Y) 
Lukas Eder   

[How to Pivot Data Rows-to-Columns with SQL](https://modern-sql.com/use-case/pivot) 
Markus Winand   

[Real-Time Deduping At Scale with Redis](http://eng.tapjoy.com/blog-list/real-time-deduping-at-scale) 
Tapjoy Engineering         

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