Projects tagged ‘dba’ and ‘mysql’

A powerful MySQL client for Win32.

GreenSQL is a database firewall engine used to protect Open Source Databases from SQL injection attacks. It works in proxy mode. Application logics is based on evaluating of SQL commands using risk ... [More] score factors, as well as blocking of administrative commands. [Less]

Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and ... [More] MySQL) and can be extended to include specialized support for other databases. The project started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of SQuirreL SQL. [Less]

Open Source Framework for PHP5, find simplicity, multiple-choices and fast development cycle. * Framework Component-based * Small Footprint * Pluggable system * for PHP 5.2.3+ ... [More] * Fast and easy to install and use. * Multiple OO Models: o internal (tdbo) o doctrine | propel * Multiple Templating and View System: o HTML::Template o Zope-Tal o PHP Embeded o Savant o CREOLE Wiki Syntax parser o SVG output o DocBook? output o RSS and Atom ready * Multiple Controllers: o Cli (Console) Controllers o SOA-WOA Controllers (RPC) o REST Controllers o XUL Interfaces o XHTML | HTMl5 [Less]

Usage: partition_balancer [options] -d -r -t Options: -c, --column= The column on which partitioning is based -d, --database= The database to use -h, --help ... [More] Display this message and exit -H, --host= The target MySQL server host -p, --password= The password of the MySQL user -P, --port= The port MySQL is listening on -r, --rows= The target number of rows in each partition -s, --socket= Use the specified mysql unix socket to connect -t, --table= The table name to evaluate -u, --username= The MySQL user used to connect -v, --verbose Increase verbosity level -V, --version Display version information and exit Defaults are: ATTRIBUTE VALUE -------------------------- --------------------- column Current partition key database No default value help FALSE host localhost password No default value port 3306 rows No default value socket No default value table No default value username No default value verbose 0 (out of 2) version FALSE [Less]

This project is now known as OmniSQL and can be found at http://code.google.com/p/omnisql/

omnisql is a command line tool for DBAs needing to issue ad-hoc queries against sharded data. Instead of logging in separately to multiple databases to issue the same query, groups of databases can ... [More] be specified in a configuration file and queries will be automatically issued against all MySQL instances. System RequirementsRequired perl Modules: Pod::Usage Getopt::Long XML::SimpleObject DBI DBD::mysql Term::ReadLine DBIx::MyParsePP LWP::Simple Sample Usage:%> omnisql --help Usage: omnisql [options] group Options: --config= The config file to use --help Display this help and exit. --list-groups List the available groups from the config file. --print-defaults Print the program argument list and exit. --version Output version information and exit. group The group (as defined in the config file) against which to issue the queries defaults are: ATTRIBUTE VALUE -------------------------- ------------------ config /etc/omnisql.cnf help FALSE list-groups FALSE print-defaults FALSE version FALSE Package ContentsREADME: Instructions for installation and usage RELEASE_HISTORY: Change log for all current & past versions omnisql.cnf.example: Sample configuration file omnisql: The executable perl script Change Log v0.0.7 (Current Version)0.0.7 - 28 October 2008 - Fixed Bug #3: Script failure when only one group is defined - Fixed Bug #4: Too Slow (now it forks) - Fixed Bug #5: Host-Specific parameters don't work - INCOMPATIBLE CHANGE: Changed format of config file - INCOMPATIBLE CHANGE: Use XML::SimpleObject instead of XML::Simple - Added group summary (Issue #6) 0.0.6 - 13 August 2008 - Fixed Bug #1: Multiple databases on the same host - Fixed Bug #2: Multiple queries from STDIN - Changed XML format of omnisql.cnf - Added a README to show how to install and use 0.0.5 - 30 July 2008 - Added the --list-groups command-line option - Updated Documentation - Added a version check on startup - Changed the project name to OmniSQL - Added support for piping commands through STDIN 0.0.4 - 18 June 2008 - BUGFIXES: #3 & #4 - Essentially improper error handling 0.0.3 - 15 June 2008 * Migration from SQL::Parser to DBIx::MyParsePP 0.0.2 - 02 May 2008 * Uses Term::ReadLine to enable a .omnimysql_history file * Fixed issue #1, a hard coded database name in the connection string * Added the --print-defaults command line option * Added the --version command line option * Can now use SSL to connect to MySQL 0.0.1 - 29 March 2008 * Initial ReleaseProject RoadmapCustom prefixes for group result-set handling (SUM, COUNT, etc...) Contact/FeedbackFeel free to email me rlowe@pablowe.net with bug reports or feature requests. Other Projectsmysqldoc - http://code.google.com/p/mysqldoc mymemcalc - http://code.google.com/p/mymemcalc [Less]

Create 10 000 sql insert queries in minutes for any table. Posibilities Export\import project Fild values generator All you need to do is configure your fields and how they will be filled ... [More] , and then pres Generate SQL. Do not forget to export project for future use. [Less]

COMING SOON.... AnyDBA will be a library of SQL scripts for Oracle & MySQL DBAs. AnyDBA will provide easy database monitoring and troubleshooting scripts which can manage many databases from ... [More] one place. The scripts are developed in pure SQL using SQL*Plus / mysql command line tools. [Less]

This has been moved to: http://kontrollsoft.com/software-kontrollbase