#195 — March 16, 2018
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 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
Giuseppe Maxia
🛠 Tips & Tutorials
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
Database Normalization and Primary Keys
Dimitri Fontaine
🔧 Tools & Code
Beaker: A Distributed, Transactional Key-Value Store — Written in Scala.
Ashwin Madavan
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 to Pivot Data Rows-to-Columns with SQL
Markus Winand
Real-Time Deduping At Scale with Redis
Tapjoy Engineering