SickRage/SickRage

Xxxxxxxxx

gborri asked for this feature almost 2 years ago — 11 comments

gborri commented almost 2 years ago

| k4n30 commented almost 2 years ago

I would suggest mariadb as that is where the industry in moving to, but still support an optional external DB solution

OmgImAlexis commented almost 2 years ago

If we added an ORM then we could use whatever database you'd like.

WebSpider commented almost 2 years ago

Sqlalchemy would be a good candidate for this, but we would need to see if we can do this without bringing in binaries and keep it all python

meffect commented almost 2 years ago

What database software does Sickrage use now?

| miigotu commented almost 2 years ago Admin

We already have sqlalchemy. There is no reason to do something like this anytime soon btw.

| gborri commented almost 2 years ago

@meffect it use sqlite

| Rick7C2 commented almost 2 years ago

This is something I asked for along time ago with sickbeard. I would still like to see it in sickrage.

| kossboss commented almost 2 years ago

I agree with miiigotu, why change to different type of DB if the max size of the DB is still pretty small with large number of shows, and sqlite3 is still providing results really fast. I have a friend with thousands of TV shows (if not more) and his DB file is just 10 times bigger than mine. My DB of about 100 shows is 6 MB. All of the queries to the DB are sub second. At this point the bottleneck of the UI is not the DB queries, but probably serving the pages themselves.

KimuzukashiiKuma commented almost 2 years ago

@gborri. What is the added benefact of MySQL/MariaDB over the current SQLite database?
Some reasoning for the change would be welcomed..

| psych0d0g commented almost 2 years ago

i dont see any benefit here, sqlite is fine with me and if properly implemented performs well enough with zero setup required from the user.

Join the discussion!

Sign-in with GitHub to comment