| 1 |
Local EmployeeDB Example |
| 2 |
======================== |
| 3 |
|
| 4 |
The purpose of this example is to demonstrate the use of the TIBLocalDB support component. |
| 5 |
This component is used with a TIBDatabase when the database is accessed using the Firebird |
| 6 |
Embedded Server. TIBLocalDB takes care of checking the environment and setting up FIREBIRD |
| 7 |
environment variables and DB parameters. It also supports initialisation of the local |
| 8 |
database from an archive in gbak format, plus save and restore of the local database. |
| 9 |
It can also run SQL scripts to upgrade the database schema when a new software version |
| 10 |
is released. |
| 11 |
|
| 12 |
Both GUI and Console Examples are provided. |
| 13 |
|
| 14 |
Before compiling and running the example, the Firebird embedded server must be installed: |
| 15 |
|
| 16 |
Under Linux: |
| 17 |
------------ |
| 18 |
|
| 19 |
Debian/Ubuntu/Mint: run "sudo apt-get install libfbembed2.5" to install the server |
| 20 |
|
| 21 |
Fedora/Red hat/Centos: su -c "yum install firebird-libfbembed" |
| 22 |
|
| 23 |
Under Windows: |
| 24 |
-------------- |
| 25 |
|
| 26 |
Download the Firebird Embedded Server from http://www.firebirdsql.org/en/firebird-2-5-5/ and |
| 27 |
extract the contents of the archive into the example directory i.e. ibx\examples\local-employeedb. |
| 28 |
You may replace the firebird.conf and firebird.msg files with those in the archive, |
| 29 |
while not replacing or renaming the readme.txt that comes with the archive. |
| 30 |
|
| 31 |
Running the application |
| 32 |
----------------------- |
| 33 |
|
| 34 |
The example should just compile and run. An archive of the Firebird example employee |
| 35 |
database is provided with the example. This will be used to create the initial database. |
| 36 |
It should then be automatically upgraded to "version 2" using the sql scripts provided in the |
| 37 |
"patches" directory. (see also the file upgrade.conf). Note that the upgrade adds |
| 38 |
a "photo" to employee number 2. |
| 39 |
|
| 40 |
Note that you will not be prompted for a username/password. The embedded server |
| 41 |
uses normal file permissions to control access. Otherwise you can edit the employee |
| 42 |
database as in the client/server version. |
| 43 |
|
| 44 |
The local database will be created in: |
| 45 |
|
| 46 |
Linux: $HOME/.MWA Software/employee.fdb |
| 47 |
Windows: <User Local Application Data Folder>\MWA Software\employee.fdb |
| 48 |
|
| 49 |
The File menu provides actions to save the current database to a gbak format archive, |
| 50 |
restore it again (replacing the current database) or to restore the database to its initial state. |
| 51 |
|
| 52 |
|
| 53 |
|
| 54 |
|
