OpenSQLManager

OpenSQLManager

OpenSQLManager is an attempt to create an alternative to Navicat that is free and open. It is build with PHP-GTK, so I’m looking for a way to create normal binaries.

Pre-configured version of php for windows

Because php-gtk is such a pain to compile on Windows, I’ve put together this package from the latest php-gtk windows package. It’s available in the downloads section.

How to run:

• On Windows: drag the index.php file to the php.exe or php-win.exe executable in the php package. php.exe brings up a DOS console, php-win.exe does not.
• On Mac:
  • Install MacPorts
  • Install these ports using MacPorts
    • php5
    • php5-cairo
    • php5-gtk
    • php5-iconv
    • php5-mysql
    • php5-postgresql
    • php5-sqlite
    • php5-ssh2
  • Run via terminal in the OpenSQLManager folder using php index.php

PHP Requirements

• Version 5.2 - 5.3.*
• PHP-Cairo PECL extension
• PHP-GTK PHP Extension
• OpenSSL
• JSON
• PDO
  • PDO drivers for the databases you wish to use

Want to Contribute?

See Dev Guide

Planned Features

• CRUD (Create, Read, Update, Delete) functionality
• Database table creation and backup

The databases currently slated to be supported are:

• Firebird version 2.5+
• MySQL / MariaDB version 5.1+
• PostgreSQL version 9.0+
• SQLite version 3+

Plan to implement, not support:

• ODBC

Won’t Support

Closed source DBs, like Oracle, MSSQL, etc.