SickRage/SickRage

Xxxxxxxxx

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

gborri commented about 2 years ago

| k4n30 commented about 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 about 2 years ago

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

WebSpider commented about 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 about 2 years ago

What database software does Sickrage use now?

| miigotu commented about 2 years ago Admin

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

| gborri commented about 2 years ago

@meffect it use sqlite

| Rick7C2 commented about 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 about 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