--- title: "A comparison of different database types" publication: "DB Weekly" issue: 273 published_at: "2019-09-27" canonical_url: "https://dbweekly.com/issues/273" --- This week's database news #273 — September 27, 2019 [Read on the Web](https://dbweekly.com/issues/273) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/gbiu71no1qycppjaiuyk.jpg)](https://www.prisma.io/blog/comparison-of-database-models-1iz9u29nwn37) [Comparing Database Types: How Database Types Evolved to Meet Different Needs](https://www.prisma.io/blog/comparison-of-database-models-1iz9u29nwn37) — NoSQL, relational, NewSQL, graph, and more.. Many types of databases exist, each with their own benefits. This post compares different approaches and what makes each one tick. Justin Ellingwood [Advanced SQL: A Look at Window Frames](https://mjk.space/advances-sql-window-frames/) — A deep dive into advanced uses of window functions ([an earlier article covers those](https://mjk.space/advanced-sql-window-functions/), if you need it). Window _frames_ are an SQL feature (in which Postgres is leading in support) that take window functions to a deeper level to perform complex and selective aggregations. Some great examples in here and a must read. Michal Konarski [![\](https://copm.s3.amazonaws.com/454605cc.png)](https://www.mongodb.com/cloud/atlas/lp/general/try?utm_campaign=cooperpress&utm_source=db&utm_medium=sponsored_newsletter) [MongoDB Atlas Is a Powerful and Reliable Cloud Database. Try Now](https://www.mongodb.com/cloud/atlas/lp/general/try?utm_campaign=cooperpress&utm_source=db&utm_medium=sponsored_newsletter) — Cloud-hosted MongoDB service on AWS, Azure, and GCP. Deploy, operate, and scale a MongoDB database in just a few clicks. MongoDB Atlas sponsor [Hacker News Discusses.. PostgreSQL or MySQL?](https://news.ycombinator.com/item?id=21040625) — There’s little more that can provoke a discussion on Hacker News than asking readers to choose between two technologies. Perhaps unsurprisingly, Postgres seems to be strongly preferred. Hacker News [Building a Relational Database Using Kafka?](https://yokota.blog/2019/09/23/building-a-relational-database-using-kafka/) — Kafka is best known for its stream processing and data pipeline management capabilities, but if it’s possible to [build a key/value store with it](https://yokota.blog/2018/11/19/kcache-an-in-memory-cache-backed-by-kafka/), you can go a step further and create a relational database too. An interesting experiment! Robert Yokota **Quick bytes:** - [PostgreSQL 12 Release Candidate 1](https://www.postgresql.org/about/news/1975/) has been released. - DigitalOcean has [added metrics](https://blog.digitalocean.com/metrics-for-managed-redis-are-now-available/) to its managed Redis service. - TigerGraph has [raised $32m and launched TigerGraph Cloud](https://www.datanami.com/2019/09/25/tigergraph-cloud-goes-live-as-firm-raises-32m/), an AWS-based managed version of their graph analytics platform. - Some thoughts on [what to expect from the O'Reilly Strata Data Conference](https://www.datanami.com/2019/09/23/what-to-expect-at-strata-this-week/) taking place this week. 💻 Jobs [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) — Make a free profile, name your salary, and connect with hiring managers from top employers. Vettery 📒 Everything else [SQLTools: Database Tools for VS Code Users](https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools#sqltools) — Supports various database types (e.g. Redshift, MySQL, Oracle, Postgres, and Cassandra support has also just been added) and offers a connection explorer, query runner, IntelliSense, bookmarks, query history, etc. Visual Studio Marketplace ▶[A Look at Dgraph: The Graph Database Written in Go](https://www.youtube.com/watch?v=CjkKRbtwWXA) — Did you know that Francesc Campoy (of [JustForFunc](https://www.youtube.com/channel/UC_BzFbxG2za3bp5NRRRXJSw) fame) now works at Dgraph on their Go-powered graph database? I didn’t, but it’s great to see him in a new video. Francesc Campoy [Monitoring & Alerting in InfluxDB Cloud 2.0](https://www.influxdata.com/blog/monitoring-alerting-in-influxdb-cloud-2-0/) — We’re trying to make learning from your data easy, and in that spirit, we’re going to walk through setting up alerts and notifications in InfluxDB Cloud 2.0. InfluxData sponsor [Comparing Distributed SQL Performance: Yugabyte vs. Aurora PostgreSQL vs. CockroachDB](https://blog.yugabyte.com/comparing-distributed-sql-performance-yugabyte-db-vs-amazon-aurora-postgresql-vs-cockroachdb/) — You should, by now, know to look at benchmarks with a skeptical and trained eye, of course 😄 though in this case, it’s nice to see a competing service actually being recommended for many use cases. YugaByte [A Look at Graph Fundamentals: RDF](https://t.co/ArMhYVpJXh) — Graph databases are on the rise, but amid all the hype it can be hard to understand the differences under the hood. This first in a series post starts with [RDF](https://en.wikipedia.org/wiki/Resource_Description_Framework), a set of specs for describing ‘resources’. Kevin Feeney [A Briefing about SQLite for Linux Hackers](https://sqlite.org/lpc2019/doc/trunk/briefing.md) — I’m filing this in the ‘interesting’ folder. It’s a short document that summarizes some of the technical aspects of SQLite for Linux kernel developers. D. Richard Hipp [How to Switch an Existing Azure SQL Database From Provisioned Compute to Serverless](https://channel9.msdn.com/Shows/Data-Exposed/How-to-switch-an-existing-Azure-SQL-Database-from-Provisioned-Compute-to-Serverless) — Azure’s SQL Database service has a [‘serverless’ compute tier](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-serverless) that scales and bills based on workload demand and computing power used. Channel 9 [SQL Exercises to Test Your Knowledge of Window Functions](https://window-functions-experiment-afc440.netlify.com/) — This is basically a prototype of an interesting idea for practicing SQL in the browser. 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