DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
papaya CMS is a Web Content Management System based on open standards (including XML, XSLT, PHP, and MySQL/PostgreSQL). It is compatible with almost every operating system, is platform-independent, is multi-lingual, offers great usability, and is easy to extend via its plugin system. It is scalable and perfect for business websites.
SOFA is a statistics, analysis, and reporting program with an emphasis on ease of use, learning as you go, and beautiful output. SOFA can connect directly to your database and lets you display results in an attractive format ready to share or put in a spreadsheet. SOFA will help you learn as you go, whether you are a student, business analyst, or researcher.
"PHP Web Security Monitor" is designed to protect Internet sites created with PHP from malicious queries from hackers and Web viruses. It filters common PHP variables via prepared security patterns and compares (unprotected) input variables against patterns of dangerous data, such as SQL injection, XSS injection, and PHP code compromising.
WebIssues is a multi-platform system for issue tracking and team collaboration. It can be used to store, share, and track issues with various attributes, comments, and file attachments. It is easy to install and use but has many capabilities and is highly customizable. Desktop and Web clients are provided.
Barman (backup and recovery manager) for PostgreSQL is an administration tool for disaster recovery of PostgreSQL servers. It allows remote backups of multiple servers in business-critical environments and helps DBAs during the recovery phase. Barman's most-wanted features include backup catalogs, retention policies, remote recovery, archiving, and compression of WAL files and backups.
The YB.ORM library aims to simplify writing C++ code that has to deal with SQL databases. The goal is to provide a convenient interface like SQLAlchemy (Python) or Hibernate (Java). The library itself is cross-platform and supports a variety of SQL dialects: SQLite3, MySQL, Postgres, Oracle, and Firebird. Integration with Boost, Qt4, and wxWidgets is built-in. In a typical usage scenario, you would describe your database schema and table relationships in a simple XML-based format, generate SQL code to populate database schema with tables, generate C++ classes, add application-specific logic to the classes, and use these classes in cooperation with the Session object to query objects from the database, create new or modify/delete existing objects, or link and unlink objects using relations. Simple serialization to XML is supported along with connection pooling.
pg_xnode is an extension (module) which adds several data types to the PostgreSQL database server, allowing it to store XML documents, XML (tree) nodes, and XPath expressions. Unlike the in-core implementation of XML, pg_xnode does not require repeated parsing of XML data, and thus should be more efficient. In addition, the extension has functions to add/remove nodes to/from existing XML documents, and templates to create XML documents from tables.