News for hackers. Stuff that matters.
Re:What's the big deal about embedded key-value databases? by lacker on Tuesday August 23, 2022 @01:15PM (#32568002)
IMO it's just confusing to call both, say, RocksDB and MySQL "databases". They sit at different levels of the stack and it is easier to just think of them as entirely different things, your "SQL database" and your "storage engine". So your stack looks like

Application

|

MySQL

|

RocksDB

|

Filesystem

In general the MySQL layer is doing all the convenient stuff for application developers like supporting different queries and datatypes. The RocksDB layer is optimizing for performance metrics like throughput and reliability and just treats data as sequences of bytes.

Re:What's the big deal about embedded key-value databases? by lcnPylGDnU4H9OF on Tuesday August 23, 2022 @03:04PM (#32569684)
Actually, this helps a lot. I'd never heard of RocksDB and I'm barely familiar with InnoDB and hopefully I am not wrong to compare the two.
Re:What's the big deal about embedded key-value databases? by lacker on Wednesday August 24, 2022 @12:04PM (#32581297)
Yes, that's right, InnoDB is the default MySQL storage engine and you can replace InnoDB with RocksDB. To summarize in one sentence, InnoDB is better at reads and RocksDB is better at writes, but if you were making an actual decision you should look at more detailed information than my one-sentence summary, such as:

https://minervadb.com/index.php/2018/06/06/a-friendly-compar...

Re:What's the big deal about embedded key-value databases? by tomhallett on Tuesday August 23, 2022 @02:12PM (#32568840)
100% agreed. TIL that mysql uses RocksDB under the hood.

Here's another example of a realtime database which uses RocksDB under the hood: https://rockset.com/blog/how-we-use-rocksdb-at-rockset/

Re:What's the big deal about embedded key-value databases? by eatonphil on Tuesday August 23, 2022 @02:35PM (#32569177)
As far as I'm aware, MySQL does not use RocksDB under the hood by default. MyRocks is a distribution of MySQL that uses RocksDB.
Re:What's the big deal about embedded key-value databases? by moralestapia on Tuesday August 23, 2022 @02:58PM (#32569591)
Yeah, weird comment from GP. By the time RocksDB was born, MySQL was already going to prom.
Re:What's the big deal about embedded key-value databases? by ruw1090 on Tuesday August 23, 2022 @03:44PM (#32570373)
Close, but in database years it was actually already in its mid life crisis.
Re:What's the big deal about embedded key-value databases? by icelancer on Tuesday August 23, 2022 @05:37PM (#32571894)
Only if you configure it that way. Same as MyISAM/InnoDB/etc.
Re:What's the big deal about embedded key-value databases? by jeffbee on Tuesday August 23, 2022 @02:58PM (#32569586)
I think the use of bare RocksDB is more common than the use of MyRocks.