Ben, thank you very much for for sharing your tool.
May be a stupid questions but *Question 1*: What can you do with beanpost, what you can't do with beanquery? *Question 2: *The documentation says: - *Transaction dates: Each posting can have its own date, allowing transactions to balance even if individual postings have different dates. This helps with common issues when transferring money between accounts where withdrawal and deposit dates differ.* How do you achieve this, if initially the database is created by importing beancount file, which has only one date per transaction? On Wednesday, April 24, 2024 at 1:20:16 PM UTC+2 [email protected] wrote: > Oh wow, that's crazy cool. I didn't know postgresql supported that! > Will have a more detailed look, sorry for not digging in deeper > > On Mon, Apr 22, 2024, 14:46 Ben Gerdemann <[email protected]> wrote: > >> Hi Everyone, >> >> I hope this email finds you well. I've been using Beancount for many >> years. It's been an amazing tool, and I'm grateful to this community and >> especially to Martin Blais for maintaining such a fantastic project. >> >> I'm sharing a project I've been working on called Beanpost, which you can >> find on GitHub at https://github.com/gerdemb/beanpost. This started as >> an experiment to see if I could recreate plain text accounting >> functionality using a PostgreSQL database, and it turned out more >> successful than I expected. I thought the Beancount community might find it >> useful and interesting. >> >> Beanpost consists of a PostgreSQL schema and import/export commands that >> let you transfer data between a beancount file and a PostgreSQL database. >> Much of Beancount's functionality is implemented using custom PostgreSQL >> functions, allowing for complex queries and data manipulation. This setup >> provides a flexible backend that can integrate with other tools like web >> apps or reporting systems. >> >> One of the reasons I created Beanpost was to build a mobile-friendly >> custom front-end. Fava is a fantastic tool, but it's not very >> mobile-friendly, isn't intuitive for beginners, and is hard to customize. >> With Beanpost, you have more flexibility to create a custom front-end that >> suits your needs. >> >> The included functionality is as follows: >> >> - Functions to calculate account balances or changes over a specific >> period. >> - Support for calculations on individual accounts or account >> hierarchies (e.g., "Assets"). >> - Check balance assertions. >> - Verify that transactions balance. >> - Support for explicit precisions for each currency to use for >> balance tolerances. >> - Display the running balance of an account by posting. >> - Convert between currencies, including converting baskets of >> currencies. >> - Store documents as byte-data in the database. >> >> I'm curious to hear your thoughts on this approach. Would love to hear >> any feedback. I think I've implemented the majority of the required >> features, but maybe I'm missing a few things? >> >> Maybe we could call this "database-based accounting" instead of "plain >> text accounting." 🙂 >> >> Thank you for your time, and I look forward to hearing from you. >> >> Best regards, >> >> Ben >> >> -- >> > You received this message because you are subscribed to the Google Groups >> "Beancount" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/beancount/143e6263-3db3-4532-ae0e-eac6d7e6ffebn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/beancount/143e6263-3db3-4532-ae0e-eac6d7e6ffebn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b66aa343-3cbb-4038-aa03-995c29e08071n%40googlegroups.com.
