--- title: "The second item is a must read" publication: "DB Weekly" issue: 348 published_at: "2021-04-02" canonical_url: "https://dbweekly.com/issues/348" --- Plus bringing conversational queries to Amazon's graph database, and a MongoDB to Elasticsearch syncing tool. | #348 — April 2, 2021 [Read on the Web](https://dbweekly.com/issues/348) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/n1aluw2kjbks6amohwjz.jpg)](https://aws.amazon.com/blogs/database/supercharge-your-knowledge-graph-using-amazon-neptune-amazon-comprehend-and-amazon-lex/) [Supercharging a Knowledge Graph with Amazon Neptune, Comprehend, and Lex](https://aws.amazon.com/blogs/database/supercharge-your-knowledge-graph-using-amazon-neptune-amazon-comprehend-and-amazon-lex/) — A good example of how various Amazon services can lean upon each other. The goal here is to build a knowledge graph application for handling both unstructured and semi-structured data that makes it easy for users to consume. Neptune provides the graph, Comprehend provides structure, and Lex provides a chat style interface for answering natural language questions about the data. Dave Bechberger (AWS) ⭐️ [Building a Fast Web Analytics System on Multiple Datastores](https://usefathom.com/blog/worlds-fastest-analytics) — [Fathom](https://usefathom.com/) is one of a number of new privacy focused _‘well, at least it’s not Google’_ Web analytics systems becoming more popular lately. This post goes into fantastic detail about how they had to scale _quickly_, their database history, and how they’ve ended up storing all their analytics data on the ‘database of their dreams’ – there’s _so much_ to enjoy and learn from here that it’s a must read IMHO. Jack Ellis (Fathom Analytics) [![\](https://copm.s3.amazonaws.com/96a30f6a.jpg)](https://event.on24.com/wcc/r/3097030/ED02206B83338E98DFE6867EF2849468?partnerref=CooperpressDBWeekly) [How to Model JSON to Get the Most Out of Your Document Database](https://event.on24.com/wcc/r/3097030/ED02206B83338E98DFE6867EF2849468?partnerref=CooperpressDBWeekly) — Thinking about using a document database for your next project? The flexible data model is a major plus, but having so many options can be intimidating at first. This free virtual event will help you make all the right choices. [Register here](https://event.on24.com/wcc/r/3097030/ED02206B83338E98DFE6867EF2849468?partnerref=CooperpressDBWeekly). Couchbase sponsor [How the Postgres Optimizer Works to Speed Up Queries](https://www.cybertec-postgresql.com/en/how-the-postgresql-query-optimizer-works/) — In Postgres you can use [use `EXPLAIN` to see](https://blog.crunchydata.com/blog/get-started-with-explain-analyze) what Postgres’s execution planner’s decisions are, but this post goes into depth on the _sort_ of optimizations that take place behind the scenes. Hans-Jürgen Schönig [Building a Full-Text Search Engine in 150 Lines of Python Code](https://bart.degoe.de/building-a-full-text-search-engine-150-lines-of-code/) — I really enjoyed this. It’s nothing super advanced, but a basic principle quickly implemented. Bart de Goede Quick Bits - A brief look at how popular UK car marketplace [_Auto Trader_ migrated from Oracle to Postgres](https://cloud.google.com/blog/products/databases/how-auto-trader-migrated-its-on-prem-databases-to-cloud-sql) using Google Cloud SQL. - [AWS is adding 'explainability'](https://www.datanami.com/2021/03/31/aws-adds-explainability-to-sagemaker/) to its SageMaker machine learning service. The idea is to help understand _why_ certain outcomes occur. [Using AWS Lambda Functions with Amazon Neptune](https://aws.amazon.com/blogs/database/use-aws-lambda-functions-with-amazon-neptune/) — Amazon Neptune is AWS’s _graph database_ service and use cases as diverse as knowledge graphs, identity graphs, and fraud graphs can benefit from using AWS Lambda functions to query Neptune graphs. Ian Robinson (AWS) [How to Model One-to-Many Relationships with AppSync and DynamoDB](https://theburningmonk.com/2021/03/how-to-model-one-to-many-relationships-with-appsync-and-dynamodb/) Yan Cui ▶[How to Choose the Right Database for Your Application](http://go.thoughtleaders.io/2119120210402) — Watch a short video about the different types of databases and how to decide which one best fits the needs of your application. Linode sponsor [Monstache: Sync MongoDB to Elasticsearch in Realtime](https://rwynn.github.io/monstache-site/) — A sync daemon (written in Go) that continuously indexes MongoDB collections into Elasticsearch. Monstache Team [Teleport 6.0: Database Access Made Easy?](https://saiyampathak.medium.com/teleport-6-0-database-access-made-easy-ec7f8a8cc40f) — Teleport is an open source, identity-aware, _access proxy_ and its latest version has added support for accessing Postgres and MySQL. Saiyam Pathak [Kafka Without ZooKeeper: A Sneak Peek at the Simplest Kafka Yet](https://www.confluent.io/blog/kafka-without-zookeeper-a-sneak-peek/) Ben Stopford and Ismael Juma (Confluent) [Databunker: Secure Storage for Personal Records Built to Comply with GDPR](https://github.com/securitybunker/databunker) — If you’re handing PII, something like Databunker might make it a bit easier. SecurityBunker 💻 Jobs [Workday - PostgreSQL Database Engineer / Administrator](https://bit.ly/3dgcr6y) — We’re looking for an engineer to help us build for the future, revamp our persistence architecture, and ensure our systems are operating flawlessly 24/7. We’re one of the largest SaaS companies globally growing rapidly in Europe. Workday [Find Data Engineering Jobs with Hired](https://hired.com/join/?utm_source=newsletter&utm_medium=sponsor&utm_campaign=%28b2c%29%28l-all%29%28r-all%29%28cooper-dbweekly%29&utm_content=5-minutes) — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now. Hired 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