Issue 296 - Some ways of calculating Pi with SQL (17)

riskquant: A Library for Quantifying Risk — We missed this release a couple of months ago, but riskquant is a Python library that can be used for risk analysis.

Ways to Compute Pi in SQL — Last Saturday it was “Pi Day” (3/14) and to celebrate, the folks in MemSQL’s engineering team came up with a way to calculate the value of Pi using SQL itself.

Is Database Interoperability at Risk? — Reflections on the current case going on between Oracle and Google over the latter’s alleged ‘copying’ of the Java API and whether it could affect database systems ‘copying’ each other’s SQL-related additions.

Understanding Recursive SQL Queries — Recursive common table expressions make it possible to work with dynamic graph or hierarchically structured data within Postgres. This is quite a nice, gentle introduction to the idea to allow you to move on to more advanced guides.

MongoDB World is now MongoDB.live on May 4-5 — MongoDB World is basically the MongoDB world’s landmark event, but the COVID-19 outbreak has forced it into being a free two-day virtual event.. so even if you weren’t planning on going before, you can easily do so now.

Amazon ElastiCache for Redis Announces Global Datastore — A small step for AWS, but a big step for Redis-kind 😄 With Global Datastore, you can now write to an ElastiCache for Redis cluster in one region and see that data replicated at low latency in two other cross-region replica clusters.

SQLite Gets Its Own User Forum — At only a week old, it’s early days, but it’s neat to have somewhere where SQLite users and developers can converse and ask questions.

Postgres is the World's Best Database: Here's Why — We try to stay database neutral here in Database Weekly but.. “I intend to prove that by virtue of both design and implementation that PostgreSQL is objectively and measurably a better database than anything currently available..” The arguments aren't bad!

“Scan” Your Badge & Cockroach Labs Will Donate $3 to Women Who Code — Cockroach Labs will donate $3 to Women Who Code for every person who "scans" their virtual badge. So stop by and get scanned.

How to Model One-to-Many Relationships in DynamoDB — DynamoDB’s document based approach means that if you’re more familiar with relational databases, you need to take some care when working out how to model things like this.

Ramping Up on Amazon DocumentDB (with MongoDB Compatibility) — Amazon’s DocumentDB is a scalable, highly available, and fully managed document database service that supports MongoDB workloads. This blog post provides a quick summary and set of resources to the topics that are most often asked about - so that you can quickly ramp up on Amazon DocumentDB.

How Netflix Uses Druid for Real-Time Insights — “We’re currently ingesting at over 2 million events per second, and querying over 1.5 trillion rows to get detailed insights into how our users are experiencing the service.”

Automating MySQL Schema Migrations with GitHub Actions and More — A deep dive into how GitHub’s daily schema migrations amounted to a significant toil on their database infrastructure team, and how they searched for a solution to automate the manual parts of the process.

The Troublesome Active Record Pattern — The Active Record Pattern is particularly inefficient even if it initially makes developers’ lives easier.

Try Studio 3T: The best way to get started with MongoDB — Code translation in a click? Easy SQL to MongoDB Migration? We’ve got it - and more. Get your 30-day trial today to see.