#348 — April 2, 2021 |
Database Weekly |
Supercharging a Knowledge Graph with Amazon Neptune, Comprehend, and 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 — Fathom 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) |
How to Model JSON to Get the Most Out of Your Document Database — 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. Couchbase sponsor |
How the Postgres Optimizer Works to Speed Up Queries — In Postgres you can use use Hans-Jürgen Schönig |
Building a Full-Text Search Engine in 150 Lines of Python Code — I really enjoyed this. It’s nothing super advanced, but a basic principle quickly implemented. Bart de Goede |
Quick Bits
|
Using 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 Yan Cui |
▶ How to Choose the Right Database for Your Application — 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 — A sync daemon (written in Go) that continuously indexes MongoDB collections into Elasticsearch. Monstache Team |
Teleport 6.0: Database Access Made Easy? — 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 Ben Stopford and Ismael Juma (Confluent) |
Databunker: Secure Storage for Personal Records Built to Comply with GDPR — If you’re handing PII, something like Databunker might make it a bit easier. SecurityBunker |
💻 Jobs |
Workday - PostgreSQL Database Engineer / Administrator — 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 — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now. Hired |