Finding Duplicate Records In a Database Table

Ideally business rules, that can be re-enforced at the database layer, should be implemented at the database layer to ensure that the integrity of the data can be relied on and does not lead to an unexpected behaviour from the application. Rules such as validation rules, e.g., which fields/columns cannot be null, etc. common sense … Continue reading Finding Duplicate Records In a Database Table

Advertisements

A Seamless “Move” To Transfer Money Between Mobile Wallets In Ghana Is Now Possible

A company that is silently making waves in the mobile financial services sector in Ghana has taken the bold step by coming out with a solution that every mobile money user would be dying to have, i.e. the ability to transfer money between the various mobile money operators (MMO) in the country. What it simply … Continue reading A Seamless “Move” To Transfer Money Between Mobile Wallets In Ghana Is Now Possible

A Regular Expression (RegEx) To Match Integers and Doubles

These regular expressions matches both the positive and negative variations of the data types specified below integers - e.g., 1, 89, 81223, -7, etc. floating point numbers (doubles or floats) - e.g., .0, 59.3, 300.12, -.87   The adopted approach was to avoid nested expressions which is not needed if it is only the number … Continue reading A Regular Expression (RegEx) To Match Integers and Doubles

Forcing Maven To Use The Local .m2 Repository

If each Maven run on a project results in always downloading dependency jars even though they have already been downloaded and stored in your local .m2 repository which is by default located at USER_HOME/.m2 e.g., on my Windows 10 machine, mine is C:\Users\ransk\.m2, then you only have to instruct Maven to operate in an offline mode. … Continue reading Forcing Maven To Use The Local .m2 Repository

Import An Oracle Dump File

These are the steps I normally follow when restoring Oracle dump files for the purposes of my work. I prefer to logically keep the restored entities logically and physically separate through the use of tablespace and associated datafile(s) respectively. Create and assign the user to the earlier defined tablespace. If I want the created user … Continue reading Import An Oracle Dump File

Creating Dynamic Log Files In Zend Framework (ZF)

The motivation for wanting to do something like this could be any of the following: You want to have separate logs depending on the context (i.e. application, testing, development, etc) in which the application is being run and you do not want to inherit a context and override some values in another context in the … Continue reading Creating Dynamic Log Files In Zend Framework (ZF)