from Hacker News

Show HN: MongoDB Protocol for SQLite

by aleksi on 7/4/23, 6:35 PM with 68 comments

  • by Thaxll on 7/4/23, 9:44 PM

    "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."

    This is not true, you can use MongoDB for commercial projects as long as you don't sell MongoDB services, but internally you're free to use it as your regular DB.

    https://www.mongodb.com/licensing/server-side-public-license...

  • by winrid on 7/4/23, 7:19 PM

    If this implemented sharding it'd be killer. I recognize that'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.
  • by yawnxyz on 7/5/23, 2:04 AM

    Honest question: why doesn't Couchdb receive any love on HN?

    It's such a perfect tool for my side projects and most projects that will never reach Twitter scale

  • by rajamaka on 7/5/23, 12:31 AM

    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.
  • by vamega on 7/4/23, 11:48 PM

    Has anyone tried running the Ubiquiti Unifi controller against this?

    Even stories of it being successful with the Postgres backend would be really helpful.

  • by Mertax on 7/4/23, 8:42 PM

    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?
  • by maxpert on 7/5/23, 3:56 AM

    Great addition of SQLite backend. I would however love prebuilt binaries for Mac, that way I can test it with Marmot (https://github.com/maxpert/marmot sorry for shameless plug). I wanted to build myself but then the instructions in README discouraged it, not sure why, it's not like I am going to train a LLM so it's pretty complex.
  • by ctippett on 7/5/23, 12:04 AM

    I started looking into replacing the MongoDB instance used by the Unifi Controller software with this, I need to revisit it.
  • by magic_hamster on 7/5/23, 9:46 AM

    It would be interesting to see some benchmarks, especially comparing the same queries between Mongo and Ferret. Also, while the readme does say it'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.
  • by adobrawy on 7/4/23, 11:50 PM

    Great project!

    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.

    Starting from version v5.7.12, MySQL provides the "MySQL Document Store" 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.

  • by Scarbutt on 7/4/23, 7:48 PM

    MongoDB was originally an eye-opening technology for many of us developers, empowering us to build applications faster than using relational databases.

    Something something HN and pitchforks.

  • by PeterZaitsev on 7/5/23, 5:22 PM

    This is fun! Look like SQLite is getting all kind of Network protocols recently What is next ? Will SQLite learn to speak MySQL ? Oracle ?
  • by jhatemyjob on 7/4/23, 8:45 PM

    Man this is exactly 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!