thefirstofthe300 292 Posted April 6, 2015 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
ebr 15435 Posted April 6, 2015 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
Untoten 303 Posted June 19, 2017 Posted June 19, 2017 @@ebr does this still hold true? I would think mariadb could offer some big improvements.
Untoten 303 Posted June 19, 2017 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/
Luke 38824 Posted June 19, 2017 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
Untoten 303 Posted June 19, 2017 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
Recommended Posts