DataKit: I built a browser tool because I was sick of Excel crashing
1–8 of 8 posts
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#2Drag 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?
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#3Drag 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…
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...
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#4Drag 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…
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
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#5Looks good. What visualizations do you plan to implement?
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#6Looks good. What visualizations do you plan to implement?
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!
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#7Drag 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…
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...
Hey thanks a lot for this feedback, I wrote it down and I will consider that dropping line in mind for next updates.
Re: DataKit: I built a browser tool because I was sick of Excel crashing
#8Drag 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…
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
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!