Skip to content

Latest commit

 

History

History
36 lines (25 loc) · 977 Bytes

README.md

File metadata and controls

36 lines (25 loc) · 977 Bytes
Raw

PromSQL: PromQL on top of SQL

This project implements the PromQL lamguage on top of SQL databases in order to query them with a timeseries query language. This way, we can query already existing data in SQL databases as if they are stored in a timeseries database like Prometheus.

Tasks:

  • Implement the PromQL grammar in LARK
  • Implement fetching data from the SQL database using sqlalchemy
  • Implement all nodes
  • Implement config manager

How to use?

First run the docker-compose file:

docker-compose up

Then push some data in the QuestDB database using

pip install -r requirements.txt
pip install -e .
promsql-cli.py

Then in the opened command prompt, enter the following:

promsql > telemetry[5m]

This will get all the telemety metric values since the last 5 minitues.

How to change the configs

Right now, the only way to change the configs is changing the values in the promsql/constants.py file.