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-support@yahoogroups.com>: > 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 solved in version 3.0, so you should disconsider this one if > you are using this version. > > 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. > > But, if your project will be bound to a single database, you can live with > these issues. > > The advantages I see on Firebird over PostgreSQL is single file database, > great charset and collation support, easiest to mantain, doesn't bring a > bunch of features you will never use, small installation size. > > Regards, > > > > > Em ter, 6 de nov de 2018 às 11:10, Kjell Rilbe > kjell.ri...@marknadsinformation.se [firebird-support] < > firebird-support@yahoogroups.com> escreveu: > >> >> >> 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 usage patterns, but I would like to start with >> considerations i general terms, e.g. framework support (e.g. Entity >> Framework), admin tools availability and usability (Windows and possibly >> Mac), query performance in general, resource load, SQL standard >> compliance, >> stability, development progress (new features, fixing bugs, ...) etc. >> >> Mvh, >> Kjell >> >> [cid:part1.5A72A320.2CD4BAEA@marknadsinformation.se] >> >> Kjell Rilbe >> Telefon: 08-761 06 55 >> Mobil: 0733-44 24 64 >> >> Marknadsinformation i Sverige AB >> Ulvsundavägen 106C >> 168 67 Bromma >> www.marknadsinformation.se<http://www.marknadsinformation.se/> >> 08-514 905 90 >> >> [Företagskontakt.se]<http://www.f%C3%B6retagskontakt.se/> >> [Personkontakt.se]<http://www.personkontakt.se/> >> >> [Non-text portions of this message have been removed] >> >> >> > -- pozdrawiam / regards, Michał Kurczabiński