---
title: "#160: A JSON type for Redis, SQLite indexes, and Solr vs Elasticsearch"
publication: "DB Weekly"
issue: 160
published_at: "2017-06-23"
canonical_url: "https://dbweekly.com/issues/160"
---

Database Weekly 160   

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

[Database Weekly](http://dbweekly.com) Issue 160 — June 23, 2017     

[MongoDB Launches Stitch, A New Backend As A Service Tool](https://www.mongodb.com/blog/post/announcing-mongodb-stitch?utm_source=dbweekly&utm_medium=email) — Sits on top of the MongoDB database and helps developers stitch together different third-party services, Mongo Charts, etc. MongoDBnews [Squeezing Performance from SQLite with Indexes](https://medium.com/@JasonWyatt/squeezing-performance-from-sqlite-indexes-indexes-c4e175f3c346?utm_source=dbweekly&utm_medium=email) — How indexes work in SQLite, and how to design indexes that can take your most important queries to the next level of performance. Jason Wyatttutorial [How to Optimize Cassandra Database Performance](https://selectstar.io/blog/optimize-cassandra-performance/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Cassandra_Blog) — 3 ways to ensure that your Cassandra workloads are operating at peak efficiency SelectStarsponsored [![\](https://copm.s3.amazonaws.com/c3cc3ebc.png)](https://selectstar.io/blog/optimize-cassandra-performance/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Cassandra_Blog) [What Is Time-Series Data and Why Do You Need A Time-Series Database?](https://blog.timescale.com/what-the-heck-is-time-series-data-and-why-do-i-need-a-time-series-database-dcf3b1b18563?utm_source=dbweekly&utm_medium=email) — A helpful primer to the world of time-series data from the creator of [TimescaleDB.](https://www.timescale.com/) Ajay Kulkarniopinion [ReJSON: A JSON Data Type for Redis](http://rejson.io/?utm_source=dbweekly&utm_medium=email) — A Redis module that implements ECMA-404 The JSON Data Interchange Standard as a native data type. Redis Labstools [Low Hanging Fruit: Cutting AWS RDS Instance Costs in Half](https://medium.com/cognitoiq/low-hanging-fruit-cutting-your-rds-instance-costs-in-half-736b8b490a24?utm_source=dbweekly&utm_medium=email) — A look at how AWS RDS’s (Relational Database Service) new start/stop ability makes it possible to reduce costs. Melvyn Mathewstutorial [MariaDB Emerging as Default MySQL Option](https://www.datanami.com/2017/06/20/mariedb-emerging-default-mysql-option/?utm_source=dbweekly&utm_medium=email) — Debian has switched from regular MySQL to the MariaDB alternative and this shift seems to be taking place across the board. Datanaminews [Lessons Learned the Hard Way: Postgres in Production at GoCardless](https://pgconf.us/conferences/2017/program/proposals/lessons-learned-the-hard-way-postgres-in-production-at-gocardless?utm_source=dbweekly&utm_medium=email) — Postgres is the primary store behind GoCardless’s payments API. Here’s a 45 minute talk from PGConf covering some of their ‘war stories’. PostgreSQL Conferencevideo [$20 Free Credit on a new account](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Linux cloud hosting starting at 1GB of RAM for $5/mo. Use code DB20 for $20 credit linodesponsored [AWS DynamoDB Accelerator (DAX) Now Generally Available](https://aws.amazon.com/blogs/aws/dynamodb-accelerator-dax-now-generally-available/?utm_source=dbweekly&utm_medium=email) — A managed caching service that sits in front of DynamoDB tables. Amazonnews [New NVMe Spec Emphasizes Data Analytics](https://www.datanami.com/2017/06/22/new-nvme-spec-emphasizes-data-analytics/?utm_source=dbweekly&utm_medium=email) Datanaminews [Top 15 Solr vs. Elasticsearch Differences](https://sematext.com/blog/2017/06/19/solr-vs-elasticsearch-differences/?utm_source=dbweekly&utm_medium=email) Rafal Kućtutorial [Summer Is Here: A Travel Agency Data Model](http://www.vertabelo.com/blog/technical-articles/summer-is-here-a-travel-agency-data-model?utm_source=dbweekly&utm_medium=email) — The latest in Vertabelo’s long line of data modelling tutorials. Emil Drkušićtutorial [Advanced SQL: Calculating Relationships with Correlation Matrices](http://www.silota.com/docs/recipes/sql-correlation-coefficient-matrix-summary.html?utm_source=dbweekly&utm_medium=email) SILOTAtutorial [Migrating from DynamoDB to Postgres: Why and How](https://containership.engineering/dynamodb-to-postgres-why-and-how-aa891681af4d?utm_source=dbweekly&utm_medium=email) Michael Stoltzstory [Why Your Encrypted Database Is Not Secure [PDF\]](http://eprint.iacr.org/2017/468.pdf?utm_source=dbweekly&utm_medium=email) — An academic paper out of Cornell Tech. Grubbs, Ristenpart, and Shmatikovstory [MongoDB Pivots to Analytics](https://www.datanami.com/2017/06/21/mongodb-pivots-analytics/?utm_source=dbweekly&utm_medium=email) Alex Woodiestory [Things You Should Be Aware Of Before using Amazon's Elasticsearch on AWS](https://read.acloud.guru/things-you-should-know-before-using-awss-elasticsearch-service-7cd70c9afb4f?utm_source=dbweekly&utm_medium=email) Liz Bennettopinion [How AWS' Database Services Stack Up Against Oracle’s](https://sweetcode.io/aws-database-stack-oracles-database/?utm_source=dbweekly&utm_medium=email) Twain Tayloropinion [It’s easy to version control your database alongside your application](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=version_control_3rd&utm_campaign=sqlsourcecontrol&utm_term=email-25729) — Connect your database to your version control system with SQL Source Control and keep track of every change. Red Gatetools sponsored [rqlite 4.0: Distributed SQLite Now with Node-to-Node Encryption](http://www.philipotoole.com/rqlite-now-available-with-node-to-node-encryption/?utm_source=dbweekly&utm_medium=email) Philip O'Toolecode    

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