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