On 11/30/2022 9:29 PM, rbowman wrote:
> On Wed, 30 Nov 2022 13:52:44 -0500, DFS wrote:
>
>> On 11/30/2022 1:23 AM, Marco Moock wrote:
>>> Am 29.11.2022 um 12:37:51 Uhr schrieb DFS:
>>>
>>>> "MeowSQL is an attempt to port a very useful GUI database client
>>>> HeidiSQL to C++/Qt (with aim to be run natively at least on Linux)"
>>>
>>> Who in the world needs such a thing?
>>
>> Everyone.
>>
>>
>>> There is the MySQL/MariaDB CLI that can handle everything.
>>
>> One big advantage of the GUI tools is you can have multiple tables and
>> query windows open.
>>
>> And they often keep a history of your queries, and offer SQL formatting,
>> GUI-driven data import and export, etc.
>>
>> A tool like SQLiteStudio or Valentina Studio generally blows the CLI
>> away in terms of productivity.
>>
>>
>>
>>> If they want a GUI, DBeaver exists.
>>
>> I usually use SQLiteStudio, but there are many GUIs.
>
> Unless it has vastly improved since the last time I tried to use it IBM
> DB2 GUI make the db2cmd prompt look fantastic. Depending on what I'm doing
> I often use psql or the various GDAL/OGR command line tools rather than
> pgAdmin4.
I wasn't impressed with pgAdmin4 at all. It was very slow last time I
tried it. But there are probably a dozen aftermarket PostgreSQL GUIs
for Windows and Linux.
> However SQL Server Management Studio is my go to for MSSQL. The only time
> I use the command line is if some dufus forgets the admin password. You
> can restart in single user mode and reset it.
SSMS is a good admin app, and last I looked at them the Reporting
Services were nice, too.
Years ago I used various Oracle stuff: SQL Developer, SQL Worksheet,
built-in admin interfaces. They were Java-based and terrible (though
SQL Developer was OK).
> I just started playing with SQLite this afternoon in .NET but don't have a
> GUI installed.
I've sung the praises of SQLite many times. It's not a multi-user
system suitable for large numbers of concurrent writing, but it's
fantastic for many scenarios, including fairly large databases. It
doesn't support the full SQL standard, but plenty enough. The
documentation is first-rate, and the SQLite Forum is great. I recently
got a quick answer directly from D. Richard Hipp, the original SQLite
developer. It's still under active development.
At one point last year I had SQLite, MariaDB, PostgreSQL, Firebird, DB2
Express and Oracle Express running at the same time on my old Win10
system, each populated with identical data. The performance of each was
plenty acceptable, but SQLite Oracle and PostgreSQL were consistently
faster (maybe 5%-10% difference between the servers, using a PyQt app).
SQLite and Firebird were the least 'robust' but I completely trust
SQLite with my data. It's a very well-tested system.
> For our next generation I want to replace a 25 year old,
> home grown, piece of crap with MFC dependencies. Even 25 years ago
> writing your own database was stupid.
That is crazy. Who let them do it?