search

ether / etherpad-lite

Etherpad: A modern really-real-time collaborative document editor.
http://docs.etherpad.org/
Apache License 2.0
16.73k stars 2.85k forks source link

why mysql? #3272

Closed hajika closed 7 years ago

hajika commented 7 years ago

I wonder why the data is saved in mysql because the data is formated only in a key/value format. This looks much more like a nosql format and a non relational DB would be even faster to process that data, would it not?

ocdtrekkie commented 7 years ago

"You can choose between dirty, postgres, sqlite and mysql"

SQLite works pretty well with Etherpad, and is a lot lighter/thinner than MySQL.

hajika commented 7 years ago

But its also sql DB, and because textbased slower than mysql. True, dirty DB is key/value, maybe that is the reason why the data is stored in key/value format?! That would be really weird to tie the data format to a DB that is recommended not to be used. Or was is planned to support another DB in the future? Looks like Redis would be a good way, it is also used by Ethercalc by the way..

lpagliari commented 7 years ago

You can actually choose some other DBs, including some noSQL. Redis is there too, by the way. You don't need to use MySQL, but you can, if that is the option you have in hand.