Jump to content

FR - Server - Different backend Database


thefirstofthe300
 Share

Recommended Posts

thefirstofthe300

I did a search because I was sure that this request had already been made but I couldn't find anything.

 

Anyway, I would like to request the ability to use a backend database such as MariaDB (MySQL clone) or PostgreSQL instead of just SQLite. I can see this being a huge advantage for users with extremely large collections as the fetch times should be faster. Also, it would allow me to consolidate one more database into my existing PostgreSQL install.

 

I know this would take some restructuring of the current backend but in the long run would give you one more leg up on our competitor as I don't believe they offer any such support. 

  • Like 2
Link to comment
Share on other sites

We designed things in a pretty modular fashion to allow for such things but I'll tell you right now that, with our current design, you wouldn't see any benefit from a different SQL engine.  In the future, as we refine some of the way we index and search for things, then maybe.

  • Like 1
Link to comment
Share on other sites

  • 2 years later...

See if you can find some numbers that compare it to sqlite. We like fast just as much as you do. If you show us some data we'll consider it.

  • Like 1
Link to comment
Share on other sites

Untoten

See if you can find some numbers that compare it to sqlite. We like fast just as much as you do. If you show us some data we'll consider it.

Any particular metrics you'd like to see?  I will do anything I can to help this project!

 

Edit: Found this, but it's more features than speeds

https://db-engines.com/en/system/MariaDB%3BMySQL%3BSQLite

 

EDIT2: Maria DB Benchmarks:

https://mariadb.org/performance-evaluation-of-mariadb-10-1-and-mysql-5-7-4-labs-tplc/

https://mariadb.com/kb/en/mariadb/benchmarks-and-long-running-tests/

 

EDIT 3: Apparently Realm blows them all away:

https://realm.io/

https://sebastiandobrincu.com/blog/5-reasons-why-you-should-choose-realm-over-coredata

 

Realm Benchmarks:

https://medium.com/@hesam.kamalan/database-benchmark-realm-vs-snappydb-f4b89711f424

Edited by Untoten
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...