Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?
Fabiano Kureck suggested sticking application version information in the checksum slot of the page header. Mark Rotteveel quite correctly responded. > > > That is very dangerous to do, the same bytes might be reused differently > in a newer ODS. Either use a normal Firebird table to store version info, > or do it outside of the database. Do not hack things in the internal > structure. > The page header is not a good place to stick information. It does change to support new features. However, the database header page has a place that you might be able to use. The format of the header page is defined in ods.h. The first part is fixed. The second part is a string of "clumplets" which are groups of attribute-length-data triplets. By design, Firebird skips over clumplets it doesn't understand. You could write a program that adds a new clumplet of a type undefined by Firebird to hold your version information. It wouldn't survive a gbak backup/restore cycle. The discussion was about finding portable mechanism to identify the application version of a database. Are you aware that databases are not portable across machines with different endian characteristics? Good luck, Ann > > > > -- >
Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?
That is very dangerous to do, the same bytes might be reused differently in a newer ODS. Either use a normal Firebird table to store version info, or do it outside of the database. Do not hack things in the internal structure. Mark - Reply message - Van: "Fabiano Kureck fabi...@sci10.com.br [firebird-support]" Aan: Onderwerp: [firebird-support] Is it save to append some data at end of the binary firebird database file? Datum: vr, dec. 4, 2015 11:08 What you can do is inspect Firebird structure and search for an unused area. Documentation about this can be found at http://www.firebirdsql.org/manual/fb-internals.html By example if you check http://www.firebirdsql.org/manual/fbint-standard-header.html Pag_checksum: Two bytes, unsigned. Bytes 0x02 - 0x03. Checksum for the whole page. No longer used, always 12345, 0x3039. Databases using ODS8 on Windows NT do have a valid checksum here. You can use this safely (?) Em 03/12/2015 22:19, Christian Gütter n...@guetter.org [firebird-support] escreveu: Mark Rotteveel wrote: > On Windows, all files can have alternative streams with additional > data. It is a form of hidden metadata that is attached to the main filename. True, but the alternate data streams get lost when the file is stored on a non-NTFS drive, sent via FTP/E-Mail etc. So depending on how the software of the OP is released, this might not work well. Anyway, rereading the original post, I realized that he is looking for a platform independent solution, so my focus on Windows did not help anyway. Cheers, Christian --
[firebird-support] Re: Firebird on Raspberry Pi 2 : Problem to connect remotely
Yes you were right. Just found the solution, just comment RemoteBindAddress in firebird.conf & restart firebird service and it works. By the way, for a small database, firebird server performance on Raspberry Pi2 is not bad at all. With my microSD (read speed about 20MB/s), it took about 2 secs to retrieve data from store procedure while on my cpu(Phenom X6 3.0GHz) took 0.2 secs. It will use as a 24/7 server for data collection only, i think, performance is enough. Regards, Agus
[firebird-support] Re: Firebird on Raspberry Pi 2 : Problem to connect remotely
Yes you were right. Just found the solution, just comment RemoteBindAddress in firebird.conf & restart firebird service and it works. By the way, for a small database, firebird server performance on Raspberry Pi2 is not bad at all. With my microSD (read speed about 20MB/s), it took about 2 secs to retrieve data from store procedure while on my cpu(Phenom X6 3.0GHz) took 0.2 secs. It will use as a 24/7 server for data collection only, i think, performance is enough. Regards, Agus
Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?
What you can do is inspect Firebird structure and search for an unused area. Documentation about this can be found at http://www.firebirdsql.org/manual/fb-internals.html By example if you check http://www.firebirdsql.org/manual/fbint-standard-header.html Pag_checksum: Two bytes, unsigned. Bytes 0x02 - 0x03. Checksum for the whole page. No longer used, always 12345, 0x3039. Databases using ODS8 on Windows NT do have a valid checksum here. You can use this safely (?) Em 03/12/2015 22:19, Christian Gütter n...@guetter.org [firebird-support] escreveu: Mark Rotteveel wrote: > On Windows, all files can have alternative streams with additional > data. It is a form of hidden metadata that is attached to the main filename. True, but the alternate data streams get lost when the file is stored on a non-NTFS drive, sent via FTP/E-Mail etc. So depending on how the software of the OP is released, this might not work well. Anyway, rereading the original post, I realized that he is looking for a platform independent solution, so my focus on Windows did not help anyway. Cheers, Christian --
Re: {Disarmed} [firebird-support] Replicating MS Access DB
> So I was looking for the replacement and as it looks to me at the > moment, I would pick LibreOffice Base as frontend, as I need to create > forms and reports, and FirebirdSQL 3 as DB engine. (Any comments are > welcome about my selection being good/bad). Firebird 3 ist at RC1 state - is your project going productive before FB3 is final? > My biggest question is about replicating multi-user environment. > Currently I have MS Access DB back-end with data on our shared network > folder and all users have frontend with all forms, reports, queries, > etc. Without any server component about 25 users can work on the > database without big issues. Now, what is best way to replicate it > with FirebirdSQL? I really like MS Access simplicity, as "simple" > users can create this multiuser environment on their own, without need > to ask IT administrators to be involved. Peer-Networking is not an option with firebird. You should install an server. > What would be the easiest way to create this kind of setup, that would > be easy deployable and stable for multiuser work. Would it be Classic > server configuration? You can use any server confguration, I would assume there is no great difference for you using single-process "SuperServer" or multiprocess "Classic" since Access-Peer-Networging was suffucient till now. Elmar
[firebird-support] Re: Firebird on Raspberry Pi 2 : Problem to connect remotely
Hi Agus, Is the RemoteBindAddress parameter restricts connections to local attachments in firebird.conf? Regards Zsolt
Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?
On 04/12/2015 00:07, Christian Gütter n...@guetter.org [firebird-support] wrote: > In Windows this is not an abuse, executable files have > provision for version metadata ("resource") and you're supposed > to use it properly. Pity this doesn't apply portably to all file types, innit. True, but if you just append the info to the exe file, it is an abuse ;-) And there are no restrictions with regard to the information you want to store. There are no restrictions doing it properly with resources - you don't have to just use the VERSIONINFO resource (although you should, as vast numbers of other tools understand it), you can add whatever custom resources you like. -- Tim Ward