TurboDB Engine Documentation
Database Files
Previous  Top  Next


This topic explains the files that make up a TurboDB database. They are named after the file extension used.

dat and rel Files
Contain the database tables, that is the records. Rel files are special database tables created transparently to implement many-to-many relationship. Deploy with your application.

mmo and blb Files
These are the memo and blob files, that exist once for each table that has at least one memo field or at least on blob field. One such file contains all the data of all the memo or blob fields in the table. Deploy with your application.

ind Files
User defined index. Each ind file contains one index. Deploy with your application.

id and inr Files
Automatically generated indexes for the primary index if defined. The id file is an index on the default sorting order and the inr file is an index on the AutoInc field. Deploy with your application.

net, rnt, mov and rmv Files
These are the lock files and exist for each table open in shared mode. Do not deploy with your application since these files contain only dynamic information. When your application crashes or is reset during debugging these files happen to remain on you harddisk and will lead to error messages like "table is in use by another application". In this case ensure, that no application accesses the table in question and just delete the *.net and the *.mov file from your disk.

Temporary tables and indexes
Temporary tables have random file names like jzbgopqw.dat and the temporary indexes are called appropriately. These files are usually stored in the Windows temporary directory or in the user's home directory (Linux). But you can define any other directory using the PrivateDir property of the TTdbDatabase component.