Tuesday, 1 December 2015

Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?

 



On Tue, Dec 1, 2015 at 7:42 AM, 'Moessinger, Semjon' S.Moessinger@pi.ws [firebird-support] <firebird-support@yahoogroups.com> wrote:


My main intend is to add some version information to a firebird database file, since I will use firebird as embedded database and installers/update mechanism will need this information.

Not a great idea.  Unusual, imaginative, but probably catastrophic.  When Firebird needs to add more data, it will append some number of blocks to the end of the file.  I don't remember the algorithm exactly, but the space will be some number of disk blocks that work out to full pages.  On a good day, your information will be overwritten.  On a bad day, the allocation will fail or become misaligned and make the database unusable.


The information should be available platform independent and I would prefer a solution not needing any database access.

Maybe distribute a separate file?   

Good luck,

Ann


__._,_.___

Posted by: Ann Harrison <aharrison@ibphoenix.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment