Re: [firebird-support] Passing an argument from Python
On 8-11-2018 15:17, Laurentiu Anisie alauren...@gmail.com [firebird-support] wrote: > I want to run a stored procedure or a sql query in firebird but I want > to pass arguments from a python file because I don't want to expose the > statements in py files. > I tried to find a solution but I failed. > > Can someone help me with an minor example? Your question is rather unclear, however it is probably better to ask this on the firebird-python list instead (see https://www.firebirdsql.org/en/mailing-lists/) Mark -- Mark Rotteveel
Re: [firebird-support] Re: Server crash when no more space for the database
2018. 11. 07. 8:51 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: > There should be no crash. Errors - yes, crash - no. > Attached log is truncated and i see no message about crash there. https://pastebin.com/0iv3FQcy Gabor ++ 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/
Re: [firebird-support] Converting dates and the ISO-8601 format
On 10/11/2018 11:19, i...@synapsesoftware.co.uk [firebird-support] wrote: > Fantastic! Works a treat! Wow, wonder how many other people are going to > be tripped up by this ! ? There is a list for firebird users on php firebird-...@yahoogroups.com It is true that Firebird does not perhaps get the love it deserves when using it with PHP and there are a few niggles that have crept in over the years as how PHP handles data has been changed. We *DO* need a few more people who can handle the complexities of C and changes to the interface to bring both the original ibase driver and the less flexible pdo_firebird driver up to PHP7 standards. The PHP developers keep threatening to drop them all together! So as a starting point, we could do with a bit more activity on the firebird-php list ... -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.co.uk
Re: [firebird-support] Does GRANT... TO PUBLIC has no more effect anymore?
On 10-11-2018 12:57, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > On 09.11.2018 at 16:03, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> On 2018-11-09 15:19, jonatan.laurit...@yahoo.dk [firebird-support] >> wrote: >>> I used to execute GRANT... TO PUBLIC for every new database object I >>> had created in the past, but for some time (I can not tell exactly - >>> whether starting from Firebird 2.1 or from Firebird 3.0 only) this has >>> not effect. I can see in the metadata tables, that PUBLIC has been >>> granted new rights, but individual users (who should inherited all the >>> assigned privilegies from the PUBLIC) have no access to the new >>> objects. It worked as expected in Firebird 1.5. Does something changed >>> here, is it by design now or is it error or I am doing something wrong >>> technically? >> >> It should still work, although possibly some form of metadata-caching >> may be involved (not sure). Please provide a reproduction recipe. >> > > I can confirm it works correctly in 2.5.x (can't say anything about 3.x > though). We're using the same approach (the users of our system are > actually created as FB users, so granting access to PUBLIC is more > convenient than having to execute dozens of grants after adding each new > user; I know it has some downsides, but that's not the point here). Firebird 4 will introduce default roles (though technically PUBLIC is a default role as well) which will allow more control by granting users a default role. That way they will get the rights of those default roles without having to explicitly specify a role on connect. Mark -- Mark Rotteveel
Re: [firebird-support] Does GRANT... TO PUBLIC has no more effect anymore?
On 09.11.2018 at 16:03, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2018-11-09 15:19, jonatan.laurit...@yahoo.dk [firebird-support] > wrote: >> I used to execute GRANT... TO PUBLIC for every new database object I >> had created in the past, but for some time (I can not tell exactly - >> whether starting from Firebird 2.1 or from Firebird 3.0 only) this has >> not effect. I can see in the metadata tables, that PUBLIC has been >> granted new rights, but individual users (who should inherited all the >> assigned privilegies from the PUBLIC) have no access to the new >> objects. It worked as expected in Firebird 1.5. Does something changed >> here, is it by design now or is it error or I am doing something wrong >> technically? > > It should still work, although possibly some form of metadata-caching > may be involved (not sure). Please provide a reproduction recipe. > I can confirm it works correctly in 2.5.x (can't say anything about 3.x though). We're using the same approach (the users of our system are actually created as FB users, so granting access to PUBLIC is more convenient than having to execute dozens of grants after adding each new user; I know it has some downsides, but that's not the point here). Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__
Re: [firebird-support] Converting dates and the ISO-8601 format
Woops! Spoke to soon, changing the setting in the PHP.ini did not change anything. Never mind, at least I know where to look . I will ask in some php forum, Thanks anyway.. Cheers
Re: [firebird-support] Converting dates and the ISO-8601 format
Fantastic! Works a treat! Wow, wonder how many other people are going to be tripped up by this ! ? Thanks a lot Mark (and all those who responded)
Re: [firebird-support] Firebird vs. PostgreSQL
On 9-11-2018 22:51, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > First thought: > > range/rows between unbounded preceding and unbounded following / > current row, etc.. Will be added in Firebird 4 (already present in the Firebird 4 Alpha 1). > own aggregate functions in conjunction with window functions, There was a discussion about it on firebird-devel back in September/October, but I don't think there was anything conclusive yet. > list(column) over ... list does work as a window function, just not with an order by clause (that produces: feature is not supported, LIST is not supported in ordered windows); I'm not sure why it isn't supported for ordered windows though. Mark -- Mark Rotteveel
Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?
On 9-11-2018 20:30, blackfalconsoftw...@outlook.com [firebird-support] wrote: > I have never used FlameRobin since the author's presentation of his > efforts appeared to be rather unprofessional so I didn't see a long life > for the project. It appears that I was correct. You should really consider hard what you just wrote here, and may be consider next time that if you have nothing friendly or constructive to say, that maybe you should just refrain from saying it. This kind of attitude against people who spend a lot of time to provide free tools is one of the reasons why contributors stop contributing. Also, FYI, FlameRobin dates back to 2004 (likely even earlier given the amount of code in the first commit). Mark -- Mark Rotteveel
Re: [firebird-support] Converting dates and the ISO-8601 format
On 9-11-2018 13:38, i...@synapsesoftware.co.uk [firebird-support] wrote: > I use Firebird primarily with Delphi and have had no problems with using > and displaying dates (suitable for my country - UK.) > > However, it seems to be a big problem with Firebird and dates when > working with PhP with firebird driver. I have a number of fields that > hold information in a field defined to be of type "date" in Firebird. > When I use PhP to query my database I get the fields formatted in the > ISO-8601 format (year/month/day.. etc). Disclaimer: I don't use PHP, but a quick google suggested https://secure.php.net/manual/bg/function.ibase-timefmt.php; that seems to be a function that has been removed, but one of the comments suggested: ``` /** * Constant definitions that has been removed from PHP 5 */ const IBASE_DATE = "ibase.dateformat"; const IBASE_TIME = "ibase.timeformat"; const IBASE_TIMESTAMP = "ibase.timestampformat"; /** * Sets the format of timestamp, date or time type * columns returned from queries */ function ibase_timefmt($format, $where = IBASE_TIMESTAMP) { ini_set($where, $format); } ``` And https://secure.php.net/manual/en/ibase.installation.php (see first comment) suggests this can also be configured in the php.ini file. Mark -- Mark Rotteveel
Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?
On 9-11-2018 19:22, Dalton Calford dalton.calf...@gmail.com [firebird-support] wrote: > All the free firebird management tools are falling by the wayside. > Flamerobin can not handle the new datatypes, does not show database > triggers, crashes with UTF8 in many areas etc. > FenixSQL is dead > FirebirdWebAdmin is based on the no longer supported php5 > the list goes on. > Dbeaver is generic and is not well suited for Firebird > > Overall, the loss of all these free administration tools stops people > from attempting to try firebird. Unless people step up and contribute (either time or money), things are not going to change. Mark -- Mark Rotteveel