This Log Buffer Edition covers Cloud, Oracle, MySQL, and PostgreSQL.
What is the quickest way to integrate NLP in an application?
How to Process and Present IoT Data on Microsoft Azure?
Amazon Kinesis Analytics Now Supports Configuring Multiple Destinations in the Console
Demystifying ML: How machine learning is used for speech recognition
Google Cloud Dedicated Interconnect gets global routing, more locations, and is GA
Microservices: Running a webserver (caddy) on Ubuntu Core with snap
ksplice kernel updates and Exadata patching
GoldenGate Naming Convention P03
Essential WebLogic Tuning to Run on Docker and Avoid OOM
Exadata X5-2L deployment & Challenges
Just within the past month there have been a number of strong technical articles written by users of PostgreSQL showcasing how they are leveraging the database. It seemed worth highlighting a few of the best that Jeremy Schneider came across.
Innumerable companies are entrusting a priceless asset – source code – to PostgreSQL via GitLab. Just a few weeks ago, Yorick Peterse from GitLab wrote about different approaches for scaling PostgreSQL and why they chose against sharding and in favor of standbys with am external connection pooler.
German eCommerce company Shopping24 is a heavy PostgreSQL user; their standard database deployment is a 40 core, 256G, SSD-backed bare metal server. Torsten Bøgh Köster recently wrote an excellent post about how they have created a dynamic autovacuum configuration. (For those of you on other database platforms, “vacuum” is PostgreSQL’s clever mechanism to move undo processing out of the commit path and defer it for later processing.)
Phil Freeman at Lumi documented their surprise at PostgreSQL’s performance and maturity in handling JSON and full text search. They successfully migrated their backend stack from RethinkDB and ElasticSearch to PostgreSQL.
Speaking of features, GIS support is something PostgreSQL is very well known for – many argue that it’s even a better platform than the commercial alternatives in this area. Mark Mathis at DescartesLabs wrote a fantastic article about creating animated maps showing crop yield forecasts over time with PostgreSQL.
And finally, are there any Game of Thrones fans out there? PatrickTriest is a fan – and he wrote a two-part article about how he aggregated open-source geo-data and wiki text from other fans to create a PostgreSQL-based google-maps-style website for exploring the entire Game of Thrones world! He even posted all of his code on github and keeps a public demo at atlasofthrones.com.
Contention-Aware Transaction Scheduling Arriving in InnoDB to Boost Performance
There’s a GTID_SUBTRACT function, and the manual shows how to write your own cheap GTID_UNION, but not a GTID_INTERSECT.
In the 1990s C.J.Date said: “The rule by which it is determined within the standard that one key word needs to be reserved while another need not be is not clear to this writer.”
Insert benchmark, IO-bound, Intel NUC: MyRocks vs InnoDB
Top Performance Metrics to Monitor on MySQL (Connections & Buffer Pool Usage)