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.

Sign up for GitHub

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

Jump to bottom

SQL: Add embedded Postgres to compare against in SQL tests #38079

Open
matriv opened this issue Jan 31, 2019 · 4 comments
Open

SQL: Add embedded Postgres to compare against in SQL tests #38079

matriv opened this issue Jan 31, 2019 · 4 comments
Labels
:Analytics/SQL SQL querying Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) >test Issues or PRs that are addressing/adding tests

Comments

@matriv
Copy link
Contributor

matriv commented Jan 31, 2019

https://github.com/opentable/otj-pg-embedded
@matriv matriv added >test Issues or PRs that are addressing/adding tests :Analytics/SQL SQL querying labels Jan 31, 2019
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

@rjernst rjernst added the Team:QL (Deprecated) Meta label for query languages team label May 4, 2020
@palesz
Copy link
Contributor

palesz commented Dec 18, 2020

The opentable version is not actively maintained. The new solution would be: https://github.com/zonkyio/embedded-postgres

Alternative approach: docker

PostgreSQL instance with a single docker command (would use a tagged version instead of the latest in tests):

docker run --rm --name postgres-latest -e POSTGRES_PASSWORD=mysecretpassword -p 5432:5432 -d postgres:latest

The good thing is that MS SQL and MySQL are also available via docker.

@matriv
Copy link
Contributor Author

matriv commented Jan 6, 2021

I'm pretty sure back then I also tried the https://github.com/zonkyio/embedded-postgres and didn't succeed. Maybe the docker solution is better and less prone to failures considering it needs to run on all of MacOS/Linux/Windows.

@wchaparro wchaparro removed the Team:QL (Deprecated) Meta label for query languages team label Jan 17, 2024
@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Jan 17, 2024
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytical-engine (Team:Analytics)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
:Analytics/SQL SQL querying Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) >test Issues or PRs that are addressing/adding tests
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@rjernst @palesz @matriv @wchaparro @elasticmachine @elasticsearchmachine