Portfolio: Software Application Projects

Delphi Projects:   PAD database updater     This application was developed for the owner of Softwareseeker.com software catalog. The main purpose of it is to update the information in the website's database using the info which software owners provide. PADUpdater receives this information from PAD files (basically, XML files of some fixed structure). While registration on the Softwareseeker.com website software owners should provide an URL pointing to the PAD file which describes an application. Then, when PADUpdater starts the process of updating the database it selects PAD file URLs from the database, downloads them and presents information in card view mode (see first screenshot). Also it updates rows of main grid changing the color depending on successfully or unsuccessfully the PAD file was downloaded. If the PAD file wasn't downloaded successfully then the application also provides a reason of the error. Then, when PAD files are retrieved the application updates the database using dynamic mapping between PAD file nodes and database fields (mapping dialog is also shown on the first screenshot). Also the application provides a functionality to edit, delete and approve applications and to change the category where the application will be listed. This all functionality is presented on second tab of the application (see second screenshot). Changing categories for the application done in a very interesting manner: using a pop-up menu. This menu is formed dynamically, basing on the information from the database (hierarchical structure), you can see this menu on the second screenshot also. Interesting application features are: Multithreaded PAD files retrieval (number of threads through the Options dialog) XML files parsing Dynamic mapping between PAD file nodes and database fields Dynamic hierarchical categories menu Programming language: Borland Delphi 7, database: MS SQL Server 2000 You can also read the customer feedback for this project.     Screensaver     The app to delivery content from the web-server to the client's computers via internet. The screensaver is packed in an install app. After installation the screensaver acts as a windows screensaver, but regularly connects to the content site and downloads html's. Downloaded htmls are shown by the screensaver itself. Also with the screensaver the install application sets the control app that installs into Autostart folder and while runs minimized to tray. All screensaver are divided by topics. The end-user can select topics he/she is interested and gets dynamic contents within selected areas. The screensaver will download only htmls that are under selected topics. Htmls are created by a designer and uploaded to the content site by the administrator/manager. Language - Borland Delphi 6 (client part) and ColdFusion/MSSQL (content site). You can also read the customer feedback for this project.     Data modeling editor     The standalone application for database modeling using CLX library. This application can be used to design entity relation data models and dimensional models. With this application, you can create and maintain databases on many different target servers. The application uses dbExpress to communicate with databases. The user can draw database diagrams and build databases using these diagrams. The application is very similar to ERWin but has its own features. It supports IDEF1X. Language - Borland Delphi 6/Kylix (CLX library). Platform -Windows/Linux.     Visual Query Builder     Delphi component which gives end-users the ability to create complex queries via intuitive visual interface(like Access SQL builder). Features MS-Access style query building visual interface Run-time multiple database connection manager with built-in storage support Data browser pane integrated with the Connection and other panes View database object information or script in the Data Browser pane Construct joins via simple drag-drop method using the Relations pane Columns toolbar combo-buttons comprising all the SQL functions including data conversion, date, aggregate, rounding, masking and other functions Supports MS-Access, SQL Server Built-in file processing and file storage support for the manipulation of queries Syntax colored SQL editor Integrate with your application by setting a few properties or a few lines of code Edit tables directly via the query result in the Result tab's grid     American Singles, Lavalife     Two projects with approximately the same purpose and functionality. They both are built as a automation of browsing the www.americansingles.com and www.lavalife.com websites. Both applications are built on the same engine. Each application connects to the website, automatically fills login form (using the info from the text file), logins to the site, browses through pages and fills a lot of web forms. Then, it parses resulting HTML and stores some information. Also it grabs some information from popup windows which sometimes appear. This application has an advanced error handling system. Language - Borland Delphi 6. You can also read the customer feedback for this project.     Contact manager     Contacts manager with custom reports, broadcast mailing and other useful features. Borland Delphi 6 with MS SQL Server DB. Features up to 100.000 contacts advanced search remenber search conditions export/import create mail templates bulk mail customizable reports     ElcPart Project     This software was written for a a company, which sells barcodereaders. With this Barcodereaders, they write ASCII-Files to the harddisk of a computer. ElcPart application reads the file and handles articles. Features of the application: Append articles to the stock (both from file and manually) Edit and remove articles Handle articles within different stock places Order articles from different suppliers Make reservations... The application is built as a network system with using Interbase database. Network model required a users management system and this was done. Administrator can manage users, set them privileges for different actions, assign users into groups and applly privileges for groups directly. The program was built with two-languages interface. When the app starts the user can select the language for the interface and then, while using the application he can change this from the menu. Different users of this software can have their own requirements for reports. That's why we made them customizable.     Hispatel project   Yellow Pages directory with phones and addresses of over 13 mln. subscribers contained on a single CD. The data are stored in a special developed format and as a result a quick search for information takes just a few seconds. The key features of the program: search by name, phone number and address; creation of bookmarks and private lists; addition of new subscribers, export of data in txt, asc, dbf formats. Borland Delphi 5, Win32 API     Minor Delphi projects   Small Delphi projects like log parsers, importers and viewers, small VCL components and libraries (Outlook integration library, TIFF editor etc.)        Java Projects:   Loosely Coupled Database     Loosely Coupled Database system is a console application. It has the same purpose as the previous project but with specially requirements and written in pure Java. Thee is a central server with many small satellites that are mobile clients connected by IP. There are tables that need to be synchronized based on a filter. Server has tables (with children) that the clients caches locally. The clients insert values(requests) into the local cache tables. The values must be propagated to the server. The server updates the parent and children with response values. The Client fetches new/updated values of the parent(s) and children for/into a local cache. It is a bi-directional replication. The java agent that makes these functions is a jar archive. The agent is a console app. Language - Java, JDBC.     Replication System   Replication System - replication transactions between Server and Client databases. The system consists of dll(Delphi), that is placed on the client side and the server layer written in JSP. The client makes replication requests through the dll. The dll connects to the server part and updates server and local databases. Using admin console (JSP) the administrator can set up the server database, replication parameters, security parameters (users and groups), errors handling parameters. Language - JSP, Delphi.        C++ Projects:   Z39.50 Gateway   Z39.50 Gateway is a console application. The collectionConnection server allows the user to search some bibliographic information. But, unfortunately, its communication protocol isn't compatible with a standard Z39.50 protocol. The communication layer interrupts a query, sent by Z39.50 client, and converts it into a collectionConnection query(according to the protocol Bib-1). Then, if a results of this query are valid, communication layer sends a results to the Z39.50 client(there are a kind of forms - XML, US-MARC, SUTRS). Language - C++.     FileMaker plugin   FileMaker plugin to verify credit card numbers and provide online payments, work both on Windows and MAC platforms. Language - C++.