---
title: "#156: Squeezing Performance from SQLite with Google's 'Room'"
publication: "DB Weekly"
issue: 156
published_at: "2017-05-26"
canonical_url: "https://dbweekly.com/issues/156"
---

Database Weekly 156   

This week's database news -[Read this on the Web](http://dbweekly.com/issues/156) 

[Database Weekly](http://dbweekly.com) Issue 156 — May 26, 2017     

[MariaDB TX 2.0: Open Source Database with Enterprise Features](https://mariadb.com/resources/blog/say-hello-mariadb-tx?utm_source=dbweekly&utm_medium=email) — TX packages various MariaDB technology, tools and services into a unified offering, while remaining open source. [More here](https://mariadb.com/products/solutions/oltp-database-tx/). Shane Johnsonnews [How Basic Performance Analysis on a Postgres Cluster Saved Millions](http://heap.engineering/basic-performance-analysis-saved-us-millions/?utm_source=dbweekly&utm_medium=email) — A look at how some performance analysis using flame graphs and ensuring some efficient indexing, improved performance and saved serious money. Michael Malisstory [Eventn - Data-driven Microservices](https://eventn.com/) — Build, deploy and scale HTTP microservices. Connect directly to a database or data warehouse and deploy RESTful services for ETL, SQL analytics or data processing with a single click. Eventnsponsored [![\](https://copm.s3.amazonaws.com/33661335.jpg)](https://eventn.com/) [Squeezing Performance from SQLite: Insertions (with Room)](https://hackernoon.com/squeezing-performance-from-sqlite-insertions-with-room-d769512f8330?utm_source=dbweekly&utm_medium=email) — Google announced a new tool at I/O called ‘Room’ which makes working with SQLite databases a lot easier. Jason Feinstein asks “how well does it perform?” Hacker Noon [GraphQL Meets Graph Database: A GraphQL + Neo4j Integration](https://neo4j.com/blog/graphql-neo4j-graph-database-integration/?utm_source=dbweekly&utm_medium=email) — Discover the newest integration between the Neo4j graph database and the GraphQL API query language that includes GraphQL-to-Cypher query translation. Michael Hunger and William Lyonnews [82% of Databases Left Unencrypted in Public Cloud](http://www.darkreading.com/cloud/82--of-databases-left-unencrypted-in-public-cloud/d/d-id/1328966?utm_source=dbweekly&utm_medium=email) — Personal health information and other sensitive data is left exposed as businesses overlook encryption and network security. Dark Readingnews [Migrating Oracle Databases to Postgres on Amazon RDS](https://selectstar.io/blog/migrating-oracle-databases-postgresql-amazon-rds/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=PostgresRDS_Blog) — See how to migrate to PostgreSQL on RDS in three steps. SelectStartutorial sponsored [How to Encrypt a Google Firebase Realtime Database](http://www.geero.net/2017/05/how-to-encrypt-a-google-firebase-realtime-database/?utm_source=dbweekly&utm_medium=email) Andy Geerstutorial [SQL Server Window Functions in Action](https://gavindraper.com/2017/05/23/sql-server-window-functions-in-action/?utm_source=dbweekly&utm_medium=email) Gavin Drapertutorial [Searching Flight Data with Neo4j](https://maxdemarzi.com/2017/05/24/flight-search-with-neo4j/?utm_source=dbweekly&utm_medium=email) — A graph database is ideal for modelling data like this. Max de Marzitutorial [A Data Model for an Electric Power Production System](http://www.vertabelo.com/blog/technical-articles/a-data-model-for-an-electric-power-production-system?utm_source=dbweekly&utm_medium=email) Vertabelotutorial [Dynamo, Citus, and Tradeoffs in Distributed Databases](https://www.citusdata.com/blog/2017/05/11/dynamo-citus-and-tradeoffs-in-distributed-databases/?utm_source=dbweekly&utm_medium=email) — Often there’s debate between relational databases and distributed ones (which are more typically NoSQL). Here’s some thoughts on the benefits of each from one of the creators of Dynamo. Citus Dataopinion [Autoscaling for your Heroku dynos](https://www.hirefire.io?utm_source=dbweekly&utm_medium=email) — Automatically scale up and down to handle increased workloads and avoid wasting money on idle resources. HireFiretools sponsored [Scuttlebot: Open-Source Peer-to-Peer Log Store](https://scuttlebot.io/?utm_source=dbweekly&utm_medium=email) — For use as a database, identity provider, and messaging system. Features global replication and end-to-end encryption. Secure Scuttlebutt Consortiumtools [Ora2Pg: A Tool to Move Oracle Databases to PostgreSQL](http://ora2pg.darold.net/?utm_source=dbweekly&utm_medium=email) — A free tool used to migrate an Oracle or MySQL database to a Postgres-compatible schema. Ora2Pgtools [M3DB: A Distributed Time Series Database Using M3TSZ Compression](https://github.com/m3db/m3db?utm_source=dbweekly&utm_medium=email) — Written in Go. M3DBcode [SQLiteProxy: A Simple HTTP JSON Proxy for SQLite](https://github.com/assafmo/SQLiteProxy?utm_source=dbweekly&utm_medium=email) github.​comcode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/156) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK