snthpy

25 ms·

1. 601.▲
   by snthpy 3y ago

   Thanks. I hadn't heard of SMEQL before. To me it structurally actually looks very similar to PRQL. PRQL just always has `srt` as an implicit parameter (now referenceable as `this` since 0.9) and a more linear flow whereas with SMEQL I
2. 602.▲
   by snthpy 3y ago

   This looks very cool! I'm most interested in the reactive runtime though and like the temporal.io and Timely Dataflow references. Is it possible to just have access to that in Rust and leave out the agent bits?
3. 603.▲
   by snthpy 3y ago

   Who's going to post the link to the Bobby Tables xkcd?
4. 604.▲
   by snthpy 3y ago

   That's probably true but the big differentiator was that DuckDB can run in your python process so there's very low fiction to adopt it. My impression of ClickHouse was that it was more like postgresql in that regard, i.e. OLAP : O
5. 605.▲
   by snthpy 3y ago

   Not quite what you're asking for but DuckDB has both PRQL [1] and Postgres [2] extensions, so you could probably query your Postgres database with PRQL from there. There's also a DBeaver plugin [3] which we still need to document
6. 606.▲
   by snthpy 3y ago

   This is awesome! Thank you! Would that mean it would also be able to use it in clickhouse-local?
7. 607.▲
   by snthpy 3y ago

   There are two symbols for separating transforms in a pipeline - \n and | so you can use | instead of \n if you prefer. So for your query from the linked gist, the following should work: from system.numbers | select number Otherwise
8. 608.▲
   by snthpy 3y ago

   Thanks! Those do look awful and more what I remember from the brief period when I used MongoDB in around 2013 or so. I take it GP comment was just trolling then?
9. 609.▲
   by snthpy 3y ago

   That's awesome! ClickHouse is a great system by all accounts and I've been meaning to try out ClickHouse Local. I'm more familiar with DuckDB and they've also been doing some great innovation on the SQL front. I don&#x27
10. 610.▲
    by snthpy 3y ago

    Unfortunately the linebreaks were lost and, as shown that isn't a valid PRQL query. It would have to be either from employees group role ( sort join_date take 1 ) or from employees | group ro
11. 611.▲
    by snthpy 3y ago

    That's right. It can be a bit hard to keep track of but the rules are quite simple. You start with all the columns from a `from`, then any `derive` just adds columns. A `select` restricts the columns to those selected and a `group + ag
12. 612.▲
    by snthpy 3y ago

    This sounds interesting. Could you provide a link to the MongoDB aggregations that your are referring to because they're not something I'm familiar with? (Disclaimer: I'm a PRQL contributor.)
13. 613.▲
    by snthpy 3y ago

    PRQL fixes this. (Disclaimer: I'm a PRQL contributor.)
14. 614.▲
    by snthpy 3y ago

    Great tool! Thanks for sharing that. Regarding the activity, there's been a lot of preparation for the 0.9 release. As to the new contributors, I don't know the reasons for that but all contributions are very welcome. It's a
15. 615.▲
    by snthpy 3y ago

    Ah, nice to see a mention of M. I don't see it mentioned a lot on HN and get the feeling most folks here probably don't even really know about it because it's so embedded in PowerQuery and PowerBI. It's actually not a ba
16. 616.▲
    by snthpy 3y ago

    Kind of. dplyr, Pandas, LINQ, Kusto, etc... are big inspirations. The fact that these are so popular and have reinvented the same workflows with slightly different syntaxes to me is a sign that they capture something fundamental about how h
17. 617.▲
    by snthpy 3y ago

    Totally agree. This was a high priority goal for us and @maximilianroos did a lot of work putting something together. In the end, I believe it was really fighting against how dbt is set up though as it is so tightly interwoven with Jinja2.
18. 618.▲
    by snthpy 3y ago

    I couldn't find that example right now but there is a similar line in the main example on the prql-lang.org homepage: aggregate { average total, ... } I can't definitively say why it is there, other th
19. 619.▲
    by snthpy 3y ago

    Disclaimer: I'm a PRQL contributor.
20. 620.▲
    by snthpy 3y ago

    Sorry that that was your first experience. I have opened an issue for this for you: https://github.com/PRQL/prql/issues/3074 The correct link is the following: https://prql-lang.org/book/
21. 621.▲
    by snthpy 3y ago

    If you're happy with SQL then there isn't much point. For the folks building and supporting PRQL, SQL just has a few too many warts and the popularity of tools like Pandas, dplyr, Polars, LINQ, ... shows that for analytical work w
22. 622.▲
    by snthpy 3y ago

    This is well timed as PRQL 0.9 was just released a few hours ago. Have a look at the release notes here: https://github.com/PRQL/prql/releases/tag/0.9.0 There is a rather large breaking change in the syn
23. 623.▲
    22/7: Calculate the digits of 𝝅 in SQL

    6 points by snthpy 3y ago|1 comments
24. 624.▲
    by snthpy 3y ago

    Thanks, this looks really interesting! I'm just thinking aloud here based on your description (and note that I'm a backend/data engineer looking to build data apps with no front end experience), would this integrate well with
25. 625.▲
    by snthpy 3y ago

    Totally agree. What are some nice monospace programming nerdfonts without ligatures?
26. 626.▲
    by snthpy 3y ago

    Great point. I'm similar.
27. 627.▲
    by snthpy 3y ago

    Good display of integrity by the Economist to publish this given that economic libertarianism is their core tenet.
28. 628.▲
    by snthpy 3y ago

    Comparing with the weight of a soul at 21 grams [1] would put the information content of a soul at 4.7652×10^13 TB (terabytes) [2]. Assuming neural storage is less efficient would suggest that this is an overestimate. FYI, I don't beli
29. 629.▲
    by snthpy 3y ago

    Was wondering what a "terminat" is but I see it's just a terminal. Looks good.
30. 630.▲
    by snthpy 3y ago

    Good to know. Thanks!