SQLite and SQLite Browser annoyances

I have recently started to use SQLite and its Browser almost on a  daily basis! Generally speaking they work very fine. In hindsight, I was a bit premature when I wrote here about my first impressions working with SQLite and SQLite Browser.

Incident of 3/28/2024

I was in the middle of composing a select statement with a where clause not exists etc. when the browser abruptly exited upon executing the select statement. It was not a very fancy or complex statement as I am not an expert SQL developer. I hope, the automatic reporting feature worked and this will be fixed soon.

Worst of all, my project file was completely deleted and existed only with 0 bytes. All lost!

I venture to guess, because I had just renamed one of the two tables involved in the select statement may have caused the program to abort.

First experiences with SQLite and Data Browser for SQLite: Disappointing!

I have worked several years each with Microsoft SQL Server and Oracle DBMS and their excellent companion visual tools (i.e. SQL Server Management Studio and Oracle SQL Developer). So I was looking forward to start a new, private project with SQLite and its visual tool. I am using SQLiteBrowser 3.12.1 (latest version) and SQLite 3.34.1 (latest version) with the Fedora Linux as the operating system.

Just created my first database with one table and only one column in SQLiteBrowser. Then I tried to add more columns choosing the modify table operation (choosing if from the main GUI and from the right click menu of the table. It crashed every time I tried without any feedback whatsoever!

The code completion assistance by SQLiteBrowser is erratic to say the least. Sometimes it shows you a suggestion at the same expression, other times it does not. When it shows you suggestions, they disappear immediately again before you can choose one etc.

The import of data stored in CSV file into an existing table is also not done very well! Why do I have to manually enter the table name?

For a product like SQLiteBrowser that is being developed since 2003, this is a very disappointing experience. After so many years of development, I expect a much more mature and stable product!