Pyrseas provides a framework and utilities to upgrade and maintain a relational database. It currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification. It also aims to develop data administration tools to supplement an agile database development process.
Relational Ètudes (re, for short) is an implementation of the relational model. Written in PHP, re can be considered a PHP Framework. Specifically, re tries to implement the ideas presented in the book "Databases, Types, and the Relational Model" (The Third Manifesto). As such, re is based on a rigorous scientific theory, and thus has wider applicability. For instance, from a Model-View-Controller (MVC) approach in software development, re can be considered as the "Model" component. It is even possible to implement your own MVC-type framework using re as its main foundation. re has a consistent and intuitive application programming interface (API). Relational operators are supported, thus, data/set manipulation is simplified. Applications using re will be easy to maintain and extend. Distributed data can be easily used. Business rules are cleanly implemented. It should be very easy to integrate re in your projects, since it is designed to be framework agnostic.
Watch My Network is a script that detects network devices connected to your network, and saves details of these devices to a MySQL database. You can access this data with a Web browser. This user interface has tabs like "Browsing History", "New Device Control", "IP - MAC Changing", "Vlan Search", and "Operating Systems Search in My Network". This program can be run repeatedly via crontab.
The Logfile Navigator, lnav for short, is a curses-based tool for viewing and analyzing log files. The value added by lnav over text viewers or editors is that it takes advantage of any semantic information that can be gleaned from the log file, such as timestamps and log levels. Using this extra semantic information, lnav can do things like interleaving messages from different files, generate histograms of messages over time, and provide hotkeys for navigating through the file. These features are meant to allow the user to quickly and efficiently focus on problems.
Extended MySQLi implements a MySQL database access wrapper using the MySQLi extension. It is based on the Reduced MySQLi class originally written by Mertol Kasanan. This version can account the memory usage and log the executed queries in the current page. It can also cache the query results in an XML file.
TIPP is an IP planning application for network departments of organizations with medium- to large-sized networks. While providing all the necessary functions for keeping track of your IP and network allocations, it combines simplicity of design and use with a clean and thoroughly modern look and feel.
sqlamp is an implementation of Materialized Path, an efficient algorithm for working with hierarchical data structures. sqlamp uses (and depends on) SQLAlchemy. Materialized Path is a way to store (and fetch) trees in a relational databases. It is the compromise between Nested Sets and Adjacency Relations in respect to simplicity and efficiency.