Emma is a graphical toolkit for MySQL database developers and administrators. It provides dialogs to create or modify MySQL databases, tables, and associated indexes. The results of an executed query are displayed in a resultset where the record data can be edited by the user, if the SQL statemant allows for it. The SQL editor and resultset view are grouped in tabs. Results can be exported to CSV files. Multiple simultaneous opened MySQL connections are possible. Emma is the successor of yamysqlfront.
pgAdmin III is an administration and management tool for the PostgreSQL database and derivative products such as EnterpriseDB, Mammoth PostgreSQL, Pervasive Postgres, and SRA PowerGres. It includes a graphical administration interface, an SQL query tool with grahical EXPLAIN, a procedural code editor, an SQL/shell/batch scheduling agent, Slony-I management, and much more. It is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy.
Affiliates is an affiliate management system for clubs, communities, schools, and associations. It allows you to set up and maintain a database and provides a graphical interface, a mailing and label printing tool, an email tool, an archive and initialization tool, import and export to CSV files, membership and record cards, support for JPEG images, templates for forms and documents, and networking support.
IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters, and companies. It can retrieve data from both the IMDb's Web server and a local copy of the whole database. The IMDbPY package can be very easily used by programmers and developers to provide access to the IMDb's data to their programs. Some simple example scripts are included in the package.
P4A (PHP For Applications) a PHP5 RAD and object oriented PHP framework for building event-driven, stateful Web applications. It is based on Zend Framework and features tableless HTML, multiple databases, access key support, auto data type recognition, transparent AJAX, UTF-8, internationalization, and localization.
Metabase is a DBMS-independent PHP API to access SQL databases. It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft Access, ODBC, Interbase, Informix, MiniSQL, and SQLite. It supports nested transactions, blobs, and prepared queries. It can install database schemas defined in a DBMS independent XML format that describe tables, indexes, primary keys, and auto-increment sequences. It is also able to upgrade a database to a new schema without affecting the data that was stored since it was installed or upgraded for the last time. There is also schema reverse engineering support.
i-net Clear Reports (formerly i-net Crystal-Clear) is a very powerful reporting solution. It can accommodate a broad range of reporting needs, from a simple standalone application to a really big enterprise Web solution. It can produce many different output formats like Java Viewer, PDF, HTML, PS, RTF, XLS, TXT, CSV, SVG, and XML. It can generate reports from many different data sources like JDBC, ODBC, Java API, JNDI Data Source, and without data.
Talend Open Studio for ESB is an innovative, Eclipse-based tooling environment for modeling, configuring, and deploying integration solutions using the Apache-based open source enterprise service bus (ESB), Talend ESB. Talend ESB is a versatile and flexible ESB that allows organizations to address integration challenges, from simple departmental projects to complex, heterogeneous IT environments. Powered by the Apache CXF, Apache Camel, and Apache ActiveMQ Open Source integration projects, it makes enterprise-class integration accessible by delivering a cost-effective and easy-to-use way to integrate and expand systems and applications.
ERW (Entities and Relationships on the Web) is an innovative system for handling complex databases using a Web browser. It uses the most recent standards endorsed by the W3C to offer to the user a sophisticated environment, similar to a dedicated client. Moreover, the user interface is generated in a completely automatic way starting from a conceptual description of the database by means of an XML-based description language for entity-relationship schemata. From the same description, you can also automatically obtain diagrams and documentation. ERW can be used for content management, in particular when the data is structured along complex relations.