Subject Re: [firebird-support] Firebird vs. PostgreSQL
Author Alexey Kovyazin
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 ak@... [firebird-support] <firebird-support@yahoogroups.com> 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 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/