Migration to postgreSQL or mongoDB

Migration to postgreSQL or mongoDB - Printable Version

+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Gekko (https://forum.gekko.wizb.it/forum-13.html)
+--- Forum: Guides (https://forum.gekko.wizb.it/forum-22.html)
+--- Thread: Migration to postgreSQL or mongoDB (/thread-57088.html)

Migration to postgreSQL or mongoDB - xFFFFF - 05-03-2018

In my opinion, this is not normal, probably everyone who did it for the first time was just as surprised as me "why the f* does not work?"

Changes should be made in the following files:

gekko/config/adapters/postgresql.toml:1:postgres://
gekko/config/adapters/mongodb.toml:1:mongodb://
gekko/config/general.toml:4:'sqlite'
gekko/web/vue/UIconfig.js:19:'sqlite'
gekko/web/routes/baseConfig.js:53:postgres://
gekko/web/routes/baseConfig.js:66:mongodb://
gekko/test/test-config.json:112:postgres://

God bless the grep!

RE: Migration to postgreSQL or mongoDB - susitronix - 05-03-2018

nice job
Id be intrested my self to compare same indicators.
I had this in mind for a TUT because...
??? that weird candle-startminute problem

thanks for share!

RE: Migration to postgreSQL or mongoDB - exmoond - 05-05-2018

(05-03-2018, 06:06 PM)xFFFFF Wrote: In my opinion, this is not normal, probably everyone who did it for the first time was just as surprised as me "why the f* does not work?"

Changes should be made in the following files:

gekko/config/adapters/postgresql.toml:1:postgres://
gekko/config/adapters/mongodb.toml:1:mongodb://
gekko/config/general.toml:4:'sqlite'
gekko/web/vue/UIconfig.js:19:'sqlite'
gekko/web/routes/baseConfig.js:53:postgres://
gekko/web/routes/baseConfig.js:66:mongodb://
gekko/test/test-config.json:112:postgres://

God bless the grep!

Did you figured out how to make paper trader work on mongodb ? in my situation it doesn't fetch any data from the market watcher

RE: Migration to postgreSQL or mongoDB - xFFFFF - 05-05-2018

Tried import mode instead market watcher to test ?

RE: Migration to postgreSQL or mongoDB - exmoond - 05-06-2018

(05-05-2018, 12:03 PM)xFFFFF Wrote: Tried import mode instead market watcher to test ?

yes , import works fine , simulation works fine , when you want to run paper trader , it seems that it do not fetch data from market watcher , problem exist only with mongodb.
Postgreqsl and sqlite are working good.
[Image: screen.png]

Like you see on attached screenshot strat runner is not fetching data from market watcher , tested graphical and text on : windows10 with bash, ubuntu , centos, windows 10 from cmd , ubuntu cloud server , in all situations there is problem only when mongodb i set as database.

market watchers were started with 1 min difference in time , database been purged before every test, and data been re-imported

RE: Migration to postgreSQL or mongoDB - xFFFFF - 05-06-2018

config

gekko welcome (i removed not usable things)

[/url]
[url=http://i.imgur.com/m6HczUW.png]This is probably the last version of stable, or develop (I'm not sure).

FreeBSD 10.3
mongodb-2.6.12_4

You set the correct host in configuration? That is: localhost? The default is mongodb or something like that.

RE: Migration to postgreSQL or mongoDB - exmoond - 05-06-2018

So nice , FreeBSD , recalling me teenager times.
Thank you for your help.
Downgrade of mongodb fixed the problem.
mongodb 3.6 is the problem .

Thank you one more time!

RE: Migration to postgreSQL or mongoDB - whoodat - 05-24-2018

Can I use the mongodb if I am running a headless server?

RE: Migration to postgreSQL or mongoDB - whoodat - 05-24-2018

Any help with this please:

/home/whoodat/gekko/node_modules/mongodb/lib/mongo_client.js:421
throw err
^
MongoError: failed to connect to server [192.168.1.30:27017] on first connect [MongoError: connect ECONNREFUSED 192.168.1.30:27017]
at Pool.<anonymous> (/home/whoodat/gekko/node_modules/mongodb-core/lib/topologies/server.js:336:35)

RE: Migration to postgreSQL or mongoDB - thegamecat - 07-13-2018

It would be really helpful if everything could be rationalised down into a single config, but it's not 5 minute job so get why it's not been done.