Hacker News new | ask | show | jobs
by aminkhorrami 406 days ago
Drag ANY CSV/XLSX/JSON file (yes, even gigantic ones) into your browser, write SQL queries, and get instant results. No uploads, no servers, no nonsense.

Try it out here: https://datakit.page

Built with: DuckDB-WASM, React, and a ton of performance optimizations to make browser-based analysis actually usable.

I need your help: What features would make this more useful for you? Any specific use cases I should optimize for? Found any bugs or have ideas for improvements?
2 comments
snthpy 406 days ago
Looks neat, thanks!

Unfortunately the first file I tried it on it didn't do anything useful because that file had header and footer lines (FTSE market files have descriptions in the first 2-3 lines and an XXXXXXXXXX marker on the last line).

Can you add an option to drop the first X and last Y lines? That's pretty common for things like pandas.read_csv() etc...

link
aminkhorrami 404 days ago
Hey thanks a lot for this feedback, I wrote it down and I will consider that dropping line in mind for next updates.
link
snthpy 406 days ago
I also found the Excel-like grid display mildly misleading because the first thing I did on your opening page was click on a cell and start typing "=..." and that didn't do anything. If it looks like an Excel grid, I'm going to try and use it like an Excel grid
link
aminkhorrami 404 days ago
This was also an interesting one, would you be able to tell me if "this was supposed to be acting more into Excel grid" function, how would you like it to function? Probably this could not be easy to answer over chat but if you are open to hopping on a call and talk over it more, I would love that!
link