Re: [firebird-support] hosting on linux questions
I'm running Firebird on Ubuntu, but also I'have run it on Debian for many years with no problems in either case. Regards, Aldo Caruso
Re: [firebird-support] Firebird 3 embedded lock/temp files
nice, i have found the "TempDirectories" section in firebird.conf so i guess that tha's it :) so i have to test that . and about classis and super server what do you recommend for this ? about lock files , i am not sure what this is usefull for . 1 : can we setup the environement vars in shared hosting ? 2 : the database is used for *strictly read only* operations, can we configure firebird to treat databases as read only options only . i am guessing that this lock files are related somehow, so if we disable write operations maybe it will help . and maybe i don't even need to setup lock files or things like that . 2018-07-16 16:09 GMT+02:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 16.07.2018 15:56, Issam Boughanmi amigof...@gmail.com [firebird-support] > wrote: > > is it possible to set custom path for the lock and temp files in > firebird 3 embedded via > > config file or anything else ? > >Yes, temp files directory are configured in firebird.conf or > FIREBIRD_TMP environment > variable and lock file can be moved by FIREBIRD_LOCK environment variable. > > > -- >WBR, SD. > > > > > > > ++ > > 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/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Firebird 3 embedded lock/temp files
16.07.2018 15:56, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > is it possible to set custom path for the lock and temp files in firebird 3 > embedded via > config file or anything else ? Yes, temp files directory are configured in firebird.conf or FIREBIRD_TMP environment variable and lock file can be moved by FIREBIRD_LOCK environment variable. -- WBR, SD. ++ 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/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Firebird 3 embedded lock/temp files
hi everyone . is it possible to set custom path for the lock and temp files in firebird 3 embedded via config file or anything else ? i want this to test my web application in a shared hosting before i buy a vps or a dedicated server . i remember that i have tried some time ago with 2.5 without success because the firebird engine have no access to program data folder in a shared hosting . so i am wondering if this is possible in fb3 or fb2.5 :p any idea or information on this is much appreciated :) thanks .
Re: {Disarmed} [firebird-support] hosting on linux questions
> > 1- after some search , it seems that the recommended linux > distribution for a web server is centos 7, then ubuntu . > > any feedbacks , recommendations, ideas on this please , and how it > behave with firebird ? I'm using firebird on debian for years - without any problems. Presumably it does not really matter for firebird which distribution is used. > 2 - i am not really a linux user , what is the best place/directory > to put the fdb databases ? You can place them according to some standard documents as mentioned before. But, it is also ok to place them in an Directory /db or /usr/local/fbdata. > 3 - i have several databases for differents custumers (20 / 30 or > more), can a single firebird server handle many databases correctly ? This number of databases does not cause problems. >ou should think about spreading to multiple servers once the workload on your server does raise and an single machine is not enough any more. Elmar
Re: [firebird-support] get number of combinations of to keys
Sure, I'd expect that to work as well (well, DISTINCT has to be added to the inner select). However, I do think my suggestion normally would be simpler if you know the data - you delete the parts that aren't needed and end up with e.g. select count( distinct PRO || '_' || FA ) ProFaCount from Tab where Key = :Key Den man. 16. jul. 2018 kl. 09:27 skrev Omacht András aoma...@mve.hu [firebird-support] : > > > Hi Set, > > > isn't > > > select count(1) > from (select pro, fa > from tab > where Key = :Key > group by pro, fa) > into :ProFaCount > > > enough? > > > András > > > -- > *Feladó:* firebird-support@yahoogroups.com < > firebird-support@yahoogroups.com>, meghatalmazó: Svein Erling Tysvær > setys...@gmail.com [firebird-support] > *Elküldve:* 2018. július 16. 9:11 > *Címzett:* firebird-support@yahoogroups.com > *Tárgy:* Re: [firebird-support] get number of combinations of to keys > > > > Well, you need to know more about PRO and FA than we do, but if they are > character fields and neither of them can include _, then maybe: > > select count( distinct coalesce( PRO, '' ) || '_' || coalesce( FA, '' ) ) > ProFaCount > from Tab > where Key = :Key > > would work. The COALESCE is there in case the fields could be NULL. If PRO > and FA are non-null numbers and FA always is between 0 and 99, then the > query would be > > select count( distinct ( 100 * PRO ) + FA ) ProFaCount > from Tab > where Key = :Key > > HTH, > Set > > Den man. 16. jul. 2018 kl. 08:58 skrev josef.gschwendt...@quattro-soft.de > [firebird-support] : > >> >> >> Hi, >> >> >> Is there a way to get this ProFaCount in one statement (without for >> select) >> >> >> ProFaCount = 0; >> for >> select distinct PRO, FA >> from Tab >>where Key = :Key >> into :PRO, :FA >> do >> ProFaCount = ProFaCount + 1; >> >> Thank you for your help. >> >> >> Regards, >> >> Josef >> >> >> > > __ Information from ESET Mail Security, version of virus signature > database 17721 (20180716) __ > > The message was checked by ESET Mail Security. > http://www.eset.com > > > __ Information from ESET Mail Security, version of virus signature > database 17721 (20180716) __ > > The message was checked by ESET Mail Security. > http://www.eset.com > > > >
Re: [firebird-support] get number of combinations of to keys
Hi Set, isn't select count(1) from (select pro, fa from tab where Key = :Key group by pro, fa) into :ProFaCount enough? András Feladó: firebird-support@yahoogroups.com , meghatalmazó: Svein Erling Tysvaer setys...@gmail.com [firebird-support] Elküldve: 2018. július 16. 9:11 Címzett: firebird-support@yahoogroups.com Tárgy: Re: [firebird-support] get number of combinations of to keys Well, you need to know more about PRO and FA than we do, but if they are character fields and neither of them can include _, then maybe: select count( distinct coalesce( PRO, '' ) || '_' || coalesce( FA, '' ) ) ProFaCount from Tab where Key = :Key would work. The COALESCE is there in case the fields could be NULL. If PRO and FA are non-null numbers and FA always is between 0 and 99, then the query would be select count( distinct ( 100 * PRO ) + FA ) ProFaCount from Tab where Key = :Key HTH, Set Den man. 16. jul. 2018 kl. 08:58 skrev josef.gschwendt...@quattro-soft.de [firebird-support] mailto:firebird-support@yahoogroups.com>>: Hi, Is there a way to get this ProFaCount in one statement (without for select) ProFaCount = 0; for select distinct PRO, FA from Tab where Key = :Key into :PRO, :FA do ProFaCount = ProFaCount + 1; Thank you for your help. Regards, Josef __ Information from ESET Mail Security, version of virus signature database 17721 (20180716) __ The message was checked by ESET Mail Security. http://www.eset.com __ Information from ESET Mail Security, version of virus signature database 17721 (20180716) __ The message was checked by ESET Mail Security. http://www.eset.com
Re: [firebird-support] get number of combinations of to keys
Well, you need to know more about PRO and FA than we do, but if they are character fields and neither of them can include _, then maybe: select count( distinct coalesce( PRO, '' ) || '_' || coalesce( FA, '' ) ) ProFaCount from Tab where Key = :Key would work. The COALESCE is there in case the fields could be NULL. If PRO and FA are non-null numbers and FA always is between 0 and 99, then the query would be select count( distinct ( 100 * PRO ) + FA ) ProFaCount from Tab where Key = :Key HTH, Set Den man. 16. jul. 2018 kl. 08:58 skrev josef.gschwendt...@quattro-soft.de [firebird-support] : > > > Hi, > > > Is there a way to get this ProFaCount in one statement (without for > select) > > > ProFaCount = 0; > for > select distinct PRO, FA > from Tab >where Key = :Key > into :PRO, :FA > do > ProFaCount = ProFaCount + 1; > > Thank you for your help. > > > Regards, > > Josef > > > >
[firebird-support] get number of combinations of to keys
Hi, Is there a way to get this ProFaCount in one statement (without for select) ProFaCount = 0; for select distinct PRO, FA from Tab where Key = :Key into :PRO, :FA do ProFaCount = ProFaCount + 1; Thank you for your help. Regards, Josef