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.

▲

owobeid 8 months ago | parent | next [-]

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.

▲

bilekas 8 months ago | parent | next [-]

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

	▲	owobeid 8 months ago \| parent [-]
		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

▲

dotancohen 8 months ago | parent | prev [-]

One day I set out to resolve this, though I can not find in my notes' files what the solution was (for MySQL). It might have been to simply use MyCLI instead of the standard MySQL CLI. Have you tried it?

https://github.com/dbcli/mycli

▲

hochmartinez 8 months ago | parent | prev | next [-]

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/

▲

TheRealPomax 8 months ago | parent | prev | next [-]

All the benefits of a normal GUI-based DB manager. So "too many things to list, have a look at the website, it should be pretty self-explanatory" =D

▲

chasil 8 months ago | parent | prev | next [-]

This 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_conne...

▲

AstroJetson 8 months ago | parent [-]

I 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 8 months ago | parent [-]

I 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 8 months ago \| parent [-]
		Maybe 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.

▲

kyawzazaw 8 months ago | parent | prev | next [-]

UI is quite useful to me

▲

dagw 8 months ago | parent | prev | next [-]

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)

▲

googie 8 months ago | parent | prev | next [-]

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/

▲

dayeye2006 8 months ago | parent | prev | next [-]

Maybe UI

▲

rmbyrro 8 months ago | parent | prev | next [-]

A good alternative to the sqlite cli is litecli [1]. I've been a happy user for quite some time.

[1] https://litecli.com

▲

emptiestplace 8 months ago | parent | prev [-]

Agreed, rip the band-aid off folks. You will be so glad you did.