how to get your data onto a web page...
Having a database available is one thing, getting data in and out of it is another.
To get data from a database incorporated into web pages you have use a "scripting language". The most commonly used systems are PHP (Personal Home Page), ASP (Active Server Pages), Perl and ColdFusion.
We have considerable experience of using ASP, ColdFusion and PHP for database data retrieval, manipulation and insertion.
|
there is no scope for complacency
While we don't want to frighten you we would be doing you a disservice if we did not point out that web based databases are often the target for malicious attacks.
People will not only try to put stuff in that you do not wish them to, but they will also try and delete information - or even the whole table from the system. It can be done if precautions are not taken.
We have considerable experience in ensuring that the data you have provided stays on the site, and in the example of intereactive sites where data can be added - only that data you approve of gets added.
|
|
planning for efficiency...
Databases can be a substantial server resource that need managing effectively to ensure that the performance of the server does not suffer.
Through out the development, design and roll out stages we consider many aspects of the web-database interaction, including:
- "normalised" database structures for effective storage and speed
- manage database connections to ensure these are used effectively
- ergonomic query designs to optimise data retrieval speeds
- smart use of error trapping to ensure pointless database queries are not conducted, such as those crafted by "inquisitive" users "playing" with systems
|
