12 ms·
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)
- runjake 2y agoGreat software. I use it almost every day. But, posted many times before: https://news.ycombinator.com/from?site=sqlitebrowser.org https://news.ycombinator.com/from?site=sqlitebrowser.org
- richardw 2y agoI’ve been here since 2008, and only saw/needed this today. I’m one of today’s 10000 :) https://xkcd.com/1053/ https://xkcd.com/1053/
- zoomablemind 2y agoThere used to be a Firefox plugin with much similar features. However since the change of Firefox plugin arch, it's no longer available.
- 0x5FC3 2y agoI remember using this back in the day, cool stuff!
- Joe_Cool 2y agoThere is one for the weird lz4json format they use now: https://addons.mozilla.org/en-US/firefox/addon/mozlz4-edit/ https://addons.mozilla.org/en-US/firefox/addon/mozlz4-edit/ 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.
- noman-land 2y agoI seriously love this app. I use it nearly every day. I scoured the net looking for a FOSS sqlite Mac app with a table exploring GUI. This is the best one!
- iKlsR 2y agoGreat 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.
- justinclift 2y agoThanks heaps. Yep the donations definitely help pay for useful stuff for us maintainers (and domain name, etc).
- zie 2y agoIf you are looking for another one: I use https://sqlitestudio.pl 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.
- thinker5555 2y agoI'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.
- keyle 2y agothis 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.
- zie 2y agoMost 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.
- winstonp 2y agoWould love one that looks as slick as Supabase's web ui
- ocdtrekkie 2y agoThis is my go-to while I've been working on a SQLite-based app to see what's actually in the database.
- me551ah 2y agoBeen using this software for a decade and it’s hands down the best SQLite browser and DB editor that I have seen.
- heavyset_go 2y agoAnother similar open source app is DBeaver: https://dbeaver.io/ https://dbeaver.io/ Works with more than just SQLite.
- artificialLimbs 2y agoNice because it has eclipse market capability with which you can install vrapper and other handy plugins.
- ekianjo 2y agoincluding duckdb as well.
- DaiPlusPlus 2y agoI’d need to use DBeaver Pro for the work I do - but they don’t offer perpetual licensing - which is a deal-killer for me (EDIT: I originally incorrectly claimed they didn’t support offline-installs, but apparently they do - but only for installs with a 12-month built-in timebomb: https://dbeaver.com/license-types/ https://dbeaver.com/license-types/ ) It says “No monthly subscription” which really just means “Annual subscription” instead: https://dbeaver.com/edition/ https://dbeaver.com/edition/ It’s not that I don’t think it’s worth $500/yr - I’d actually be happy to pay $1000 or more - but I absolutely need a pain+hassle-free UX that I can drag around air-gapped networks - and install on a legacy Windows 2003 VM running an ancient build of Sybase and then forget about it for 3-5 years, but be able to RDP-in and know that my DB tooling is still going to be there, unchanged, reliable and dependable. …whereas subscription desktop software with deeply integrated online accounts and activation and mandatory updates every few weeks (and the occasional account system outage, which ruins everything (looking at you, GitKraken) really really does not work well in those kinds (…my kinds) of environment. ——- SaaS as a business-model for online services is fine; great, even; and I’m not even opposed to it for desktop software provided that it delivers more value and overall UX quality compared to how-we-did-things-before - but SaaS companies don’t have a solution to the problem of ultra-long-life’d, ultra-dependable, server/system administration tooling. Can you imagine if Bash or Zsh - or phpMyAdmin - or systemd had to phone-home for a new OAuth access-token every month?
- czaxvgdcs 2y agoOddly the release version doesn’t support strict tables. Nightly does. I moved to beaver and it’s mostly been fine.
- forwardemail 2y ago[dead]
- bigyikes 2y agoI have this app open right now, actually. It's honestly... okay. I wish I had something better installed. It gets the job done, but the UI leaves something to be desired. It's free though, so I can't complain. I use it to manage my local financial transaction database.
- jszymborski 2y agoDataGrip is less free and has a pretty good UI. I primarily use DBeaver, it is meh...
- tester457 2y agoFor the CLI there's litecli. It has auto-completion and syntax highlighting. https://github.com/dbcli/litecli https://github.com/dbcli/litecli
- lf-non 2y agoNice. I use pgcli for postgres and wanted something similar for sqlite.
- hprotagonist 2y agosame core devs.
- webprofusion 2y agoUse this a lot, doesn't seem to get many releases but it looks like there's one coming soon.
- lucydodo 2y agoHello 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.
- gvkhna 2y agoThank you for your contribution. This is a great piece of FOSS!
- Fudgel 2y agoWill support for STRICT be in this release?
- justinclift 2y agoYep, 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/v3.13.0-rc3 https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/...
- cushychicken 2y agoJust 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.
- abnry 2y agoI appreciate this software, thanks!
- m-p-3 2y agoThank 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
- 2y ago
- lbj 2y agoLooks very nice - I'm still hard-stuck in EJC, the convenience is just unbeatable.
- moonshinefe 2y agoThe 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.
- erremerre 2y agoI 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 :/
- justinclift 2y ago> 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.
- Stagnant 2y agoAll 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.
- erremerre 2y agoI 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.
- justinclift 2y ago
- xwat 2y agoThe best
- digitalsankhara 2y agoWould really like to have a dedicated DuckDB version of this please. Also, add in a few simple tools for analytics - basic chart, pivot table tool, ETL etc. Nothing fancy, just enough to scope out the data before building pipelines/reports etc. No rush - tomorrow is fine :-) Thanks.
- pjmlp 2y agoLooks great, specially for not being yet another Chrome shell. Good job!
- justinclift 2y agoIt's an actual native app (Qt5). ;)
- Shalomboy 2y agoThis application single-handedly underpins the entire competitive/online yugioh space. Thank you for your excellent work!
- justinclift 2y agoInteresting. Are there (SQLite?) extensions or other bits commonly used with the application for Yugioh? 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. ;)
- asmr 2y agoI 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.
- 7thaccount 2y agoSurprised 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.
- punnerud 2y agoI posted it (and did a couple of years ago). 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.
- aabbcc1241 2y agoI'm teaching people dev with sqlite, and DB Browser is a few tools I recommend them to download (alone with VSCode and Meld)
- GGerome 2y agoI am a huge fan of this app that is the Toad like equivalent for Sqlite for me. Keep up this excellent work!
- julius-fx 2y agoMy favorite for years - love it.
- vekker 2y agoI 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.
- justinclift 2y agoWonder 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.
- sanjaysubra 2y agoVery useful app in my day job as a Windows dev, it works flawlessly and is quite reliable.
- RamblingCTO 2y agoAwesome, other than the vscode sqlite browser I can actually view dbs using sqlite-vss!