---
title: "A chat with SQLite's creator, Jepsen on MongoDB 4.2.6, and RedisConf videos"
publication: "DB Weekly"
issue: 305
published_at: "2020-05-22"
canonical_url: "https://dbweekly.com/issues/305"
---

Plus more database news, views, and links.       

#305 — May 22, 2020 

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

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1590148294/sdppelpgsv4fieobagjo.jpg)](https://simonwillison.net/2020/May/21/dogsheep-photos/)  

[Using SQL to Find The Best Photo of a Pelican (According to Apple Photos)](https://simonwillison.net/2020/May/21/dogsheep-photos/) — Apple Photos stores photo metadata in an SQLite database – nothing odd about that. But what _is_ odd is that Photos calculates numerous types of ‘aesthetic score’ for your photographs.. meaning you can find out which photos of yours it thinks are best! 

Simon Willison   

[A Jepsen Analysis of MongoDB 4.2.6](http://jepsen.io/analyses/mongodb-4.2.6) — Jepsen is well known for its in-depth reports on the safety and reliability of distributed systems, and here their attention is turned to MongoDB with some worrying conclusions particularly around transactions and consistency violations. 

Kyle Kingsbury   [![\](https://copm.s3.amazonaws.com/aae77ecc.png)](https://hibernatingrhinos.com/products/cosmosdbprof/about) 

[CosmosDB Profiler: Your Cloud Cost Optimization Tool](https://hibernatingrhinos.com/products/cosmosdbprof/about) — Use the CosmosDB Profiler to cut your Cloud budget up to 70% by optimizing how your application interacts with your CosmosDB Database. It’s the easy way to save money. 

Hibernating Rhinos sponsor   

▶[A Chat with Richard Hipp, the Creator of SQLite](https://www.youtube.com/watch?v=2eaQzahCeh4) — Part of a broader initiative to [interview database experts](https://federico-razzoli.com/two-weeks-of-databases) every week. I really enjoyed this. Richard is an engaging speaker. 

Federico Razzoli and Richard Hipp   

[Spark 3.0 to Get Native GPU Acceleration](https://www.datanami.com/2020/05/14/spark-3-0-to-get-native-gpu-acceleration/) — NVIDIA is working with Apache Spark’s open source community to bring native GPU acceleration to the next version of the big data framework. 

Datanami   

[The PGCon 2020 PostgreSQL Conference Streaming Free Next Week](https://www.pgcon.org/2020/) — Due to the current world situation, many events are going online-only and Postgres’s annual PGCon is doing just the same with three streaming rooms, Zoom, and an IRC chat across May 26-29. 

PGCon   

▶[The Top 10 Videos from RedisConf Takeaway](https://www.youtube.com/playlist?list=PL83Wfqi-zYZGPnJqkVn9yeNCMX-V6Pvzm#redistop10) — _RedisConf Takeaway_ was a remote version of the annual Redis conference that took place recently and Redis Labs has shared some of the talks covering topics like how [Redis 6.0’s security features work](https://www.youtube.com/watch?v=wJkWqhjNbgw&list=PL83Wfqi-zYZGPnJqkVn9yeNCMX-V6Pvzm&index=6&t=0s), [memory optimization](https://www.youtube.com/watch?v=RYrQFHNx5D4&list=PL83Wfqi-zYZGPnJqkVn9yeNCMX-V6Pvzm&index=5&t=0s), and how to [get started with Redis.](https://www.youtube.com/watch?v=oHPcou3LYXc&list=PL83Wfqi-zYZGPnJqkVn9yeNCMX-V6Pvzm&index=7&t=0s) 

Redis Labs   

[SQL Is Dead, Right?](https://thenewstack.io/sql-is-dead-right/) — An opinion piece, _obviously_ 😁 At 46 years old, SQL is far from dead, and it’s neat to see an evangelist for Couchbase acknowledge this. 

Andrew Oliver   

[Shrinking BSON Documents](https://richardstartin.github.io/posts/shrinking-bson-documents) — One issue with systems with dynamic schemas is that the _names_ for things can take up more space than the actual _values_, as was seen in a tweet about DynamoDB. Does shrinking attribute names also help with MongoDB? Yes, but readability takes a bit of a hit! 

Richard Startin   

[MongoDB Is Easy. Now Make It Powerful. Free Download for 30 Days.](https://studio3t.com/download/?utm_source=cooper&utm_medium=newsletter&utm_campaign=dbweeklymay22) — Using MongoDB Atlas? Studio 3T is the professional GUI and IDE that unlocks the power you need. 

Studio 3T sponsor   

[PostgreSQL 13 Beta 1 Released](https://www.postgresql.org/about/news/2040/) — The [draft release notes](https://www.postgresql.org/docs/13/release-13.html) are available. 

PostgreSQL Global Development Group   

[How to Build an AppSync API using a Single Table DynamoDB Design](https://www.goingserverless.com/blog/single-table-dynamodb-for-appsync) — Heads deep into the GraphQL weeds here. 

Rich Buggy   

[SQL Window Functions Cheat Sheet and Reference](https://learnsql.com/blog/sql-window-functions-cheat-sheet/) 

LearnSQL   

[Global DataSphere to Hit 59 Zettabytes in 2020 Alone, IDC Projects](https://www.datanami.com/2020/05/19/global-datasphere-to-hit-59-zettabytes-in-2020-alone-idc-projects/) — Just to put that into some perspective, that’s 7.8 terabytes for every human on Earth. In a single year! 

Datanami         

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