Looks great, specially for not being yet another Chrome shell.
Good job!
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
31–40 of 70 posts
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#32Hello 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.
Will support for STRICT be in this release?
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#33The 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.
I tried the non-installer exe version (32 &64bits) because that csv loading sounded very interesting, but cant make it work without installation because sqlite3.dll, qt5network.dll, qt5xml.dll nor qt5printsupport.dll can't be found.
I don't see the point of providing a standalone exe version that does not work?
Well, back to excel for csv :/
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#34If you are looking for another one: I use https://sqlitestudio.pl which is GPL-3 only and also cross platform. I'm not sure I ever compared them, I think I just came across sqlitestudio first and it stuck.
I've used both DB Browser and SQLiteStudio, and I prefer the flow and interface of SQLiteStudio.
It's been a few years since I've used DB Browser, so I forget exactly what I didn't like about it. Maybe I should download it again and try it out one more time and see if I still feel the same way.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#35The 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.
You might want to give VisiData a look: https://visidata.org
It's a TUI program, so if you want a full-featured GUI, it might not be up your alley, but it's the best tool I've ever used for doing ad-hoc work with large CSVs.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#36Hello 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.
Will support for STRICT be in this release?
Yep, it's been in the development code base since 2021, and is in our Release Candidate builds for the next upcoming release:
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/...
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#37The 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.
I tried the non-installer exe version (32 &64bits) because that csv loading sounded very interesting, but cant make it work without installation because sqlite3.dll, qt5network.dll, qt5xml.dll nor qt5printsupport.dll can't be found. I don't see the point of providing a standalone exe version that does not work? Well, back to excel for csv :/
> I don't see the point of providing a standalone exe version that does not work?
Which download did you use?
For windows there's really only an .msi which installs everything, and a .zip which needs to be unzipped and have the executable file run from inside the uncompressed directory.
The files it's complaining about missing should next to the .exe inside the unpacked directory. If you move the .exe elsewhere, or just extract it by itself, it's not going to work.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#38Great project, came in super handy on a project and I needed a way to mass import csv files which wasn't a feature at the time (7 years ago), threw together a PR over a weekend and the kind maintainers helped get it in. The chief maintainer at the time Justin is a cool guy, donate if you can.
Thanks heaps. Yep the donations definitely help pay for useful stuff for us maintainers (and domain name, etc).
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#39The 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.
One of the senior devs (Martin) spent a loooot of time optimising the CSV import process. Many different approaches using sample data sets (from rough memory) of between 800MB and a few GB I think.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#40Looks great, specially for not being yet another Chrome shell. Good job!
It's an actual native app (Qt5). ;)