purpose

verdb manages the execution of PostgreSQL DDL scripts. It expects to be executed in a directory containing list of sub-directories, each of which corresponds to a set of changes. The sub-directories must contain an 'up.sql' and a 'down.sql' script. (although these filename may be changed)

The list, and order of the changes, must be maintained in a control file. This file is an ordered list of sub-directories. The pointer will reference a single sub-directory name contained in this file.

verdb maintains a pointer to the last batch (directory) of DDL scripts that executed correctly.

example

verdb init database postgres batches
verdb status
verdb up all
verdb show all
verdb extract stored_procedure schema.name

verdb gen trigger students --table=students --func=log_students
verdb gen table instructors --table=instructors
verdb gen index instructors-index --table=instructors --fields=name,location --schema=sch

install

With npm do:

sudo npm install verdb -g

license

MIT