--- title: "#154: MapD Open Sources Its GPU-Powered Database" publication: "DB Weekly" issue: 154 published_at: "2017-05-12" canonical_url: "https://dbweekly.com/issues/154" --- Database Weekly 154 . Microsoft's new multi-model database, and running SQLite on Redis -[Read this on the Web](http://dbweekly.com/issues/154) [Database Weekly](http://dbweekly.com) Issue 154 — May 12, 2017 Featured [Microsoft Unveils Azure Cosmos DB, A New Multi-Model DB](https://docs.microsoft.com/en-us/azure/cosmos-db/introduction?utm_source=dbweekly&utm_medium=email) — An Azure-based globally-distributed multi-model database built for low latency, elastic scalability, and high availability. Microsofttools [MapD Open Sources Its GPU-Powered Database](https://www.mapd.com/blog/2017/05/08/mapd-open-sources-gpu-powered-database/?utm_source=dbweekly&utm_medium=email) — Mark Litwintschik has also written a handy guide to [compiling MapD from source.](http://tech.marksblogg.com/compiling-mapd-ubuntu-16.html) MapD Blogstory [RediSQL: A Redis Module That Embeds SQLite](http://redbeardlab.tech/2017/05/10/redisql-road-to-50k?utm_source=dbweekly&utm_medium=email) — Provides a way to get a SQLite server on the cheap and it can serve many 10,000s of queries per second. RedBeardLabtools [Manifold is your hub for amazing developer services](https://www.manifold.co/?utm_source=db-weekly&utm_medium=email&utm_campaign=manifold-2017-wk-19&utm_content=db-weekly-2) — Why waste time managing your own database? Sign Up for Manifold and manage all your services with a single account. We have awesome partners like JawsDB and RedisGreen — so you can get started today with Redis, Postgres, MySQL and even MariaDB. Manifoldsponsored [![\](https://copm.s3.amazonaws.com/0034a1bc.png)](https://www.manifold.co/?utm_source=db-weekly&utm_medium=email&utm_campaign=manifold-2017-wk-19&utm_content=db-weekly-2) [CockroachDB 1.0: A Production-Ready Go-Based SQL Database](https://www.cockroachlabs.com/blog/cockroachdb-1-0-release/?utm_source=dbweekly&utm_medium=email) — One of the “NewSQL” generation of databases, CockroachDB is an open source, distributed SQL database designed for high availability. Spencer Kimballtools [Microsoft Launches Azure Database for MySQL and Postgres](https://techcrunch.com/2017/05/10/microsoft-launches-azure-database-for-mysql-and-postgressql/?utm_source=dbweekly&utm_medium=email) — While Cosmos DB (above) is Microsoft’s big database news of the week, most developers will find their MySQL and PostgreSQL offerings of more immediate use. TechCrunchnews [What Are Graph Databases and Why Should We Care?](https://www.youtube.com/watch?v=qiqLhlG4CkU&utm_source=dbweekly&utm_medium=email) — This hour long talk goes quite deep on understanding the graph database ecosystem from stores such as Neo4j and OrientDB to processing frameworks like GraphX. Dave Bechbergervideo [A Dive Into Spatial Search Algorithms](https://medium.com/@agafonkin/a-dive-into-spatial-search-algorithms-ebd0c5e39d2a?utm_source=dbweekly&utm_medium=email) — The art of searching through millions of points in an instant. Vladimir Agafonkintutorial [Detecting Abuse at Scale with Locality Sensitive Hashing](https://eng.uber.com/lsh/?utm_source=dbweekly&utm_medium=email) — How Uber uses [Locality Sensitive Hashing](https://en.wikipedia.org/wiki/Locality-sensitive_hashing) on Apache Spark to reliably detect fraudulent trips at scale. Uber Engineeringstory [Optimizing Memcached Efficiency at Quora](https://engineering.quora.com/Optimizing-Memcached-Efficiency?utm_source=dbweekly&utm_medium=email) — Quora uses memcached heavily to speed up operations and has just released a new tool called [mcinspector](https://github.com/quora/mcinspector) for analyzing its memory use. Siyuan Fustory In brief [With Cosmos DB, Microsoft Wants to Build One Database to Rule Them All](https://techcrunch.com/2017/05/10/with-cosmos-db-microsoft-wants-to-build-one-database-to-rule-them-all/?utm_source=dbweekly&utm_medium=email) TechCrunchnews [The European Investment Bank Invests €25M into MariaDB](https://ec.europa.eu/commission/commissioners/2014-2019/katainen/announcements/investment-plan-europe-eur-25-million-support-mariadbs-development-new-software_en?utm_source=dbweekly&utm_medium=email) European Commissionnews [A SQL 'Cheat Code' For Faster JSON Queries on SQL Server 2016](https://blog.bertwagner.com/one-sql-cheat-code-for-amazingly-fast-json-queries-1c2402b4b0d2?utm_source=dbweekly&utm_medium=email) Bert Wagnertutorial [How can you help your team write better, shareable SQL faster?](http://www.red-gate.com/products/sql-development/sql-prompt/resources/?utm_source=dbweekly&utm_medium=displayemail&utm_content=stop_bad_sql_2&utm_campaign=sqlprompt&utm_term=email-25727) — Learn more with our free video tips showing how SQL Prompt lets you write, refactor, and share SQL. Red Gatesponsored [The Basics of Good T-SQL Coding Style](https://www.simple-talk.com/sql/t-sql-programming/basics-good-t-sql-coding-style/?utm_source=dbweekly&utm_medium=email) Robert Sheldontutorial [An Intro to Scaling Connections in Postgres](https://www.citusdata.com/blog/2017/05/10/scaling-connections-in-postgres/?utm_source=dbweekly&utm_medium=email) citusdatatutorial [Restoring MongoDB Atlas Database Backups in AWS](https://www.mongodb.com/blog/post/restoring-mongodb-atlas-database-backups-in-aws?utm_source=dbweekly&utm_medium=email) Jay Gordontutorial [Testing Huge PostgreSQL Backups for 37 Cents a Day](https://feedbin.com/blog/2017/05/05/testing-huge-postgresql-backups-for-37-cents-a-day/?utm_source=dbweekly&utm_medium=email) Ben Uboistutorial [Caching Out of Hadoop: How New York Times Embraces New Technology](https://thenewstack.io/caching-hadoop-new-york-times-embraces-new-technology?utm_source=dbweekly&utm_medium=email) Alex Handystory [Developing a Production Realtime App on RethinkDB](https://focus.parabol.co/developing-a-production-realtime-application-on-rethinkdb-b7d759180edc?utm_source=dbweekly&utm_medium=email) Jordan Husney and Matt Krickstory [Migrate your deployment from mLab or Compose and get $100 in credit](https://www.mongodb.com/cloud/atlas/lp/cloud-manager?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=sponsored&utm_medium=display&utm_source=dbweekly0511) — With MongoDB Atlas' Live Import utility, you can migrate your entire deployment with no downtime. MONGODBsponsored [Nitrite: An Embedded NoSQL Database for Java and Android](https://medium.com/@anidotnet/nitrite-an-embedded-nosql-database-for-java-and-android-318bf48c7758?utm_source=dbweekly&utm_medium=email) — An open-source NoSQL embedded document database with a MongoDB-like API. Anindya Chatterjeetools [TiDB Brings Distributed Scalability to SQL](https://thenewstack.io/tidb-brings-distributed-scalability-sql/?utm_source=dbweekly&utm_medium=email) — TiDB supports the MySQL protocol, making it easy to adopt. Susan Halltools Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/154) [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