mediacenterjs icon indicating copy to clipboard operation
mediacenterjs copied to clipboard

MariaDB (MySQL) Database

Open igorer88 opened this issue 8 years ago • 8 comments

Is it possible to make the database abstraction layer works with mySQLor MariaDB database?

igorer88 avatar May 28 '16 23:05 igorer88

Any database options would be nice. stupid node-sqlite3 module can be a pain to install

curioussavage avatar Jun 25 '16 17:06 curioussavage

Not sure, but something embedded is probably the best option... I'm not sure how good/bad the firebird bindings are (that would at least give the option to switching to standalone with only a config change)... there's also levelup, which could be used to run a separate data service layer for the application, while still being embedible.

tracker1 avatar Jun 29 '16 02:06 tracker1

Something like https://github.com/louischatriot/nedb would be nice IMO. Looking at https://github.com/jansmolders86/mediacenterjs/blob/fc56fb89c229687fb7587113aca823a00af18073/lib/utils/database-schema.js it seems like a document database would be fine. Plus its just another javascript module so pretty much zero chances of problems installing unlike sqlite3 which wouldn't compile on my mac or raspberry pi.

curioussavage avatar Jul 01 '16 04:07 curioussavage

Sounds like a wonderful option. The whole sqlite thing is an eye sour for sure.

jansmolders86 avatar Jul 01 '16 08:07 jansmolders86

It's has been some time, since I checked this issue. There's has been any update that we could work with?

igorer88 avatar Jul 13 '19 20:07 igorer88

@jansmolders86 dropped out the project???

igorer88 avatar Aug 18 '19 17:08 igorer88

@igorer88 iirc, he's just been busy and hasn't had a lot of time to dedicate to this project.

Personally, I've been using NVidia Shield TV, so don't even have an HTPC hooked up anymore. I have wanted to find time to work from this project to create a mediacenter server that uses chromecast. Basically a web interface for control on a more powerful desktop/server, that can be controlled via phone/tablet and chromecast to the TV(s) in the house. Just haven't had the time to really even look at this project.

Aside, wonder how well this might work with the new rpi4.

tracker1 avatar Aug 19 '19 17:08 tracker1

Well, I guess I'll see how the project evolves...

igorer88 avatar Aug 20 '19 09:08 igorer88