Author 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).
It's a great tool. My use-case is a bit unusual: I decommissioned an Oracle Portal instance and decided to keep a copy of the tables in SQLite so that I can recover files people may later remember they need. It's much easier than maintaining an Oracle instance.
It's a nice feature of SQLiteStudio that you can click on a blob and see the image, if it's an image file.
SQLiteStudio is fantastic, I've been using it on and off for a few years already and it's saved my ass so many times. Once, we were doing many many meetings discussing a potential implementation for a sales incentive scheme and it was very difficult to get everyone onboard. Fed up with this I built a demo database in sqlite using a portable SQLiteStudio instance and prepared a bunch of queries. This "reference implementation" made it possible to get everyone aligned in record time !! This would not have been possible at all with the "frictions" of a convential RDBMS.
Also, analyzing and cleaning up client data during project UATs is so damn convenient in SQLiteStudio. Thanks !!!!
love it! thank you so much!!
Thank you! This is great software. I don't use it much (and recently almost not at all), but I still love. It's fast, it's easy to use. I just checked your website and it looks there are tons of features I didn't know about :). Thanks again.
This 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.
I'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!
I'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.
It's in AUR
That's my Swiss knife.
Super handy in a lot of scenarios, and I use it side-by-side with Jetbrains' DataGrip.
I have been using sqlitebrowser as well. Fairly satisfied, except for the poor 'export to csv' that seems to fail on respecting csv separations in some cases. Does SQLiteStudio handle this correctly?
Do you have the specifics of the failure cases? We (sqlitebrowser.org devs) tend to fix bugs like that when we have a reproducer.
Just tried it, it might replace DBeaver for me! Vim mode without plugin is amazing. Need a few days to fully try it out
Is 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.
Very 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!
Excellent product that behaves as expected and adheres to Sqlite's unique requirements when updating schema objects.
Be 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).
> 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.
Solid 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
Author here. This was never reported. I haven't noticed it for myself either. Feel free to get in touch through the official email (mentioned on the homepage) or through GitHub issues. I'm in the process of polishing 3.4.x branch, eliminating as many bugs as possible, before focusing on 3.5.0.
I've used it for many years. Never faced this problem.
Really?
To me that's a major annoyance, an obvious defect in the software. It's like a car going unresponsive from standing still at a red light and needing me to turn it off and waiting for five seconds before I start it again before I can drive away, or having to turn it off when stopping and then starting again when the light changes.
Then 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.
No, I'm just not going to use the software if I encounter this.
What 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.
Here's one use case: while I don't use this particular GUI, it really does help when you have some columns containing RTL text such as Arabic and you want to browse through a table. RTL handling in most terminal emulators I've used is really lacking, though I can't blame them.
That's actually a really interesting case I had never considered. I actually just took it for granted that RTL in the console was a solved problem
Not just in consoles. While RTL is solved for most cases, I generally avoid writing Arabic in code for example (hard-coded strings, regex, etc) and just use Unicode escape sequences. Some issues include ASCII punctuation appearing (visually) in the wrong order and very awkward text selection
Lots of things! It gives you sqlite superpowers. It makes you more productive and saves you lots if time. You can edit several databases at the same time. And editing them is far easier. For example, it generates and executes the sql code to add new columns for you. You can edit the data of several rows directly on a query response, as if It was a spreadsheet, just by clicking on a column value (or you can use a column value editor). Super handy. You can view and edit blobs. The sql editor has autocompletition and you can execute a statement just by having the cursor on this statement, so you can quickly test multiple independent queries in a single editor window. It shows the execution times, so you can easely compare the speed of several query strategies. You can view the query optimizer info by clicking a button. It supports several scripting lenguajes, and the list goes on and on. Check the features here: https://sqlitestudio.pl/features/
A good alternative to the sqlite cli is litecli [1]. I've been a happy user for quite some time.
For example it has context-aware syntax autocompletion, easy D&D for tables between databases, and many more - you can see longer list at https://sqlitestudio.pl/features/
Allows people who are not versed in SQL to interact with and edit sqlite files as if it was a spreadsheet (for better or worse)
UI is quite useful to me
Maybe UI
Agreed, rip the band-aid off folks. You will be so glad you did.
I just use Datagrip. Works with SQLite and many more dbs
Datagrip is a paid, proprietary and closed source commercial product.
Author 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).
It's a great tool. My use-case is a bit unusual: I decommissioned an Oracle Portal instance and decided to keep a copy of the tables in SQLite so that I can recover files people may later remember they need. It's much easier than maintaining an Oracle instance.
It's a nice feature of SQLiteStudio that you can click on a blob and see the image, if it's an image file.
SQLiteStudio is fantastic, I've been using it on and off for a few years already and it's saved my ass so many times. Once, we were doing many many meetings discussing a potential implementation for a sales incentive scheme and it was very difficult to get everyone onboard. Fed up with this I built a demo database in sqlite using a portable SQLiteStudio instance and prepared a bunch of queries. This "reference implementation" made it possible to get everyone aligned in record time !! This would not have been possible at all with the "frictions" of a convential RDBMS. Also, analyzing and cleaning up client data during project UATs is so damn convenient in SQLiteStudio. Thanks !!!!
love it! thank you so much!!
Thank you! This is great software. I don't use it much (and recently almost not at all), but I still love. It's fast, it's easy to use. I just checked your website and it looks there are tons of features I didn't know about :). Thanks again.
This 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
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.I'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!
Screenshots here: 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
Actually the project is much older. It started in 2007. More details on this can be found at https://sqlitestudio.pl/about/
How does this compare with https://sqlitebrowser.org/ ?
I'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.
It's in AUR
That's my Swiss knife.
Super handy in a lot of scenarios, and I use it side-by-side with Jetbrains' DataGrip.
I have been using sqlitebrowser as well. Fairly satisfied, except for the poor 'export to csv' that seems to fail on respecting csv separations in some cases. Does SQLiteStudio handle this correctly?
Do you have the specifics of the failure cases? We (sqlitebrowser.org devs) tend to fix bugs like that when we have a reproducer.
My goto as well.
I've been using this client lately: https://dbgate.org
Anyone else?
Just tried it, it might replace DBeaver for me! Vim mode without plugin is amazing. Need a few days to fully try it out
Is 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.
Very 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!
Excellent product that behaves as expected and adheres to Sqlite's unique requirements when updating schema objects.
Be 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).
The WAL journal mode does not work over Samba. See the first disadvantage from 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), you should see if the problem happens with the default `DELETE` journal mode.
Also, see https://www.sqlite.org/atomiccommit.html#_broken_locking_imp... for warnings about the SQLite that ships with macOS.
Solid 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
Author here. This was never reported. I haven't noticed it for myself either. Feel free to get in touch through the official email (mentioned on the homepage) or through GitHub issues. I'm in the process of polishing 3.4.x branch, eliminating as many bugs as possible, before focusing on 3.5.0.
I've used it for many years. Never faced this problem.
Really?
To me that's a major annoyance, an obvious defect in the software. It's like a car going unresponsive from standing still at a red light and needing me to turn it off and waiting for five seconds before I start it again before I can drive away, or having to turn it off when stopping and then starting again when the light changes.
Then 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.
No, I'm just not going to use the software if I encounter this.
What 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.
Here's one use case: while I don't use this particular GUI, it really does help when you have some columns containing RTL text such as Arabic and you want to browse through a table. RTL handling in most terminal emulators I've used is really lacking, though I can't blame them.
That's actually a really interesting case I had never considered. I actually just took it for granted that RTL in the console was a solved problem
Not just in consoles. While RTL is solved for most cases, I generally avoid writing Arabic in code for example (hard-coded strings, regex, etc) and just use Unicode escape sequences. Some issues include ASCII punctuation appearing (visually) in the wrong order and very awkward text selection
Lots of things! It gives you sqlite superpowers. It makes you more productive and saves you lots if time. You can edit several databases at the same time. And editing them is far easier. For example, it generates and executes the sql code to add new columns for you. You can edit the data of several rows directly on a query response, as if It was a spreadsheet, just by clicking on a column value (or you can use a column value editor). Super handy. You can view and edit blobs. The sql editor has autocompletition and you can execute a statement just by having the cursor on this statement, so you can quickly test multiple independent queries in a single editor window. It shows the execution times, so you can easely compare the speed of several query strategies. You can view the query optimizer info by clicking a button. It supports several scripting lenguajes, and the list goes on and on. Check the features here: https://sqlitestudio.pl/features/
A good alternative to the sqlite cli is litecli [1]. I've been a happy user for quite some time.
[1] https://litecli.com
For example it has context-aware syntax autocompletion, easy D&D for tables between databases, and many more - you can see longer list at https://sqlitestudio.pl/features/
Allows people who are not versed in SQL to interact with and edit sqlite files as if it was a spreadsheet (for better or worse)
UI is quite useful to me
Maybe UI
Agreed, rip the band-aid off folks. You will be so glad you did.
I just use Datagrip. Works with SQLite and many more dbs
Datagrip is a paid, proprietary and closed source commercial product.