Dekart without postgresql

[AdeelK93]

Hi, is there a way to run Dekart (via docker) without postgresql? I don't really need to save any metadata, and I don't want to have to manage a postgres database in order to use Dekart.

Not passing in the postgres environmental variables gets me this error:

{"level":"fatal","error":"dial tcp 127.0.0.1:5432: connect: connection refused","time":1638744281,"message":"WithInstance"}

I suppose another solution would be to include postgres in the Dockerfile so that one could be available on localhost.

Thank you!

[delfrrr]

Hey @AdeelK93 currently it's not possible, you need to Postgres; it is used to store query metadata and map configs so you can return to them later;

If you could describe you use-case in detail it would help us to consider it for future versions

currently I can offer this docker-compose example with should be easy enough to run on single instance or locally: https://dekart.xyz/docs/self-hosting/docker-compose/

[delfrrr]

Heads up: we are considering introduce alternative (fully managed) db option for Dekart which hopefully will make deployment to GCP much cheaper. Stay tuned.

[AdeelK93]

Neat! Ease of deployment was really the use case

[delfrrr]

Hey so this is a working proposal to use Firebase to store Reports Metadata

• User Firestore Instead of Postgres
• Stream Query Status using Firestore Real Time Updates instead of sync via in-memory storage

Advantages

• Dekart Server can be scaled up and down on App Engine
• No user sessions lost during deploying/restarting
• GCP Billing will be proportional to number of request and not to time available (cheaper for small number of requests)