pgDynamicPartitions is a script that allows you to maintain a rolling window of daily table partitions under PostgreSQL. When called daily via cron, it will create x empty partitions into the future and keep only n partitions from the past 30 days, for example, and drop any that are older. It can be used with multiple tables, and each can be treated differently by calling it with different parameters via cron.
ERDesignerNG is a Java-based entity relationship design and database modeling tool. It has a powerful WYSIWYG interface for physical database design, supports 2D and 3D database modeling, browsing, and design, handles tables, relations, indexes, and comments, supports a central repository for all models (Model Repository), supports subject areas, supports domains, supports MySQL, Oracle, Microsoft SQLServer, PostgreSQL, and H2, creates the SQL DDL statements for schema creation, has an integrated schema version control system, can generate schema migration scripts for every change, stores the database definition as XML files for further processing, can export the database schema as GIF, BMP, JPEG, or SVG files, has an integrated reverse engineering module for existing schemas, has a build in schema compare feature, can generate schema documentation as PDF, HTML, RTF, and other formats, and supports schema conversion between different dialects.
MySQLi Query is a class that executes queries from parameter lists using MySQLi. It extends the MySQLi class with functions that can compose and execute SELECT, INSERT, UPDATE, DELETE, REPLACE, and HANDLER queries with parameter values that define tables, fields, field values, conditions, etc. The class destructor function disconnects from the MySQL server.
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.
Autoplot is an interactive browser for data on the Web. Give Autoplot a URL or a local file name and it creates a sensible plot of the data. Autoplot allows you to interactively browse data stored in ASCII, .cdf, netcdf, and many other formats. Autoplot was developed under the NASA Virtual Observatories for Heliophysics program in a collaborative effort among several institutions.