graphic design l logo design l web design l development l SEO
PostgreSQL DB Replication
Reliable data replication between PostgreSQL two databases. DB triggers and background processes were written in Perl.
The application runs on a Centos 5.1 server. In normal LAN conditions (100 MB, not congested) data gets replicated in 0.2 sec
(roughly 24 records/sec). This application is required for a high-availabilily, dual-redundant server setup.
Reliable data replication between PostgreSQL two databases. DB triggers and background processes were written in Perl.
The application runs on a Centos 5.1 server. In normal LAN conditions (100 MB, not congested) data gets replicated in 0.2 sec
(roughly 24 records/sec). This application is required for a high-availabilily, dual-redundant server setup.
Web Report Builder for PostgreSQL
Report Builder is a web tool designed to create simple, single-table reports from PostgreSQL databases.
Its main features are:
- Can be accessed from any computer connected to the LAN.
- Provides simplified query building. No SQL knowledge is required.
- Is server-based for efficient network bandwidth utilization
- Columns can be hidden or reordered as required.
- Easy to use Date and Time picker.
- User-friendly comparison operators.
- Auto-refresh function.
Report Builder is a web tool designed to create simple, single-table reports from PostgreSQL databases.
Its main features are:
- Can be accessed from any computer connected to the LAN.
- Provides simplified query building. No SQL knowledge is required.
- Is server-based for efficient network bandwidth utilization
- Columns can be hidden or reordered as required.
- Easy to use Date and Time picker.
- User-friendly comparison operators.
- Auto-refresh function.
Perl applications for data processing
Various background services running on the server to apply the bussiness rules on the company data.
Database records go through extensive transformations, translations, filtering and reduction to obtain the desired result.
The services were written in Perl 5.10, are running mostly on Linux (Centos) servers and process data on
PostgreSQL and MySQL servers (local and remote).
Various background services running on the server to apply the bussiness rules on the company data.
Database records go through extensive transformations, translations, filtering and reduction to obtain the desired result.
The services were written in Perl 5.10, are running mostly on Linux (Centos) servers and process data on
PostgreSQL and MySQL servers (local and remote).
Data migration
Various data migration applications for importing data from different formats (Paradox, XLS, CSV, Access, MySQL, MS SQL)
and schemas to a vendor speciffic data server (MS SQL) and schema. Applications were written in Delphi 7 for
Windows XP and Windows Server 2002 for Audeosoft GmbH.
Most of the company's new clients wanted to preseve and import all their existing records into the new application.
Various data migration applications for importing data from different formats (Paradox, XLS, CSV, Access, MySQL, MS SQL)
and schemas to a vendor speciffic data server (MS SQL) and schema. Applications were written in Delphi 7 for
Windows XP and Windows Server 2002 for Audeosoft GmbH.
Most of the company's new clients wanted to preseve and import all their existing records into the new application.
Webcrawler for Windows
Webcrawler application for searching the web for CV and resumes.
It uses a customizable list of search engines to search for certain key-words.
All the retrieved results are analyzed with very complex regular expressions for clasifying the content as CV.
Webcrawler application for searching the web for CV and resumes.
It uses a customizable list of search engines to search for certain key-words.
All the retrieved results are analyzed with very complex regular expressions for clasifying the content as CV.
