--- title: "This week's database news, issue 146" publication: "DB Weekly" issue: 146 published_at: "2017-03-17" canonical_url: "https://dbweekly.com/issues/146" --- Database Weekly 146 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/146) [Database Weekly](http://dbweekly.com) Issue 146 — March 17, 2017 Featured [How Discord Indexes Billions of Messages](https://blog.discordapp.com/how-discord-indexes-billions-of-messages-e3d5e9be866f?utm_source=dbweekly&utm_medium=email) — Discord is a chat service supporting millions of users. How could they add quick searching? Here’s how they set it up with Elasticsearch. Discordstory [Timescale: An Open Source Time-Series Database](http://www.timescaledb.com/?utm_source=dbweekly&utm_medium=email) — SQL made scalable for time-series data. It’s Postgres compatible and optimized for fast ingest & complex queries. Timescale [Real-Time Deduping At Scale with Redis](http://eng.tapjoy.com/blog-list/real-time-deduping-at-scale?utm_source=dbweekly&utm_medium=email) — Deduping at scale is a hard problem and Tapjoy share a lot of details of how they use Redis to do it on over 2 million analytics messages per minute arriving in an ‘at-least-once’ style. Tapjoy Engineeringstory [Linode is the SPEEDIEST SSD host for your DB - simple, reliable & powerful.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) — MySQL? MariaDB? PostgreSQL? Whatever DB you use, run it on a Linode, the most scalable, reliable and fastest servers in the cloud. Use promo code DB20 for a $20 credit and get started! linodesponsored [![\](https://copm.s3.amazonaws.com/c740311a.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) [Miller: Like awk, sed, cut, join, and sort for CSV, TSV, and JSON](https://github.com/johnkerl/miller?utm_source=dbweekly&utm_medium=email) — Provides Unix tool-esque functionality but around key-value pair data. Written in C too, so no dependencies. John Kerltools [Hoodie: Uber's Incremental Processing Framework on Hadoop](https://eng.uber.com/hoodie/?utm_source=dbweekly&utm_medium=email) — Uber Engineering recently built and open sourced [Hoodie](https://uber.github.io/hoodie/), an incremental processing framework to power Uber’s data pipelines at low latency. Uber Engineeringtools [Has Hadoop Failed Us?](https://www.datanami.com/2017/03/13/hadoop-failed-us-tech-experts-say/?utm_source=dbweekly&utm_medium=email) — Alex Woodie brings together several people from across the industry to question if the Hadoop dream of unifying data and compute in a distributed manner has become too expensive and complex. Datanamiopinion [Don’t Migrate Databases Automatically](https://blog.staffjoy.com/dont-migrate-databases-automatically-5039ab061365?utm_source=dbweekly&utm_medium=email) — Migrating your DB and deploying app code at the same time can create a race condition that could take down your app. Philip I.​ Thomasopinion In brief [Amazon Aurora Cuts Entry-Level Pricing With Support for t2.small Instances](https://aws.amazon.com/about-aws/whats-new/2017/03/amazon-aurora-cuts-entry-level-pricing-in-half-with-support-for-t2-small-instances/?utm_source=dbweekly&utm_medium=email) Amazon Web Services, Inc.​ news [FaunaDB Launches Serverless Cloud](https://fauna.com/blog/faunadb-serverless-cloud-launch-day?utm_source=dbweekly&utm_medium=email) Faunanews [Database Performance Monitoring Buyer’s Guide](https://www.vividcortex.com/resources/database-performance-monitoring-buyers-guide?utm_campaign=DB%20Weekly&utm_source=dbweekly&utm_medium=email) — This guide is designed to aid when evaluating database monitoring solutions for your unique environment. VividCortextutorial sponsored [Faster SQL Through Occasionally Choosing Natural Keys Over Surrogate Keys](https://blog.jooq.org/2017/03/16/faster-sql-through-occasionally-choosing-natural-keys-over-surrogate-keys/?utm_source=dbweekly&utm_medium=email) JavaOOQtutorial [Amazon Redshift Pitfalls And How To Avoid Them](https://blog.heapanalytics.com/redshift-pitfalls-avoid/?utm_source=dbweekly&utm_medium=email) James Katztutorial [The Complete Guide to GROUP BY on Oracle](http://www.databasestar.com/oracle-group-by/?utm_source=dbweekly&utm_medium=email) Ben Brummtutorial [An Antique Store Data Model](http://www.vertabelo.com/blog/technical-articles/an-antique-store-data-model?utm_source=dbweekly&utm_medium=email) — Vertabelo’s fine data modelling guides continue to get more niche :-) Vertabelotutorial [First Impressions of Google Cloud SQL for PostgreSQL](http://penningpence.blogspot.co.uk/2017/03/first-impressions-google-cloud-sql-for.html?utm_source=dbweekly&utm_medium=email) Payal Singhopinion [Why You Should Choose SQL for Your Web Application](https://stateofprogress.blog/choose-sql-d017cfc08870?utm_source=dbweekly&utm_medium=email) Paris Kasidiarisopinion [SQL Source Control: track each change to your SQL Server database](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=email&utm_content=track_every_change&utm_campaign=sqlsourcecontrol&utm_term=email-25327) — Get a full history in your source control system. See who made changes, what they did and why. [See how](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly=displayemail=track_every_change=sqlsourcecontrol=email-25327). Red Gatetools sponsored [Euphrates: A Periodic 'Table Copier' from MySQL to Amazon Redshift](https://github.com/patreon/euphrates?utm_source=dbweekly&utm_medium=email) Patreontools [Flyway: An Open Source Database Migrations Tool](https://flywaydb.org/?utm_source=dbweekly&utm_medium=email) — Works with all major databases. Boxfusetools [TeamSQL: A Multi-Platform SQL Client (in Private Beta)](https://teamsql.io/?utm_source=dbweekly&utm_medium=email) — Looks promising. You can join a waiting list if interested. Tapholictools [A Curated Guide to the Best Tools and Resources for Data Visualization](http://dataviz.tools/?utm_source=dbweekly&utm_medium=email) dataviz.​toolstools Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/146) [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