Hi,
We've been using Firebird "forever". For upcoming projects and also possible
replacement in existing ones, we're considering PostgreSQL.
What would you say is the pros and cons of Firebird vs. PostgreSQL?
I'm aware that the answers may very well be different depending on application
and us
Firebird doesn't support schemas.
This is the main reason I am replacing it by PostgreSQL in all my projects.
In versions prior to 3.0, there is a limit on SQL instruction size, what
makes it hard to use with frameworks like Hibernate, which tends to
generate huge SQL instructions.
But this is sol
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 PostgreSQ
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.
Wow is this true? If yes in my opinion going to PG is a mistake.Regards,Karol
Bieniaszewski
null
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 t
InterBase, NexusDB and Firebird.
-Original Message-
From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Sent: Wednesday, November 07, 2018 5:17 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird vs. PostgreSQL
07.11.2018 17:11, liviuslivius
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 li
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 s
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
-support]"
Do: firebird-support@yahoogroups.com
Data: 07.11.2018 17:37:00
Temat: Re: [firebird-support] Firebird vs. PostgreSQL
>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
&
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
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) C
2.1
From: firebird-support@yahoogroups.com
Sent: Tuesday, November 6, 2018 7:45 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird vs. PostgreSQL
Hi,
We've been using Firebird "forever". For upcoming projects and also possible
replacement in e
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 ha
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 63
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)
> agr
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 wait
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.
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?
Yes, some errors are 'allowed', like a mismatch in parameter name in
declaration and code. You'll get an error when executing, eg:
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 s
08.11.2018 0:27, Dalton Calford dalton.calf...@gmail.com [firebird-support]
wrote:
> > 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 w
2018-11-07 16:33 GMT+01:00, 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 Pos
2018-11-07 19:06 GMT+01:00, 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
On 9-11-2018 22:51, Michal Kurczabinski michk...@gmail.com
[firebird-support] wrote:
> First thought:
>
> range/rows between unbounded preceding and unbounded following /
> current row, etc..
Will be added in Firebird 4 (already present in the Firebird 4 Alpha 1).
> own aggregate functions in
I forgot about very useful feature lile FILTER on window functions
select some_col, count(other_col) over() FILTER ( where other_col >
soime_val) Maybe in FB 4.0 it might be implemented
2018-11-10 9:47 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] :
> On 9-11-2018 22:51, Mi
On 2019-03-12 13:13, Michal Kurczabinski michk...@gmail.com
[firebird-support] wrote:
> I forgot about very useful feature lile FILTER on window functions
> select some_col, count(other_col) over() FILTER ( where other_col >
> soime_val) Maybe in FB 4.0 it might be implemented
FILTER has been
2019-03-12 16:56 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]
>
> FILTER has been implemented in Firebird 4. See "FILTER Clause for
> Aggregate Functions" in the Firebird 4 beta 1 release notes, or
> http://tracker.firebirdsql.org/browse/CORE-5768
Great!
> Note though that the
28 matches
Mail list logo