Posts by Jiri Pik

PostSharp and Excel-DNA

Writing readable and concise source code is one of the key objectives of software development as majority of the total costs of ownership of a software solution is usually spent on code maintenance. Aspect Oriented Programming enables, inter alia, to reduce the amount of…

How to use Advanced Installer for an Excel-DNA Project

Excel-DNA is a game-changing solution for development of XLL Excel add-ons in C# without VSTO abstracting away majority of the C++ implementation details. While a simple XLL add-on requires no registration or installation, the more advanced XLL add-ons with rich…

Optimal DB Architecture for Fast Access to Historical FX Data in MySQL

The optimal database architecture depends on the structure of the data, the number of the records to be stored, their intended updates (if any), the typical queries and their frequency, and the database engine itself. Each database engine is optimized…
keyboard_arrow_up