Show HN: MongoDB Protocol for SQLite

&quot;However, as time passed, MongoDB abandoned its open-source roots; changing the license to SSPL - making it unusable for many open source and early-stage commercial projects.&quot;<p>This is not true, you can use MongoDB for commercial projects as long as you don&#x27;t sell MongoDB services, but internally you&#x27;re free to use it as your regular DB.<p><a href="https:&#x2F;&#x2F;www.mongodb.com&#x2F;licensing&#x2F;server-side-public-license&#x2F;faq" rel="nofollow noreferrer">https:&#x2F;&#x2F;www.mongodb.com&#x2F;licensing&#x2F;server-side-public-license...</a>

If this implemented sharding it&#x27;d be killer. I recognize that&#x27;d be a huge amount of work, but that would be amazing! I may do that someday. You could just use one PG instance as the config servers and this takes place as the mongos.

Honest question: why doesn&#x27;t Couchdb receive any love on HN?<p>It&#x27;s such a perfect tool for my side projects and most projects that will never reach Twitter scale

Wow, I have nothing to add except this is exactly what I was looking for prior to abandoning my last project... time to dig it back up again. Amazing stuff.

Has anyone tried running the Ubiquiti Unifi controller against this?<p>Even stories of it being successful with the Postgres backend would be really helpful.

Is there any documentation on the native schema used to store the documents. Is it sane enough that you could manually roll your own JSON1 queries in SQL to facilitate more relational join like features?

Great addition of SQLite backend. I would however love prebuilt binaries for Mac, that way I can test it with Marmot (<a href="https:&#x2F;&#x2F;github.com&#x2F;maxpert&#x2F;marmot">https:&#x2F;&#x2F;github.com&#x2F;maxpert&#x2F;marmot</a> sorry for shameless plug). I wanted to build myself but then the instructions in README discouraged it, not sure why, it&#x27;s not like I am going to train a LLM so it&#x27;s pretty complex.

I started looking into replacing the MongoDB instance used by the Unifi Controller software with this, I need to revisit it.

It would be interesting to see some benchmarks, especially comparing the same queries between Mongo and Ferret. Also, while the readme does say it&#x27;s meant to be a drop in replacement, it does not say whether feature parity has been achieved. I would very much like to see how it fares with an ODM layer.

Great project!<p>I find it intriguing to note a comparable approach by MySQL, where it functions as a NoSQL database, specifically a document database, owing to its adoption of a multi-paradigm methodology.<p>Starting from version v5.7.12, MySQL provides the &quot;MySQL Document Store&quot; feature, which enables data access through a document interface utilizing the proprietary XProtocol protocol. It is important to mention that this protocol is incompatible with MongoDB. The fascinating aspect is that the data can be modified interchangeably using both XProtocol and SQL.

<i>MongoDB was originally an eye-opening technology for many of us developers, empowering us to build applications faster than using relational databases.</i><p>Something something HN and pitchforks.

This is fun! Look like SQLite is getting all kind of Network protocols recently What is next ? Will SQLite learn to speak MySQL ? Oracle ?

Man this is <i>exactly</i> what I need at a high level but not writing this in C is a complete show-stopper. All that Docker effluvium adds insult to injury. Sad!