--- title: "This week's database news, issue 51" publication: "DB Weekly" issue: 51 published_at: "2015-03-14" canonical_url: "https://dbweekly.com/issues/51" --- This week's database news, issue 51 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/51) DB WeeklyIssue 51 — March 14, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [Defusing Database Time Bombs: Avoiding the Need to Refactor Databases](https://www.simple-talk.com/sql/t-sql-programming/defusing-database-time-bombs-avoiding-the-need-to-refactor-databases/?utm_source=dbweekly&utm_medium=email)Thomas LeBlancWhere applications evolve gradually, challenges to database development can arise. If designed too loosely, schemas can become harder and harder to refactor until they constitute a database ‘time bomb.’ Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs. [Why SQLite's Temporary File Prefix is 'etilqs_', not 'sqlite_'](https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db733dd38f96896cd825f/src/os.h#L52?utm_source=dbweekly&utm_medium=email)GitHubYou’d never guess the reason, but it’s a funny piece of history and an example of how simple things in code can have real life consequences. [The Battle against Patent Trolls Starts Again](http://www.rackspace.com/blog/the-battle-against-patent-trolls-starts-again/?utm_source=dbweekly&utm_medium=email)RackspaceSponsoredEveryone hates patent trolls, but we can only fight them one at a time. Solving the patent troll problem for everyone requires changing the system that aids and encourages troll behavior. Read more on the Innovation Act that was recently re-introduced to Congress. [![Rackspace\](http://ddf912383141a8d7bbe4-e053e711fc85de3290f121ef0f0e3a1f.r87.cf1.rackcdn.com/patent-troll-social-image-1600x800.png)](http://www.rackspace.com/blog/the-battle-against-patent-trolls-starts-again/?utm_source=dbweekly&utm_medium=email) [GraphpostgresQL: GraphQL for Postgres](https://github.com/solidsnack/GraphpostgresQL?utm_source=dbweekly&utm_medium=email)Jason DusekGraphQL is a data querying language designed to describe the complex, nested data dependencies of modern applications. Essentially, a graph interface to relational data. [Pinterest Open Sources 'Pinball', a Data Workflow Manager](http://engineering.pinterest.com/post/113376157699/open-sourcing-pinball?utm_source=dbweekly&utm_medium=email)Pinterest [Why Presto is the Best SQL-On-Hadoop You Haven’t Heard Of](http://blog.treasuredata.com/blog/2015/03/12/presto-sql-on-hadoop/?utm_source=dbweekly&utm_medium=email)Treasure DataPresto is an open source, in-memory distributed SQL query engine developed by Facebook. [Introducing Apache Spark 1.3](https://databricks.com/blog/2015/03/13/announcing-spark-1-3.html?utm_source=dbweekly&utm_medium=email)Patrick WendellA powerful open source processing engine that provides easy-to-use APIs for operating on large datasets. [Why We Built ActorDB](http://blog.biokoda.com/post/112206754025/why-we-built-actordb?utm_source=dbweekly&utm_medium=email)BiokodaActorDB is a distributed SQL database with linear scalability that aims to have no single point of failure. [Goodbye MongoDB, Hello PostgreSQL](http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/?utm_source=dbweekly&utm_medium=email)Yorick PeterseMongo offers developers a lot of agility but data often has structure that needs to be managed in a more relational way. Here’s an interesting and detailed story of someone moving from Mongo to Postgres highlighting the why and how. Jobs - [Customer Data Engineer](https://uscareers-rackspace.icims.com/jobs/10641/customer-data-engineer/job?utm_source=dbweekly&utm_medium=email)Rackspace is seeking a Customer Data Engineer. To do this successfully you’ll be switching hats often, from Systems Administrator resolving a configuration problem on a machine, to DBA digging into production databases to identify issues, to Software Developer troubleshooting customer code. You’ll have the opportunity to work with a broad range of technologies – MongoDB, MySQL, Redis, and Hadoop in particular. [Apply here.](https://uscareers-rackspace.icims.com/jobs/10641/customer-data-engineer/job) Rackspace - [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 - [Microsoft Azure Delivers NoSQL Storage via DocumentDB](http://www.techrepublic.com/article/microsoft-azure-delivers-nosql-storage-via-documentdb/?utm_source=dbweekly&utm_medium=email) news TechRepublic - [MySQL 5.7 Includes CJK Full Text Parsing](https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html?utm_source=dbweekly&utm_medium=email) news MySQL - [SQL-like Query Language for Real-time Streaming Analytics](http://www.kdnuggets.com/2015/03/sql-query-language-realtime-streaming-analytics.html?utm_source=dbweekly&utm_medium=email) opinion Srinath Perera - [Why I Don’t (Yet) Recommend In-Memory OLTP to My Customers](http://www.sqlpassion.at/archive/2015/03/11/dont-yet-recommend-memory-oltp-customers/?utm_source=dbweekly&utm_medium=email) opinion _Warning: Autoplays music for some reason._ Klaus Aschenbrenner - [A Report on Redis Conference 2015](http://antirez.com/news/87?utm_source=dbweekly&utm_medium=email) opinion Salvatore Sanfilippo - [SQLAlchemy 1.0.0 Beta 1 Released](http://www.sqlalchemy.org/blog/2015/03/13/sqlalchemy-1.0.0b1-released/?utm_source=dbweekly&utm_medium=email) code SQLAlchemy is a Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy - [db.py 0.4: Handlebars Meets SQL (in Python)](http://blog.yhathq.com/posts/dbpy-0.4-handlebars-meets-sql.html?utm_source=dbweekly&utm_medium=email) code ŷhat - [goqu: An Expressive SQL Builder and Query Library for Go](https://github.com/doug-martin/goqu?utm_source=dbweekly&utm_medium=email) code Aims to make the generation of SQL easy, provides a DSL for the most common SQL expressions, and has a simple query API too. Doug Martin 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/51) © 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)