[firebird-support] Re: Firebird on Raspberry Pi 2 : Problem to connect remotely

[m-zs...@freemail.hu [firebird-support]]

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?

[Tim Ward t...@telensa.com [firebird-support]]

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

[firebird-support] Re: Firebird on Raspberry Pi 2 : Problem to connect remotely

[trsk...@yahoo.com [firebird-support]]

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?

[Fabiano Kureck fabi...@sci10.com.br [firebird-support]]

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

[trsk...@yahoo.com [firebird-support]]

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: {Disarmed} [firebird-support] Replicating MS Access DB

[Elmar Haneke el...@haneke.de [firebird-support]]

> 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

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

['Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]]

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












-- 

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

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

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

>
>

> 
> --
>