--- title: "MongoDB 4.2 and AWS Lake Formation both GA" publication: "DB Weekly" issue: 267 published_at: "2019-08-16" canonical_url: "https://dbweekly.com/issues/267" --- This week's database news #267 — August 16, 2019 [Read on the Web](https://dbweekly.com/issues/267) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/wgyfhodlxhxjjbht6jc3.jpg)](https://www.mongodb.com/blog/post/mongodb-42-is-now-ga-ready-for-your-production-apps) [MongoDB 4.2 Released](https://www.mongodb.com/blog/post/mongodb-42-is-now-ga-ready-for-your-production-apps) — The popular document-oriented database takes another step forward with support for distributed ACID transactions, on-demand materialized views, wildcard indexes, and retryable reads and writes (for handling transient cluster failures). Client-side field-level encryption is also in beta. Eliot Horowitz (MongoDB) [AWS Lake Formation Now Generally Available](https://aws.amazon.com/blogs/aws/aws-lake-formation-now-generally-available/) — Not got enough time to build a data warehouse..? Just throw your data into a ‘data lake’, basically a giant pit of all of your data which you can query at leisure. _Lake Formation_ makes the process simpler if you’re using AWS. Amazon Web Services [![\](https://copm.s3.amazonaws.com/4cad9ffe.png)](https://studio3t.com/mongodb-sql-coexistence-whitepaper/?utm_source=cooper&utm_medium=newsletter&utm_campaign=Aug16) [The DevOps Perspective on Database Coexistence](https://studio3t.com/mongodb-sql-coexistence-whitepaper/?utm_source=cooper&utm_medium=newsletter&utm_campaign=Aug16) — Whether you're in DevOps, development, or database administration, download the full SQL Migration whitepaper for free, from Studio 3T. Studio 3T sponsor ['I Wasn’t Getting Hired As A Data Scientist. So I Sought Data On Who Is.'](https://t.co/oRN2PjADkc) — If you’re a data analyst, why not solve your problems using data analysis? 😄I’m not sure how _useful_ Hanif’s discoveries are, but it’s interesting to see so much detail on _who_ data scientists are. Hanif Samad ▶[Serving Deep Learning Models with RedisAI](https://changelog.com/practicalai/53) — A 45 minute chat with Pieter Cailliau, senior product manager at Redis Labs, about using Redis’s _RedisAI_ module for working with tensor data types and deep learning models. The Changelog podcast **Quick bytes:** - PostgreSQL 11.15, 10.10, 9.6.15 and others [have been released](https://www.postgresql.org/about/news/1960/) to fix up some security issues. - A security researcher thought having the license plate `NULL` would be fun. But [it absolutely wasn't](https://www.wired.com/story/null-license-plate-landed-one-hacker-ticket-hell/). - One developer shares [how he keeps up ▶️](https://www.youtube.com/watch?v=5JuNB5V9Alg) with the wide world of SQL Server bloggers. 💻 Jobs [Lead Cloud Security Engineer](https://grnh.se/59299dec1) — Make an impact as our first Security Engineer, focusing on driving innovation and best practices around our cloud security efforts. Cockroach Labs [DB Developers Are in Demand on Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Ready for a bold career move? Make a free profile, name your salary, and connect with hiring managers from top employers today. Vettery 📒 Everything else [How We Built a Logging Stack at Grab](https://engineering.grab.com/how-built-logging-stack) — Before the work outlined in this post, _“performing a query for a string from the last three days was something only run before you went for a beverage.”_ I think we can all sympathize.. Elasticsearch to the rescue! Daniel Kasen [Good Database Design Starts Here](https://t.co/VbqdzFwWxU) — Rules to follow when you start a new database project: usage, model selection, process and testing. Jun Wu [An Overview of Server-Side Programming in PostgreSQL](https://pgdash.io/blog/postgres-server-side-programming.html) — If you just use PostgreSQL as a data store that your app interacts with, you might not realize just how powerful it is as a platform of its own with user defined types, SQL and PL/pgSQL functions and integration with other languages. RapidLoop [The Hidden Costs of Not Properly Managing Your Databases](https://learn.percona.com/cooperpress-the-hidden-costs-not-properly-managing-databases) — See the true cost of downtime to your business, the potential losses that can incur without a well-configured database & infrastructure setup. Percona sponsor [Gaining Code Execution with a Malicious SQLite Database](https://research.checkpoint.com/select-code_execution-from-using-sqlite/) — A demonstration of _“a couple of real-world scenarios: pwning a password stealer backend server, and achieving iOS persistency with higher privileges.”_ Check Point Research [How a Scalable SQL Database Powers Real-Time Analytics at Uber](https://www.memsql.com/blog/scalable-sql-database/) — James Burkhart of Uber explains how MemSQL (a distributed, in-memory, SQL RDBMS) has helped solve latency issues at a critical point in Uber’s growth. MemSQL [Building a Real-Time Anomaly Detection System for Time Series at Pinterest](https://medium.com/pinterest-engineering/building-a-real-time-anomaly-detection-system-for-time-series-at-pinterest-a833e6856ddd) Kevin Chen and Brian Overstreet (Pinterest) [Is Python Strangling R to Death?](https://www.datanami.com/2019/08/15/is-python-strangling-r-to-death/) — The [R language](https://www.r-project.org/about.html) is targeted at the statistical computing and data analysis space, but despite a recent burst of popularity, it’s already being called “a dying language” thanks to Python’s ever increasing domination. Alex Woodie [sqltop: Find The Most Resource Consuming SQL Server Queries](https://github.com/soheilpro/sqltop) — Use [sqlmon](https://github.com/soheilpro/sqlmon) to collect and store SQL Server event data in Elasticsearch, then use this for the analysis. Soheil Rashidi 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