Hooking in BASIC+

OI 10 Logo Transparent2

A respected colleague recently asked for ideas on how to audit the OpenInsight Editor++ so he can track when a stored procedure is compiled. We proposed a wrapper around the Editor++ commuter module. While our colleague was familiar with this technique, it occurred to us that some developers might not know how to implement this form of hooking into BASIC+. Software hooking is a well known technique used by developers and tools within various platforms. The concept allows a custom process to intercept function calls in order to monitor the messages being generated or, in some cases, to change the behavior of the function. This article will document how to create a stored procedure wrapper that can be used to hook into both developer stored procedures as well as (most) system stored procedures.

Continue reading

OpenInsight LinearHash Service and High Server Memory Usage

UD 5.0

The rule of thumb when it comes to the Universal Driver’s LinearHash service and server performance is to have enough free physical RAM available on the server to fit all the commonly accessed OpenInsight database files (the LK and OV files managed by the LinearHash service) into memory. This article walks through the problems associated when requests for commonly accessed LinearHash files exceed the amount of available server memory.

Continue reading

SRP Editor 2.8

It’s been a long time coming, but we finally have a new release of the SRP Editor. The highlight of this version is complete control over themes, but there are some other quality of life enhancements as well. This article will give you an overview of the changes.

Continue reading

Revelation Software 2016 Pricing Increase

OI_150x150

In order to prepare our customers ahead of time, we thought it would be helpful to post on our blog site that Revelation Software has recently announced price increases that will become effective October 1, 2016. This increase will apply to most products, but WORKS subscriptions (new sign-ups and renewals) and the Universal Driver Heavy (UDH) will remain the same. The general increase will be 8%, although special “connector” licenses (e.g., SQL-only, MV-only) will increase by 16%.

Continue reading

Comparison with 400 Clients – UD 5.0 Benchmarks – Part 4

UD 5.0

This is a continuation of our series focusing on the performance difference of the Universal Driver 5 and 4.7. In what is likely to be the last article in the series, we resume testing the number of simultaneous clients and the rate in which they are able to read records from the Linear Hash service. Please note, however, that these tests were performed with UD 5.0.0.2. Since then, Revelation Software has released two more patches. The latest patch addresses some rather significant performance issues which were identified in the wild. Given that our tests are synthetic, we do not expect the following results to vary much. Therefore we opted not to retest our results in the latest release. Continue reading

API-Centric Development

API

As a software developer, I have often expressed my indebtedness to those who have gone before me. Some of these were “giants” whose shoulders I have stood upon. Others were selfless “guides” who patiently navigated me around complicated roadblocks. In addition to the technical knowledge I obtained, this has impressed upon me other valuable experiences, two of which stand out more than others. First among these is the joy of paying it forward. Not just giving back, but giving unto those who will come after me. The second of these is the humility of realizing that I am never quite as clever as I might like to think. Whatever technique, skill, or novel solution I might come up with, someone else has already done it…probably years before it ever germinated in my head.

Continue reading