Projects tagged ‘dba’

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]

Over the years I have crated allow of home grown code, which I now wish to share.

DBPro Bridge is an emerging open source Visual Studio add-in that enables access to the Database Professional project for developers without a DB Professional license. DBPro Bridge facilitates better ... [More] collaboration between a DBA, who is using Team System Edition for DBPro, and developers without a Team System for DBPro license that need to edit and create new files in sync with the DBA. DBPro Bridge enables the developer to create a "mirror" of an existing DB Professional project file and make it available via source control. Visual Studio developer’s project files are kept in sync with the DBA’s version and vice versa, making it a free alternative to Team System Edition for DBPro. [Less]

EnglishThis management tool is designed for the Oracle RDMS. The tool was developed using Borland Delphi 7.0 programming environment which provides fast Access to the Oracle database. The code was ... [More] developed after examining techniques to determine the fastest and the most effective ways of database Access to increase the overall performance of the system. As a consequence of this study, the most effective techniques and SQL statements are determined for better performance and put into action. DBAExplorer allows you to access an Oracle database and perform any administrative task. Here are some of the features of DBAExplorer: Object Browser: you can browse through the database objects like, Schema, Tables, Packages, Sequences, Views, Procedures, DB Links, Synonyms, Functions and advanced objects etc. DBA Utilities: Allows DBAs to perform administrative tasks in a convenient way and most of the time with just clicks. It allows you to create Tablespaces, Rollback Segments, Users and redo log files. DBAConnect also allows you to manipulate all the information regarding an instance, SGA, Block, Free space and to alter wherever it is needed. Developer Utilities: Allows you to perform the developers related actions like creating tables, views, synonyms, DB Links, Procedures, Functions, Packages and Types. It allows you to execute any SQL command through an editor window. Also provides search facility to find any object, dependencies, relationships between tables and privileges. DBA Admin: Instance Monitoring & Space Management: includes active and running jobs, SGA information (Shared pool, Library cache, UGA space used, Data Dictionary, Redo log buffer cache, Database buffer cache), Free space information, Locks, Redo log files, Object and Data files, Rollback segment, Session information, User information, Table Space and Data files. You can change or alter any information by clicking on the active link for example to drop a user or to kill a session or even to change control files. If you have any questions, comments, or suggestions please contact me. alpaslankilickaya@gmail.com Note: You must install Oracle Client (9i - 10g) before trying this program. TürkçeOracle veri tabanı yönetim sistemi için hazırlanmış bir Veri Tabanı Yönetim Aracıdır. Yazılan program, veri tabanına hızlı erişim sağlayan Borland Delphi 7.0 programlama dili ile geliştirilmiştir. Programın hazırlanmasında veri tabanı erişim yöntemleri incelenmiş, en hızlı ve etkin bağlanma şekilleri araştırılmıştır. Yapılan araştırmalar sonucunda en etkin performans yöntemleri ve SQL cümleleri bulunmuş ve hazırlanmıştır. Eğer herhangibir öneri veya sorunuz var ise benle irtibat kurabilirsiniz. alpaslankilickaya@gmail.com [Less]

Report Oracle Database Info

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]

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]