| Powered by phpBay Pro |
A flat file database is one in which data is stored in plain text format. It is usually used to store and retrieve a small amount of data in a local text file.
Need of flat file database: Most free web hosts do not allow their users to use MYSQL database for free. In that case flat-file database is an alternative solution.
How to store data: In a database data are stored in tabulated form. An example of typical table database is given below.
Student Class Age John 9 15 Susan 6 11 Emili 10 15
When we store such a table in a flat file, file structure will be as follows.
John^^9^^15 Susan^^6^^11 Emili^^10^^15
Here I use a new string '^^' as column separator, and new line character is used for row separation. While selecting such a separator we must confirm that data itself not contain that string. So we have to filter-out data from such string before any write operation.
Problems of flat-file database:
A flat-file is a SISO (serial in serial out) memory system. New data can only be entered at the end of the file. So if we want to edit or delete a record from our database; or if we want to insert a new record in-between two records, we have to rearrange and then rewrite the entire database file. So speed of operation lowers with the size of database file. Actually flat-file database should not be used for size more than 5mb.
Flat file database is not very safe in multi-user environment like blog, guestbook etc. where many users sharing the same database from different ends.
For practical application of Flat file database in website contact form please visit our site at http://ramui.com You may reprint this article with all links intact only.
What Is On YouTube Today?
VINTAGE GUITARS 1976 Ibanez Custom Agent . Made in Japan Japanese
Here Are Some Items From Amazon You Might Like.
 How To Restore Ford Tractors: The Ultimate Guide to Rebuilding and Restoring N-Series and Later Tractors 1939-1962 List Price: Sale Price: $19.69 You save: $10.30 (34%)  Eligible for free shipping!Availability: Usually ships in 1-2 business days  |
 The Chicago World's Fair of 1893: A Photographic Record (Dover Architectural) List Price: Sale Price: $6.51 You save: $6.44 (50%) Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Standard Catalog of Schwinn Bicycles Sale Price: $41.95 Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Classic Schwinn Bicycles (Collector's Library) Sale Price: $47.50 Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 The Guild Guitar Book List Price: Sale Price: $21.38 You save: $11.61 (35%) Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Automotive Websites List Price: Sale Price: $32.41 You save: $2.59 (7%) Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Julie's Gift: Memories of London List Price: Sale Price: $12.28 You save: $0.67 (5%) Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Fender Amp Book (Cloth) Sale Price: $225.16 Eligible for free shipping!Availability: Usually ships in 1-2 business days |
 Gibson's Fabulous Flat-Top Guitars: An Illustrated History and Guide Sale Price: $35.44 Eligible for free shipping!Availability: Usually ships in 1-2 business days |
Items recently purchased on this site:
| Powered by phpBay Pro |
Thanks for visiting!
Tags: mediumformat, reference, camera, photography