© 2006-2024 Radicore Software Ltd
Latest news
RADICORE v2.27.0 released14 October 2023
RADICORE v2.26.0 released04 April 2023
RADICORE v2.25.0 released04 February 2023
Knowledge Base
Evolution of the RADICORE framework01 June 2022
How Radicore prevents SQL Injection attacks17 July 2021
How Radicore prevents CSRF attacks08 October 2017
Articles
Support for PHP4 dropped, support for PHP7 started01 October 2016
Why you should build your web application back-to-front06 January 2013
What is the 3-Tier Architecture?14 October 2012
Other Stuff
I fail to GRASP these principles27 March 2024
Namespaces are for numpties27 March 2024
Inheritance is NOT evil17 March 2024
Archive for Databaseswithout synopsis
Database Design - are you Novice, Ninja or Nincompoop?
When you design your database for your PHP application are you aware that some of your design decisions can have a detrimental effect when it comes to writing the code to access that database? I have been designing databases, and building the applications which use them, for several decades, and I have learned over the years that there are some design decisions which help the developer while others do nothing more than hinder. This article lists 18 of these “hindrancesâ€.
Published: 23 September 2012
Creating an SQL Server driver for RADICORE
This article shows how a database driver for the SQL Server database was developed for the RADICORE framework.
Published: 01 January 2011
Creating an Oracle driver for RADICORE
This article shows how a database driver for the Oracle database was developed for the RADICORE framework.
Published: 15 January 2007
Creating a PostgreSQL driver for RADICORE
This article shows how a database driver for the PostgreSQL database was developed for the RADICORE framework.
Published: 10 September 2005
The Relational Data Model, Normalisation and effective Database Design
This discusses the workings of a relational databases, about keys, relationships, joins and dependencies. It explains what normalisation is and how to do it, as when denormalisation is OK. It explains what an Entity-Relationship Diagram (ERD) is, and gives a few personal guidelines.
Published: 30 September 2004
Technical Keys - Their Uses and Abuses
There are two ways of using technical keys - intelligently and indiscriminately. The indiscriminate use of technical keys shows a distinct lack of intelligence.
Published: 01 January 2004