51–60 of 70 posts
Hello Hacker News! I'm one of the maintainers of this project. Thank you for featuring our project here, and we will be releasing a new stable version soon, so stay tuned for the new version! If you have any further comments, suggestions, or questions about the project, please feel free to leave an issue in our repository! Thank you.
The killer feature for me with this app is the stupidly easy CSV loading. I deal with huge CSVs at work often. SQLite Browser is the easiest, fastest and most lightweight UI tool to analyze them I've tried. It can load millions of records into a table in like <3 seconds. Then obviously you can query the CSV data via SQL.
This application single-handedly underpins the entire competitive/online yugioh space. Thank you for your excellent work!
Asking because we're getting very near the next major release, but if there are extensions or similar (OSS) things people commonly use with our application, then we could look at adding them to in the next release. Or maybe the point release after that (depending on time/effort/etc).
Note that I'm not at all familiar with Yugioh personally, but looking at the wikipedia page... wow that's an extensive extended Community. ;)
There used to be a Firefox plugin with much similar features. However since the change of Firefox plugin arch, it's no longer available.
But it is super unwieldy. Pretty much the only way to decode those files without compiling the decoder from source since it has non-standard lz4 headers.
For the few remaining SQLite files DB Browser works great.
The killer feature for me with this app is the stupidly easy CSV loading. I deal with huge CSVs at work often. SQLite Browser is the easiest, fastest and most lightweight UI tool to analyze them I've tried. It can load millions of records into a table in like <3 seconds. Then obviously you can query the CSV data via SQL.
For example, go here [1]. Press "." (this loads vscode in browser) and you will be analyzing large .csv or .parquet files directly in your browser, after you click on the .malloynb file
Something I made to analyze every form submitted to the Securities and Exchange Commission (SEC) (10-K etc.) since 2014. [2] Go there, press ".", install the malloy extension, and click on the .malloynb file! Do it all within your browser, or download it and use it in VScode.
[1] https://github.dev/malloydata/quickstart/blob/main/README [2] https://github.dev/mrtimo/isa5
I guess devs haven't ventured down the rabbithole of public DBs? Not trying to be a jerk, just honestly surprised this is on the front page.
I use Datagrip as my primary tool when connecting to DB, but DB Browser is still used several times each month because the simple CSV import, adding index and view data.
I even copy-paste DB Browser in Application folder on Mac, to be able to run 2-3 instances at the same time.
The killer feature for me with this app is the stupidly easy CSV loading. I deal with huge CSVs at work often. SQLite Browser is the easiest, fastest and most lightweight UI tool to analyze them I've tried. It can load millions of records into a table in like <3 seconds. Then obviously you can query the CSV data via SQL.
Thanks for letting me know about this! I do the same thing... DuckDB loads CSVs very quick and easy. Malloy uses duckDB and can work in VScode or vscode.dev or the vscode built into github. So, you can analyze large .csv files in any of those places. For example, go here [1]. Press "." (this loads vscode in browser) and you will be analyzing large .csv or .parquet files directly in your browser, after you click on th…