Nice tool to be a part of the ecosystem, I can see this being very helpful, thank you for writing this and sharing!
Some thoughts/feedback: - if the PAGER is used automatically, when needed, that’ll eliminate having to pipe through less, given you want a tool with a minimal cli burden. This is a common interface for polished CLI tools in my experience. click.echo_via_pager() does this for you - automatic date range detection conflicts for me as I look up accounts using account numbers frequently. Beancount account names can include numbers (even though they can’t start with them) - A way to stuff command line options into environment variables would eliminate the need to keeping specifying things like --zero and --total. Eg: BQ_BAL_OPTS=--zero --total - Is there a way to convert balances to the default currency I’m not seeing? For commodity accounts. - Does the tool have to be constrained by ledger syntax? It seems like it’s a good idea on its own. Would calling it something else (bq for beanquick?) allow the syntax to develop on its own right, suited to Beancount better? On Tuesday, September 2, 2025 at 3:51:33 PM UTC-7 Alen Šiljak wrote: > Thank you for the link! That is useful to know. > > In the meantime, I've had a few ideas and have implemented various options > and filters that don't exist or are not as elegant in Ledger (i.e. date > range syntax). The beauty of having a tool in a language that one is > comfortable with. > I'm looking to minimize the syntax, so that quick queries for balances or > transaction listing for a certain period, currency, payee, account, etc. > can be quickly listed. With or without total or running balance. > `bal` and `reg` are the most common queries I use. The filters are mostly > common for both. > With this tool I now feel I have a query tool that provides a quick > insight into transactions and balances for everyday use, like when you need > to see how much you've spent on auto electricity during the holiday period, > checking if a bill to @xyz was paid, when the bills were paid, how much > you've spent in certain currency, etc, etc. > > On Wednesday, 3 September 2025 at 12:01:47 am UTC+2 just...@gmail.com > wrote: > >> https://github.com/zacchiro/beangrep >> >> It's not quite the same thing -- it isn't trying to be similar to ledger >> and doesn't cover many of the metadata'ish aspects of what you've done -- >> but still might be worth looking at. >> >> On Tuesday, September 2, 2025 at 3:42:01 AM UTC+9:30 Alen Šiljak wrote: >> >>> As a poc, today I've quickly assembled and published a couple of scripts >>> that provide a simpler, ledger-style queries for Beancount. >>> Over the years I've become so used to using a quick "l b card" or "l r >>> cash -b 2025-08" to see balances and last transactions. These tend to be my >>> most-frequent queries, for balance checks and finding missing or erroneous >>> records. >>> >>> If there are other Ledger-CLI converts who are missing this, feel free >>> to try and suggest missing features. I will likely add more parameters and >>> parsing for the most-common use cases I need. >>> >>> At the same time, before going deeper, I'd like to ask if there is >>> already something of this sort out there that I was unable to find. >>> >>> The repo is here: >>> https://github.com/alensiljak/ledger2bql >>> >>> -- 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 beancount+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/beancount/413b0806-f237-4b1f-8da4-30ee32e437c5n%40googlegroups.com.
