27 November 2006

Replacement for sqlplus. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
PySQL 0.2 aim to be a full replacement for sqlplus (and much more). It has features such as history, completion, and line editing. It has high level functions (searching for tables, indexes, count, explain plan, list of sessions, etc.), proper output for screen and files (CSV ready for inclusion in spreadsheets), and user-defined SQL."

25 November 2006

Backups of a MySQL server's data files. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
mylvmbackup 0.3 (Default branch)
mylvmbackup is a Perl script for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds."

22 November 2006

PHP report generator. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
phpreports 0.4.9 is a PHP report generator that uses XML report layout files to generate PHP code and create reports in output formats like HTML and TXT."

Backup and recovery solution for MySQL. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Zmanda Recovery Manager for MySQL 1.1.2 for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL, you can schedule full and incremental logical or raw backups of your local or remote MySQL database, perform a backup that is the best match for your storage engine and your MySQL configuration, get encrypted and compressed backups, get email notification about the status of your backups (including RSS feeds), monitor and get backup reports, and recover a database easily to any point in time or to any particular transaction."

21 November 2006

Database normalization tips

Get practical database normalization tips
Normalization is a series of steps to guide you through analyzing and designing relations in your database schema. Tim Chapman explains why he thinks a database in the third normal form is sometimes not very practical and why he prefers a hybrid approach to table normalization.

16 November 2006

Perl script for quickly creating backups of a MySQL server's data files. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
mylvmbackup 0.2 (Default branch)
mylvmbackup is a Perl script for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds."

08 November 2006

Run and edit complex reports from any SQL relational database. Freeware

Search for: free programs, free software, freeware, programs gratis.: "
Ariacom Business Reports v4.2a is a database reporting and analysis tool with dynamic SQL generation, that enables non-technical users to run and edit complex reports from any SQL relational database."

07 November 2006

02 November 2006

GTK+ 2 interface to Oracle that aids in Oracle application development. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "GTKO 1.72 (Default branch) is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports."