--- title: "This week's database news, issue 52" publication: "DB Weekly" issue: 52 published_at: "2015-03-20" canonical_url: "https://dbweekly.com/issues/52" --- This week's database news, issue 52 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/52) DB WeeklyIssue 52 — March 20, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [Understanding SQL's NULL](https://www.periscope.io/blog/understanding-sql-null.html?utm_source=dbweekly&utm_medium=email)PeriscopeTony Hoare invented the null reference in 1965 and he considers it a ‘billion-dollar mistake’ for the amount of trouble it has caused. Even today, SQL’s null value is the cause of several common mistakes. [Presto: Distributed SQL Query Engine for Big Data](https://prestodb.io/?utm_source=dbweekly&utm_medium=email)FacebookAn open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. [Using Elasticsearch with SQL Server](http://blog.pluralsight.com/elasticsearch-and-sql-server?utm_source=dbweekly&utm_medium=email)JP TotoIf you administer an SQL Server database but you’d like to expose all the data you’ve collected in more interesting, effective, and searchable ways, this is worth a read. [Batch, Streaming and Serving: Dive into Hortonworks Data Platform version 2.2](http://www.rackspace.com/blog/batch-streaming-and-serving-hortonworks-data-platform-version-2-2-is-here/?utm_source=dbweekly&utm_medium=email)RackspaceSponsoredNormally, point releases in technology are not always newsworthy. For many legacy applications, the only glaring differences are subversive bug fixes and enhancements to keep up with competitive pressures. The Apache HadoopTM application is an exception because the technology is evolving so fast and in such high demand that each point release comes with notable improvements and several new tools that are actively changing the way users are running their queries, architecting their environments and developing their use cases. [Learn More.](http://www.rackspace.com/blog/batch-streaming-and-serving-hortonworks-data-platform-version-2-2-is-here/) [![Rackspace\](http://s3.amazonaws.com/nlga/uploads/item/image/34934/125.png)](http://www.rackspace.com/blog/batch-streaming-and-serving-hortonworks-data-platform-version-2-2-is-here/?utm_source=dbweekly&utm_medium=email) [Using MongoDB with Spark](https://databricks.com/blog/2015/03/20/using-mongodb-with-spark.html?utm_source=dbweekly&utm_medium=email)DatabricksMatt Kalan discovers Spark is easy to integrate with MongoDB for doing large scale analysis. [A Million Rows Isn't Cool. You Know What's Cool? A Billion Rows.](http://radar.oreilly.com/2015/02/a-million-rows-isnt-cool-you-know-whats-cool-a-billion-rows.html?utm_source=dbweekly&utm_medium=email)O'Reilly RadarWhile you can exercise the features of a traditional database with a million rows, for Hadoop it’s not nearly enough. Think billions of rows instead. [SQL School](http://sqlschool.modeanalytics.com/the-basics/introduction.html?utm_source=dbweekly&utm_medium=email)Mode AnalyticsAre you or someone you know looking to find a good resource for learning SQL? Here’s a great walkthrough of the basics. Jobs - [Database Administrator (Blacksburg, VA)](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job?utm_source=dbweekly&utm_medium=email)Rackspace is seeking a Senior Database Administrator in our Blacksburg, VA office. The Senior DBA will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation. [Learn More.](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job) Rackspace In brief - [Hello World, ZeroDB Here](http://blog.zerodb.io/hello-world-zerodb-here/?utm_source=dbweekly&utm_medium=email) news ‘We’re building an end-to-end encrypted database that lets you run queries without exposing the decrypted data to the server.’ ZeroDB - [Announcing The RethinkDB 2.0 Release Candidate](http://rethinkdb.com/blog/2.0-release-candidate/?utm_source=dbweekly&utm_medium=email) news RethinkDB - [MongoDB 3.0.1 Released](https://groups.google.com/d/msg/mongodb-user/A5vk4RZceGc/RqeLe7IWVPcJ?utm_source=dbweekly&utm_medium=email) news Fixes some issues from 3.0.0 and recommended to all 3.0 users. mongodb-user - [Embedded Analytics Goes Mainstream](http://www.datanami.com/2015/03/17/embedded-analytics-goes-mainstream/?utm_source=dbweekly&utm_medium=email) news Datanami - [MongoDB 3.1.0 (Developer Only Release) Released](https://groups.google.com/d/msg/mongodb-dev/rHe0EmxkIcc/OCouB60v248J?utm_source=dbweekly&utm_medium=email) news mongodb-dev - [Amazon RDS for PostgreSQL Adds Support for 9.4.1](http://aws.amazon.com/about-aws/whats-new/2015/03/amazon-rds-for-postgresql-now-supports-94/?utm_source=dbweekly&utm_medium=email) news Amazon - [MemSQL Brings Geospatial Analysis to In-Memory, Distributed Databases](http://www.marketwired.com/press-release/memsql-brings-geospatial-analysis-to-in-memory-distributed-databases-2001185.htm?utm_source=dbweekly&utm_medium=email) news MarkedWired - [How to Backup your AWS Cloud-based PostgreSQL Database](http://www.n2ws.com/blog/how-to-backup-your-aws-cloud-based-postgresql-database.html?utm_source=dbweekly&utm_medium=email) tutorial N2W Software - [Visual Representations of SQL Joins](http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins?utm_source=dbweekly&utm_medium=email) tutorial From 2009 but still good. CodeProject - [Tinder is Scaling with MongoDB and Some Help from ObjectRocket](http://thenewstack.io/tinder-is-scaling-with-mongodb-and-some-help-from-objectrocket/?utm_source=dbweekly&utm_medium=email) The New Stack - [Performance Testing MongoDB 3.0: Throughput Improvements Measured with YCSB](https://www.mongodb.com/blog/post/performance-testing-mongodb-30-part-1-throughput-improvements-measured-ycsb?utm_source=dbweekly&utm_medium=email) MongoDB - [Why I Choose PostgreSQL Over MySQL/MariaDB](http://news.dice.com/2015/03/19/why-i-choose-postgresql-over-mysqlmariadb/?utm_source=dbweekly&utm_medium=email) opinion Dice News - [Dropping A Column in SQLite Is A Blood Bath](https://medium.com/@baudoui/dropping-a-column-in-sqlite-9d7613e73ae5?utm_source=dbweekly&utm_medium=email) opinion Baudouin - [Generate Test Data Instantly with dbForge Data Generator for SQL Server](http://www.devart.com/news/2015/dbforgesqldatagenerator.html?utm_source=dbweekly&utm_medium=email) tools Devart Curated by [Peter Cooper](http://twitter.com/peterc) and published by [Cooper Press](https://cooperpress.com/) for [Rackspace](http://www.rackspace.com/?utm_source=dbweekly&utm_medium=email). Send feedback by simply replying to this mail. Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q4.pdf) Want to post a job? E-mail us or [use our self-serve system.](https://cooperpress.com/jobs) [Unsubscribe](*|UNSUB|*) : [Change email address](*|UPDATE_PROFILE|*) : [Read this issue on the Web](http://dbweekly.com/issues/52) © Cooper Press Ltd. Office 30, Lincoln Way, Louth, LN11 0LS, UK [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)