---
title: "SQLite gains generated column support"
publication: "DB Weekly"
issue: 288
published_at: "2020-01-24"
canonical_url: "https://dbweekly.com/issues/288"
---

Plus more database news, views, and links.       

#288 — January 24, 2020 

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

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/y4nzqq6ul6sferivcetx.jpg)](https://blog.google/products/search/discovering-millions-datasets-web/)   

[Discovering Millions of Datasets with Google Dataset Search](https://blog.google/products/search/discovering-millions-datasets-web/) — Google has now _officially_ launched _Dataset Search_ (no longer in beta) powered by an index of 25 million datasets, helping scientists, journalists, students, and other data geeks to find data to work with. 

Google   

[MongoDB Atlas Introduces GraphQL Support on Stitch](https://www.mongodb.com/blog/post/introducing-graphql-support-in-mongodb-atlas-with-stitch) — You can now interact with MongoDB through GraphQL directly in Stitch, MongoDB’s serverless platform, without the need for a backend web service. 

Nicolas Raboy (MongoDB)   [![\](https://copm.s3.amazonaws.com/5a4e3dd1.jpg)](https://www.cockroachlabs.com/blog/unpacking-competitive-benchmarks/?utm_campaign=cooperpress-2020-Q1&utm_source=dbweekly&utm_medium=newsletter&utm_content=unpacking-competitive-benchmarks) 

[Unpacking Competitive Benchmarks: Yugabyte & CockroachDB](https://www.cockroachlabs.com/blog/unpacking-competitive-benchmarks/?utm_campaign=cooperpress-2020-Q1&utm_source=dbweekly&utm_medium=newsletter&utm_content=unpacking-competitive-benchmarks) — An analysis detailing performance of the two systems on a variety of benchmarks. It unpacks Yugabyte’s claims and shows the architectural differences between the two systems. 

Cockroach Labs sponsor   

[SQLite 3.31.0 Released](https://sqlite.org/releaselog/3_31_0.html) — I’m always delighted to see SQLite taking further steps forward as it powers _so much_ of the world today (and often silently). 3.31.0’s big new feature is support for [generated columns.](https://www.sqlite.org/gencol.html) 

SQLite   

[TerminusDB 1.1 Released](https://medium.com/terminusdb/terminusdb-1-1-the-big-babushka-9020aeb712b7) — TerminusDB is a relatively new open source graph database designed for knowledge graph representation. It uses a strong schema for simplicity and adopts a delta-encoding approach to updates so data can be branched, merged, rolled back, etc. [This paper](https://github.com/terminusdb/terminus-server/blob/dev/docs/whitepaper/terminusdb.pdf) explains more. 

Luke Feeney   

[Five Methods For Database Obfuscation](https://habr.com/en/company/yandex/blog/485096/) — There’s nothing like testing on true datasets but what if your dataset is full of private data? How can you create a dataset that’s ‘real’, shareable, but not a data protection liability? 

Anonymous   

[Apache Flink Powers Cloudera's New Streaming Analytics Product](https://www.datanami.com/2020/01/15/apache-flink-powers-clouderas-new-streaming-analytics-product/) — Cloudera’s new Cloudera Streaming Analytics (CSA) tool is aimed at processing large amounts of IoT and event data and is based on [Apache Flink](https://flink.apache.org/), a data stream computation system. 

Datanami   

[Tips on How to Get Your Database Conference Talk Selected](https://www.citusdata.com/blog/2020/01/16/tips-on-getting-talk-proposals-accepted/) — 16 tips from someone who was instrumental in choosing talks for this week’s [PGDay SF conference](https://2020.pgdaysf.org/). These tips will be useful for any future event IMHO. 

Claire Giordano   

[All The Ways You Can Corrupt an SQLite Database File](https://sqlite.org/howtocorrupt.html) — Not _deliberately_, of course.. ;-) 

SQLite   

[Working With Spatial Data in Neo4j GraphQL in the Cloud](https://blog.grandstack.io/working-with-spatial-data-in-neo4j-graphql-in-the-cloud-eee2bf1afad) 

William Lyon   

[Advanced DB Automation & Monitoring with the New ClusterControl 1.7.5](https://severalnines.com/product/clustercontrol?utm_campaign=Potpourri_Campaign_JAN20&utm_content=dbweekly&utm_medium=Paid_Search&utm_source=banner) — Full Lifecycle Database Management - Now featuring full support for PostgreSQL 12, MongoDB 4.2 & MySQL 8. 

Severalnines sponsor   

[Chasing a Postgres Performance Issue (Twitter Thread)](https://twitter.com/felixge/status/1219268882416001025) — A developer found that index-only scans on a database got 3x slower after running a newly optimized ETL process and set out to establish why.. an interesting case of chasing a performance issue. 

Felix Geisendörfer on Twitter   

[query-pipe: Command-Line (ND)JSON Querying](https://github.com/paybase/qp) — A tool for filtering and transforming JSON from the command line using an SQL-like query language. 

Paybase   

[STADO: SQL TCPDump Analyzer Designed for Oracle](http://blog.ora-600.pl/2020/01/22/when-awr-is-not-enough-a-k-a-why-your-app-is-not-cloud-ready-smartdb/) — My ignorance of the Oracle ecosystem doesn’t help here but this seems like it could be valuable if you want to monitor or debug Oracle Database connections. 

Kamil Stawiarski         

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