TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Show HN: MongoDB Protocol for SQLite

147 pointsby aleksialmost 2 years ago

13 comments

Thaxllalmost 2 years ago
&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>
评论 #36593272 未加载
评论 #36596920 未加载
评论 #36593207 未加载
评论 #36593019 未加载
评论 #36597452 未加载
评论 #36599955 未加载
评论 #36603623 未加载
winridalmost 2 years ago
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.
评论 #36591635 未加载
yawnxyzalmost 2 years ago
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
评论 #36595157 未加载
评论 #36595144 未加载
评论 #36594962 未加载
评论 #36594812 未加载
rajamakaalmost 2 years ago
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.
vamegaalmost 2 years ago
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.
评论 #36596036 未加载
Mertaxalmost 2 years ago
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?
评论 #36592441 未加载
maxpertalmost 2 years ago
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.
评论 #36596059 未加载
ctippettalmost 2 years ago
I started looking into replacing the MongoDB instance used by the Unifi Controller software with this, I need to revisit it.
评论 #36599238 未加载
magic_hamsteralmost 2 years ago
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.
评论 #36598347 未加载
adobrawyalmost 2 years ago
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.
Scarbuttalmost 2 years ago
<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.
评论 #36592670 未加载
PeterZaitsevalmost 2 years ago
This is fun! Look like SQLite is getting all kind of Network protocols recently What is next ? Will SQLite learn to speak MySQL ? Oracle ?
jhatemyjobalmost 2 years ago
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!
评论 #36592460 未加载
评论 #36605658 未加载
评论 #36593192 未加载