Projects

2009

MySQL Maintenance Buddy

MySQL Maintenance Buddy is a ruby command line application for automated MySQL backups, restores and daily maintenance jobs

Features

• create MySQL backups using mysqldump for all or some databases
• restore databases from backups
• optimize database tables using mysqlcheck
• delete old database backups based on retention time
• collect some maintenance stats such as duration of maintenance and number of db’s backed up
• send a maintenance summary by email, log actions to log file

Technologies

• Ruby
• MySQL

http://github.com/niwo/mysqlbuddy

2009

named-admin

Ruby command line application for zone file administration on Bind DNS servers

Features

• zones can be inserted based on customizable zone templates
• find action which accepts wildcards i.e. to find all zones of a certain domain
• zones will be alphabetically sorted within your configuration file after each manipulation
• option to automatically check the zone file syntax after manipulations with named-checkconf
• option to ask for a named service restart after changes on the named configuration

Technologies

• Ruby
• Regular Expressions
• YAML
• optparse

http://github.com/niwo/named-admin

2008

ScriptCommander

Ruby web-application to manage web page revisions and launching common maintenance scripts

Features

• runs subversion info, log and switch commands
• runs maintenance scripts (bash, PHP etc.)
• multi user support and multi project support
• easy extension and configuration over YAML files
• all user interventions are being logged

Technologies

• Ruby CGI
• AJAX (Prototype & Scriptacolous)
• YAML for data and configuration files
• bash

2007-2009

ICCIS

A Ruby on Rails web application for project management and reporting developed during the diploma thesis for PricewaterhouseCoopers

Features

• associate projects, servers, contacts and credentials
• track project states and server updates
• rich, interactive user interface using Prototype/Scriptacolous
• task lists per project/server
• secure encryption of credentials

Technologies

• Ruby
• Ruby on Rails
• MySQL
• AJAX (Prototype & Scriptacalous)

2006

Next.Step

A Ruby on Rails web application for project management and reporting developed during the diploma thesis for PricewaterhouseCoopers

Features

• centralized management of projects, opportunities and clients
• reporting of work efforts per project and per employee
• individual, configurable views of project data
• integrated user guides and help system
• integrated full text search

Technologies

• Ruby on Rails
• AJAX (Prototype & Scriptacalous)
• Oracle 10g

2006

DDI Admin

Web application written in C# using the ASP.NET framework to manage number blocks of big enterprise telephone systems

Features

• assures the proper allocation and reservation of telephone number blocks
• assign numbers or number blocks to companies, emergency numbers, system numbers etc.
• manage company telephone numbers and technical contacts
• search functionality (who is the owner of a given number)

Technologies

• C# and ASP.NET
• SQL Server 2005