StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I can comment on Firebird. The following changed since the first comparison: </p> <blockquote> <p>Multi Threaded Architecture Available? Yes (super server)</p> </blockquote> <p>Actually, Classic Server is the preferred server type for scalability. Starting from Firebird 2.5 there is also an architecture called SuperClassic. I wrote a small post on the differences: <a href="http://www.sinatica.com/blog/en/index.php/articles/firebird-superserver-classicserver-or-superclassic" rel="noreferrer">SuperServer, ClassicServer or SuperClassic?</a></p> <blockquote> <p>Stores Transaction Information in same file as data? Yes (in red)</p> </blockquote> <p>I don't see how this could be a problem to be written in red. Firebird uses careful writes to ensure the database structure is always consistent.</p> <blockquote> <p>Temporary Tables? No</p> </blockquote> <p>Available in Firebird 2.1. <a href="http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-globaltemp" rel="noreferrer">Release Notes</a></p> <blockquote> <p>Rich Built in Functions? No</p> </blockquote> <p>Firebird 2.1 also improved this. <a href="http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-appx-A" rel="noreferrer">Release Notes</a></p> <blockquote> <p>Multiple authentication methods(i.e. LDAP) No</p> </blockquote> <p>While there is no LDAP support, Firebird 2.1 allows Windows authentication. <a href="http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-wintrusted" rel="noreferrer">Release Notes</a></p> <blockquote> <p>Create user defined types? No</p> </blockquote> <p>I'm not sure what the author means here, but Firebird has had domains forever.</p> <blockquote> <p>Require backup/restore to compact? Yes (in red)</p> </blockquote> <p>Arguable. Database space is reused. I find it hard to imagine the need to shrink a database in production.</p> <blockquote> <p>Use POSIX Regular Expressions in queries? No</p> </blockquote> <p>Firebird 2.5 supports regular expressions. <a href="http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-dml-regex" rel="noreferrer">Release Notes</a></p> <blockquote> <p>Database Monitoring? No</p> </blockquote> <p>Yes, Firebird 2.1 supports database monitoring via system tables. Firebird 2.5 adds support to trace facilities.<br> I know at least one excellent <a href="http://sinatica.com/" rel="noreferrer">database monitoring tool for Firebird</a>. ;)</p> <blockquote> <p>Ability to query databases on other servers local or remote. No</p> </blockquote> <p>Firebird 2.5 can query remote databases. <a href="http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-psql-extqry" rel="noreferrer">Release Notes</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload