--- title: "MySQL, still the most popular open source database?" publication: "DB Weekly" issue: 258 published_at: "2019-06-14" canonical_url: "https://dbweekly.com/issues/258" --- This week's database news #258 — June 14, 2019 [Read on the Web](https://dbweekly.com/issues/258) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ftryu0c63eifvjsgdhd4.jpg)](https://scalegrid.io/blog/2019-open-source-database-report-top-databases-public-cloud-vs-on-premise-polyglot-persistence/) [A 2019 Open Source Database Report: MySQL Still Leading The Way?](https://scalegrid.io/blog/2019-open-source-database-report-top-databases-public-cloud-vs-on-premise-polyglot-persistence/) — 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). ScaleGrid [Using R vs. Python for Data Science](https://github.com/matloff/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. Norm Matloff [![\](https://copm.s3.amazonaws.com/d77111cf.png)](https://www.cockroachlabs.com/blog/dash-kubernetes-native-database/?utm_campaign=cooper%20press-2019-Q2&utm_source=dbweekly&utm_medium=newsletter&utm_content=kubernetes-native-database) [What Makes a Database Kubernetes-Native?](https://www.cockroachlabs.com/blog/dash-kubernetes-native-database/?utm_campaign=cooper%20press-2019-Q2&utm_source=dbweekly&utm_medium=newsletter&utm_content=kubernetes-native-database) — 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](https://habr.com/en/company/postgrespro/blog/452968/) — 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 on [bloom filters](https://en.wikipedia.org/wiki/Bloom_filter), a type of data structure that can provide very rapid membership checks but with a chance of false positives. Egor Rogov [Socrates: The New SQL Server in the Cloud?](https://www.microsoft.com/en-us/research/publication/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. Microsoft Research [Kafka is Coming to MongoDB (and Vice Versa): Previewing The Official Connector](https://www.mongodb.com/blog/post/kafka-is-coming--previewing-the-official-mongodb-connector-for-apache-kafka) — 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.) 💻 Jobs [Wanted: Curious Developers with ❤️](https://www.keyvalues.com/carbon-five) — Stagnating? Check C5 out: New projects, tech, and challenges perfectly paired with kind, supportive, and brilliant people. Carbon Five [Land a New Dev Job on Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Vettery specializes in tech roles and is completely free for job seekers. Vettery 📒 Tutorials and Stories ▶[How AWS Provides Managed PostgreSQL Databases](https://www.youtube.com/watch?v=hdQ-geGBsq4) — 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. Kevin Jernigan [How to Switch from a RDBMS to DynamoDB in 20 Easy Steps..](https://twitter.com/jeremy_daly/status/1137002244157710336) — 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 [The Chande Momentum Oscillator and InfluxDB](https://www.influxdata.com/blog/the-chande-momentum-oscillator-and-influxdb/?utm_campaign=whytimeseries&utm_medium=newsletter&utm_source=cooperpress) InfluxData sponsor [Coming in MongoDB 4.2: Wildcard Indexes](https://www.mongodb.com/blog/post/coming-in-mongodb-42--1-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. Dj Walker-Morgan ▶[Exploring 10 Postgres Tips and Tricks](https://www.youtube.com/watch?v=vFq9Yg8a3CE) — Webinar-style audio but the [slides are here](https://momjian.us/main/writings/pgsql/tips.pdf) if you prefer. Bruce Momijan ▶[How to Migrate MongoDB to a SQL Database Using Studio 3T](https://www.youtube.com/watch?v=yt8TdNPDvfY) Studio 3T **IN BRIEF:** - Jepsen has done [an analysis of TiDB 2.1.7.](https://jepsen.io/analyses/tidb-2.1.7) PingCAP, the maintainers of TiDB, have [written a post on the process and results.](https://www.pingcap.com/blog/tidb-passes-jepsen-test-for-snapshot-isolation-and-single-key-linearizability/) - Qubole has [a serverless SQL engine](https://www.datanami.com/2019/06/13/serverless-sql-engine-targets-cloud-analytics/) aimed at "pay as you go" cloud-based analytics. - People are questioning whether Hadoop's time is up, whether it's [the public cloud](https://www.nextplatform.com/2019/06/06/have-the-public-clouds-killed-hadoop/) or [Kubernetes](https://www.bmc.com/blogs/hadoop-cloud-native-kubernetes/) killing it off. MongoDB user? 🍃 Check out [our MongoDB newsletter](https://mongodb.email/). 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