I don’t think it is that matter whether a license is OSI compliant or not. The more important one is whether it is a Free Software License compliant like GPL3 preferably.
FerretDB: open-source MongoDB alternative
81–90 of 130 posts
Re: FerretDB: open-source MongoDB alternative
#82When MongoDB came out it was sort of the anti-SQL database, so it is interesting that this flavor of the same kind of database is backed by postgreSQL.
Re: FerretDB: open-source MongoDB alternative
#83Earlier quoted context omitted.
A use case I have for FerretDB is migrating existing apps off MongoDB without needing to change the code. I find it funny that you could call these now „legacy“ apps.
Yeah, anxiously waiting for FerretDB to support Meteor over here.
FerretDB maintainer here: we are working on it. We are already getting reports of successful migrations with Meteor apps. [1]
Would you mind sharing the specific Meteor app you are looking to get supported?
MeteorJS is among the most requested applications/frameworks our users are looking to use with FerretDB.
[1]: https://twitter.com/CowboyCaramel/status/1646089964126347264
Re: FerretDB: open-source MongoDB alternative
#84Earlier quoted context omitted.
Yeah, anxiously waiting for FerretDB to support Meteor over here.
FerretDB maintainer here: we are working on it. We are already getting reports of successful migrations with Meteor apps. [1] Would you mind sharing the specific Meteor app you are looking to get supported? MeteorJS is among the most requested applications/frameworks our users are looking to use with FerretDB. [1]: https://twitter.com/CowboyCaramel/status/1646089964126347264
I'm a contributor to the Sandstorm.io project, and Mongo continues to present a bit of a pickle for us. We can arguably write our way out of one upgrade, but upgrading to a later Mongo just punts the issue again. We'd much rather just leave Mongo behind.
Re: FerretDB: open-source MongoDB alternative
#85At one company we had one-off requests to run get some statistics from our mongodb. Writing the proper queries proven pretty tricky whenever GROUP BY/JOINs were involved, so I used online converters between SQL -> mongo query. But then I realized that PostgreSQL has nice JSONB type (supports indices for subfields). So I put all the mongo data into tables with a single JSONB column (or two columns id+data, if you pref…
I would recommend against modeling too many relations in a document DB. It can work, but it gets bogged down very quickly for the reasons you've stated. My off-the-cuff suggestion is that document databases are not built to model normalized relational data. If you try to do so, you bring a whole new level of pain upon yourself. It is do-able, but it is hard and annoying. I know this from extensive personal experience…
This is one of the reasons we created https://schemafreesql.com. We wanted SQL with some of the document store (NOSQL) features.
Re: FerretDB: open-source MongoDB alternative
#86I’m still waiting for the NoSQL crowd to realize that the best use case was always handled by CouchDB.
I started picking up CouchDB and PouchDB and the DX is fantastic. Always wondered why there’s never been any hype or more examples around this stack?
Re: FerretDB: open-source MongoDB alternative
#87I’m still waiting for the NoSQL crowd to realize that the best use case was always handled by CouchDB.
Apparently npm runs couchdb under the hood. There’s your answer to the “does it scale” question
Re: FerretDB: open-source MongoDB alternative
#88Earlier quoted context omitted.
I would recommend against modeling too many relations in a document DB. It can work, but it gets bogged down very quickly for the reasons you've stated. My off-the-cuff suggestion is that document databases are not built to model normalized relational data. If you try to do so, you bring a whole new level of pain upon yourself. It is do-able, but it is hard and annoying. I know this from extensive personal experience…
We had everything de-normalized, as you pointed out. However, every now and then we had some one-off questions that required using Mongo for something it's not designed for. However, migrating to postgres+JSONB made it easy to do both.
We've been on a big "Use postgres for everything" path. Mostly migrating dynamodb, elasticsearch, and redis to postgres.
The number of times we've had to do some one-off query that was orthogonal to production usage is higher than I predicted. There were so many times in the past where we just didn't fix something because it was too difficult to backfill a document store. We just hacked around it.
Now with postgres we fix the root of the problem instead of hacking around it. And we do so with a level of confidence we've never had with document stores.
Re: FerretDB: open-source MongoDB alternative
#89But is it web scale?
Re: FerretDB: open-source MongoDB alternative
#90I don’t think it is that matter whether a license is OSI compliant or not. The more important one is whether it is a Free Software License compliant like GPL3 preferably.
Sigh. Again.
"Free software" is not coterminous with copyleft. It includes copyleft and non copyleft free licenses like BSD. Even Stallman would happily call BSD- or MIT-licensed stuff free software.
The OSD was carefully chosen to incorporate what was already known as free software.