QueryLeaf: SQL for Mongo

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

23•tilt•1y ago

Comments

ttfkam•1y 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•1y ago

https://www.ferretdb.com/

VWWHFSfQ•1y 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•1y ago

this makes so much sense.

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

etse•1y 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•1y 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•1y ago

Curious if there is something similar that works with sqlite.

maxbond•1y ago

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

zareith•1y 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•1y ago

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

zareith•1y 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•1y ago

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

gavinray•1y 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•1y ago

That driver is read-only

gitroom•1y 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_•1y 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.

A domain can now say it is for sale, in DNS

Fastmail offers EU data region

DeepMind's WeatherNext model achieves breakthrough forecasting cyclones

Timeline of the OpenAI accidental attack against Hugging Face

LinkedIn Feed Blocker

Gateway 2000's hilariously bad ads in the 90s (Part II)

Triton: DirectX 11 Driver for QEMU

Voyager 1 FDS Computer Emulator

From your doorbell to your home network

US Military's cyber command unit grapples with cluster of deaths by suicide

BYOC Is Not Just 'Deploy into Their Cloud'

A physicist rigged his pet hamster’s wheel to upload to Strava

Gentoo bugzilla closed due AI bot scraper overload

Building a Rust Inference Engine That Matches Llama.cpp

Hardware backdoors in some x86 CPUs

DeepSeek V4 Flash 0731

U.S. Department of Energy Launches the Genesis Open Models Initiative

No one can afford to make Myst games anymore

What happens if an entire class of workers loses faith in their careers

Wireblast a 100 Gbps packet generator in Go using AF_XDP

k-Coloring is Faster than Computing the Chromatic Number

Assembly Hall of Shame

ao486: x86-compatible Verilog core implementing all features of a 486 SX (2014)

"Code was never the hard part" is an insult to all programmers

Europe's free satellite service just made it easier to track wildfires

Lost my phone at the office. Claude suggested tracking Bluetooth signal strength

Ancient Library – 1,060 Greek/Latin texts, click any word to parse it

2027 memory capacity is reportedly sold out

As a Windows user, it's a surreal way to install a program

NASA figured out how to keep its Voyager 2 probe running for another year

A domain can now say it is for sale, in DNS

Fastmail offers EU data region

DeepMind's WeatherNext model achieves breakthrough forecasting cyclones

Timeline of the OpenAI accidental attack against Hugging Face

LinkedIn Feed Blocker

Gateway 2000's hilariously bad ads in the 90s (Part II)

Triton: DirectX 11 Driver for QEMU

Voyager 1 FDS Computer Emulator

From your doorbell to your home network

US Military's cyber command unit grapples with cluster of deaths by suicide

BYOC Is Not Just 'Deploy into Their Cloud'

A physicist rigged his pet hamster’s wheel to upload to Strava

Gentoo bugzilla closed due AI bot scraper overload

Building a Rust Inference Engine That Matches Llama.cpp

Hardware backdoors in some x86 CPUs

DeepSeek V4 Flash 0731

U.S. Department of Energy Launches the Genesis Open Models Initiative

No one can afford to make Myst games anymore

What happens if an entire class of workers loses faith in their careers

Wireblast a 100 Gbps packet generator in Go using AF_XDP

k-Coloring is Faster than Computing the Chromatic Number

Assembly Hall of Shame

ao486: x86-compatible Verilog core implementing all features of a 486 SX (2014)

"Code was never the hard part" is an insult to all programmers

Europe's free satellite service just made it easier to track wildfires

Lost my phone at the office. Claude suggested tracking Bluetooth signal strength

Ancient Library – 1,060 Greek/Latin texts, click any word to parse it

2027 memory capacity is reportedly sold out

As a Windows user, it's a surreal way to install a program

NASA figured out how to keep its Voyager 2 probe running for another year

QueryLeaf: SQL for Mongo

Comments