NTR Lab
Homepage >> Experience

SQLite

Dating websites Firefox extension

Task:
This tool is intended for a dating agent. It maintains a database of clients and monitors potential matches for each client on various dating websites.

Functionality:

• Maintain client database; activate or deactivate clients;
• Maintain database of to-be-monitored websites;
• Maintain response database: each response has text and color;
• Monitor websites for each client by providing client ID markers on the profile’s web page;
• Track whether a client’s response was answered (status) and remove if necessary;
• Display response (status) on the client’s page;
• Switch quickly between clients.
The tool is a Mozilla FireFox extension that stores all required data in the local SQLite database.

Technologies: Mozilla XUL, JavaScript, SQLite.

 

Everest – cross-platform data processing tool

Initial data:
A desktop XUL tool working with text files: it presented data in the table and performed filtering and searching queries on the data.
The tool consisted of two parts: XUL client and C++ server. XUL part was responsible for GUI and C++ part did data filtering. The client and server communicated with each other using disk files.

Task:
Our task was to increase the speed of data processing, fix application bugs and add multiple data source support: application-specific input and output files and the ability to import and export the files.

Result:
The C++ server was designed and developed from scratch as a command processing service. It communicates with the XUL client using socket, and provides a 70-80% performance increase for data filtering.
The XUL client was modified to support open/save in its own data files format that combines data and filtering criteria for user convenience; export/import to CSV format; data type mapping screen with type correctness checking was added to the application. Some GUI changes were made: modifying menu items, icons, controls, event handlers, etc. Some business logic and GUI problems were detected and fixed.

Technologies: Mozilla XUL, JavaScript, C++, SQLite.
 

Incentivizer™: application for awarding stock options in startups

Client: RampUp Solutions, USA

Description: The program was especially challenging because it combined teaching the user a new philosophy (necessary to its successful use) and a numbers-manipulating methodology. It was accomplished by seamlessly providing explanations in the wizard with live links to Help information that shows simultaneously. Program downloads from corporate site. Status: Beta-testing.

Application for surveying internal staff

Client: Stavka, a consulting company

Description: Survey tool for HR consulting company. It consists of a respondee interface and an admin interface for editing questionnaires and respondees’ answers.

Recipes exchange system and web community for Dannon

Client: Dannon Company, Inc. (US division of Danone)

General contractor: Tribal DDB (USA)

Recipes exchange system and web community for Dannon

Description: Application enables users to exchange recipes. The system includes the corresponding administrative interface.

Microsoft gold certified partner

ISO 9001