MySQL Icon

MySQL

MySQL is an open source relational database management system.
10 Stories
All Topics

Shayon Mukherjee shayon.dev

Why I enjoy PostgreSQL (an infra engineer's perspective)

This post by Shayon Mukherjee is in response to the recently logged post by Mike Coutermarsh in praise of MySQL for infra folks:

This is not a MySQL vs PostgreSQL post. This is just a small summary of what I have come to appreciate about PostgreSQL as an Infrastructure Engineer.

Always good to keep in mind whenever comparing technologies: trade-offs abound and certain people in certain situations will value certain things about different technologies differently. That’s for certain. 😉

MySQL mikecoutermarsh.com

Why infrastructure engineers prefer MySQL

From Mike Coutermarsh:

For years I’ve been noticing this pattern of infrastructure engineers I really respect preferring MySQL and product engineers preferring Postgres. It took quite a while for me to understand it. Especially coming from my background as a product engineer. Infrastructure engineers generally…

Read on to hear why (from Mike’s perspective).

Deno github.com

Deno gets an ORM

DenoDB has a fully-typed API (which is great for editor integration) and supports a whole host of backends: MySQL/Maria, SQLite, Postgres, and MongoDB.

Broad database support is great for library adoption, but as a user I’d prefer something that leans in to a specific ecosystem, which usually lets you squeeze more out of it.

Regardless of that, it’s great to see the Deno community building foundational tools like this.

Michael Malis YouTube

Writing an interpreter in SQL for fun and no profit!

Michael Malis at !!Con 2019:

Writing SQL can be hard. SQL code is a bizarre combination of yelling and relational algebra. How can we make writing SQL easier? By embedding our own programming language in our SQL queries of course! In this talk, we’ll take a look at how you use a combination of various Postgres features to build a programming language out of SQL.

Git github.com

gitbase – an SQL interface to Git repositories

It can be used to perform SQL queries about the Git history and about the Universal AST of the code itself. gitbase is being built to work on top of any number of git repositories.

The emphasis here is on querying a bunch of repositories at once, not digging deep in to the history of a single repo. It uses MySQL’s wire protocol to communicate, so it can be accessed by any compatible client or library. gitbase is still in early alpha, but they’re working hard to improve it quickly.

  0:00 / 0:00