FerretDB: open-source MongoDB alternative
At one company we had one-off requests to run get some statistics from our mongodb.Writing the proper queries proven pretty tricky whenever GROUP BY/JOINs were involved, so I used online converters between SQL -> mongo query.But then I realized that PostgreSQL has nice JSONB type (supports indices for subfields). So I put all the mongo data into tables with a single JSONB column (or two columns id+data, if you prefer).Turned out that was much faster to run analytical queries :)"document" is just row"collection" is just table