websqlclient (WSQLC or wiskl) is a lightweight HTTP server which allows an end user to access JDBC data sources via automatically-generated data entry screens. It is designed to be used with standard Web browsers and wireless tablet PCs, and is highly configurable. It can connect to any JDBC data source. Its main purpose is to provide rapid data-model-driven development. The websqlclient data entry forms are generated by querying the database system table information, but can be configured manually. websqlclient includes a database-agnostic data loading utility (SQLLoader), a data unloading tool (SQLExport), and SQL scripting capabilities.
Large Database Backup is a class to back up large MySQL databases into multiple files. It can list the tables of a given MySQL database, and generate SQL statements to create and insert records with the current values of the table rows, as if it were creating a new database. The class stores the generated SQL statements in files. A full backup process can be split into multiple iterations so as to not exceed the PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.
Change Web Site Mode is a PHP class that can be used to switch the access to sites between test and production versions. Each Web site must have a copy of all files in the production server and in a test server. This class allows the user to switch between the two copies of the site without having to change the URL. It provides a GUI interface for switching between the test mode and production site. The test version may be run in the local machine or in another machine.
Site Checker can be used to find broken links in Web pages. First, it retrieves the list of all pages of the Web site, either static pages or dynamic pages generated from data stored in a database. Then it checks the links in each of the pages to verify if they are on the list. Links to external sites can also be verified by performing HTTP requests to the remote Web servers to check whether the pages still exist.
Id3 Tag Correction and Downloading is a PHP class that can be used to correct tags of MP3 tags of music with records stored in a MySQL database. It scans a MySQL database table with information about music albums to see which albums do not yet have the associated ID3 tags. The class accesses the Web services APIs of sites like audioscrobbler.com, last.fm, lyricwiki.org, and lyricsfly.com to correct the pending music tags and get other details about the stored music.
Usenet Downloader can be used to retrieve newsgroup articles from NNTP servers. There is a generic NNTP class that can retrieve listings of groups, listing of group articles, and the article headers and bodies. There are other classes that can retrieve listing of groups from several different sites and insert the listings into a MySQL database table. Other classes can retrieve groups stored in the database and retrieve articles of those groups from the NNTP servers.
Loomes' Nested Set is a class that can be used to manage a tree of information stored in a database. It can perform several types of operations to manipulate a hierarchy of nodes that are stored in a database as table records. Currently, it can insert a root node, insert a node that is child of a given parent, delete a branch of nodes under a given node, delete a single node, rename a node, move nodes, check whether the root node exists, and retrieve the whole tree of nodes.