jansmolders86 / mediacenterjs

A HTML/CSS/Javascript (NodeJS) based Media center
http://mediacenterjs.com
1.29k stars 243 forks source link

MariaDB (MySQL) Database #223

Open igorer88 opened 8 years ago

igorer88 commented 8 years ago

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

curioussavage commented 8 years ago

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

tracker1 commented 8 years ago

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.

curioussavage commented 8 years ago

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.

jansmolders86 commented 8 years ago

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

igorer88 commented 5 years ago

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

igorer88 commented 5 years ago

@jansmolders86 dropped out the project???

tracker1 commented 5 years ago

@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.

igorer88 commented 5 years ago

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