Introducing ellycache - pgDash
Looking to balance the demands of BI/analytics/ops dashboard apps that query PostgreSQL data and management of system resources consumed by the PostgreSQL server? Have a look at our new open source tool ellycache – a novel way to schedule, cache and serve query results for front end apps.
ellycache is a simple, performant, query cache for Postgres with a built-in HTTP server. It runs the queries you specify at cron-like schedules, caches the results in-memory or on-disk and serves them at specified HTTP endpoints using the built-in webserver.
It is a single-binary, zero-dependency, statically-linked executable, making it easy to deploy anywhere or to bundle with your app. It is open source and lives on GitHub.
ellycache was built to balance the needs of BI/analytics apps that access PostgreSQL data, and PostgreSQL DBAs who need to manage the system resources consumed by PostgreSQL. The cron-like scheduling of SQL queries, together with a compact single binary deployment that includes an HTTP server, connection pooler and on-disk encrypted file cache make ellycache a compelling alternative to traditional query caching software.
You can start ellycache with a nginx-like configuration file listing the HTTP URI endpoints together with the SQL query and run schedule. Here is an example configuration file:
