This article describes a process that programmers call "creating a database." Let us explain that it is quite tedious. It is better, of course, for people who do not have free time, not to go to these "jungle". It is much easier to entrust this lesson to a professional. It’s good that today the Internet is full of similar announcements. For example, there is a network of freelance exchanges or a similar specialist, you can easily find articles on any exchange. To do this, you need to apply for the creation of such a program as a regular article, describing the necessary task.
What is database creation? There are two
types of databases: desktop and client-server. To create desktop
databases, you need a program like Access. You can easily find it in any office suite. Access is now being released by Infra-Office, Microsoft and many other office suite creators. As for the client-server model, a simple model can be implemented using the Delphi “training” program. Serious databases today are written in Oracle and Visual Fox Pro. These software platforms are equipped with graphical tools for creating processed queries to databases of 500,000 and 1,000,000 or tens of millions of lines.
Consider the most promising programming platform of past years, Delphi 6.0. We make a reservation right away that creating a database in Delphi is not just receiving * .db or * bdb files, but installing it on a personal computer, setting up and automating it. So, in Delphi 6.0, database files are created in a routine located on the main menu of the development environment, Date Base Desktop 6.0.
Here you will find all the necessary tools for creating database files, assigning its type and pre-filling. Note that you will only be able to create and operate those files for which a driver is installed on the platform. For example, to work with the Visual Fox Pro 9.0 type, an external driver must be installed in the operating system.
As for the program’s work with the database created on Delphi 6.0, without its coexistence with the platform itself, this problem is solved by installing and configuring the Data Base Engine 6.0 (BDE) software package.
So, if you firmly decided to work with the Paradox file type, then, having written the program in a specific folder on your hard drive, you need to subsequently register the settings in the Data Base Engine 6.0 package, which include the file paths, their properties and the name of the database. This scheme works when moving the programs you create to another computer.
The Data Base Engine 6.0 package must be installed on the computer where you install the machine code created on Delphi 6.0.
Creating a database on Delphi 6.0 is quite automated. An elementary program for storing data with one database file is obtained by a few keystrokes. The main difficulty here is the implementation of relational database forms. So SDNF 3 can be implemented by setting up two DBGRID tables. And getting various types of reports in QReport is a whole story that I don’t even want to touch on. We will only say that it is better not to throw the code of the created program into the basket, since each user report for people who do not know SQL will have to be re-programmed ...
Access creating a database in an office suite is easy. Having entered the program, you get access to the necessary tools for creating or editing an existing database. Here you do not have to make much effort to create a report or a new project form. Everything is solved almost intuitively. So, to establish a connection between tables, graphical tools are used, which, in almost one touch, can connect the two necessary tables with the desired key.
This article discusses only the creation of a database on training and desktop packages. As for serious programming, without knowledge of the existence of these platforms, you can never solve the problem of operating with large databases.