---
title: "New SQL features SQLite gained in 2018"
publication: "DB Weekly"
issue: 237
published_at: "2019-01-18"
canonical_url: "https://dbweekly.com/issues/237"
---

This week's database news       

#237 — January 18, 2019 

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

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ouayk6j9lwirrvdiv86x.jpg)](https://modern-sql.com/blog/2019-01/sqlite-in-2018)  

[SQLite in 2018: A State of The Art SQL Dialect](https://modern-sql.com/blog/2019-01/sqlite-in-2018) — 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?](https://www.enterprisedb.com/blog/documentdb-really-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   [![\](https://copm.s3.amazonaws.com/1004e5f6.png)](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=DBWeeklyPrimary) 

[eBook: Best Practices for Optimizing Postgres Query Performance](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=DBWeeklyPrimary) — 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](https://www.scylladb.com/2019/01/17/scylla-open-source-3-0-overview/) — 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](https://www.nextplatform.com/2019/01/15/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](https://arxiv.org/abs/1901.01973) — There’s [some background](https://databeta.wordpress.com/2019/01/09/a-history-of-postgres/) 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.](https://arxiv.org/pdf/1901.01973.pdf) 

Joseph M. Hellerstein   

[Benchmarking Three NoSQL Databases](https://www.datanami.com/2019/01/16/benchmarking-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](https://www.enterprisedb.com/edb-postgres-cds) 

EDB Postgres Cloud Database Service sponsor   

[Real-Time Analytics Using SQL on Streaming Data with Apache Kafka and Rockset](https://rockset.com/blog/real-time-analytics-using-sql-on-streaming-data-kafka-rockset/) 

Rockset   

[Comparing 3 Open Source Databases: PostgreSQL, MariaDB, and SQLite](https://opensource.com/article/19/1/open-source-databases) — A relatively high level comparison if you're in the market. 

Sam Bocetta   

[HeidiSQL: A Native Windows App for Database Work](https://www.heidisql.com/) — 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](https://github.com/agershun/alasql) — 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](https://hackajob.co/p/discover?utm_source=cooperpress&utm_medium=paid&utm_campaign=db_jan-18) — 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         

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