Keep up with the latest news.
July 07, 2018The next release of Postgres Compare includes a new "Create Script" experience which allows you to work with and make alterations to an update script in real time. Previously this was a small modal. Now it is a seperate, resizable window to make it easier to work with and include some extra information.
June 16, 2018Follow these steps to get up and running quickly with PostgresCompare.
April 16, 2018Its been a little over a month since the alpha of PostgresCompare started and, thankfully, I've received a lot of feedback as to how I can improve the application. To help clear up how I'm going to get from alpha to beta and beyond I'm detailing here the work I am going to tackle before taking that next step.
January 11, 2018
Here’s a gif of me comparing a couple of databases and viewing the differences.
June 11, 2017
While exploring the
pg_catalogschema I noticed that while the relationships between the tables are documented, they are not enforced by actual database constraints. Tom Lane provided an excellent answer as to why this is the case:
June 07, 2017
User interface design is hard. There is something about the frontend that doesn’t come naturally to me. At the same time I’ve witnessed first hand the impact a beautiful and intuitive UI can have on a user. A beautiful UI is easy on the eyes, users want to interact with it and they are more forgiving when something doesn’t quite work.
June 06, 2017
The CREATE DATABASE statement is used to create a new PostgreSQL database. It does so by cloning an existing database, a template. PostgreSQL comes with two template databases,
template1. The difference between
template1is their intended use.
template1is the default template when creating a new database, it can also be connected to and any custom objects that new databases should have can be created there.
template0does not accept connections and is therefore a clean source for those times when
template1has become messy for some reason.
May 16, 2017
I believe that while listening to customer feedback and giving the people what they want can be of great benefit to the short term development of an application, it is also important to lay out some key principles that really define the essence of the product. Key principles help in many ways. From a users point of view the application has an identity and a unique look and feel. Internally the principles can be used as a guide for decision making.
May 12, 2017
April 20, 2017
There was a question recently on pgsql-general about Stored procedure version control. The question was: