--- title: "#163: Do We Need Specialized Graph Databases?" publication: "DB Weekly" issue: 163 published_at: "2017-07-14" canonical_url: "https://dbweekly.com/issues/163" --- Database Weekly 163 This week's database news -[Read this on the Web](http://dbweekly.com/issues/163) [Database Weekly](http://dbweekly.com) Issue 163 — July 14, 2017 [BigchainDB 1.0: A Scalable Blockchain Database](https://blog.bigchaindb.com/bigchaindb-version-1-0-released-932bee682266?utm_source=dbweekly&utm_medium=email) — [BigchainDB](https://www.bigchaindb.com/) is a decentralized database with blockchain characteristics, at scale. [GitHub repo.](https://github.com/bigchaindb/bigchaindb) Tim Daubenschütznews [Delivering Billions of Messages Exactly Once](https://segment.com/blog/exactly-once-delivery/?utm_source=dbweekly&utm_medium=email) — The single requirement of all data pipelines is that they cannot lose data, but de-duplicating messages can be the trickier part. Segmentstory [A pipeline for continuous data migration with the SQLizer API](http://blog.sqlizer.io/posts/the-sqlizer-api/) — With data holed up in third party apps everywhere, APIs are the sensible way to continuously migrate data to your own databases. The SQLizer API gives you essential conversion to SQL capability for your migration pipeline, all from your command line. SQLizersponsored [![\](https://copm.s3.amazonaws.com/905f7fff.png)](http://blog.sqlizer.io/posts/the-sqlizer-api/) [Do We Need Specialized Graph Databases?](https://blog.acolyer.org/2017/07/07/do-we-need-specialized-graph-databases-benchmarking-real-time-social-networking-applications/amp/?utm_source=dbweekly&utm_medium=email) — A look through an academic paper where the authors ran a graph data management system benchmark suite over several popular graph databases with interesting results. the morning paperstory [Working with DynamoDB At Scale is Very Tricky](https://syslog.ravelin.com/you-probably-shouldnt-use-dynamodb-89143c1287ca?utm_source=dbweekly&utm_medium=email) — Or, as the author puts it, _“You probably shouldn’t use DynamoDB”_. (Note: DynamoDB is AWS’s NoSQL database service.) Jono MacDougallopinion [ORMs Should Update “Changed” Values, Not Just “Modified” Ones](https://blog.jooq.org/2017/06/28/orms-should-update-changed-values-not-just-modified-ones/?utm_source=dbweekly&utm_medium=email) — How the SQL language and its implementations distinguish between changed values and modified values. Lukas Ederopinion [Using SQL Within Google Sheets](http://www.benlcollins.com/spreadsheets/google-sheets-query-sql/?utm_source=dbweekly&utm_medium=email) — Did you know Google’s Web-based spreadsheet tool includes a ‘query’ function for using SQL against your spreadsheet? This is a guide to using it. Ben Collinstutorial [All About Indexes: The Very Basics](http://www.vertabelo.com/blog/technical-articles/all-about-indexes-the-very-basics?utm_source=dbweekly&utm_medium=email) — Well placed and defined indexes will improve your database’s performance significantly. A popular article from last year. Emil Drkušićtutorial [New CEO, Same Strategy for Couchbase](https://www.datanami.com/2017/07/12/new-ceo-strategy-couchbase/?utm_source=dbweekly&utm_medium=email) Datanaminews [Apache Spark 2.2.0 Released](http://spark.apache.org/releases/spark-release-2-2-0.html?utm_source=dbweekly&utm_medium=email) — The [_structured streaming_](http://spark.apache.org/docs/2.2.0/structured-streaming-programming-guide.html) stream processing engine is now considered GA. Apache Foundationnews [Estimating CPU Per Query with Weighted Linear Regression](https://www.vividcortex.com/resources/estimating-cpu-per-query-with-weighted-linear-regression?utm_campaign=DB%20Weekly&utm_source=ppc) — This eBook explains how a specialization of linear regression answers seemingly unsolvable database questions. VividCortexsponsored [The Seven Types of SQL Joins](https://blog.teamsql.io/the-seven-types-of-sql-joins-5bc72f69a609?utm_source=dbweekly&utm_medium=email) Eren Baydemirtutorial [Modeling Polymorphic Associations in a Relational Database](https://hashrocket.com/blog/posts/modeling-polymorphic-associations-in-a-relational-database?utm_source=dbweekly&utm_medium=email) Jack Christensentutorial [Access all of the content from MongoDB World 2017](https://explore.mongodb.com/?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=sponsored%20&utm_medium=email&utm_source=dbweekly) — Watch the keynote videos and download all of the breakout session presentations [here](https://explore.mongodb.com/?jmp=cpress=WW_CP_newsletter_sponsorship_FY17Q2=sponsored%20=display=dbweekly0714). Mongo DBvideo sponsored [MongoDB Users Discuss Their NoSQL Journeys](https://www.datanami.com/2017/06/26/mongodb-users-discuss-nosql-journeys/?utm_source=dbweekly&utm_medium=email) Datanamistory [Enhanced Real-Time Data Processing with Redis Labs’ In-Memory Database Solution](http://www.dataversity.net/enhanced-real-time-data-processing-redis-labs-memory-database-solution/?utm_source=dbweekly&utm_medium=email) Dataversitystory [BuntDB: Embeddable, In-Memory Key/Value Database](https://github.com/tidwall/buntdb?utm_source=dbweekly&utm_medium=email) — A low-level, in-memory (but persists to disk), key/value store in pure Go, with geospatial support. Inspired by BoltDB. Josh Bakercode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/163) [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