1. 27
  1.  

  2. 7

    I use Rosefinch as SQLite GUI.

    1. 3

      Even though, it might be worth the money, I had to click to realise that it’s closed source and requires a one time payment.

    2. 5

      Cool. When I still used GUIs to work with SQLite, I used to use SQLiteMan which was free and open source as well, but apparently it became unmaintained. :( I guess SQLiteMan is dead, long live SQLite Browser :D .

      Unrelated, people might want to take a look at litecli for a SQLite shell with live auto-complete.

      1. 1

        Oh, litecli looks great! Thanks for sharing!

      2. 5

        I use https://sqlitestudio.pl/ OSS, Wndows, MacOS, Linux, etc.

        1. 4

          I like TablePlus (paid). Not affiliated, just a user.

          1. 4

            My current favorite SQLite tool is Observable’s reactive notebooks. Sure, for schema visualization or data changes a local full featured GUI is necessary, but the notebook model is so nice for exploration and analysis. Especially because you can mix pure SQL query cells with soft data munging in JavaScript. Here’s their starter example: https://observablehq.com/@observablehq/sqlite

            1. 4

              Another one: https://dbeaver.io (Java-based, cross-platform)

              1. 1

                Any idea how this compares to https://dbvis.com/ ? (Which is also Java and cross-platform)

              2. 3

                Note that despite the tag, this is not a mac-only app.

                1. 1

                  Thank you, I hadn’t realized that and didn’t even bothered to read the page!

                  I’ve suggested the removal of the tag.

                2. 2

                  There’s also https://lite.datasette.io for an in browser SQLite browser.

                  1. 1

                    I used to use sqlitemanager extension in firefox, then it disappeared, now it’s back and it plots as well..

                    UI is not as intuitive as it used to be or sqlitebrowser is though…

                    https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/

                    1. 1

                      I have an M1 Mac but apparently there’s no binary download available for the M1 architecture. That’s fine, since I can use brew to install it instead. But even the binary generated by brew says the same thing, which baffles me.

                      1. 1

                        Nice. Is there something similar based on ncurses or something that might be easier to use on a remote system that you can only SSH into?

                        1. 2

                          If you have nushell installed on the remote system, the latest version just added the ability to read and manipulate sqlite dbs.