search

shadowmoose / RedditDownloader

Scrapes Reddit to download media of your choice.
1.12k stars 99 forks source link

Changing the DB Backend #125

Open xatnight opened 4 years ago

xatnight commented 4 years ago

Is your feature request related to a problem? Please describe.

I seem to struggle with sqlite. All problems I had so far are related to the database. I'm probably not the average usecase since my last run died at about 770k images. Loving the programm nonetheless!

Describe the solution you'd like:

I'd like to know how much effort you think it would take to change the database backend to support a "real" DBMS (think: postgresql, mariadb).

Additional context:

Just wanted to know because I might start to learn python on this project to change the database handling myself.

shadowmoose commented 4 years ago

This would be possible. RMD is built around using SQLAlchemy to wrap all database calls, which supports multiple other, stronger databases.

For some of those, it may be as simple as switching out the SQLAlchemy initialization code. I've not tested every query against other databases, however, so some SQLite-specific details might cause failure.

If you're interested, it's probably simple enough to hook up. Otherwise, I'll add it to the list.