thefirstofthe300 291 Posted April 6, 2015 Share Posted April 6, 2015 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. 2 Link to comment Share on other sites More sharing options...
ebr 14898 Posted April 6, 2015 Share Posted April 6, 2015 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. 1 Link to comment Share on other sites More sharing options...
Untoten 295 Posted June 19, 2017 Share Posted June 19, 2017 @@ebr does this still hold true? I would think mariadb could offer some big improvements. Link to comment Share on other sites More sharing options...
Luke 36992 Posted June 19, 2017 Share Posted June 19, 2017 That's not an embedded-able db right? Link to comment Share on other sites More sharing options...
Untoten 295 Posted June 19, 2017 Share Posted June 19, 2017 @@Luke Should be? It's a branch of mysq, here are some others who seem to have it working, I know a startup I worked with a while back did this too, huge improvements once they moved.https://github.com/vorburger/MariaDB4jhttps://mariadb.com/kb/en/mariadb/embedded-mariadb-interface/ Link to comment Share on other sites More sharing options...
Luke 36992 Posted June 19, 2017 Share Posted June 19, 2017 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. 1 Link to comment Share on other sites More sharing options...
Untoten 295 Posted June 19, 2017 Share Posted June 19, 2017 (edited) 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 June 19, 2017 by Untoten Link to comment Share on other sites More sharing options...
Recommended Posts