[firebird-support] Off-topic discussions

[Helen Borrie hele...@iinet.net.au [firebird-support]]

All,

Please be reminded that the firebird-support list is for topics that
are about your questions or problems concerning your work with
released versions of Firebird.

The recent thread "Firebird vs. PostgreSQL" should have been launched
in firebird-general.  It's too late to divert it now, but please be
mindful of this for future discussions.

If it is not directly a support topic, then please take it to
firebird-general.

If it is a technical question about a feature in a future release,
including alphas and betas, take it to firebird-devel.

Helen (Moderator)


---
This email has been checked for viruses by AVG.
https://www.avg.com

[firebird-support] Passing an argument from Python

[Laurentiu Anisie alauren...@gmail.com [firebird-support]]

Hi,

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?

Thanks.

Regards!

Re: [firebird-support] Re: Server crash when no more space for the database

[hv...@users.sourceforge.net [firebird-support]]

07.11.2018 14:16, hvlad@... mailto:hvlad@... [firebird-support] wrote:
 >> The last lines i see inyour message is:
 
 >After that several bugchecks wer reported. You should have whole message in 
 >your mail box.
 
 >> (Message over 64 KB, truncated)
 
 >AFAIU it is limitation of web-interface.
 
 

   And I use web-interface for this group, surprise ?
 

 Regards,
 Vlad

Re: [firebird-support] Firebird vs. PostgreSQL

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

08.11.2018 0:27, Dalton Calford dalton.calf...@gmail.com [firebird-support] 
wrote:
>  > Master-Slave is already in HQbird for 2.5 and 3.0, and will be in 
> community Firebird 4.0
>  > Master-Master is the next step for 5.0.
> 
> Great news!
> 
>  >  (6) High Available Clustering
>  >  agree, it will be based on top of the replication.
> Sounds like this would be in 5.0

   FireSwarm is a replication solution by IBPhoenix that allow to create 
Master-Master 
HA/LB cluster right now with Avalerion (modified Firebird 3) and in future with 
Firebird 4 
(if support of Changed Data Capture plugins will be implemented in it).
   Feel free to take part in alpha testing.


-- 
   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/

Re: [firebird-support] Firebird vs. PostgreSQL

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hello Dalton,

I am totally agree with you - all these features would be definitely good.

Regards,
Alexey




Hi Alexey,

Just my 2cents from someone who has not had time to review the code 
and could not find a breakdown of the firebird code structure in a 
very cursory search.



> (1) Schema support as per oracle not microsoft (although you can 
simulate MS style schema with a proper implementation)

>   agree, we need schema support

If we have a system table that has the columns (parent, child, type, 
internal_reference) and had it hold the user facing table names, while 
referencing a system generated name (the internal reference) that is 
used in blr and other tasks, then most of the work would be adding a 
name lookup function to the parser which uses a recursive CTE to do 
the name matching.  This would be the least amount of work and would 
mostly involve the parser.



> (2) Cube SQL support
>  would be good, but not critical,

This is hard and can wait, because it is mostly making the 
api's/result sets be bug for bug compatible with the MS platforms


> (3) Linked Databases in addition to the psql connections
>  would be good, but not critical

This can wait, but, I do believe it is critical in many work places.

> (4) Jobs with Schedular
>  would be good, not critical, can be implemented with bundled 
product (not core)


All this needs is some system tables to be created and parser support 
added.  The actual implementation can be written by third parties as 
long as the tables exist and are documented.


> (5) Replication
> Master-Slave is already in HQbird for 2.5 and 3.0, and will be in 
community Firebird 4.0

> Master-Master is the next step for 5.0.

Great news!

>  (6) High Available Clustering
>  agree, it will be based on top of the replication.
Sounds like this would be in 5.0

Overall, things like JSON can be done with packages, stored procs and 
psql functions, not needing anything from the developers, but the 
schema and schedular support could be covered by someone who knows the 
parser well.


Best regards

Dalton





On Wed, 7 Nov 2018 at 14:32, Alexey Kovyazin a...@ib-aid.com 
 [firebird-support] 
> wrote:


Hello Dalton,


>Where do you see the list of features that are destined to be in 5?

There is no list of features yet. However, as a member of
Technical Task Group, I will work to include into 5.0 the 3 main
features: multi-master replication, partitioning/table spaces,
schema support.



>I have been a supporter of firebird for years but there are
several things that hold it back

My opinion:

(1) Schema support as per oracle not microsoft (although you can
simulate MS style schema with a proper implementation)

agree, we need schema support

(2) Cube SQL support
would be good, but not critical

(3) Linked Databases in addition to the psql connections
would be good, but not critical

(4) Jobs with Schedular
would be good, not critical, can be implemented with bundled
product (not core)

(5) Replication
Master-Slave is already in HQbird for 2.5 and 3.0, and will be in
community Firebird 4.0
Master-Master is the next step for 5.0.

(6) High Available Clustering
agree, it will be based on top of the replication.

Regards,
Alexey



On Wed, 7 Nov 2018 at 12:19, Alexey Kovyazin a...@ib-aid.com
 [firebird-support]
mailto:firebird-support@yahoogroups.com>> wrote:

Thank you!

In my opinion, Firebird will close the gap with PG in main
features in 2
years, with FB5.0 version.

Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com 

On 07.11.2018 19:58, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com 
[firebird-support] wrote:
> Hello Alexey,
>
>> What about compilation of stored procedures - is it true
that it is
>> possible to create SP with errors, and they appear only
when it will be
>> invoked?
> Unsure, will try tomorrow. Do note, that for example, Oracle
allows you to
> 'save' or 'compile' invalid stored routines > they are
stored in the
> database
> anyway and you can ask for a list of errors. In Database
Workbench, these
> routines are shown in red as to signal they are currently
invalid.
>
>> Also, about checking the parameters - is it true that you
can create
>> stored procedure which invokes other stored procedure with
wrong list of
>> parameters, and it will give error only at the execution time?
> I'll let you know.
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> 

Re: [firebird-support] Firebird vs. PostgreSQL

['Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]]

Hello Alexey,

>What about compilation of stored procedures - is it true that it is
>possible to create SP with errors, and they appear only when it will be
>invoked?

Yes, some errors are 'allowed', like a mismatch in parameter name in
declaration and code. You'll get an error when executing, eg:

' column "p_inventory_id2" does not exist '

A wrong variable name as the target for an assignment, however, isn't 
allowed.

>Also, about checking the parameters - is it true that you can create
>stored procedure which invokes other stored procedure with wrong list of
>parameters, and it will give error only at the execution time?

Yes, correct. Example:
CREATE OR REPLACE FUNCTION public.last_day(Timestamp)

Call v_d = last_day(); results in:
' function last_day() does not exist '

PostgreSQL supports multiple stored routine languages out of the box: 'sql'
and 'plpgsql', with different (weird) syntax.

And it supports parameter overloading > functions with the same name but
a different number of parameters.

Also, triggers are different > you need a stored function that returns 
'trigger',
and when creating a trigger, you assign it that function. Triggers don't 
have
code.


Hope this helps.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com


On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
> Yes, it's true and it's rather annoying when, for example, developing an
> interactive database development tool;)







++

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










++

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/