A 2019 Open Source Database Report: MySQL Still Leading The Way? — Based on a survey at the recent Percona Live event, ScaleGrid presents a look at open source database usage (where MySQL, PostgreSQL, and MongoDB are the unsurprising frontrunners).
Using R vs. Python for Data Science — The use of Python for data science work is shooting up and up, but R is perhaps even better suited to the task. Which is better? A R-leaning professor makes some comparisons here.
What Makes a Database Kubernetes-Native? — Running a database in K8s is a contentious topic, as stateful sets and K8s don’t always play nice. What properties does a DB need to make it work?
Cockroach Labs sponsor
A Look at Bloom Indexes in PostgreSQL — The last in a fantastic series of articles digging deep into each type of index that PostgreSQL provides. This time, it’s the turn of bloom indexes which are based onbloom filters, a type of data structure that can provide very rapid membership checks but with a chance of false positives.
Socrates: The New SQL Server in the Cloud? — A paper that presents a novel DBaaS architecture, called Socrates which has been implemented in Microsoft SQL Server and is available in Azure as SQL DB Hyperscale.
Kafka is Coming to MongoDB (and Vice Versa): Previewing The Official Connector — Apache Kafka, the real-time data pipeline and stream processing system, is very popular in enterprise deployments and MongoDB is working on a new, native, and fully supported connector to enable integration in both directions.
Scott L’Hommedieu (MongoDB, Inc.)
Wanted: Curious Developers with :heart: — Stagnating? Check C5 out: New projects, tech, and challenges perfectly paired with kind, supportive, and brilliant people.
Land a New Dev Job on Vettery — Vettery specializes in tech roles and is completely free for job seekers.
:ledger: Tutorials and Stories
▶ How AWS Provides Managed PostgreSQL Databases — A high level 50 minute session that covers the history of AWS RDS and how AWS has provided managed Postgres services over the years. This is a really great overview if you’re considering relying on AWS for running Postgres.
How to Switch from a RDBMS to DynamoDB in 20 Easy Steps.. — These thoughts on what it takes to move from a monolithic RDBMS mindset to one oriented around AWS’s popular key/value and document-based offering are interesting.
Jeremy Daly on Twitter
Coming in MongoDB 4.2: Wildcard Indexes — It’s been over a year since MongoDB 4.0 was released but now we can start looking forward to the next feature driven release, 4.2, which will include a type of index that can only index data that matches specific filters.
▶ Exploring 10 Postgres Tips and Tricks — Webinar-style audio but theslides are here if you prefer.
- Jepsen has done an analysis of TiDB 2.1.7. PingCAP, the maintainers of TiDB, have written a post on the process and results.
- Qubole has a serverless SQL engine aimed at "pay as you go" cloud-based analytics.
- People are questioning whether Hadoop’s time is up, whether it’sthe public cloud orKubernetes killing it off.