MySQL and SQL Server are the most popular databases in use..

(and other insights from the Stack Overflow Survey)

#195 — March 16, 2018 Read on the Web Database Weekly 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 — 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 JackDB: A Modern Database Client — 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 — Stack Overflow's 2018 survey results are out with MySQL and SQL Server being the most popular databases in use, Redis the most loved, IBM Db2 the most 'dreaded', and MongoDB the one most non-users want to learn next. Stack Exchange The most loved databases as voted by Stack Overflow users ▶  The Time Series Database Lectures — Fascinating set of 6 lectures from the end of 2017 covering InfluxDB, time series analytics, TimescaleDB & more. Carnegie Mellon University HeidiSQL: A Native Windows App for Database Work — 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 — 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 — An open-source column-oriented database management system that allows generating analytical data reports in real time. GitHub repo. Yandex 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 SelectStar sponsor Introducing MongoDB Weekly — We've got a new newsletter covering the vast ecosystem surrounding the most popular non-relational database. Cooperpress Updating a 50 Terabyte PostgreSQL Database Reinier Haasjes MySQL Security for Real Users Giuseppe Maxia 🛠  Tips & Tutorials Loading Terabytes of Data from Postgres into BigQuery Statsbot Detect Sensitive Information in NoSQL Documents Automatically with 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 — 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 SQLite Database Normalization and Primary Keys Dimitri Fontaine 🔧  Tools & Code Beaker: A Distributed, Transactional Key-Value Store — Written in Scala. Ashwin Madavan redis-cell: A Redis Module That Provides Rate Limiting Functionality Brandur Linux Cloud Hosting Starting at 1GB of RAM for $5/mo Linode Cloud Hosting sponsor ✨  Golden Oldies ▶  SQLite: The Database at the Edge of the Network — 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 Lukas Eder How to Pivot Data Rows-to-Columns with SQL Markus Winand Real-Time Deduping At Scale with Redis Tapjoy Engineering

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