--- title: "PostgreSQL grabs a lifetime achievement award from O'Reilly" publication: "DB Weekly" issue: 264 published_at: "2019-07-26" canonical_url: "https://dbweekly.com/issues/264" --- This week's database news #264 — July 26, 2019 [Read on the Web](https://dbweekly.com/issues/264) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1564134845/gpawa1qb9oni4gb1mdjq.jpg)](https://www.zdnet.com/article/forget-silicon-sql-on-dna-is-the-next-frontier-for-databases/) [Is SQL on DNA The Next Frontier for Databases?](https://www.zdnet.com/article/forget-silicon-sql-on-dna-is-the-next-frontier-for-databases/) — An EU ‘Future and Emerging Technology’ initiative funds far out technology ideas, one of which is the idea of storing data within synthesized DNA. It’s still _incredibly_ expensive to do but progress has been made and there are academic papers and demos ready to go. An area to keep an eye on. George Anadiotis (ZDNet) [LinkedIn Open Sources Brooklin: Near Real-Time Data Streaming at Scale](https://engineering.linkedin.com/blog/2019/brooklin-open-source) — Brooklin is a distributed service for working with streaming data at scale and has been heavily used by LinkedIn for the past few years. It’s built in Java and is [now open source.](https://github.com/linkedin/Brooklin/) LinkedIn Engineering [![\](https://copm.s3.amazonaws.com/b251de0c.png)](https://www.strongdm.com/postgres-weekly/?utm_source=DBWeekly&utm_medium=email&utm_campaign=2019-07-22%20-%20%5BSELF%5D%20-%20%5BSDM%5D%20-%20%5BMID%5D) [Chef’s CTO on Managing DB Access with StrongDM](https://www.strongdm.com/postgres-weekly/?utm_source=DBWeekly&utm_medium=email&utm_campaign=2019-07-22%20-%20%5BSELF%5D%20-%20%5BSDM%5D%20-%20%5BMID%5D) — Adam Jacob says “strongDM takes the friction out of getting end users access to the systems they need.” Zero trust access to any database, server or k8 cluster. [Click here](https://www.strongdm.com/postgres-weekly/?utm_source=DBWeekly&utm_medium=email&utm_campaign=2019-07-22%20-%20%5BSELF%5D%20-%20%5BSDM%5D%20-%20%5BMID%5D%20) to try for free. strongDM sponsor [Expediting Data Fixes and Data Migrations at LinkedIn](https://engineering.linkedin.com/blog/2019/expediting-data-fixes-migrations) — Let’s say LinkedIn decides to enforce a limit of 1000 characters on users’ names.. that requires a ‘data fix’ over the existing database. Here’s how they think about and orchestrate such a job. Kevin Fu [DB Fiddle: An SQL Database Playground](https://www.db-fiddle.com/) — This isn’t exactly _new_ but it’s a (very!) quiet week and I’ve found this tool useful several times when testing out little bits of SQL. It lets you run basic queries upon several versions of MySQL, PostgreSQL, and SQLite, right from the browser. Status200 **IN BRIEF:** - [PostgreSQL has picked up](https://www.2ndquadrant.com/en/blog/postgresql-award/) an O'Reilly Open Source Award for Lifetime Achivement making it essentially the Paul McCartney of databases. - The latest [SQL Server 2019 technology preview is out.](https://cloudblogs.microsoft.com/sqlserver/2019/07/24/sql-server-2019-community-technology-preview-3-2-is-now-available/) It includes _"Big Data Clusters"_, a new feature for doing big data analytics within SQL Server. - [Azure Data Share](https://www.datanami.com/2019/07/19/azure-data-share-seeks-to-streamline-big-data-sharing/) is a new service to make sharing data from Azure Blob Storage or Azure Data Lake Storage to third-party organizations easier. - _Ascend_ has [emerged from 'stealth'](https://venturebeat.com/2019/07/17/ascend-exits-stealth-with-19-million-to-create-automated-intelligent-dataflows/) with $19m in funding to build its 'Autonomous Dataflow Service' for building data pipelines. - Terraform and Vault support are [coming to MongoDB's hosted Atlas platform.](https://www.mongodb.com/blog/post/terraform-and-vault-are-coming-to-mongodb-atlas) 💻 Jobs [Find a Job Through Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery matches top tech talent with growing companies. Create a profile to get started. Vettery 📒 Tutorials and Stories [Random Ordering of Results with SQL](https://vladmihalcea.com/sql-order-by-random/) — An article that covers the use of `ORDER BY` to randomly sort rows in several database-specific ways. Vlad Mihalcea [Standby in Production: Scaling at the Second Largest Classified Site in the World](https://medium.com/avitotech/standby-in-production-scaling-application-in-second-largest-classified-site-in-the-world-97a79a1929de) — _Avito_ is Russia’s largest classified ads site and stores 20TB of data across a hundred PostgreSQL nodes. Here’s a detailed look at their high availability setup. Konstantin Evteev [Test Drive First Class CI/CD Pipelines](https://www.gocd.org/test-drive-gocd.html?utm_campaign=gocd_test_drive&utm_medium=email&utm_source=cooperpress_db&utm_content=go_website&utm_term=) — Use our new test drive to quickly see how GoCD helps solve your CI/CD challenges with our first class pipelines, visualizations, and more. ThoughtWorks - GoCD sponsor [Creating 'Similar Images' Recommendations using FastAi and Annoy](https://towardsdatascience.com/similar-images-recommendations-using-fastai-and-annoy-16d6ceb3b809) — A Python-based image similarity search implementation based on feature vectors obtained from pre-trained CNNs. Gautham Kumaran [Why Running Database Migrations on App Startup is a Bad Idea](https://pythonspeed.com/articles/schema-migrations-server-startup/) Itamar Turner-Trauring [Implementing Constraint Exclusion for Faster Query Performance](https://www.timescale.com/blog/implementing-constraint-exclusion-for-faster-query-performance/) — A look at how Timescale (who create a time-series focused extension for PostgreSQL) leveraged the foundation of PostgreSQL and extended its capabilities to improve performance. Sven Klemm [The Key Aspects of SQL Server Index Analysis and Optimization](https://towardsdatascience.com/sql-server-index-analysis-and-optimization-1edd84d9da) Evgeniy Gribkov A **[Cooperpress](https://cooperpress.com/)** publication. [Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom