Postgres Vs Interbase/Firebird (Score:0) By Anonymous Reader on 2004.12.03 18:23 (#102740) http://www.vitavoom.com/postgresql.htmlFirebird has not true text type you must use the clumsy blobs and weird blob subtypes.Postgres is much closer for enterprise use than Firebird.almost all of this applies to Firebird as well as interbase.PostgreSQL vs InterbasePostgreSQL… * … has no “dialects” or other weird features. * … has no “backdoors” which can compromise your whole company’s security and business (check here and here). * … supports unlimited row sizes, unlimited datasebase sizes, tables up to 16TB (!!), unlimited number of rows, unlimited indexes for table and 1Gb per field. * … has a boolean field. * … can cancel a query asynchronously (Interbase 6.5 – the commercial version – seems to support it now). * … has a flexible (not fixed) types system, and supports more types then Interbase. You can always add your own types at your wish, or change existent types behavior. PostgreSQL even has geometrical and IPv4 types support (!!). * … supports inheritance. * .. supports flexible full text indexing through OpenFTS. * … has a much more sofisticated locking mechanism (MVCC). * … has arbitrary precision numeric fileds (numeric type). * … is resistant to crashes and power failures (by using it’s logging system, MVCC and chepoint)). Although it is technically possible that a database gets corrupt, we at Vita voom never saw it (except for corrupt media storage of course). * … supports functions (whose can be used as stored procedures). These functions current can be written on SQL, pl/PgSQL (a language similar to Oracle’s pl/SQL), TCL, Perl, and Python, C, C++ (or other compiled languages) but it’s not limited to them. * … can have functions to define default values for columns (providing ultimate default value flexibility). * … supports much more arrays types then Interbase, they are more flexible and can support much more elements. * … supports rules. * … supports “fetch” SQL command to get only a limited number of rows at a time, making queries more responsive and resource economic. * … has regular expressions support (for searches and operations). * … has a ‘EXPLAIN’ command which will show will how it will perform a query, so that you optimize it. * … has statistics about database usage which can be used to optimize queries and indices. * … has sequences. * … has more built-in functions then Interbase (or any other open source RDBMS). * … supports indexes on functions. * … has broader subselects support then Interbase. * … has a more flexible BLOB fields support. * … can limit the number of rows retrieved at at time (with the ‘LIMIT’ keyword). * … is more standards-compliant then Interbase. * … allo From: http://sitestree.com/?p=4715
Categories:2
Tags:
Post Data:2013-03-14 18:15:43
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
