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
<mailto:a...@ib-aid.com> [firebird-support]
<firebird-support@yahoogroups.com
<mailto: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 a...@ib-aid.com
<mailto:a...@ib-aid.com> [firebird-support]
<firebird-support@yahoogroups.com
<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 <http://www.ib-aid.com>
On 07.11.2018 19:58, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com <mailto: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
> http://www.upscene.com
>
> Regards,
> Alexey
>
>
>
> On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)'
> m.ton...@upscene.com <mailto: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
>
>
>
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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/
<http://www.ibphoenix..com/resources/documents/>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
firebird-support-fullfeatu...@yahoogroups.com
<mailto:firebird-support-fullfeatu...@yahoogroups.com>