5 ms·

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

4 points by aminkhorrami 1y ago

aminkhorrami 1y 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 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 1y 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 1y 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 1y 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 1y 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 1y ago
Looks good. What visualizations do you plan to implement?
- aminkhorrami 1y 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/1bAyzuKE05htq10Zch1eErfoWzOF6fJ7l/view?usp=sharing 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 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!

4 points by aminkhorrami 1y 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 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 1y 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 1y 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 1y 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 1y 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 1y ago

Looks good. What visualizations do you plan to implement?

aminkhorrami 1y 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/1bAyzuKE05htq10Zch1eErfoWzOF6fJ7l/view?usp=sharing 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 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!