Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 975 Bytes

README.md

File metadata and controls

32 lines (22 loc) · 975 Bytes

pg_dw

A PostgreSQL extension for creating a minimalistic datawarehouse.

Docker Compose

Use docker compose for testing the extension

docker-compose build
docker-compose up
docker-compose down

Dockerfiles

Instructions for installation and deployment are detailed in the Dockerfile. A ready to run version is available at Docker Hub. Just run it as:

docker run -d -p 5433:5432 --name pg_dw -e POSTGRES_PASSWORD=postgres -d benizar/pg_dw

Future work

  • New functionalities:

    • Log usage statistics (e.g. user/usage maps and bounding box statistics).
    • Geohash aggregates
    • group by).
    • scales
  • Improve features:

    • Since PostgreSQL 9.5 we can create customized range queries for big range groups.
    • Improve classification methods.
  • Data:

    • Compile a detailed list of available sources.
    • Import more and more data for testing.