pgdbDiffo - online database designer for your own servers

If you are in a hurry...

If you are in a hurry, do the following:

  1. Download pgdbdiffo ZIP archive from https://dbdiffo.com/getpgdbdiffozip.php.
  2. Unzip the archive into your web application’s folder.
  3. Give write access to the user running the WEB server for the web application’s folder.
  4. Run pgdbdiffo.php or index.php with a browser of your choice.

If you are curious about what’s going on here, or ran into an error, continue reading! :)

pgdbDiffo and dbDiffo

Before I get into the details of pgdbDiffo’s installation, allow me to explain why it was necessary to develop pgdbDiffo after dbDiffo.

Both of them are free online database designers, and pgdbDiffo is essentially based on dbDiffo’s code. While dbDiffo only enables designing databases and generating SQL scripts, pgdbDiffo lets you directly change the database, and immediately run the generated SQL scripts against the database.

This, of course, requires you to install it on your server, but that’s easy enough. I started this article with a basic summary of the installation process. Any further important information will be highlighted in the text.

Please note: pgdbDiffo (unlike dbDiffo) only supports PostgreSQL database management systems. For MySQL use mydbDiffo. (PostgreSQL, Oracle, Microsoft SQL Server and IBM DB2 are not supported.)

System requirements

  1. A WEB server cabable of running PHP scripts. So far pgdbDiffo was only tested with PHP 7.3.x+ and 8.2.x+.
  2. Write access for the user running the WEB server for the folder where pgdbdiffo ZIP archive will be unzipped.
  3. While running on your WEB server, pgdbdiffo.php and the other related PHP scripts will NOT establish HTTPS connection with the dbdiffo.com server anymore. Running pgdbDiffo requires the ZipArchive class.
  4. Enable pgsql and zip (PHP 8.x+) extensions in the php.ini file.
  5. PostgreSQL v9.6+

Installing pgdbDiffo

Downloading pgdbdiffo ZIP archive

pgdbdiffo ZIP archive can be downloaded from the following address.

https://dbdiffo.com/getpgdbdiffozip.php

Unzip pgdbDiffo ZIP archive to the server

After downloading pgdbDiffo ZIP, log in to the server and unzip the files into your web application’s folder.

(If you have more than one web applications you want to run pgdbDiffo on, we recommend unzip pgdbDiffo ZIP to all web applications’ folders. pgdbDiffo integrates with MakeLoveNotCode, which requires a separate installation for every web application.)

Write access for the user running the WEB server

Let’s see an example on how to give write access.

Use the following folder for your web application:

/var/www/www.yourserver.com/yourwebapp

You can give write acccess with the following command:

sudo chmod g+w /var/www/www.yourserver.com/yourwebapp -R

Launching pgdbDiffo

Just one more thing to do. Run pgdbdiffo.php and log into the database using pgdbDiffo’s login window.

Example:

Use the following folder for your web application:

/var/www/www.yourserver.com/yourwebapp

To launch pgdbDiffo, enter the following URL into the browser:

https://www.yourserver.com/yourwebapp/pgdbdiffo.php

pgdbdiffo.php does NOT create and download all necessary files from the dbdiffo.com server anymore. If a newer version was released on dbdiffo.com, the software warns you, but you have to download the ZIP archive and istall it again. When the login window appears, enter the database login information.