#251 — April 26, 2019

Read on the Web

Database Weekly

Generating Fractals with SQL — At !!Con West 2019, Michael gave a talk about creating fractals using SQL and here’s the written version. This is not only a (very detailed) bit of fun, but you’ll learn something about both SQL and Postgres along the way — strongly recommended.

Michael Malis

MongoDB is the 'Most Wanted' Database by Developers for the 4th Consecutive Year — Four years in a row, MongoDB is the Most Wanted Database by developers in Stack Overflow’s popular survey (taken by over 90,000 developers this year). Mat credits MongoDB’s document oriented model and MongoDB’s ability to be widely distributed.

Mat Keep

Studio 3T Makes SQL Migration to MongoDB, Powerfully Simple — Now you can import an entire SQL database to MongoDB using Studio 3T and its new SQL Migration feature.

Studio 3T sponsor

Amazon RDS Now Supports Per-Second Billing — Rather than being billed for an entire hour, the billing increment is now in seconds. But don’t get too excited for spinning up and destroying new instances too quickly, as there’s a 10 minute minimum charge (as with Aurora Serverless).

Amazon Web Services

Ireland Failing on Enforcement of New Data Privacy Rules — This story sounds dull but it actually goes pretty deep and is some great reporting. Essentially, Ireland is the EU’s ‘lead regulator’ for GDPR issues but Ireland’s commitment to policing data standards is under question.

POLITICO

Search Benchmarking: RediSearch vs. ElasticsearchRediSearch is a distributed full-text search and aggregation engine built as a module on top of Redis and it’s benchmarked against Elasticsearch here. Naturally, take note that the benchmark is being done by Redis Labs :-)

Redis Labs

MongoDB to Acquire Open-Source Mobile Database Realm (for $39 Million) — MongoDB Inc. is to acquire Realm, an open-source database geared for mobile applications, later this summer.

TechCrunch

📒 Tutorials and Opinions

Comparing Approaches to Real-Time Analytics on Amazon DynamoDB — AWS’s DynamoDB NoSQL database has been a fundamental part of AWS since its launch in 2012. Here, see some approaches for building analytical systems and dashboards on top of it.

Anirudh Ramanathan (Rockset)

The Best Way to Manage Access to DBs — strongDM works with everything in your stack. Seriously. Any database (yes, even Druid). Any server. Every environment. See how it works.

strongDM sponsor

Medical Records, But On The Blockchain? The History of A Bad Idea — Yes. Please let’s not go down this path. Not everything has to be shoe-horned into a blockchain.

David Gerard

SQL Performance Explained: The Database Tuning Book for Developers — It’s not free but Markus is very well respected in this space, a PDF version is only €10, and he’s just made some updates for 2019.

Markus Winand ebook

Using IGNORE NULLS With SQL Window Functions to Fill Gaps — A nice answer to a challenge posed on Twitter. It’s written in Oracle-flavored SQL but there’s a neat SQLite answer to the same challenge in the comments.

Lukas Eder

Calling an Oracle Function with PL/SQL BOOLEAN Type from SQL — Did you know Oracle doesn’t support boolean types in its SQL engine?

Lukas Eder

💻 Jobs

Senior Site Reliability Engineer, Cloud Services (New York) — Help build and support the best database management service for the leading document database server in the world.

MongoDB

Have You Tried Vettery? — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started.

Vettery

🛠 Code and Tools

Databricks Open Sources Delta Lake — Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark™ and big data workloads. The story behind this is covered in more depth by Datanami.

Databricks

Free SQL Server Load Testing Tools — If I wanted to know anything about SQL Server, Brent would be the first person I’d hit up, so.. I’m trusting this list of tools.

Brent Ozar

redis-Tui: A Redis Text-Based UI Client — A terminal-based way to navigate a Redis database in a slightly more visual way than using redis-cli.

🍃 Do you work with MongoDB?

MongoDB Weekly: Our Bi-Weekly MongoDB Newsletter — We recently brought back our MongoDB newsletter as a bi-weekly publication after a brief hiatus. Here’s the latest issue. If you’re using MongoDB at all or just want to keep up with the latest developments, check it out.

Cooperpress