--- title: "This week's database news, issue 75" publication: "DB Weekly" issue: 75 published_at: "2015-10-16" canonical_url: "https://dbweekly.com/issues/75" --- Database Weekly 75 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/75) [Database Weekly](http://dbweekly.com) Issue 75 — October 16, 2015 Featured [SQLite 3.9.0 Released](https://www.sqlite.org/releaselog/3_9_0.html?utm_source=dbweekly&utm_medium=email) — It’s adopted semantic versioning, and both the json1 and fts5 (Full Text Search 5) extensions are now part of the core. SQLitenews [Data Infrastructure at IFTTT](https://medium.com/engineering-at-ifttt/data-infrastructure-at-ifttt-35414841f9b5?utm_source=dbweekly&utm_medium=email) — As a service that connects many other Internet services together, IFTTT handles a lot of data both in and out. This is a look at how they manage it all. IFTTT [Benchmark: PostgreSQL, MongoDB, Neo4j, OrientDB and ArangoDB](https://www.arangodb.com/2015/10/benchmark-postgresql-mongodb-arangodb/?utm_source=dbweekly&utm_medium=email) — Note that ArangoDB (an open source multi-model NoSQL database) published this benchmark, so your mileage may vary (there was [further discussion on this](https://news.ycombinator.com/item?id=10380527) at Hacker News). ArangoDB [Real-time database monitoring at any scale](http://dtdg.co/1PkYlNZ) — Datadog can monitor resources, errors, and performance of all your databases in one place. By visually correlating metrics and events originating from anywhere in your stack, Datadog gives you powerful, actionable insights about the health of your infrastructure and services. Begin your free Datadog trial today! Datadogsponsored [![\](https://copm.s3.amazonaws.com/00d562b8.png)](http://dtdg.co/1PkYlNZ) [Oracle Live SQL: SQL Documentation and Tutorials from Oracle](https://livesql.oracle.com/apex/livesql/file/index.html?utm_source=dbweekly&utm_medium=email) — Lots of great code examples, and you can optionally run them ‘live’ on a real Oracle instance (but this requires a login). Oracle [The 10 Most Popular DB Engines (SQL and NoSQL) in 2015](http://blog.jooq.org/2015/10/15/the-10-most-popular-db-engines-sql-and-nosql-in-2015/?utm_source=dbweekly&utm_medium=email) — Oracle, MySQL and SQL Server hold the top 3 positions, with MongoDB, Cassandra and Redis climbing. jooqnews [Couchbase Passes MongoDB in Functionality, CEO Claims](http://www.datanami.com/2015/10/06/couchbase-passes-mongodb-in-functionality-ceo-claims/?utm_source=dbweekly&utm_medium=email) — With Couchbase 4 now out, their CEO thinks features like N1QL, JSON joins, and the nesting and unnesting of JSON are giving Couchbase an edge. Datanamiopinion [GalaXQL 3.0: An SQL Tutorial Disguised As A Galaxy Simulation?](http://sol.gfxile.net/g3/?utm_source=dbweekly&utm_medium=email) — An interesting, interactive approach for a simple SQL tutorial. gfxile.​nettutorial In brief [AWS Import/Export: Cloud Data Transfer Services](http://aws.amazon.com/importexport/?utm_source=dbweekly&utm_medium=email) — Got a huge database (even on the scale of petabytes) to migrate to Amazon? They’ve invented some appliances to get things going. Amazonnews [Scale Out PostgreSQL for Real-Time Big Data with CitusDB](http://info.citusdata.com/BigDataDBW.html) — Gain [real-time insights](http://info.citusdata.com/BigDataDBW.html) into your Big Data and leverage your existing PostgreSQL knowledge and applications. Citus Datasponsored [Microsoft Improving Data Security for Azure SQL Database](https://azure.microsoft.com/en-us/blog/microsoft-azure-sql-database-provides-unparalleled-data-security-in-the-cloud-with-always-encrypted/?utm_source=dbweekly&utm_medium=email) — ‘Always Encrypted’ will keep data encrypted at all times. ‘Transparent Data Encryption’ will make encryption available without making changes to your applications. And more, naturally. Microsoftnews [Combined Row-Based and Columnar Storage in PostgreSQL 9.5](https://www.citusdata.com/blog/14-marco/273-combined-row-based-and-columnar-storage-postgresql-95?utm_source=dbweekly&utm_medium=email) Citus Datatutorial [SQL for Beginners: Installing PostgreSQL and Creating Your First Database](https://www.youtube.com/watch?v=xaWlS9HtWYwa&utm_source=dbweekly&utm_medium=email) YouTubevideo [Health Care Emerges as Hadoop Use Case](http://www.datanami.com/2015/10/08/health-care-emerges-as-hadoop-use-case/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [Why Do You Need Data Modeling?](http://www.vertabelo.com/blog/technical-articles/why-do-you-need-data-modeling?utm_source=dbweekly&utm_medium=email) — A very simple introduction to modelling your data’s structure and relationships. Adrian Więch and Agnieszka Kozubek-Krycuńopinion [Survey: More Data Sources Making it Tougher to Herd](http://www.datanami.com/2015/10/14/survey-more-data-sources-making-it-tougher-to-herd/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [Give your legacy DB a power-up with our open source REST API platform](https://www.dreamfactory.com/signup-for-dreamfactory?utm_source=dbweekly&utm_medium=email&utm_campaign=vwo) — Been asked to build a mobile app integrating an existing DB with an external service? We can help. DreamFactorysponsored [Mongoop: Monitor and Locate Long Running Operations on MongoDB](https://github.com/Lujeni/mongoop?utm_source=dbweekly&utm_medium=email) Lujenitools [EDB: A Framework to Make and Manage Backups of Your Database](https://github.com/RoxasShadow/EDB?utm_source=dbweekly&utm_medium=email) — Make ciphered backups of your database(s) and then upload them via FTP and Amazon S3 (or just keep them in your server). Giovanni Capuanotools code Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/75) [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