DB Weekly Issue 75: October 16, 2015

SQLite 3.9.0 Released — It’s adopted semantic versioning, and both the json1 and fts5 (Full Text Search 5) extensions are now part of the core.

Data Infrastructure at IFTTT — 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.

Benchmark: PostgreSQL, MongoDB, Neo4j, OrientDB and ArangoDB — Note that ArangoDB (an open source multi-model NoSQL database) published this benchmark, so your mileage may vary (there was further discussion on this at Hacker News).

Real-time database monitoring at any scale — 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!

Oracle Live SQL: SQL Documentation and Tutorials from Oracle — Lots of great code examples, and you can optionally run them ‘live’ on a real Oracle instance (but this requires a login).

The 10 Most Popular DB Engines (SQL and NoSQL) in 2015 — Oracle, MySQL and SQL Server hold the top 3 positions, with MongoDB, Cassandra and Redis climbing.

Couchbase Passes MongoDB in Functionality, CEO Claims — 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.

GalaXQL 3.0: An SQL Tutorial Disguised As A Galaxy Simulation? — An interesting, interactive approach for a simple SQL tutorial.

AWS Import/Export: Cloud Data Transfer Services — Got a huge database (even on the scale of petabytes) to migrate to Amazon? They’ve invented some appliances to get things going.

Scale Out PostgreSQL for Real-Time Big Data with CitusDB — Gain real-time insights into your Big Data and leverage your existing PostgreSQL knowledge and applications.

Microsoft Improving Data Security for Azure SQL Database — ‘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.

Combined Row-Based and Columnar Storage in PostgreSQL 9.5

SQL for Beginners: Installing PostgreSQL and Creating Your First Database

Health Care Emerges as Hadoop Use Case

Why Do You Need Data Modeling? — A very simple introduction to modelling your data’s structure and relationships.

Survey: More Data Sources Making it Tougher to Herd

Give your legacy DB a power-up with our open source REST API platform — Been asked to build a mobile app integrating an existing DB with an external service? We can help.

Mongoop: Monitor and Locate Long Running Operations on MongoDB

EDB: A Framework to Make and Manage Backups of Your Database — Make ciphered backups of your database(s) and then upload them via FTP and Amazon S3 (or just keep them in your server).