---
title: "This week's database news, issue 127"
publication: "DB Weekly"
issue: 127
published_at: "2016-10-21"
canonical_url: "https://dbweekly.com/issues/127"
---

Database Weekly 127   . 

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

[Database Weekly](http://dbweekly.com) Issue 127 — October 21, 2016     

Featured [Picking A Cloud Database for Analytics: The SQL Options](http://blog.parsely.com/post/4516/cloud-sql-bigquery-redshift/?utm_source=dbweekly&utm_medium=email) — _“Amazon Redshift and Google BigQuery provide particularly compelling answers for running analytics queries on event data.”_ Andrew Montalentiopinion [Your Database is Your Prison - Here's How Expensify Broke Free](http://firstround.com/review/your-database-is-your-prison-heres-how-expensify-broke-free/?utm_source=dbweekly&utm_medium=email) — A business oriented look at the relationship between a startup, the database it uses, and how database choices affect security and more. First Roundstory [How We Build TiDB, a NewSQL Database](http://weekly.pingcap.com/2016/10/17/how-we-build-tidb/?utm_source=dbweekly&utm_medium=email) — The story of how and why a team is building TiDB, a new distributed SQL database inspired by Google’s F1 and including the best of both traditional RDBMS and NoSQL. Max Liustory [Linode is the SPEEDIEST SSD host for your DB - simple, reliable & powerful.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) — MySQL? MariaDB? PostgreSQL? Whatever DB you use, run it on a Linode, the most scalable, reliable and fastest servers in the cloud. Use promo code `DB20` for a $20 credit and get started. linodesponsored [![\](https://copm.s3.amazonaws.com/c740311a.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) [SQLite Archiver: A Tool for Packaging Assets in an SQLite Database](http://jamielittle.org/2016/10/19/sqlar.html?utm_source=dbweekly&utm_medium=email) — Takes a file or a list of files and and creates a SQLite database with the files as stored as BLOBs. You can also mount this archive as a FUSE filesystem. Jamie Littletools [MySQL Cluster 7.5 Released](https://blogs.oracle.com/MySQL/entry/mysql_cluster_7_5_is?utm_source=dbweekly&utm_medium=email) — With support for 128TB+ data set sizes per data node you can both better scale up and out with this release. It’s compatible with MySQL 5.7 under the hood. Oracletools [Interactive Analytics: Redshift vs Snowflake vs BigQuery](https://www.periscopedata.com/blog/interactive-analytics-redshift-bigquery-snowflake.html?utm_source=dbweekly&utm_medium=email) — Periscope thoroughly analyzes the use of Redshift, Snowflake and BigQuery for data warehouse-based analytics work. _(Spoiler: Redshift won for them.)_ Periscopestory [MongoDB's JavaScript Fuzzer: Creating Chaos](https://engineering.mongodb.com/post/mongodbs-javascript-fuzzer-creating-chaos/?utm_source=dbweekly&utm_medium=email) — Mongo’s fuzz tester is now their most prolific bug finding tool. Here’s a look at how it works. Robert Guostory Jobs [Data Integration Engineer (Kafka/ElasticSearch/Postgres/Python)](https://jobs.lever.co/realscout/c81351cc-c623-467b-b433-e517530cb16e?lever-source=DBWEEKLY) — Want to help make sense of the data behind the $1 trillion real estate market? Hundreds of data feeds to normalize. Millions of photos to classify. Millions of user events to analyze. You name it, we got it. REALSCOUT [Shouldn't Companies Apply to You? - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-dbweekly) — You're on the cutting edge of technology, why job hunt like it's the 90s? Try Hired today and have 4,000+ top companies apply for the chance to interview you. Hired In brief [SQL Server 2016 Express Edition in Windows Containers Now Available](https://blogs.technet.microsoft.com/dataplatforminsider/2016/10/13/sql-server-2016-express-edition-in-windows-containers/?utm_source=dbweekly&utm_medium=email) Microsoftnews [SQLite 3.15.0 Released](http://www.sqlite.org/releaselog/3_15_0.html?utm_source=dbweekly&utm_medium=email) — A key addition is support for [row values.](http://www.sqlite.org/rowvalue.html) SQLitenews [Announcing Automated Daily Backups for the Firebase Database](https://firebase.googleblog.com/2016/10/announcing-automated-daily-backups-for-the-firebase-database.html?utm_source=dbweekly&utm_medium=email) Googlenews [MySQL on Compose - hosted on AWS, GCP or SoftLayer](https://compose.com/articles/connecting-to-compose-for-mysql/?utm_source=cooper&utm_medium=newsletter&utm_content=connect-mysql) — Get the most from your favorite RDBMS with 3 Node HA, Daily Backup and Auto-scaling. See how easy it is to connect your Database, hassle-free. Composesponsored [Building SQL Queries with Temporary Tables vs WHERE IN](http://stevenyue.com/blogs/build-sql-queries-with-temporary-table-vs-where-in/?utm_source=dbweekly&utm_medium=email) Steven Yuetutorial [Declarative Data Fetching with GraphQL](https://css-tricks.com/declarative-data-fetching-graphql/?utm_source=dbweekly&utm_medium=email) — Nilan Marktanner creates an Instagram clone highlighting some of the benefits that GraphQL brings to the table. CSS Trickstutorial [PandaSQL: Make Python Speak SQL](http://blog.yhat.com/posts/pandasql-intro.html?utm_source=dbweekly&utm_medium=email) Yhattutorial [Creating A Mongo Cluster in AWS with Ansible](https://medium.com/@jduv/creating-a-mongo-cluster-in-aws-with-ansible-b97c36f55586?utm_source=dbweekly&utm_medium=email) Jeremy Duvalltutorial [How to Quickly Rename all Primary Keys in Oracle](https://blog.jooq.org/2016/10/21/how-to-quickly-rename-all-primary-keys-in-oracle/?utm_source=dbweekly&utm_medium=email) jOOQtutorial [Datanet: A New CRDT Database That Let's You Do Bad Bad Things to Distributed Data](http://highscalability.com/blog/2016/10/17/datanet-a-new-crdt-database-that-lets-you-do-bad-bad-things.html?utm_source=dbweekly&utm_medium=email) Todd Hoffstory [Survey: The Hidden Costs of Data Operations](https://docs.google.com/forms/d/e/1FAIpQLSeagAsxJ8lMPMr9OHUXn3GoHLx8Hkl0R2ZKotyRuPege9R_kA/viewform?utm_source=dbweekly&utm_medium=email) — VividCortex are seeking opinions on how your organization handles its database systems. Baron Schwartzopinion [SQL Source Control: track each change to your SQL Server database](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change_v2&utm_campaign=sqlsourcecontrol&utm_term=email-25070) — Get a full history in your source control system. See who made changes, what they did & why. [See how.](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change_v2&utm_campaign=sqlsourcecontrol&utm_term=email-25070) Red Gatesponsored [Rebridge: A Transparent JavaScript Object to Redis Bridge](https://www.npmjs.com/package/rebridge?utm_source=dbweekly&utm_medium=email) Capacitor Setcode [Cassandra 3.7 LTS: A 3.x Edition with Backported Bugfixes](https://github.com/instaclustr/cassandra?utm_source=dbweekly&utm_medium=email#cassandra-37-lts) Instaclustrcode [RXHash: Missing Redis Commands for the Hash Type](https://github.com/redismodule/rxhash?utm_source=dbweekly&utm_medium=email) github.​comcode [migrate-mongo: A Database Migration Tool for MongoDB in Node](https://github.com/seppevs/migrate-mongo?utm_source=dbweekly&utm_medium=email) Sebastian Van Sandecode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/127) [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