Thursday, February 04, 2021

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!

No comments: