--- title: "This week's database news, issue 64" publication: "DB Weekly" issue: 64 published_at: "2015-07-24" canonical_url: "https://dbweekly.com/issues/64" --- Database Weekly 64 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/64) [Database Weekly](http://dbweekly.com) Issue 64 — July 24, 2015 Featured [SQL Style Guide](http://www.sqlstyle.guide/?utm_source=dbweekly&utm_medium=email) — A well thought out, cleanly presented, and Creative Commons licensed SQL style guide you can adopt or fork for your own purposes. Simon Holywell [Serenity: A Database with Disk Storage and ACID Transactions under a Redis-Compatible Protocol](http://serenitydb.org/?utm_source=dbweekly&utm_medium=email) — A pre-beta release of a Redis-protocol compatible database system but with added cursor, ACID transaction, and stored procedure support. Dmitry Simonenkotools [It's the Data, Stupid](https://blog.shodan.io/its-the-data-stupid/?utm_source=dbweekly&utm_medium=email) — A look at what you can find when you crawl the Internet for publicly accessible MongoDB instances (595TB of data for example - make sure you secure your setups). Shodan [VividCortex - the New Face of Database Monitoring](http://t.sidekickopen13.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg4WJ3rsN6448bPf6xSsW2BgSpx56dQQddQpf6002?t=https%3A%2F%2Fvividcortex.com%2F%3Futm_source%3Dpaid%26utm_medium%3Ddbw&si=6148852320567296&pi=5783cdb1-275a-4db4-ffcc-3eff454d2604) — VividCortex is the best way to see what is happening on your production servers. Unlike traditional monitoring, we measure and analyze the system’s work and resource consumption. This leads directly to better performance for IT as a whole, at reduced cost and effort. Vivid Cortexsponsored [![\](https://copm.s3.amazonaws.com/6f0f4bb4.png)](http://t.sidekickopen13.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg4WJ3rsN6448bPf6xSsW2BgSpx56dQQddQpf6002?t=https%3A%2F%2Fvividcortex.com%2F%3Futm_source%3Dpaid%26utm_medium%3Ddbw&si=6148852320567296&pi=5783cdb1-275a-4db4-ffcc-3eff454d2604) [Big Data, Small Cluster](http://radar.oreilly.com/2015/07/big-data-small-cluster.html?utm_source=dbweekly&utm_medium=email) — Engineers at Dell were developing customer apps when they found that the query response times their customers were demanding required a new type of query engine. An engineer on this new solution will be presenting a webinar next Wednesday. Marie Beaugureau [Why You Should Never, Ever, Ever Use MongoDB](http://cryto.net/~joepie91/blog/2015/07/19/why-you-should-never-ever-ever-use-mongodb/?utm_source=dbweekly&utm_medium=email) — A very controversial opinion piece that we’re only linking to due to its popularity and the discussions it has caused this past week such as [this](https://news.ycombinator.com/item?id=9912842) on Hacker News. Sven Slootwegopinion [ZomboDB: Postgres Extension For Elasticsearch-Backed Indexes](https://github.com/zombodb/zombodb?utm_source=dbweekly&utm_medium=email) — An extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch. In order to achieve this, ZomboDB implements Postgres’ Access Method API. ZomboDBcode [Elasticsearch with AWS Spot Instances](http://blog.pixlee.com/elasticsearch-with-aws-spot-instances?utm_source=dbweekly&utm_medium=email) — Elasticsearch is a distributed full text search engine that’s well suited to spot instances in AWS since it’s OK if the occasional node falls down. Dennis Yu [Startup Launches Big Data-as-a-Service](http://www.cio.com/article/2951220/big-data/startup-launches-big-data-as-a-service.html?utm_source=dbweekly&utm_medium=email) — Cazena aims to help enterprises solve big data engineering challenges with a managed service platform addressing the security and complexity challenges that have kept many enterprises from the cloud. CIO In brief [IBM Acquires Database-As-A-Service Startup Compose](http://techcrunch.com/2015/07/23/ibm-acquires-database-as-a-service-startup-compose/?utm_source=dbweekly&utm_medium=email) TechCrunchnews [Microsoft Unites Analytics Under 'Cortana,' Adds Spark Support](http://www.datanami.com/2015/07/13/microsoft-unites-analytics-under-cortana-adds-spark-support/?utm_source=dbweekly&utm_medium=email) Datanaminews [SQL for Beginners: Learn The Basics of SQL in 1 Hour](https://www.youtube.com/watch?v=7Vtl2WggqOg&utm_source=dbweekly&utm_medium=email) Rajamanickam Antonimuthuvideo [Building Your Own User Analytics System In SQL](https://www.periscope.io/blog/how-to-build-your-own-user-analytics-in-sql.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Exploring MySQL 5.7’s Geo-Spatial Functions](http://www.databasejournal.com/features/mysql/exploring-mysql-5.7s-geo-spatial-functions.html?utm_source=dbweekly&utm_medium=email) Database Journaltutorial [Debugging MySQL Stored Procedures](http://www.databasejournal.com/features/mysql/debugging-mysql-stored-procedures.html?utm_source=dbweekly&utm_medium=email) Database Journaltutorial [Demystifying Oracle's Clustering Factor](http://www.databasejournal.com/features/oracle/demystifying-oracles-clustering-factor.html?utm_source=dbweekly&utm_medium=email) Database Journaltutorial [3 Limits of NoSQL Data Processing](http://www.enterpriseappstoday.com/data-management/3-limits-of-nosql-data-processing.html?utm_source=dbweekly&utm_medium=email) Enterprise Apps Todayopinion [10 Enterprise Use Cases That Are Driving NoSQL Adoption](http://www.eweek.com/database/slideshows/10-enterprise-use-cases-that-are-driving-nosql-adoption.html?utm_source=dbweekly&utm_medium=email) eWeekopinion [Ask HN: How Do You Version Control A Database?](https://news.ycombinator.com/item?id=9916834&utm_source=dbweekly&utm_medium=email) Hacker Newsopinion [kingshard: A High-performance Proxy for MySQL Powered by Golang](https://github.com/flike/kingshard?utm_source=dbweekly&utm_medium=email) Chen Feicode tools [PostgREST: A REST API for Any Postgres Database](https://github.com/begriffs/postgrest?utm_source=dbweekly&utm_medium=email) Joe Nelsoncode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/64) [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