+1 for DBeaver. It doesn’t have a pretty UI like TablePlus but it’s FOSS, cross platform and has all of the same features (maybe more).

Agreed. The only thing it probably doesn't satisfy here is lightweight (being built on Eclipse). But actually one of the things that keeps me with it is that being built on Eclipse I can use a whole bunch of Eclipse plugins that have have from that environment and they work great.

Does the code completion/autocomplete in dbeaver support "fuzzy typing" like in Sublime Text?

For example, if you have a table called "catalog_product_flat", would the autocomplete suggest that table when you typed "catprfl"?

I looked at TablePlus but the formatter was horrible.

DBeaver internal formatter is decent and if I want more I can use an external tool.

I tried many free alternatives and for a long time I am using valentina studio. It requires registration for free version license key. It has nearly all features that I need with in free version.

Agree as well! Best SQL IDE for Oracle/PostgreSQL. It uses the same IDE framework that eclipse use. So you can quickly get familiar with and even use the same shortcuts.

I have also been a dbeaver user, but DBeaver 7 has been really unstable for me and has caused me to look for alternatives.

> Advanced cryptography algorithms for SSL/SSH connections.

as a feature limited to the enterprise version sounds kind of scary.