I don't know why, but this program had difficulty opening what was clearly a correct SQLite3 database file (created with TypeORM) on Ubuntu 22.04. "Reason: Invalid file format". I ended up using Beekeeper Studio instead, which didn't have any problems with that file. I wonder if that bug is fixed.
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
61–70 of 70 posts
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#62Very useful app in my day job as a Windows dev, it works flawlessly and is quite reliable.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#63Hello 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.
Thank you for this great piece of software. I had to process some data and it was either trying to do it with a spreadsheet, which was slow and awful, while this was simple and snappy.
Plus I get to use the SQL syntax which is great :D
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#64Hello 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.
I've used this for debugging on pretty much every single SQLite project I've ever done. An excellent piece of software!
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#65Awesome, other than the vscode sqlite browser I can actually view dbs using sqlite-vss!
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#66Earlier quoted context omitted.
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.
I can see them but somehow it does not find it being next to it.
Don't know if it is a windows policy I am not aware.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#67Earlier quoted context omitted.
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…
How do you feel about Malloy vs PRQL?
I think I would miss the the semantic data modeling of malloy, and Malloy is definitely easier to read and write IMHO, in part because of the semantic data modeling.
I would also miss the nest feature of Malloy, and the way it handles time / dates / timestamps.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#68Earlier quoted context omitted.
What feature do you need that isn't in the open source version? Why not fork it and implement that feature, and then use that? If you don't want to deal with a company trying to extract profit from you, use the open source version. That's the way to ensure your own freedom.
> What feature do you need that isn't in the open source version? ODBC support, Cassandra, Redis, and Azure (Table) Storage support, and support for the kinds of obsolete RDBMS and "4GL" you see in large enterprise and small mom-and-pop backrooms (Progress, Clipper, AdvantageDB, ElevateDB, etc). And SQL script debugging for Postgres. Currently I have separate tools/clients/IDEs for all the different data systems I ta…
Your reasons are valid and make complete sense to me. I wonder if you could write to them and explain your use case and offer to pay for a perpetual license? No idea if it'll work, but worth a shot maybe?
If you try this, do update and let us know what they say.
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#69Earlier quoted context omitted.
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.
I can see them but somehow it does not find it being next to it. Don't know if it is a windows policy I am not aware.
How are you unzipping the .zip before running the .exe?
It sort of sounds like you're double clicking on the zip? I'm not personally sure if that unzips the whole folder in the right way or not.
If that's what you're doing, maybe right click on the .zip and extract everything using that first?
Note that I don't personally use windows much any more, so my windows knowledge is getting rusty for some stuff. ;)
Re: DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
#70I don't know why, but this program had difficulty opening what was clearly a correct SQLite3 database file (created with TypeORM) on Ubuntu 22.04. "Reason: Invalid file format". I ended up using Beekeeper Studio instead, which didn't have any problems with that file. I wonder if that bug is fixed.
Wonder if it was something to do with STRICT mode support not being present in the 3.12.2 release (what you probably tried)?
Our new 3.13.0 release (should be out tomorrow) supports STRICT, as have our dev builds for a few years.
That's the only situation that springs to mind for it having issues like that. Though it's also possible there was some other unknown bug at the time lurking around.