Building A Financial Website – Part 2 (Architectural Design)

It is very essential to have a mental picture of how the application will be structured and how the various components will interact with each other before proceeding to even write a single line of code. This point cannot be overemphasised especially in projects that involve other collaborators or programmers. If you are a lone … Continue reading Building A Financial Website – Part 2 (Architectural Design)

Advertisements

Building A Financial Website – Part 1 (Overview)

For those who live in this space where stock trading, foreign exchange (forex) trading, etc. is their daily bread, trading data/information comes in handy for them, but at the end of the day, developers like us have to build those platforms. The good thing about developers is that we get to work in a space … Continue reading Building A Financial Website – Part 1 (Overview)

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

Dropping All Tables In A MySQL Database Using A Stored Procedure

Using an engine like InnoDB, which enforces referential integrity through the use of foreign keys, poses a little problem when deleting a table whose field(s) act as foreign keys in other table(s). Dropping an entire database may seem like a convenient approach to use, but will not be an option to users who do not … Continue reading Dropping All Tables In A MySQL Database Using A Stored Procedure

How To Solve MySQL Character Sets and Collations Mixing Problems

Character sets and collations enable MySQL to perform comparisons on strings, so if have two or more columns with different character sets and/or collations are used in a way that performs some comparison of some sort on them (either using =, >, <, , a JOIN ON, etc), MySQL will be a little confused and … Continue reading How To Solve MySQL Character Sets and Collations Mixing Problems