backend icon indicating copy to clipboard operation
backend copied to clipboard

Add Postgres, GraphQL, and Dataloaden

Open maebeam opened this issue 4 years ago • 6 comments

maebeam avatar Jul 10 '21 19:07 maebeam

@maebeam will global state move to postgres too? im looking at whether its worth creating global state db that can handle states from multiple nodes via global-state-remote-node. But if its moving to postgres then its easier to wait for that.

tijno avatar Oct 01 '21 16:10 tijno

It is moving to postgres (or mysql, exploring that option this week)

maebeam avatar Oct 04 '21 14:10 maebeam

Ok thx for letting me know @maebeam . My votes for sticking with postgres and not mysql, and maybe having a separate DB url for it to allow optional storing of global state separate from block / deso data.

One request would be to allow some kind of "node" classifier field in global state so it can maintain state for multiple nodes separately in a single DB.

tijno avatar Oct 04 '21 14:10 tijno

I'm encountering performance issues with postgres so I'm evaluating the performance of mysql. Unfortunately if it is significantly faster we will have to switch

maebeam avatar Oct 04 '21 15:10 maebeam

I will keep that request in mind when moving global state to mysql / postgres

maebeam avatar Oct 04 '21 15:10 maebeam

Incase, you are considering mysql, mariadb is better than mysql in terms of liberal license and open source spirit.

namelessperson0 avatar Oct 27 '21 15:10 namelessperson0