It can be tedious when designing an application ( and not using frameworks like Symfony ) to design your database and then create corresponding SQL scripts. Thanks to Parse-Dia-SQL you can design your database using Dia and then generate corresponding SQL script for your database.

To mark an attribute as being a primary key, set Visibility = protected

To add NOT NULL and DEFAULT xxx to your attributes, first add the default value and then the NULL or NOT NULL in Value field. For example to have DEFAULT CURRENT_TIMESTAMP NOT NULL on your SQL file, just add CURRENT_TIMESTAMP NOT NULL in Value field

Additional indexes can be create in [Operations] tab where :

Operation Name = Index name ( e.g table_col_idx )

Operation Type = Index type ( INDEX or UNIQUE INDEX )

Parameters = Index columns ( one parameter name for each column name in the index )

Stereotype: Index type — For PostgreSQL, you can choose other than btree ( hash, gist, gin ). Please note that GIN indexes may be useful for JSON datatype

Foreign-keys constraint are done with UML aggregation tool ( line with a diamond at one end ) in which in its properties you are going to specify foreign-key direction and columns

Please note that for PostgreSQL no need to use typemaps for autoincrement columns, just put SERIAL as attribute type

Suppose that you want to add a surrogate key to a table in PostgreSQL to help you quickly identify each rows in a unique way. You can do this easily and quickly by just adding a SERIAL type column. When adding a SERIAL type column to an already filled table, PostgreSQL will automatically fill the column with some values.
To ensure your surrogate key uniqueness, don’t forget to add the UNIQUE constraint : on top of that this will create an index, thus speeding up your join queries on this column.

At work we are using Windows workstations, but we are working most of the time in our Virtual Machine, hosted in a Cloud, running under Linux. We have access to our Linux VM with NXClient or by using Putty. If you want to transfer some files from your Windows workstations to your Linux VM, several solutions exists. Most solutions are using the built-in SFTP server of OpenSSH : Filezilla, WinSCP. Their drawbacks ? They are just some FTP-like clients, and so you lack integration with Windows, notably the Windows Explorer.

Under Linux we can use SSHFS to mount your SSH server as a filesystem. Nautilus and Dolphin, at least, allow also to mount your remote SSH server in your local filesystem. Under Windows there are 2 solutions : ExpanDrive which a proprietary solution, and Dokan which is an OpenSource and Free implementation of a FUSE-like filesystem.

Installing Dokan

In fact Dokan is not really a program but a library implementing a FUSE-like filesystem. So for SSHFS support, you need to install the Dokan library, and then after, you will install the module allowing to use SSHFS protocol.