How to go about this...
-
Hi everybody, I want to explore more of creating a file database on my own. I can already create a system with fixed-length records in binary format to add, delete and search through it, with file headers and manipulating at the bytes level. Now I would like to find any sources (articles, books, code...) to see how to go about creating a variable fixed records (providing the type of the value that will be stored in the record), how to internally organise the tables, how to link tables, etc... The purpose of it is to use it in some simple applications to escape the overload of bringing the MDAC, Jet and other componenets into the installation, if I am not going to need any high-performance database, but still wish to have a data storage. I searched all over the net, but could not find much details about it. Thanks a lot in advance. .
-
Hi everybody, I want to explore more of creating a file database on my own. I can already create a system with fixed-length records in binary format to add, delete and search through it, with file headers and manipulating at the bytes level. Now I would like to find any sources (articles, books, code...) to see how to go about creating a variable fixed records (providing the type of the value that will be stored in the record), how to internally organise the tables, how to link tables, etc... The purpose of it is to use it in some simple applications to escape the overload of bringing the MDAC, Jet and other componenets into the installation, if I am not going to need any high-performance database, but still wish to have a data storage. I searched all over the net, but could not find much details about it. Thanks a lot in advance. .
You have two choices, either an index of fixed length records that shows where everything is and how big it is, or start each structure with a field that says how long it is. I recomend both, that way if something gets corrupt you can use the other to recover most data. If you sprinkle "magic numbers" in there - something that is unlikely to be real data, you can start from any magic number and recover the rest of the file. (this might require someone to manually read the file) You will have to decide how important the data is, and compare that to the increased disk space. Don't forget to consider checksums to verify the data. Again, something that might not be worth the cost.
-
Hi everybody, I want to explore more of creating a file database on my own. I can already create a system with fixed-length records in binary format to add, delete and search through it, with file headers and manipulating at the bytes level. Now I would like to find any sources (articles, books, code...) to see how to go about creating a variable fixed records (providing the type of the value that will be stored in the record), how to internally organise the tables, how to link tables, etc... The purpose of it is to use it in some simple applications to escape the overload of bringing the MDAC, Jet and other componenets into the installation, if I am not going to need any high-performance database, but still wish to have a data storage. I searched all over the net, but could not find much details about it. Thanks a lot in advance. .
The are a number of compact DBM's around if you don't want to write one yourself. eg. SQLite is very popular. Neville Franks, Author of ED for Windows www.getsoft.com and coming soon: Surfulater www.surfulater.com
-
Hi everybody, I want to explore more of creating a file database on my own. I can already create a system with fixed-length records in binary format to add, delete and search through it, with file headers and manipulating at the bytes level. Now I would like to find any sources (articles, books, code...) to see how to go about creating a variable fixed records (providing the type of the value that will be stored in the record), how to internally organise the tables, how to link tables, etc... The purpose of it is to use it in some simple applications to escape the overload of bringing the MDAC, Jet and other componenets into the installation, if I am not going to need any high-performance database, but still wish to have a data storage. I searched all over the net, but could not find much details about it. Thanks a lot in advance. .
-
Hi everybody, I want to explore more of creating a file database on my own. I can already create a system with fixed-length records in binary format to add, delete and search through it, with file headers and manipulating at the bytes level. Now I would like to find any sources (articles, books, code...) to see how to go about creating a variable fixed records (providing the type of the value that will be stored in the record), how to internally organise the tables, how to link tables, etc... The purpose of it is to use it in some simple applications to escape the overload of bringing the MDAC, Jet and other componenets into the installation, if I am not going to need any high-performance database, but still wish to have a data storage. I searched all over the net, but could not find much details about it. Thanks a lot in advance. .