Database Programming

A MySQL database will always form a suitable backend for any application, and the Perl programmer will find that this can be achieved very easily.

Jul 19, 2009 - Mark Alexander Bain

Business rules are incredibly important to every organisation. They can be made application independent by placing them in a MySQL database.

Jul 10, 2009 - Mark Alexander Bain

When looking an OpenOffice.org database there is no way of adding user accounts. Not directly, anyway. The secret is to use a little bit of SQL.

Jun 23, 2009 - Mark Alexander Bain

With the release of OpenOffice.org 3.1 the programmer can do something important. They can add a macro to a database and they can run it automatically.

Jun 19, 2009 - Mark Alexander Bain

Release 3.1 of OpenOffice.org gives programmers a new facility - the ability to save macros as part of a database file.

Jun 19, 2009 - Mark Alexander Bain

It is important to keep the contents of a database up to date. It's fortunate, therefore, that C# and the MySQL .NET connector make that an easy task.

May 30, 2009 - Mark Alexander Bain

As well as viewing data in a MySQL database, a C# programmer can add information by using the SQL insert statement and the MySQL .NET connector

May 27, 2009 - Mark Alexander Bain

PowerShell is Microsoft's .NET scripting language. If the programmer combines this with the MySQL .NET connector then they can build a very powerful database application

May 15, 2009 - Mark Alexander Bain

SQL queries can extract data from single or multiple tables. How that data is extracts greatly affects what the programmer can obtains - and it all comes down to the join

Jan 9, 2009 - Mark Alexander Bain

VBScript (the scripting language for Visual Basic) can make the processing of records and fields in a recordset very easy for the database programmer.

Jan 7, 2009 - Mark Alexander Bain

A programmer does not actually have to open a Microsoft Access database in order to create or modify a stored query - that can be done by using VBScript

Jan 3, 2009 - Mark Alexander Bain

The contents of a database (such as Microsoft Access) can be examined and modified by using VBScript and the insert, update, delete and select statements.

Dec 31, 2008 - Mark Alexander Bain

Microsoft Access is a very powerful database - so powerful that that a VBScript programmer doesn't even need to install it in order to use it.

Dec 30, 2008 - Mark Alexander Bain

There is no need for a database designer to manually create a Microsoft Access database - they can automate the process using VBScript.

Dec 23, 2008 - Mark Alexander Bain

MySQL stored procedures and triggers are a powerful tool in the hands of a database developer. This articles looks at how to use them to automate tasks on a database.

Sep 30, 2008 - Mark Alexander Bain

Oracle, unlike MySQL, has stored procedures and functions available for the database developer, giving Oracle a major advantage. That's all changed with MySQL 5.

Aug 29, 2008 - Mark Alexander Bain