Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-07-10 Thread ben
Hi Chao, Thank you for your message! I’m glad to hear you’re interested in trying beanpost. I’ll do my best to answer your questions. First, the idea for this project was to use PostgreSQL to implement a beancount-inspired “database engine” for double-entry accounting. While it’s possible to q

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-06-28 Thread Chao Chen
Hi Ben. It's so cool to do accounting in a real database! So I am eager to learn more about your way of using beancount and beanpost. 1. I haven't tried beanpost yet (I'll definitely do!), but my first thought is that editing beancount files is much easier than updating the postgresql entries. Do

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-28 Thread Martin Blais
It's not pedantic, it's totally needed at some point It would be nice to be able to generate accurate statements from both sides of these transactions. On Sat, Apr 27, 2024 at 4:59 AM Brian Lalor wrote: > Yes, that’s the one! I might be a bit overly pedantic about setting the > effective date,

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-27 Thread Brian Lalor
Yes, that’s the one! I might be a bit overly pedantic about setting the effective date, but it helps reconciling transactions with my bank. -- Brian Lalor (he/him) bla...@bravo5.org > On Apr 26, 2024, at 10:58 PM, b...@gerdemann.org wrote: > >  > >> On Apr 26, 2024, at 1:53 PM, Brian Lalor

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-26 Thread ben
> On Apr 26, 2024, at 1:53 PM, Brian Lalor wrote: > > There’s a plugin that adds processing for an effective_date field. Maybe part > of Reds’ suite? I use this extensively. Maybe worth exploring and adding > explicit support for? Hi Brian, Thanks for sharing this! I wasn't aware of this

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-26 Thread Brian Lalor
There’s a plugin that adds processing for an effective_date field. Maybe part of Reds’ suite? I use this extensively. Maybe worth exploring and adding explicit support for? -- Brian Lalor (he/him) bla...@bravo5.org > On Apr 26, 2024, at 6:27 PM, b...@gerdemann.org wrote: > > However, when exp

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-26 Thread ben
> On Apr 26, 2024, at 12:32 PM, Chary Chary wrote: > > On Wednesday, April 24, 2024 at 11:24:23 PM UTC+2 Ben Gerdemann wrote: > >> Question 2: The documentation says: >> >> • Transaction dates: Each posting can have its own date, allowing >> transactions to balance even if individual po

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-26 Thread Chary Chary
On Wednesday, April 24, 2024 at 11:24:23 PM UTC+2 Ben Gerdemann wrote: *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 wh

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-24 Thread ben
Chary, Thanks for your interest and good questions! > On Apr 24, 2024, at 3:22 PM, Chary Chary wrote: > > Question 1: What can you do with beanpost, what you can't do with beanquery? I think there are two key differences between beanpost and beanquery: the SQL ecosystem and integration with o

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-24 Thread Chary Chary
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 bal

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-24 Thread ben
> On Apr 24, 2024, at 8:19 AM, Martin Blais 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 Martin, Thanks for your interest. This started as a simple experimental side project, but I was able

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-24 Thread Martin Blais
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 wrote: > Hi Everyone, > > I hope this email finds you well. I've been using Beancount for many > years. It's been an amazi

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-24 Thread ben
Hi Martin, Thanks for your reply and for creating such a valuable tool in Beancount. I wrote a response yesterday, but I haven't seen it posted to the mailing list yet, so apologies if there's some repetition in this message. Beanpost does support multiple currencies using a custom PostgreSQL t

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-24 Thread Ben Gerdemann
Hi Martin, Thanks for your feedback, and thanks for maintaining Beancount. Your work has made it such a great tool for so many of us. I wanted to clarify that Beanpost does support multiple currencies using a custom PostgreSQL type and custom aggregator functions. I apologize for not making

Re: Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-22 Thread Martin Blais
Thanks for sharing, Ben, Broadly speaking this approach will work if you don't have to match cost basis and if you have only a single currency. Note that export to SQL has existed for a while, but I think to be able to most generally replace the functionality from Beancount one would need a custom

Introducing Beanpost: A PostgreSQL-Based Experiment for Beancount Users

2024-04-22 Thread Ben Gerdemann
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