42 projects tagged "Database"
CDDBD.sh is a shellscript speaking the CDDB Protocol version 1 without enhancements and read only. CDDBD.sh allows to query a local database on a filesystem that was filled with entries using such programs like xmcd or kscd. CDDBD.sh was developed to be used in a local or home network and not to serve a WAN.
xdata implements an interface to arbitrary key-value pairs which are accessible to simple shell and Perl programs. Applications for this include to-do lists, contact databases, browser bookmarks, and anything else which requires small pieces of data to be referenced by keys. xdata stores timestamps for the data it manages, and comes with a program to synchronise databases among cooperating hosts. This allows you to propagate information among hosts in a transparent fashion (creations, updates, and deletes are correctly handled). xdata consists of a set of shell-level utilities and a Perl module.
kshSQL is a conversion of shql into Korn shell. It runs 30%-40% faster than shql. Like its Bourne shell counterpart, kshSQL is a database management system with an "Ingres"-like interface. It reads SQL commands interactively and executes those commands by creating and manipulating Unix files.
Lease Parser saves lease states from an ISC DHCP server in a MySQL database, making it possible to tell which MAC address owned an IP at a particular time. If you need to track down a DHCP user for any reason, such as an abuse complaint for actions weeks beforehand, you can simply search the database via the Web form for the IP during the time in question. Then, search on the MAC address you obtained to see if the system is still on the network and what it's current IP is.
Raven is a scripting language featuring whitespace indentation for defining code blocks a la Python, postfix notation and a data stack a la Forth; int, string, list, hash, and object data types a la Perl and PHP, regular expression support, MySQL connectivity, and variable scope a la Javascript. Development is fast and fun, code is succinct and easy to read, and the runtime is snappy.
Oracle online (hot) backup script is a multi-platform, storage independent, safe, and flexible online physical backup script for Oracle databases (of any version). It features database checks before backup; dynamic backup of instance datafiles, archives, and configuration files; extensive error detection over all steps involved in the process; a clean and easy-to-read log with timestamps for each step; detailed error messages for troubleshooting; and more.
OraRep is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.
MP3DB2 is a collection of bash scripts for keeping track of large MP3 collections. It will retrieve song information from the filenames and ID3 tags of a directory or CD of MP3s and store them in a local database. It then allows you to search any of the fields, generate a master listing of all your complete albums, see the size of your entire collection, and more.
ALTSE is an alternative search engine technology. It can index up to a couple million Web pages. Altse does not aim to replace existing search engine technologies such as Google, Yahoo, and so on. Instead, it aims to provide an affordable alternative to index Web pages for small size businesses and organizations.
RefDB is a reference database and bibliography tool for SGML, XML, and LaTeX documents. Command-line tools allow interactive or scriptable access to the data which are stored in a SQL database. RefDB can also be accessed through a Web interface, a SRU interface, or via editor extensions (Emacs/vim). Libraries for Perl and PHP are available for programmers. RefDB provides sophisticated character encoding handling, using Unicode by default.