---
title: "SQLite 3.28.0, InfluxDB, and an intelligent knowledge graph database"
publication: "DB Weekly"
issue: 250
published_at: "2019-04-19"
canonical_url: "https://dbweekly.com/issues/250"
---

This week's database news       

#250 — April 19, 2019 

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

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/kgyuou7dgozjao8wcpwd.jpg)](https://grakn.ai/)   

[Grakn: An 'Intelligent' Knowledge Graph Database](https://grakn.ai/) — Grakn ([GitHub repo](https://github.com/graknlabs/grakn)) is an open source (GNU Affero) knowledge graph database built in Java that’s targeted at organizing and analysis complex networks of data (such as [the logistics of the London Underground system](https://blog.grakn.ai/planning-logistics-and-operations-modelling-the-london-tube-network-in-grakn-7c03baff65c6), perhaps). 

GRAKN.AI   

[SQLite 3.28.0 Released](https://www.sqlite.org/releaselog/current.html) — The version number makes it sound like a relatively minor release but the latest SQLite packs in a _lot_ of enhancements including support for EXCLUDE, window chaining, and GROUPS frames in window functions. 

SQLite   [![\](https://copm.s3.amazonaws.com/46bad8be.jpg)](https://influxdays.com/london-2019/) 

[InfluxDays: The Only Event Focused on Time Series Data](https://influxdays.com/london-2019/) — Attend InfluxDays London on 6/13-6/14 and learn why TSDB’s are the fastest growing database segment. 20% off code: `LONDON`. 

InfluxData sponsor   

[The Definitive Guide to InfluxDB in 2019](http://devconnected.com/the-definitive-guide-to-influxdb-in-2019/) — InfluxDB is an open-source time series database built in Go that provides a SQL-like language for querying. This guide is more a definitive _introduction_ to InfluxDB than for existing users. 

Antoine Solnichkin   

[The Cost of Useless Surrogate Keys in Relationship Tables](https://blog.jooq.org/2019/03/26/the-cost-of-useless-surrogate-keys-in-relationship-tables/) — A look at the pros and cons of using natural keys versus surrogate keys. 

Lukas Eder   

[The 'Data Scientist' Title is Evolving Into A New Thing](https://www.datanami.com/2019/04/17/data-scientist-title-evolving-into-new-thing/) — The term ‘data scientist’ has been adapted and twisted to fit a lot of different data related roles from SQL-oriented business analyst to machine learning jobs. 

Datanami   

[Improving Key Expiration in Redis](https://blog.twitter.com/engineering/en_us/topics/infrastructure/2019/improving-key-expiration-in-redis.html) — Twitter is a heavy user of Redis, the popular data structure server. They were running into some interesting performance issues on their cluster which they’ve resolved yielding up to a 25% reduction in memory use. 

Matthew Tejo (Twitter Engineering)   

[Microsoft Expands Hadoop on Azure](https://www.datanami.com/2019/04/16/microsoft-expands-hadoop-on-azure/) — Microsoft has upgraded its open source analytics services running on Azure with a new version of Hadoop incorporating enhancements of Apache Hive and other open source analytics frameworks. 

Datanami   

[Past to Present: The Evolution of Geographic Information Systems (GIS)](https://www.omnisci.com/blog/past-to-present-the-evolution-of-gis) — Geographic data has long held a special place in the database world given the extra requirements and query types it demands. 

Linda Stevens   

[How Postgres Is More Than a Relational Database: Extensions](https://www.citusdata.com/blog/2018/11/27/postgres-more-than-a-relational-database/?utm_source=DB_Weekly&utm_medium=email&utm_campaign=sponsor_blog) — Extensions allow Postgres to be customized in cool new ways. 10 favorites from the Citus database team. 

CITUS DATA, NOW PART OF THE MICROSOFT FAMILY sponsor   

[SQLiteQueryServer: A Way to Expose an SQLite Query Over The Network](https://github.com/assafmo/SQLiteQueryServer) — Give this an SQLite database, an SQL query, and it’ll make it available over HTTP, complete with extra params. 

Assaf Morami   

[Miniredis: A Pure Go Redis Server, Ideal for Unit Tests](https://github.com/alicebob/miniredis) — A mature project and has gained support for pub/sub in the past few weeks. 

Harmen   

[pq: The Pure Go Postgres Driver for `database/sql`](https://github.com/lib/pq) — [v1.1](https://github.com/lib/pq/releases/tag/v1.1.0) came out this week dropping support for Go 1.8 and below. 

Blake Mizerany and contributors  

💻 Jobs  

[Full Stack, Mobile & Infrastructure Engineers](https://we.are.expensify.com/apply) — Joining our team means you will be working in our fast paced environment and you are fearless of our next big challenge. 

Expensify   

[Find A DB Job Through Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started. 

Vettery         

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