pgCodeKeeper

Make the PL/pgSQL code maintenance easy

A tool for an easy work with PostgreSQL

Helps find changes between databases and create migration scripts for selected objects.

Features

change-bd

Show changes between databases

Finding out the DBs code differences is very easy now. It is possible to compare both the code of the DB working instances and the code formed by pg_dump, as well as pgCodeKeeper project code.

create-migration

Generate migration scripts

Now you can generate the migration scripts by means of user-friendly interface. You can use both the working DB and the DB dump as initial data. The comparison between the pgCodeKeeper projects is also possible — it is convenient when working with versions control systems.

work with system of control version

Support work with numerous VCS

pgCodeKeeper is the Eclipse platform extension. The DB code is saved in the Eclipse project, and the project code can be put into one of the versions control systems supported by the Eclipse — Git, SVN, Mercurial, CVS and many others.

work with system of continuous delivery

Non-interactive mode for continuous integration systems

pgCodeKeeper-cli can work in the non-interactive mode, which is really convenient for the formation of the continuous integration pipelines.

News

pgCodeKeeper 4.1.0

September 25, 2017

  • JDBC loader is able to read schemas of different PostgreSQL versions now, 9.2 though 9.6 are currently supported. Following SQL-clauses from these versions are now supported: CREATE FUNCTION ... TRANSFORM, CREATE FUNCTION ... PARALLEL, ROW LEVEL SECURITY. JDBC loader no longer fails when reading SEQUENCEs from PostgreSQL 10.
  • Added support for FOREIGN TABLE, MATERIALIZED VIEW objects and CREATE TABLE UNLOGGED clause.
  • Project builder now detects object name conflicts.
  • Error markers in sql-files are disabled for non-pgCodeKeeeper projects.
  • Added an object and change types filters to the diff table in the project editor.
  • pgCodeKeeper item is now visible in the main menu when working in the program's editors or its files.
  • Added a notification for errors found in sql-files while comparing DBs.
  • Extended .-operator (dot) support when it's used with nested composite types etc.
  • Object owners' names are now quoted the same as other identifiers.
  • Fixed a parser error when reading malformed COMMENT ON statements.
  • Fixed and error in checkbox state tracking in diff table.

Registration in the unified register of the Russian programs for ECM and DB

April 18, 2016

By order of The Ministry of Communications and Mass Media of Russia pgCodeKeeper is registered in the unified register of Russian programmes for electronic computing machines and data bases.

The taming of the scoundrel

February 1, 2016Habrahabr

Do you like to develop databases? No, not the modern NoSQL, but good old-fashioned relational ones, where you can describe the relations and the stored procedures for the data access and logic [...]

Other news

Using pgCodeKeeper you will greatly ease your work on PostgreSQL data bases maintenance

Contacts

Got questions, suggestions? Contact us.

Contact us

codekeeper@pgcodekeeper.org

Company address

117/V, Koli Myagotina Street, Kurgan, Kurgan region, Russia, 640000

We are in social networks

Get in touch with us through Telegram