pgCodeKeeper

PL/pgSQL code maintenance made easy

PostgreSQL schema development tool

Easily find differences between database objects and create migration scripts, interactively or automatically.

Features

change-bd

Compare databases

Comparing database code is made easy with pgCodeKeeper. Compare live DB instances, pg_dump output, as well as pgCodeKeeper projects.

create-migration

Generate migration scripts

Generate migration scripts in a user-friendly interface. You can use both live DB instances and DB dumps as initial data. You can also compare pgCodeKeeper projects — useful when working with versions control systems.

work with system of control version

Use various VCSs

pgCodeKeeper is an Eclipse IDE plug-in. The DB code is saved as an Eclipse project, and the project can be tracked under any of the versions control systems supported by Eclipse — Git, SVN, Mercurial, CVS and others.

work with system of continuous delivery

Non-interactive mode for continuous integration systems

pgCodeKeeper-cli can work non-interactively, which is convenient when setting up continuous integration pipelines.

News

pgCodeKeeper 6.6.0

September 27, 2022

  • It is now possible to generate the creation of CONSTRAINTs using NOT VALID/VALIDATE in migration scripts (CLI option --generate-constraint-not-valid).
  • It is now possible to change the trustServerCertificate parameter for MS SQL connections.
  • It is now possible to roll forward selected objects in the project editor without checked marks.
  • Added support for COLLATION objects.
  • Added CLI option --update-project to update project in --parse mode.
  • Added CLI option --clear-lib-cache to clear libraries cache.
  • Added a marker for the current group in the database selection menu.
  • Improved quick fix mechanism for FUNCTION, USER MAPPING, CAST objects.
  • Disabled re-launches of the parser by right-clicking in the SQL editor.

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 programs 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

pgCodeKeeper will make your time maintaining PostgreSQL databases easier

Contacts

Got questions, suggestions? Contact us.

Company address

72 Gertsena St., Bldg. 1, Office 301, Tyumen, Tyumen Oblast, Russia, 625000

Get in touch with us through Telegram