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.
Microweber is a drag-and-drop Web content management system that makes it possible to create Web sites without any programming. You can edit text directly on the site and see the results in real-time rather than having to constantly reload the page. You can also reorder site elements and extend them using custom modules such as galleries and contact forms. Every aspect of your page’s elements can be changed, including their skin.
deltasql is a tool to synchronize databases with source code, which helps to keep database evolution under control. While developing mid-sized or big applications, developers make changes to the data model that go along with changes to the source code. From time to time, branches of source code are done to stabilize the code that will go to production. A sort of data model branch is also needed. deltasql provides a simple way to collect all scripts that change the data model and means to handle data model branches. The deltasql server runs on Apache and is backed by MySQL.
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.
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.
MP3 Management can be used to build a catalog of MP3 files in a MySQL database. It can traverse a given directory to find MP3 files. For each MP3 file that is found, it extracts its ID3 tags, including album art, and adds an entry in a MySQL database. The class also extracts 20 second clips of each MP3 file and stores them in a subdirectory named clips. The duration of the clips is configurable. The class is intended to be used with the Id3 Tag Correction and Downloading script, which corrects id3 tags and downloads lyrics, artist biographies, and other information using Web services and other Web sites.
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.
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.