Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hello All, As there are many people involved and truly interested in further Firebird development in this thread, I would like to remind, that Firebird is funded by Firebird Foundation sponsors and members, and there is always ability to boost development with money sponsorship and donations.

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
For me highest priority are grouping sets and pivot.If we are talking about triggers/procedures. For me there is one big disadvantage about string processing.Why we can not use indexed access to string? This should be simplified.E.g. declare variable A char(50)A[4] = 'x'A[7] = A[8]I

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
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) >

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-11-06 14:44, Fabiano Bonin fabiano.bo...@personalsoft.com.br [firebird-support] wrote: > There is a 31 characters table name limit, the can bring some > restrictions if you are planning to create a multi-database > application and you use big table names. This limit will be doubled (to

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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

RE: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread edmende...@gmail.com [firebird-support]
Kjell, In our shop we are using Firebird 2.5x for Data warehouse and Postgresql 10..x for other projects. Below is my list of Pros and Cons between the two. The list below is my experience with the two products. PostgreSQL over Firebird 2.5 Pros * Table Partitions are

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
Hi Alexey, Where do you see the list of features that are destined to be in 5? I have been a supporter of firebird for years but there are several things that hold it back (1) Schema support as per oracle not microsoft (although you can simulate MS style schema with a proper implementation) (2)

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-11-07 16:28, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > Firebird also doesn't support data partitioning, extended window > functions What are you really missing in existing window functions support? Mark

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support]
Alexey I can confirm that it is possible to 'compile' SP with error that will appear during SP execution. Probably the most annoying thing in the world for Firebird users ;-) I hate it. Marcin -- Wiadomość oryginalna -- Od: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" Do:

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread '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? Unsure, will try tomorrow. Do note, that for example, Oracle allows you to 'save' or 'compile' invalid stored routines > they are

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Martijn, 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? Also, about checking the parameters - is it true that you can create stored procedure which invokes other stored procedure with wrong

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Yes, it's true and it's rather annoying when, for example, developing an interactive database development tool ;) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase,

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.11.2018 17:11, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Wow is this true? https://www.tutorialspoint.com/postgresql/postgresql_transactions.htm "Transactions can be started using BEGIN TRANSACTION or simply BEGIN command. Such transactions usually persist until

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Wow is this true? If yes in my opinion going to PG is a mistake.Regards,Karol Bieniaszewski null

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.11.2018 16:28, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > Firebird also doesn't support data partitioning, extended window functions On the other hand transactions in PostgreSQL are strange: they automatically rolled back on any statement error. -- WBR, SD.

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Michal Kurczabinski michk...@gmail.com [firebird-support]
Firebird also doesn't support data partitioning, extended window functions -- Regards, Michal Kurczabinski 2018-11-06 14:44 GMT+01:00, Fabiano Bonin fabiano.bo...@personalsoft.com.br [firebird-support] : > Firebird doesn't support schemas. > This is the main reason I am replacing it by

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

2018-11-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.11.2018 14:16, hv...@users.sourceforge.net [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. --

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

2018-11-07 Thread hv...@users.sourceforge.net [firebird-support]
2018. 11. 07. 8:51 keltezéssel, hvlad@... mailto:hvlad@... [firebird-support] írta: >> There should be no crash. Errors - yes, crash - no. >> Attached log is truncated and i see no message about crash there. > The firebird.log not exists when started the OLTP. My second message >

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

2018-11-07 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2018. 11. 07. 8:51 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: >   There should be no crash. Errors - yes, crash - no. > Attached log is truncated and i see no message about crash there. The firebird.log not exists when started the OLTP. My second message contains the

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

2018-11-07 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 07/11/2018 07:51, hv...@users.sourceforge.net [firebird-support] wrote: > > While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space > > for the database the server crashed. See the attachment. Is it a known > > limitation (not fixed in 2.5 because it's too old) or a bug? >

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

2018-11-07 Thread hv...@users.sourceforge.net [firebird-support]
> While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space > for the database the server crashed. See the attachment. Is it a known > limitation (not fixed in 2.5 because it's too old) or a bug? There should be no crash. Errors - yes, crash - no. Attached log is