Valentina is cross-platform SQL and non-SQL columnar database that allows development of client-server [Web] solutions and applications with an embedded local database using the same sources. Valentina DB provides an Object-Relational model, but you can also mix Relational and Extended Navigational. It introduces a revolutionary model abstraction "Link" that greatly simplifies db schema, and therefore simplifies SQL queries. It supports disk and in-memory databases, and field types including Bit, BLOB, Pictures, and Enum. It provides advanced features such as triggers, views, stored procedures, regular expressions, XML, full-text search, and calculated fields. It exists as Valentina Server, Valentina Studio, and a set of Valentina ADKs for all major programming languages.
OpenEMR is a medical practice management, electronic medical records, prescription writing, and medical billing application. It is a replacement for medical applications such as Medical Manager, Health Pro, and Misys. It features support for EDI billing to clearing houses such as MedAvant and ZirMED using ANSI X12. Major features include electronic billing (includes Medicare), document management, integrated practice management, e-prescribing, prescriptions by printed script, fax, or email, insurance tracking, multilanguage support, easy customization, easy Windows installation, integration with an external general accounting program (SQL-Ledger), and a built-in scheduler. It is multi-facility capable, voice recognition ready (on Windows), and Web based (secure access with SSL certificates).
URL Router is a PHP class that can match URLs with routes for controllers and actions. It takes the definition of one or more routes with string expressions that define patterns to match given URLs. It supports a special route pattern syntax that allows defining how to extract the name of the controller and action from the URL. The class returns an array with the details of the matched route.
Reportico is a PHP reporting tool. It can create a report from a single SQL command and then build a whole suite of reports with criteria entry, graphs, groups, drill-downs, and expression handling. You can perform data transformation with your own custom PHP code. It can produce output in HTML, PDF, CSV, XML, and JSON.
Web Note Pad is a Web-based notepad script. It features a two paned interface that allows you to manage your documents, create new files, search text content, or select a file to load into the editor. Previous versions of documents are kept, and 30 days of history can be examined using the "Older" or "Newer" navigation buttons on the toolbar.
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.
Link Searcher is a PHP class that can be used to crawl Web pages to search for given text. It retrieves a given Web page and searches for links contained in it. The new links that are found are added to a queue to be crawled later and so implement recursive searching up to a given depth limit. The class looks for pages with text that match a given regular expression.
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.
Site Tools provides several classes for performing several types of operations to search, list, and view files from a directory. It can search for a string within all files in the given directory and sub-directories, list all files in the given directory and its sub-directories, or view all files that are listed in a CSV file on the server. The list of files appears in a form select input. Each file can be viewed in a frame below. The pages in the list can be displayed automatically as in a slide show. The user can browse the files forwards or backwards. Each file can be marked. The name of the marked files is saved in a CSV file.