Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Support for Postgres in Document Store #114

Closed
jainnidhi703 opened this issue Nov 9, 2020 · 2 comments
Closed

Add Support for Postgres in Document Store #114

jainnidhi703 opened this issue Nov 9, 2020 · 2 comments

Comments

@jainnidhi703
Copy link

jainnidhi703 commented Nov 9, 2020

Use Case

Adding an alternative datastore i.e. Postgres to the document store, currently, it is limited to MongoDB only.

Proposal

The entity document will be stored as json in Postgres data-store. Following the conventions from MongoDB,
the postgres schema will look as follows:

CREATE TABLE documents (
	id TEXT PRIMARY KEY,
	document JSONB NOT NULL,
	created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
	updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

The document-store will connect to Postgres via JDBC driver.

I'm already working on a PR to add this. Here is the initial draft of the PR.
All the functionalities provided by MongoDB will be implemeneted on Postgres as well.

@JBAhire
Copy link
Member

JBAhire commented Nov 9, 2020

Thanks for initiating this @jainnidhi703 ! looking forward to it! :)

@kotharironak
Copy link
Contributor

Closing this as above PR adds support for this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants