Querying your ledger journal in SQL

• ledgercalcite

  1 1 2.6 Shell

  Query your ledger journal with Calcite SQL.

For fun, I created a tool for querying a ledger-cli journal using SQL: github. It's still a very rough prototype now but it can extract your ledger data into a table with the following schema:

• ledgersql

  1 8 10.0 Shell

  Integration of Ledger with PostgreSQL

While there's already existing tools like ledgersql which extracts a similar table out of your ledger journal and load the data into a PostgreSQL database, this tool can be run as a container, avoiding the need to download and configure a PostgreSQL database. There's also no loading of the data into a database: the execution engine runs directly on the csv table.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project