#237 — January 18, 2019

Read on the Web

Database Weekly

SQLite in 2018: A State of The Art SQL Dialect — SQLite is the most heavily used database in the world but its embedded, file-based nature can limit its use cases. Nonetheless, its SQL dialect has gained some serious improvements in 2018 alone, including window functions, the FILTER clause, ‘upsert’, and more.

Markus Winand

Is Amazon's DocumentDB Really Just PostgreSQL? — Amazon just announced DocumentDB, a MongoDB-compatible document database, but under the covers there are a number of hints that point to it actually being Postgres…

Ken Rugg

eBook: Best Practices for Optimizing Postgres Query Performance — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk in this free pganalyze eBook.

pganalyze sponsor

Scylla Open Source 3.0 Released — Scylla is an open source NoSQL database that offers the horizontal scale-out and fault-tolerance of Cassandra, but delivers 10x the throughput and consistentently low latency.

Peter Corless

Spanning The Database World With Google — An interview with Andrew Fikes, a Google Engineering Fellow instrumental in the development of many of its recent database-related services such as Spanner and BigTable.

Timothy Prickett Morgan interview

Looking Back: A History of Postgres — There’s some background to this, but essentially it’s a free chapter from a ACM-commissioned book about Turing Award winners and it digs deep into Postgres’s origins. Direct PDF link.

Joseph M. Hellerstein

Benchmarking Three NoSQL Databases — Altoros Systems, a cutting edge software engineering consultancy, has benchmarked Couchbase, DataStax Enterprise, and MongoDB. Spoiler: Couchbase was the leader in the pure performance stakes.

Datanami

On Demand EDB Postgres Databases on the AWS Cloud in Minutes with CDS

EDB Postgres Cloud Database Service sponsor

Real-Time Analytics Using SQL on Streaming Data with Apache Kafka and Rockset

Rockset

Comparing 3 Open Source Databases: PostgreSQL, MariaDB, and SQLite — A relatively high level comparison if you're in the market.

Sam Bocetta

HeidiSQL: A Native Windows App for Database Work — If you’re on Windows, HeidiSQL is a handy, open source database management tool. Supports Postgres, MySQL and SQL Server.

Ansgar Becker

AlaSQL: A JavaScript SQL Database for Browser and Node.js — Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

Andrey Gershun

💻 Jobs

UK Tech Jobs? Check Out hackajob — We're trusted by over 65,000 developers and engineers to help them find their perfect tech job. Make 2019 the year you get hired because of your skills.

hackajob