​​FerretDB - (★ 5.7K on GitHub) is a truly Open Source MongoDB alternative, built on PostgreSQL. FerretDB is an open-source proxy, converting the MongoDB 6.0+ wire protocol queries to SQL - using PostgreSQL as a database engine.

They recently announced FerretDB 1.0 GA release and now officially this project is production ready, here is the blog post with nice introduction

#db #mongodb #postgresdb #proxy

​​PGlite - (★7.3k at GitHub) is a lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno.

#postgresdb #browser #frontend #database #wasm

​​SQL Explain Plan Visualizer by Datadog.

This is a very useful tool for analysing your SQL query performance and identifying bottlenecks. Simply call the command for your SQL database, like this:

EXPLAIN (ANALYSE, FORMAT JSON, VERBOSE, BUFFERS) [your query]

The console will then generate a detailed JSON report. Copy this report and paste it into the visualiser to explore your query’s weaknesses.

#sql #report #analyse #postgresdb #mysql