Everybody who wants to install a web server database but does not know which software is necessary and how it is installed should benefit from reading this text. This text provides all information necessary to get a SQL database for a web server going; it does not go into any detail of CGI programming, nor does it explain the SQL database language. Excellent books are available on both topics, and it is the intention of this text to provide a working platform based on which a user can then study CGI programming and SQL. For getting a small scale SQL system running (not the notorious example of a major airline booking system, or space mission management database) it will be sufficient to have the software described in this text and the documentation accompanying it. The user manual of msql (a database introduced in this text) provides sufficient information on SQL for building your own database.
Read the rest of this entry »

• 0 Comments

A database manager is a computer program for storing information in an easily retrievable form. It is used mainly to store text and numbers (for example, the Library catalogue, which includes the author, title, class number and accession number for each book). Most modern database managers also allow the storage of other types of information such as dates, hyperlinks, pictures and sounds. As well as being able to store data, a database allows you to select information quickly and easily (for example, a list of the books written by a particular author or those on a certain subject). Finally, it may allow you to produce printed summaries (reports) of the information selected.
Read the rest of this entry »

• 0 Comments

This tutorial shows a simple example using Hibernate. We will create a simple Java application, showing how Hibernate works. Hibernate is a solution for object relational mapping and a persistence management solution or persistent layer. This is probably not understandable for anybody learning Hibernate.
Read the rest of this entry »

• 0 Comments

SQL - Structured Query Language
Structured Query Language, is a computer language designed for retrieval and management of data in relational database management systems database schema creation and modification database object access control management.
History:
The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. Standardized in 1986 by ANSI. Subsequent versions of the SQL standard have been released as ISO standards
Read the rest of this entry »

• 0 Comments

MySQL and Perl have been around for quite a while. They are still widely used even if the “fashion” is changing. This article talks about these two products working together as a whole, either on the Internet or on your local network. The provided example is written for Unix systems, free or not, even if it can be adapted to other widespread “systems”.
Read the rest of this entry »

• 0 Comments

In the early days of the World Wide Web, information was stored in simple files with only HTML markup. Today, the web server often processes scripts within web files that e.g. call other files, stylesheets, etc. Furthermore, the scripts may also acquire information from a relational database management system. Such a modern system gets data from database tables and includes them in the web page that is delivered to the user.
Read the rest of this entry »

• 0 Comments

MySQL is an open source relational database management system which is quite popular for light-weight web applications. Over the last few years, the product has also added some features which allow it to be used for larger business tools. This paper will provide an overview of this software on Windows. MySQL does not have as many features as PostgreSQL, and while many of the more advanced features are not as mature. However one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL uses a process-based architecture instead).
Read the rest of this entry »

• 0 Comments

Over the course of this book, it will be my job to guide you as you take your first steps beyond the HTML world of client-side site design. Together, we’ll explore what it takes to develop the kind of large, content-driven sites that are so successful today, but which can be a real headache to maintain if they aren’t built right. Before we get started, you need to gather together the tools you’ll need for the job. In this first chapter, I’ll guide you as you download and set up the two software packages you’ll need: PHP and MySQL.
Read the rest of this entry »

• 0 Comments