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] <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 > [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.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 [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 >> >> >> >> > >
