Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

sqlitebrowser.org

Post reply on HN
Print view View original

41–50 of 70 posts

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#41

Post by cushychicken »

lucydodo wrote: post #22

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.

Just discovered this piece of software on my own about two months ago.

Thank you for making - and giving away - such a valuable tool. I am a huge fan and very grateful to you and your team.

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#42

Post by keyle »

zie wrote: post #6

If 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.

this is weird

> Portable - No need to install or uninstall. Just download, decompress and run.

and I download the dmg and it's an unverified installer inside. Pass.

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#44

Post by Stagnant »

erremerre wrote: post #33
moonshinefe wrote: post #28

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.

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 :/

All of those DLLs are included in the same zip file as the portable exe. Sounds like you may be trying to run it without extracting first.

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#46

Post by 7thaccount »

asmr wrote: post #45

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.

Surprised and not surprised. There's a lot of devs that know a little SQL, but I think it's different when you're mostly using ORMs to abstract away the DB. For business users, you pull up a GUI like this or the one that comes with the DB and sometimes spend hours writing queries and exploring the schema, so you get used to these kinds of tools... especially if you have to move between several databases. I'm sure plenty of devs, do as well, but probably a smaller proportion. It's a great project though.

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#47

Post by tracker1 »

moonshinefe wrote: post #28

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.

I think this feature should be included in more structured database tools. Being able to load a CSV and query against it, either to an in-memory sqlite or a temp directory (depending on size) is a great option for this kind of work.

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#48

Post by chasil »

heavyset_go wrote: post #12

Another similar open source app is DBeaver: https://dbeaver.io/ Works with more than just SQLite.

Toad by Quest Software was the original SQL GUI development tool, and developed the basic style that most of these apps use today. I have senior developers who refuse to consider anything else, and cling to unsupported versions of Toad.

Oracle SQL Developer does not support SQLite, but the design is their "internal Toad-killer," and reimplements Toad in Java. It does accept JDBC drivers for 3rd-party databases (but not SQLite so far).

Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

#50

Post by zie »

keyle wrote: post #42
zie wrote: post #6

If 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.

this is weird > Portable - No need to install or uninstall. Just download, decompress and run. and I download the dmg and it's an unverified installer inside. Pass.

Most OSS software is not signed, as Apple, MS, etc require you to pay to sign. I know there are some non-profits that will sign OSS stuff for Windows, but I don't know of any that do that for Apple devices.

I run on MacOS, I have no idea how I installed it, but I haven't had any trouble.

Post reply on HN