Subject Re: [firebird-support] Firebird vs. PostgreSQL
Author Alexey Kovyazin
Post date 2018-11-07T19:32:03Z
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 ak@... [firebird-support] <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.tonies@... [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
> http://www.upscene.com
>
> Regards,
> Alexey
>
>
>
> On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)'
> m.tonies@... [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
>
>
>



------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/