DataKit: I built a browser tool because I was sick of Excel crashing

DataKit: I built a browser tool because I was sick of Excel crashing(datakit.page)

4 points by aminkhorrami 1 year ago | 7 comments

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?

snthpy 1 year 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...

aminkhorrami 1 year ago | | |

Hey thanks a lot for this feedback, I wrote it down and I will consider that dropping line in mind for next updates.

snthpy 1 year 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

aminkhorrami 1 year 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!

I_am_tiberius 1 year ago |

Looks good. What visualizations do you plan to implement?

aminkhorrami 1 year ago | |

I've got a PR waiting to be merged on this latest on Tuesday. Just to give you an idea I uploaded an image here: https://drive.google.com/file/d/1bAyzuKE05htq10Zch1eErfoWzOF... If you wanna be more into the loop I'll defintley share some updates here: https://www.reddit.com/r/SQL/comments/1knhx7t

Please drop me a DM if you want me to text you when visualisation's is rolled out!