Compiere is an integrated ERP and CRM business solution for automating financial, distribution, sales, and service processes, including: financial management, purchasing, materials management, manufacturing, order management, project accounting, customer management, sales, service requests, ecommerce, reporting, and performance management. Compiere utilizes a powerful model-driven application platform that provides customers with unprecedented adaptability, rapid deployment, and low cost of ownership.
Permission Record Information Machine (PRIM) delivers database connectivity via a web browser. Users can have different database permissions (e.g. create tables, modify tables, etc.). PRIM has built-in database analytical tools such as graph displays, reporting, etc. English and Chinese (Big5) language support.
PyDBDesigner is an entity-relation (ERW) database modeling tool for both Windows and Unix/Linux. It is similar to Power Designer or Erwin, and both physical and logical models are supported. Its main features are database modeling, SQL generation, documentation generation, and reverse engineering. PyDBDesigner is intended to be a GUI design tool for the ERW (entities and relations on the Web) project.
SQL Uniform is a database comparison and SQL query program. It is a database client with a graphical user interface. It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Solid, SQLITE, Sybase, ThinkSQL, and Yard.
C-Cramp (the C-Cramp College Radio Audio Management Program) is a Web-based frontend to MySQL for managing the types of things that small radio stations might need: audio files, data, and "metadata"; DJ and staff information, schedules, live music and program logs, and all sorts of other data. Currently, a cross-platform PHP application is the focus of the project, but more features and types of programs are planned that will hopefully enable easier playback, storage, loading, and entering for all types of applicable data.
XML to DDL is a set of Python programs that converts an XML representation of a database into a set of SQL or DDL (Data Definition Language) commands. In addition, it can examine the difference between two XML files and output a sequence of SQL statements (normally ALTER statements) to bring one database up-to-date with the XML schema. You can also download the XML schema directly from the database. Finally, there's a tool to convert your schema into HTML for documentation purposes. XML to DDL currently supports the most recent versions of PostgreSQL, MySQL, Oracle, and Firebird databases.
naarani Personal Access is a Java library to run programs that need to create, design, and access a MySQL database. It features automated managment of user rights, SQL code, table updates/track, data input/user masks, and a plugin to quickly add menu/custom fields management. Table and modules (masks) can be created or updated while debugging (even inside Eclipse) without reloading the program.