QueryLeaf: SQL for Mongo

https://github.com/beekeeper-studio/queryleaf

23•tilt•11mo ago

Comments

ttfkam•11mo ago

Would much rather have "Mongo" for SQL like this:

I am skeptical that SQL with Mongo backing it would be at all performant except in the most trivial cases. On the flip side, Postgres's jsonb indexing makes the inverse very doable.

Zambyte•11mo ago

https://www.ferretdb.com/

VWWHFSfQ•11mo ago

We're seeing a convergence of document DBs adding relational features, and relational DBs adding document features. At this point I find the best of both worlds to simply be PG with JSONB.

    create table document (
      id uuid primary key default gen_random_uuid(),
      doc jsonb
    );

This alone will give you a huge number of the features that Mongo provides, but also the full power of Postgres for everything else.

victor106•11mo ago

this makes so much sense.

I also wonder if there are some specific capabilities of MongoDB that this pattern does not support?

etse•11mo ago

Maybe not capabilities, but I'm wondering if Postgres has gotten any easier to scale horizontally. The administrative overhead of scaling and maintenance with MongoDB seemed lower to Postgres to me.

Would love to hear from others with more Postgres than I.

ttfkam•11mo ago

Excluding conversations about MongoDB compatibility, PG16 added bidirectional replication for multiple writers and there are Postgres-compatible options out there for a distributed database including Citus, EDB Postgres Distributed, Yugabyte, CockroachDB, Aurora Limitless, etc.

The choices require some nuance to figure out a best fit, but then again so does any MongoDB installation (despite the marketing hype to the contrary as there are no free lunches).

You might be surprised how far most folks can typically scale with just read replica(s) on a reasonably sized writer. Add in bidirectional replication for multiple writers, and you can go even further. Beyond that, even vanilla Postgres can do it, but you'll need to do some combinations of partitioning and foreign tables.

zareith•11mo ago

Curious if there is something similar that works with sqlite.

maxbond•11mo ago

As of 3.38 (or 3.45 if you meant a binary JSON structure specifically) https://sqlite.org/json1.html

zareith•11mo ago

We can use json type, but the dx around directly using that is not comparable to mongodb. Which is why I was looking for a similar abstraction.

aleksi•11mo ago

There is FerretDB v1, which provides MongoDB protocol for SQLite. See https://github.com/FerretDB/FerretDB/tree/main-v1

zareith•11mo ago

They seemed to have moved away from that.

From https://docs.ferretdb.io/migration/migrating-from-v1

> Unlike v1.x that provides options for PostgreSQL and SQLite as backend, FerretDB v2.x requires a PostgreSQL with DocumentDB extension as the backend

aleksi•11mo ago

FerretDB v2 is built on top of this extension. See https://github.com/FerretDB/FerretDB

gavinray•11mo ago

It's somewhat of a secret, but AWS's JDBC driver for DocumentDB supports Mongo as well

Let's you interact with Mongo as if it were a regular SQL JDBC database

https://github.com/aws/amazon-documentdb-jdbc-driver

bdcravens•11mo ago

That driver is read-only

gitroom•11mo ago

Honestly, putting Mongo and SQL together always confuses me a bit. I'm way more comfy with Postgres and jsonb. Anyone else feel like scaling Postgres is still kinda a pain?

sparky_•11mo ago

I can appreciate the technical aspect of a translation layer, but I struggle to understand the use case for a tool like this. If your data is inherently relational, then you should be using a relational store anyway. And if it isn't, trying to hammer it on-demand into something that looks relational is going to eat you with performance implications. Unless I'm missing something.

Vercel says internal systems hit in breach

Archive of BYTE magazine, starting with issue #1 in 1975

The Bromine Chokepoint: How Strife Could Halt Production of World’s Memory Chips

Show HN: Faceoff – A terminal UI for following NHL games

KTaO3-Based Supercurrent Diode

Notion leaks email addresses of all editors of any public page

Nanopass Framework: Clean Compiler Creation Language

Game devs explain the tricks involved with letting you pause a game

The seven programming ur-languages (2022)

Uber's AI Push Hits a Wall–CTO Says Budget Struggles Despite $3.4B Spend

SPEAKE(a)R: Turn Speakers to Microphones for Fun and Profit [pdf] (2017)

Show HN: Shader Lab, like Photoshop but for shaders

What are skiplists good for?

College instructor turns to typewriters to curb AI-written work

NIST scientists create 'any wavelength' lasers

Reading Input from an USB RFID Card Reader

Show HN: Prompt-to-Excalidraw demo with Gemma 4 E2B in the browser (3.1GB)

Claude Brain

Reverse Engineering ME2's USB with a Heat Gun and a Knife

Anonymous request-token comparisons from Opus 4.6 and Opus 4.7

Gender reassignment significantly increases psychiatric morbidity

The electromechanical angle computer inside the B-52 bomber's star tracker

Turtle WoW classic server announces shutdown after Blizzard wins injunction

Why Japan has such good railways

Notes from the SF Peptide Scene

When moving fast, talking is the first thing to break

Ask HN: How did you land your first projects as a solo engineer/consultant?

Minimal Viable Programs (2014)

The world in which IPv6 was a good design (2017)

Binary GCD

Vercel says internal systems hit in breach

Archive of BYTE magazine, starting with issue #1 in 1975

The Bromine Chokepoint: How Strife Could Halt Production of World’s Memory Chips

Show HN: Faceoff – A terminal UI for following NHL games

KTaO3-Based Supercurrent Diode

Notion leaks email addresses of all editors of any public page

Nanopass Framework: Clean Compiler Creation Language

Game devs explain the tricks involved with letting you pause a game

The seven programming ur-languages (2022)

Uber's AI Push Hits a Wall–CTO Says Budget Struggles Despite $3.4B Spend

SPEAKE(a)R: Turn Speakers to Microphones for Fun and Profit [pdf] (2017)

Show HN: Shader Lab, like Photoshop but for shaders

What are skiplists good for?

College instructor turns to typewriters to curb AI-written work

NIST scientists create 'any wavelength' lasers

Reading Input from an USB RFID Card Reader

Show HN: Prompt-to-Excalidraw demo with Gemma 4 E2B in the browser (3.1GB)

Claude Brain

Reverse Engineering ME2's USB with a Heat Gun and a Knife

Anonymous request-token comparisons from Opus 4.6 and Opus 4.7

Gender reassignment significantly increases psychiatric morbidity

The electromechanical angle computer inside the B-52 bomber's star tracker

Turtle WoW classic server announces shutdown after Blizzard wins injunction

Why Japan has such good railways

Notes from the SF Peptide Scene

When moving fast, talking is the first thing to break

Ask HN: How did you land your first projects as a solo engineer/consultant?

Minimal Viable Programs (2014)

The world in which IPv6 was a good design (2017)

Binary GCD

QueryLeaf: SQL for Mongo

Comments