Codimd: Either choose PostgreSQL or MongoDB

Created on 11 Sep 2015  路  5Comments  路  Source: hackmdio/codimd

First of all, thank you for open source this software!

I only have one issue with it: It uses two full-tiered databases. As far as I can see there is only one table in the PostgreSQL database. That looks like is a huge overhead. Could you please reduce the number of database systems to 1?
I plan to use hackmd for ad-hoc documentation running in a vagrant box. It would be great to reduce the footprint of hackmd in this box. :)

enhancement

Most helpful comment

:+1: Since PostgreSQL has both BLOB and JSON data, no need for MongoDB here. See positive result of moving from MongoDB to PostgreSQL http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/

And it's faster:
benchmark

All 5 comments

Thanks for using!

Yes, I would like to reduce the number of databases to only one.
But it takes some time to migrate two dbs.
As you can see, the PostgreSQL is only used for note saving.
And MongoDB is used on the other data.

Last, I would prefer PostgreSQL as far as I can tell.

Last, I would prefer PostgreSQL as far as I can tell.

+1 for Postgres

This is important and should be implemented soon in my opinion. Two full-fledged databases are just not needed and PostgreSQL should do the job.

:+1: Since PostgreSQL has both BLOB and JSON data, no need for MongoDB here. See positive result of moving from MongoDB to PostgreSQL http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/

And it's faster:
benchmark

Drop MongoDB and support PostgreSQL, MySQL, MariaDB, SQLite, MSSQL in version 0.4.0

Was this page helpful?
0 / 5 - 0 ratings

Related issues

ghost picture ghost  路  4Comments

farleylai picture farleylai  路  5Comments

Someniak picture Someniak  路  3Comments

ccoenen picture ccoenen  路  4Comments

mxmo0rhuhn picture mxmo0rhuhn  路  3Comments