7 ms·
SQLiteStudio: Create, edit, browse SQLite databases
- sirjaz 2y agoThis is the way IDEs should be. We should be able to run things locally without the overhead of a webbrowser
- mey 2y agoGoing to give this a try. I use DBeaver occasionally when working with SQLite db's but it's designed for persistent connections so opening random files isn't it's strong suit. (Also JDBC driver for SQLite)
- yupyupyups 2y agoI'm very thankful for this tool, it is powerful, doesn't stand in your way and does the job. It is as others have said, lightwight due to it being build with Qt. The interface is mostly intuitive, and utilizes screen space properly. If you need an open source SQLite editor, this is a solid choice.
- skylovescoffee 2y agoBeekeeper Studio is fantastic as well
- apatheticonion 2y agoHow did you make a cross platform native UI like that? I keep trying to start writing native apps but give up because of the GUI EDIT: Oh looks like QT - I should learn how to use QT from Rust...
- mpbart 2y agoTo echo some other comments here I use DBeaver as my daily database IDE but it doesn’t work well with SQLite. This looks like a great tool for handling that use case
- djsnoopy 2y agoWhat does this have that the SQLite command line program doesn’t? Because every time I try one of these I go back to the cli.
- chasil 2y agoThis interface is similar to Toad from Quest Software, or SQL Developer from Oracle. If you don't like either of those, then you likely won't like this. After a quick search it is possible to load a JDBC driver into SQL Developer. https://www.reddit.com/r/sqlite/comments/ci1wd2/sqlite_connector_for_oracle_sqldeverloper/?rdt=43141 https://www.reddit.com/r/sqlite/comments/ci1wd2/sqlite_conne...
- AstroJetson 2y agoI went from company F to company V, used Toad at F all the time. I was told at V that Toad was not approved nor money for it. So I bought my own copy. Within 6 months all of the DBA team owned copies of Toad, a few months later V bought it for Developers and paid back all the DBA team for their copies.
- chasil 2y agoI am stuck with stubborn developers who are holding on to Oracle 8-era Toad. Everybody else is on SQL Developer. I wish I could erase it.
- AstroJetson 2y agoMaybe if a) Oracle did upgrades to SQL-D and b) Didn't charge for SQL-D like it was made of spun Unicorn horn you would have better luck.
- dayeye2006 2y agoMaybe UI
- kyawzazaw 2y agoUI is quite useful to me
- emptiestplace 2y agoAgreed, rip the band-aid off folks. You will be so glad you did.
- hysan 2y agoHow does this compare with https://sqlitebrowser.org/ https://sqlitebrowser.org/ ?
- jksmith 2y agoMy goto as well.
- knighthack 2y agoThat's my Swiss knife. Super handy in a lot of scenarios, and I use it side-by-side with Jetbrains' DataGrip.
- hochmartinez 2y agoI've used both. Sqlitestudio is far more powerful, intuitive and easy to use. Fast and efficient. Flies even in old PCs. In Linux you won't find It in the repositories. You have to download and run a handy installer.
- Jach 2y agoIt's in gentoo's default portage tree
- 0points 2y agoIt's in AUR
- dotancohen 2y agoIt's GPL, so why no Debian packaging, if it is popular?
- shortrounddev2 2y agoAnecdotally, but I see less and less software distributed through apt these days
- mappu 2y agoThe ITP was in 2016, but it seems like it didn't really progress from there - https://bugs.debian.org/827236 https://bugs.debian.org/827236
- deleted 2y ago[deleted]
- simonw 2y agoScreenshots here: https://sqlitestudio.pl/gallery/ https://sqlitestudio.pl/gallery/ It's built in C++ and Qt, is GPL licensed, looks like it's been in development for just under ten years. https://github.com/pawelsalawa/sqlitestudio https://github.com/pawelsalawa/sqlitestudio
- googie 2y agoActually the project is much older. It started in 2007. More details on this can be found at https://sqlitestudio.pl/about/ https://sqlitestudio.pl/about/
- skc 2y agoSolid tool. But on Windows it has a tendency to freeze and remain unresponsive if you leave it open without using it for an extended period eg overnight. It's a minor annoyance
- cess11 2y ago[flagged]
- cztomsik 2y agoYou pay for a car. This is free and OSS.
- cess11 2y agoAre you sure? Maybe I only borrow the car. Edit: I apply the same rule to FOSS, of course. If it can't idle or if it freezes up or crashes sporadically or whatever I remove it. I'm old, I don't have the patience for stuff that breaks without good reason.
- Temporary_31337 2y agoThen report it via the appropriate channels with as much detail as possible and steps to reproduce. It looks like you are complaining without having even used the software.
- cess11 2y agoNo, I'm just not going to use the software if I encounter this.
- gchamonlive 2y agoYou'll have to stick to pen and paper, although pens stop working if you don't use it for an extended period of time, so I guess it's an obvious defect with the product and you shouldn't use it.
- DecoPerson 2y agoBe very careful using this over Samba, even with WAL mode enabled. I corrupted an important testing DB this way. Thankfully .recover came to the rescue and only a small amount of data was lost (but the test team had to wait a couple hours for me to bring the test environment back online).
- CaliforniaKarl 2y agoThe WAL journal mode does not work over Samba. See the first disadvantage from https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html: > All processes using a database must be on the same host computer; WAL does not work over a network filesystem. This is because WAL requires all processes to share a small amount of memory and processes on separate host machines obviously cannot share memory with each other. The presence of the `-shm` file is one of the signs that the database is currently operating in WAL mode, and must only be accessed from the machine hosting the database file. Looking at the list of journal modes supported (https://www.sqlite.org/pragma.html#pragma_journal_mode https://www.sqlite.org/pragma.html#pragma_journal_mode), you should see if the problem happens with the default `DELETE` journal mode. Also, see https://www.sqlite.org/atomiccommit.html#_broken_locking_implementations https://www.sqlite.org/atomiccommit.html#_broken_locking_imp... for warnings about the SQLite that ships with macOS.
- chasil 2y agoThat is not the only limitation of WAL mode. “It is not possible to change the page size after entering WAL mode.” “In addition, WAL mode comes with the added complexity of checkpoint operations and additional files to store the WAL and the WAL index.” https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf “SQLite does not guarantee ACID consistency with ATTACH DATABASE in WAL mode. “Transactions involving multiple attached databases are atomic, assuming that the main database is not ":memory:" and the journal_mode is not WAL. If the main database is ":memory:" or if the journal_mode is WAL, then transactions continue to be atomic within each individual database file. But if the host computer crashes in the middle of a COMMIT where two or more database files are updated, some of those files might get the changes where others might not.” https://www.sqlite.org/lang_attach.html https://www.sqlite.org/lang_attach.html
- killingtime74 2y agoI just use Datagrip. Works with SQLite and many more dbs
- turblety 2y agoDatagrip is a paid, proprietary and closed source commercial product.
- earthnail 2y agoTrue, but it’s one of the strongest offerings out there. Not everything has to be OSS. If you work with SQLite professionally (as I do), spending a few bucks on a good tool shouldn’t be a problem. I still think SqliteStudio is a phenomenal piece of software. Super lightweight, just works, cross-platform… really not a lot to complain about. And incredibly well maintained.
- JaggerFoo 2y agoExcellent product that behaves as expected and adheres to Sqlite's unique requirements when updating schema objects.
- hu3 2y agoI've been using this client lately: https://dbgate.org https://dbgate.org Anyone else?
- Oxodao 2y agoJust tried it, it might replace DBeaver for me! Vim mode without plugin is amazing. Need a few days to fully try it out
- ctm92 2y agoI wanted to replace DBeaver for a long time, but I have some not really common connections there (e.g. Sybase SQL Anywhere), that no other client seems to support
- andreasha 2y agoThere's Dbvisualizer if you want to try an alternative. Though I moved from the company provided dbvis pro version to DBeaver Community when I discovered it.
- thinker5555 2y agoI just tried it out, but for some reason it's complaining about missing a pivot_vtab module when I try to open an existing database. (MacOS ARM/Ventura)
- googie 2y agoAuthor here. I'm surprised and honored to have my pet project here ;) As mentioned in another comment, I'm currently in the process of bugfixing/polishing 3.4.x branch. Then I will focus more on 3.5.0, which will bring many big features. One of them being ERD (read & write).
- Nickersf 2y agoThank you very much for this amazing piece of software.
- mytdi 2y agoThank you for this great app! I have used it for a while now on both, Windows and Linux. Love it! I have recommended it here on HN in the comments a few times.
- zeroq 2y agoHa! I was going to reach out to you through a different channel, but here you are, on HN. :) The import function is really slow. I was recently playing with my pet project which is building an sqlite database from IMDB public datasets. It's 6Gb of CSV files into a ~12Gb database after a vacuum. With nodejs I can import the data within 6 minutes and create indexes and vacuum in another 4, which gives me a fully indexed database in just 10 minutes. With SQLStudio the import alone takes at least half an hour. Probably not a typical use case for a sqlite database, but nevertheless, a decent benchmark. BTW. Dobra robota! Dzięki! :)
- googie 2y agoIn few days there will be another 3.4.x branch release (3.4.7), which addresses this exact problem - https://github.com/pawelsalawa/sqlitestudio/issues/5119 https://github.com/pawelsalawa/sqlitestudio/issues/5119
- googie 2y ago...or if you didn't mean the import() SQL function, but in general importing functionality (through Import Dialog) and it's still slow there, then please contact me and I will see what can be done to improve it - https://sqlitestudio.pl/contact/ https://sqlitestudio.pl/contact/
- hochmartinez 2y agoI've been using It for several years, in Windows and now in Linux. Fast, slick and very powerful. Flies on my humble Atom laptop. By far the best free sqlite manager. Thanks Paweł Salawa for this great piece of software!
- SonOfLilit 2y agoThis week I needed to quickly have a peek at what was saved in a testing database, and I wondered "does VisiData support this?" and sure enough vd test.sqlite3 gave me a list of tables, right there in the terminal, and choosing a table with arrows and Return showed me the table data in a grid view with all of vd's filtering and sorting commands right there.
- seanw444 2y agoI forgot about VisiData. Great tool too.
- Alifatisk 2y agoIs there a tool that allows multiple people to work in the same sql workspace? I thinking an application like mysql workbench but for collaboration where everyone shares the same editor, terminal and everything else. That would accelerate the brainstorming a lot when working in a team remotely.
- pjturpeau 2y agoVery nice "pet" project! I was about to ask what would make it more interesting than HeidiSQL or DB Browser for SQLite and then I remembered those two are crashing on few of my .sqlite files while SQLiteStudio does not!
- xenodium 2y agoThis looks great. For Emacs users, v29 introduced sqlite-mode. I've experimented with some convenience extensions which can be handy for quick sqlite views and edits https://lmno.lol/alvaro/sqlite-mode-goodies https://lmno.lol/alvaro/sqlite-mode-goodies
- deleted 2y ago[deleted]
- coldcode 2y agoMacOS refused to run the installer on Sequoia. Signing it is not all that hard.
- dathery 2y agoDon't you have to pay an annual fee to Apple to sign software? It looks like they have a fee waiver program but for some reason it doesn't cover open source or even let an individual person apply at all: https://developer.apple.com/support/fee-waiver/ https://developer.apple.com/support/fee-waiver/ I'm not sure it is reasonable to demand that open source devs pay a fee to Apple so that you don't have to right-click the app and whitelist it...
- tensor 2y agoI thinks it's very reasonable. They provide an important security service, also the windows equivalent is many hundreds of dollars per year, per application, vs $99 per year which would cover any number of applications.
- dathery 2y agoMy comment was about whether it is reasonable for random people to demand open source devs pay a platform fee, not about whether the fee itself is reasonable. Quoting the last line of my comment again with added emphasis in case it was confusing: > I'm not sure it is reasonable *to demand that open source devs pay a fee to Apple* so that you don't have to right-click the app and whitelist it...
- tensor 2y agoOh yes. For sure. Agree completely.
- coldcode 2y agoIt has nothing to do with open source, it's about security. Installing an app with no connection to anything invites lots of people to build apps that steal your stuff (sure this app might be trustworthy, but not all). Every Mac and iOS developer has the same requirements. Installing an app with no signature is asking for people to get hacked. Do you leave your house open so that some contractor you don't know can enter your house and do whatever they please? $99 a year means Apple can trust that they at least know who the contractor is. There are people who want to steal your stuff (or your mom's) much smarter than you or I. This isn't an onerous requirement at all. I shipped my first Mac app in 1987, back then security was not an issue. It is today.
- bbqbbqbbq 2y ago[dead]
- deleted 2y ago[deleted]
- DonnyV 2y agoJust tried it out. It seems to freeze on Windows with large sqlite views. I have a 89GB sqlite file and it doesn't like it. sqlite file I used https://btrfs.openfreemap.com/areas/monaco/20241022_231001_pt/tiles.mbtiles https://btrfs.openfreemap.com/areas/monaco/20241022_231001_p...
- googie 2y agoThe file you linked is around 388kB in size. Are you sure it's the one you intended to link? I've checked it anyway and I see no problem for SQLite to open and query views from that db file.
- DonnyV 2y agoSorry, wrong one https://btrfs.openfreemap.com/areas/planet/20241120_001001_pt/tiles.mbtiles https://btrfs.openfreemap.com/areas/planet/20241120_001001_p...
- nbevans 2y agoI've been using this tool pretty much every day for almost a decade. It has a few quirks but it is still the best desktop tool for interacting with SQLite databases.
- dkjaudyeqooe 2y agoThis behaves very strangely on macOS 10.14.6: the installer downloaded from the website immediately logs you out without warning.
- googie 2y agoWeird behavior indeed. I don't observe it myself on MacOS 10.11 and I had feedback from couple of other Mac users, where it worked fine - even on older MacOS than yours. I really cannot imagine what could cause your MacOS to log out. Sorry.