prasoonds

11 ms·

91.
by prasoonds 3y ago
Thank you! Yes, one of the items in the Roadmap is support for Pyodide ( https://github.com/pyodide/pyodide ) for running in-browser python on the results of each of the code blocks! This should allow most ML libs to be
92.
by prasoonds 3y ago
Hey, absolutely - that's a perfectly fair question. I can give you my personal reasons: - I don't have excel on a Mac so I need to use Google Sheets. Google Sheets crashes on any file over 30-40 MB (at least on my macbook air) - I
93.
by prasoonds 3y ago
Oh hey! I remember seeing your HN post several weeks ago, I think - it's a great tool, thanks for building this! It was definitely an inspiration for us :)
94.
by prasoonds 3y ago
This echoes my thoughts exactly. Right now, we're actually more limited by the JS UI so a couple 100 MBs is the most you can do in a browser otherwise the UI becomes really slow. There's a lot of room for improvement - we're
95.
by prasoonds 3y ago
Hey Max, love what you all doing with PRQL! It's a wonderful tool. That makes sense. I ran into some old issues about Pivot but it seems it's not been implemented yet. And yes, s-strings wouldn't work - the DuckDB pivot state
96.
by prasoonds 3y ago
This is certainly true - I'm not saying "large file" in the colloquial sense of the "big data" but rather as in - a file you might want to open in Excel/Google Sheets. I've worked actual large datasets bef
97.
by prasoonds 3y ago
Thanks! This is interesting - just to make sure I'm understanding you correctly - you're trying to build analytics into your SaaS tool to offer it to your users, correct? And you're using Superset to build the analytics insid
98.
by prasoonds 3y ago
We're going to build this over the next week - it's a high priority item for us. Once done, you should be able to do two things: - Save existing workdflows to localStorage (a little drawer on the left side of the screen) - Export
99.
by prasoonds 3y ago
Oh this looks really interesting! I hadn't heard of EdgeDB/EdgeQL - I'll have to do a deeper read but at first brush, it looks like EdgeQL can be compiled down to SQL based on this HN comment: https://news.ycombina
100.
by prasoonds 3y ago
Hey Marco, I'll take a look - filters theoretically should be fast, when you create a new filter, it simply reads does a `select * from table limit 1` to get column names I wasn't sure whether you could query DBs directly from the
101.
by prasoonds 3y ago
That's an interesting point! No we haven't really - for now, I asked a bunch of friends to send me large CSVs - I loaded them on Google Sheets to see how it performs (usually terribly - crashes my browser tab or it's unbearab
102.
by prasoonds 3y ago
Yes, there's definitely some downsides (which honestly, we didn't realize when we started to build this). For us, it was the lack of a PIVOT statement so I had to make a modified dialect of PRQL that supports PIVOT, then split on
103.
by prasoonds 3y ago
Thank you. We're definitely looking to get to a point where you don't need to jump to a jupyter notebook for simple analyses, especially things which are hard to do in SQL (a basic linear regression model for eg). Happy to chat at
104.
by prasoonds 3y ago
Yes! I'm heartened to see people realize the the benefits of PRQL and chained transforms over vanilla SQL (with some caveats!). We'll definitely add a PRQL/SQL block to the UI soon (you will be able to toggle to select which
105.
by prasoonds 3y ago
Thanks for the feedback! > Are you planning on supporting parquet files any time soon? Yes. This is an oversight on our part - duckdb natively supports Parquet and Arrow files but we just haven't gotten around to adding upload suppo
106.
by prasoonds 3y ago
That's great feedback, thanks! This tool definitely comes from a place of personal need - beyond just handling large files, I've also never really gelled well with the Excel/Google Sheet model of changing data in place as if
107.
Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL(github.com)
227 points by prasoonds 3y ago|74 comments
108.
by prasoonds 3y ago
One potential advantage of these compile-to-SQL languages seems to be - they might be easier to tune a codegen LLM on. SQL is very verbose and IME, english -> SQL doesn't really work too well, even in high end products (i.e. pricy S
109.
by prasoonds 3y ago
If I may ask, what's Perspective - couldn't find anything on a first google search.
110.
by prasoonds 3y ago
Excel is definitely used some - people download CSVs from their DB, upload in Excel, run some filters/pivot tables until they kind of get what they want. IMO it's a terrible user experience not to mention the collaboration/sh
111.
Ask HN: Jupyter notebook for "non-technical" people – does this exist?
4 points by prasoonds 3y ago|2 comments
112.
by prasoonds 3y ago
It took me over 3 months to register (which is shocking in itself) - perhaps things are not so dire in Munich
113.
by prasoonds 3y ago
In a startup, you either build, ship and you survive another day, or, you die. If I were hiring for an early stage startup, I know exactly which of you two I would want to hire.
114.
by prasoonds 3y ago
> you are mostly just coming for economic reasons, and countries don't need that. On the contrary, that is _precisely_ what Germany needs if you are to sustain the bloated bureaucracy and the pensions. As another comment pointed out
115.
by prasoonds 3y ago
This is correct and I'm not sure why it's been downvoted. In Germany, you'd better only every use the work-room for work only. As people have pointed out, you're not likely to get audited for this but often, with apartme
116.
by prasoonds 3y ago
I don't think it's because of regulation. PSD2 related open-banking regulations are broadly about letting customers have access to their bank's functions via API. > PayPal enables XS2A use cases for TPPs through PayPal’s R
117.
Your AI Second Brain and the pitfalls of productivity tools(barelyintelligible.substack.com)
6 points by prasoonds 3y ago|1 comments
118.
by prasoonds 3y ago
I assume you're a tech worker - that places you in the top 5-10% of the population, wealth and income wise. Most of the 'other half' isn't doing so well - living in shared apartments well into their late 30s, never being