snthpy

31 ms·

1. 661.▲
   by snthpy 4y ago

   Looks cool and to me the most interesting part is that it uses htmx which I like! However how does it differ from all the other offerings in this space that it is increasingly difficult to keep up with? I'm thinking of: - Dash - Stream
2. 662.▲
   Calculate the Digits of Pi with DuckDB and PRQL(prql-lang.org)

   6 points by snthpy 4y ago|1 comments
3. 663.▲
   by snthpy 4y ago

   TL;DR: PRQL recently added a `loop` construct which makes it Turing Complete and allows doing cool things like calculating Pi right in your database. Last week saw the 0.6 release of PRQL which brought with it the capability to express Recu
4. 664.▲
   by snthpy 4y ago

   Not Pandas but very similar and (in my very biased opinion) better is PRQL (www.prql-lang.org) which as of yesterday you can now use in DuckDB! See my comment above: https://news.ycombinator.com/item?id=35027712
5. 665.▲
   by snthpy 4y ago

   I made a docker image with a number of extensions already installed and enabled so you can start using DuckDB with the lowest friction. `alias dckr='docker run --rm -it -v $(pwd):/data -w /data duckerlabs/ducker'` t
6. 666.▲
   XlOil: The fastest library for writing Excel functions in Python(xloil.readthedocs.io)

   4 points by snthpy 4y ago|1 comments
7. 667.▲
   by snthpy 4y ago

   I recently discovered xlOil after many years with xlWings and periodically checking for other options out there. xlOil is an order of magnitude faster than xlWings or VBA (benchmarks taken from here: https://github.com/luked
8. 668.▲
   by snthpy 4y ago

   Isn't this how IP addresses work? No 8.8.8.8 here, try over there ...
9. 669.▲
   by snthpy 4y ago

   Ha ha ha, I initially expected this to be the opposite, i.e. vim controls to shift gears on a BMW. This is much better (and safer).
10. 670.▲
    by snthpy 4y ago

    I also passed my IQ test. What's the passing grade, 50?
11. 671.▲
    by snthpy 4y ago

    I see there are already a bunch of questions about how this compares to other tools like DVC, dolt, pachyderm.io and LFS? I would just like to add one to that list: How does this compare to lakeFS?
12. 672.▲
    by snthpy 4y ago

    Am I the only one that thought this was going to be about a Wolfenstein 3D MUD? Anyway, I loved playing the Dune MUD in 1997-1998 in my first years at university.
13. 673.▲
    by snthpy 4y ago

    Looking through my history, I found that I have asked this question before and got an answer: https://news.ycombinator.com/item?id=19645440 => https://github.com/vinci1it2000/formulas This looks rea
14. 674.▲
    by snthpy 4y ago

    Does anyone know of a tool/library that extracts the computational graph from an Excel spreadsheet? I saw someone start a project on this a few years ago but I don't know if it ever got anywhere.
15. 675.▲
    by snthpy 4y ago

    Easily build Excel add-ins in Python. Also allows using SQL in Excel. Looks like a great alternative to xlWings and pyXLL.
16. 676.▲
    XlOil: Easy Excel Integration for Python and SQL(github.com)

    2 points by snthpy 4y ago|2 comments
17. 677.▲
    by snthpy 4y ago

    Your point about shared adversity is so interesting to me. I was on a "ferry" (it was really a kind of speedboat or something) from Belize to Honduras that got caught in a tropical storm. The waves were terrible, people vomiting e
18. 678.▲
    by snthpy 4y ago

    Sorry to hear that. In my country we also have daily power cuts but they are geographically distributed in order to prevent a total collapse of the grid. Is the latter what happened in your country? Our power cuts in South Africa are here t
19. 679.▲
    by snthpy 4y ago

    It's because Lex Friedman and Andrew Huberman now create these 2 - 3 hour episodes that there's no time to listen to anything else anymore.
20. 680.▲
    by snthpy 4y ago

    Thank you. If you need recursive/iterative queries then watch this space. That's ok the roadmap!
21. 681.▲
    by snthpy 4y ago

    [Disclaimer: PRQL core dev here] I'm hoping that PRQL [0] will one day become the universal API for tabular/relational data. We're targeting SQL as the backend in the first iteration given it's universality but there are
22. 682.▲
    by snthpy 4y ago

    No, that's pretty much what I was looking for. I'm going to pretend I didn't see the XML example but I think I could produce CSV files with this. Thanks!
23. 683.▲
    by snthpy 4y ago

    No
24. 684.▲
    by snthpy 4y ago

    Very cool! Does anyone know of something similar for text file formats? In particular something that makes it easy to work with legacy fixed width record file formats?
25. 685.▲
    by snthpy 4y ago

    Or Google? Google probably also replaced the work of many a research assistant. It's interesting that ChatGPT feels more human so we're more likely to anthropomorphise it, like list it as a coauthor.
26. 686.▲
    by snthpy 4y ago

    Interesting. In case you are not aware, [PRQL][1] has similar aims and is usable in Python [2]. [1]: https://prql-lang.org/ [2]: https://pypi.org/project/pyprql/
27. 687.▲
    by snthpy 4y ago

    Oh this is exciting! Thank you!
28. 688.▲
    by snthpy 4y ago

    There's a github issue thread about adding plotting.
29. 689.▲
    Ask HN: How does dagger.io compare to drone.io?

    2 points by snthpy 4y ago|0 comments
30. 690.▲
    by snthpy 4y ago

    Also, are you aware of the new Advanced Formula Environment? https://youtu.be/yIAl1XbuVzU