On Thu, Oct 2, 2014 at 5:51 PM, Simon Michael <[email protected]> wrote:
> On 9/28/14 10:02 PM, Martin Blais wrote: > >> The ideas are a little bit fresh, so this proposal might feel a bit >> "stream of consciousness" and needs a bit more polishing. >> > ... > >> https://docs.google.com/document/d/1d88MkHqxiVdF8XSQBT1QQpOKEOt6O >> C1P9ZoF3u86DwI/edit?usp=sharing >> > > I haven't much to add today, except this is a very nice discussion - > thanks. > > Your "Gmail-style" query language describes hledger's current query > language well. > I'm assuming you mean this: http://hledger.org/manual#query-arguments Thanks for pointing it out, I hadn't noticed, it's indeed quite similar. I think I lean heavily on the SQL version though, for the following reasons: - I like the explicit nature of the transaction filter vs. postings filter being in two separate location. - With aggregate operations defined on inventory objects, I'm able to fold both the journal and balance operations into a single syntax. This gets rid of the concept of "report" altogether, which is nice. There would be no more reports, just a query expression syntax (and perhaps some shortcuts to generate the reports using a prebaked query). - I like to be able to specify the desired output columns. Along with aggregations, this will allow it to replace all the custom holdings reports I had been creating lately. It's always important to me to state the reasons why this is not possible as a regular table: filtering has to be operable on complete transactions (with all legs), and operations on inventories of commodities have to be possible. These are the reasons that we cannot just spit out the data to some SQLite table and then use that (I'd like to see someone argue the opposite). A more powerful SQL-ish query language does seem like a good idea, > especially one based on the nice Google Charts api linked in your comments. I'm not sure about the chart API, that's an idea that has been pointed out to me. -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
