SQL Multi Select on Ubuntu 17.04 and Wine 2.0.1

Well, SQL Multi Select mostly runs on Ubuntu 17.04 with Wine 2.0.1.  Instructions for installing Wine 2.0.1 on Ubuntu 17.04 can be found here. What works: running multiple statements in a script using scripts located on Linux file system displaying images in result set using the command line interface to...Read more

Table and index sizes in DB Doc 4

Starting from DB Doc 4, table and index objects now have size properties. For tables, the following size properties are available: total size table size (excludes indexes and toast sizes) indexes size toast size For indexes, there is a single size property.  In all the report templates, the size properties...Read more

Documenting your PostgreSQL database

PostgreSQL has a pretty nifty feature to add comments to database objects, using the COMMENT function.  You can pretty much add comments to almost any objects, like tables, view, foreign keys, constraints, columns, etc. You add a comment using the COMMENT ON … function, then retrieve the comment using the...Read more

How fast is DB Doc

DB Doc is our PostgreSQL database schema documentation tool, and we recently had the opportunity to work on a fairly large production database.  The database had 7 schemas, containing over 800 tables, over 17000 columns in total, 300+ sequences, and 350+ functions.  DB Doc was ran on the server with...Read more

Extracting files and data from OLE Object fields

OLE Object fields are commonly used by applications using Access as the back-end database to store files and common document formats.  It is convenient because Windows handles how the files or documents are opened, modified, and saved via OLE servers.  However, it is difficult to extract the data from those...Read more

Customizing DB Doc PDF and Word report templates

The PDF and Word reports in DB Doc share the same template.  Most of the elements in the PDF template are customizable.  To customize the report, click on the Edit button next to the Report template file name. There are broadly 2 types of elements in the report templates: text memos...Read more