pgCodeKeeper

PL/pgSQL code maintenance made easy

A tool for easier PostgreSQL development

Finds differences between database objects and creates migration scripts, interactively or automatically.

Features

change-bd

Compare databases

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

create-migration

Generate migration scripts

Generate migration scripts via 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 many others.

work with system of continuous delivery

Non-interactive mode for continuous integration systems

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

News

pgCodeKeeper 5.0.0

August 1, 2018

  • SQL code generation has been changed. All SQL statements are now created for search_path = pg_catalog. This improves security and stability of generated code, for more information see PostgreSQL 10.3 changelog.
    Because of this, differences in name qualification will be found when comparing projects with DBs. Projects need to be updated to the new format by saving these differences.
  • Location of schema SQL files in projects has been changed. They are now stored in their schema directories instead of common SCHEMA directory.
    When opening older projects pgCodeKeeper will suggest moving schema files to their new location.
  • Using constant search_path for SQL code generation allows JDBC loader to read objects from all schemas with a single query. This greatly improves schema load speeds and allows us to get rid of server helper functions, they are no longer used. Work with pg_dbo_timestamp extension is also greatly sped up.
  • Fixed parsing of nameless function parameter of type character varying. (4.6.1)
  • Fixed compatibility with Eclipse 4.8. (4.6.1)
  • Fixed decrementing SEQUENCEs to comply with PostgreSQL 10 implementation. (4.6.1)
  • Fixed CONSTRAINT processing when working with pg_dbo_timestamp extension. (4.6.1)

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.

Contact us

codekeeper@pgcodekeeper.org

Company address

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

Follow us in social networks

Get in touch with us through Telegram