Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Mongita is to MongoDB as SQLite is to SQL

github.com

Post reply on HN
Print view View original

81–90 of 95 posts

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#81

Post by coverup »

kragen wrote: post #75

"Mongita" is a misspelling according to the DLE; the standard spelling is "monjita". Literally, the word means "little nun", but is the common name for flycatchers of the genus Xolmis . https://dle.rae.es/?formList=form&w=monjita# https://es.wikipedia.org/wiki/Xolmis_rubetra Unfortunately every time I see the misspelling in this thread I involuntarily cringe. I suppose "MongoDB" is named after a slur used to insult p…

It seems more likely to me that it's not a misspelling of "monjita" but rather just a naive application of the Spanish -ito/-ita diminutive suffix to "Mongo".

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#83

Post by kragen »

coverup wrote: post #81
kragen wrote: post #75

"Mongita" is a misspelling according to the DLE; the standard spelling is "monjita". Literally, the word means "little nun", but is the common name for flycatchers of the genus Xolmis . https://dle.rae.es/?formList=form&w=monjita# https://es.wikipedia.org/wiki/Xolmis_rubetra Unfortunately every time I see the misspelling in this thread I involuntarily cringe. I suppose "MongoDB" is named after a slur used to insult p…

It seems more likely to me that it's not a misspelling of "monjita" but rather just a naive application of the Spanish -ito/-ita diminutive suffix to "Mongo".

These two possibilities are not mutually exclusive.

While your guess about the thought processes of the originator may well be correct, it is still the case that the result, "Mongita", is ① unambiguously Spanish and ② unambiguously pronounced in Spanish as [monxita], which is a real Spanish word, the diminutive of the common word monja, meaning "nun". But [monxita] is spelled "monjita".

The result is that what may well have been an incorrect application of the diminutive suffix (the correct result would be "Monguito") produced a misspelling of "monjita". It's just as clearly misspelled Spanish as "Ke keres aser?" or "yerba maté", if not more so. So you can expect most Spanish speakers to read it as ridiculing the literacy of an unspecified person—more so if they also know English, given that "mongo" has been an English word used for ridiculing someone's intelligence for many generations.

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#85

Post by kragen »

davisoneee wrote: post #77
kragen wrote: post #75

"Mongita" is a misspelling according to the DLE; the standard spelling is "monjita". Literally, the word means "little nun", but is the common name for flycatchers of the genus Xolmis . https://dle.rae.es/?formList=form&w=monjita# https://es.wikipedia.org/wiki/Xolmis_rubetra Unfortunately every time I see the misspelling in this thread I involuntarily cringe. I suppose "MongoDB" is named after a slur used to insult p…

To be fair, one suggested etymology I've seen for for 'mongo' is a simplification of 'humongous'. Whether you believe this claim or not, it's entirely down to whether you want to take a charitable or negative guess at the original intention.

Anyone who reads Spanish fluently will react to the misspelling "Mongita"—whether with distaste, amusement, pity, or defensiveness—long before they have time to think through the possible motivations of the MongoDB developers.

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#86

Post by scottrogowski »

lelanthran wrote: post #73
scottrogowski wrote: post #57

Earlier quoted context omitted.

Hey, your first statement is true but your second is not. The disk engine does store data in memory which is part of the design. You wouldn't want to use a database that doesn't utilize caching. The last benchmark panel, https://raw.githubusercontent.com/scottrogowski/mongita/mast... , shows cold starts where I test it without cache. So in that, it does hit the disk.

> The last benchmark panel, https://raw.githubusercontent.com/scottrogowski/mongita/mast ..., shows cold starts where I test it without cache. So in that, it does hit the disk. Okay, so looking at the first two tests - "Retrieve all documents" and "Get 1000 documents by ID" ... If you switch the order around, does it make a difference to the benchmark? Because I suspect that the first test preloads all records into R…

You're right. Fixed. SQLite is more-so the winner but Mongita appears to squeak ahead in id lookups https://github.com/scottrogowski/mongita/blob/master/assets/... (to be fair, it might be the thin translation layer I built). Regular MongoDB struggles a lot and I don't think I'm being unfair to it in any way afaik.

Thank you for pointing that all out.

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#87

Post by bvrmn »

scottrogowski wrote: post #57
bvrmn wrote: post #51

It's sad that author did not mentioned that disk engine basically stores copy of data in memory. And it seems from benchmark code that reading doesn't hit disk at all.

Hey, your first statement is true but your second is not. The disk engine does store data in memory which is part of the design. You wouldn't want to use a database that doesn't utilize caching. The last benchmark panel, https://raw.githubusercontent.com/scottrogowski/mongita/mast... , shows cold starts where I test it without cache. So in that, it does hit the disk.

O(n) cache size is a very novel approach in computer science. This "cache" is crucial part of implementation and limits project applicability.

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#88

Post by kragen »

rpastuszak wrote: post #76
kragen wrote: post #75

"Mongita" is a misspelling according to the DLE; the standard spelling is "monjita". Literally, the word means "little nun", but is the common name for flycatchers of the genus Xolmis . https://dle.rae.es/?formList=form&w=monjita# https://es.wikipedia.org/wiki/Xolmis_rubetra Unfortunately every time I see the misspelling in this thread I involuntarily cringe. I suppose "MongoDB" is named after a slur used to insult p…

FYI the name MongoDB comes from "humongous". Thanks for the wiki links, though.

You're welcome! I hope the information is useful in helping scottrogowski carefully consider how many people he wants to insult. However, the DLE is not a Wiki.

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#89

Post by thomas4019 »

hardwaresofton wrote: post #21

Cool project but I have to admit I sure wish this was written on top of SQLite, rather than just mentioned it, implementing a query language shim for MongoDB on SQLite would be an amazing project. In the absence of such a project though, this is a pretty great alternative to have.

I created something like this for PostgreSQL. It's a Node.js service that implements the MongoDB wire protocol and converts the query to use jsonb. It works pretty well, but it also got increasingly hard to make it compatible because MongoDB has a lot of quirks.

Re: Show HN: Mongita is to MongoDB as SQLite is to SQL

#90

Post by pbreit »

wokwokwok wrote: post #71
pbreit wrote: post #48

Earlier quoted context omitted.

I am astonished that this is this is the sentiment. I've always of SQLite as a small, self-contained implementation of a SQL DB server. And so the comparison makes perfect sense to me.

It’s not even remotely self contained though, so how is the comparison relevant?

Looked self-contained to me.
Post reply on HN