English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Firebird vs. MySQL

System Properties Comparison Firebird vs. MySQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFirebird  Xexclude from comparisonMySQL  Xexclude from comparison
DescriptionFirebird is an open source RDBMS forked from Borland's InterBaseWidely used open source RDBMS
DB-Engines Ranking measures the popularity of database management systems
Trend Chart
Rank25
Score20.50
Rank2
Score1272.45
Websitewww.firebirdsql.orgwww.mysql.com
Technical documentationwww.firebirdsql.org/­en/­reference-manualsdev.mysql.com/­doc
DeveloperFirebird FoundationOracle since 2010, originally MySQL AB, then Sun
Initial release2000 As fork of Borland's InterBase1995
Current release2.5.3 Security Update 1, December 20145.6.23, February 2015
LicenseOpen Source Initial Developer's Public LicenseOpen Source GPL version 2. Commercial licenses with extended functionallity are available
Database as a Service (DBaaS) Only available as a cloud servicenono
Implementation languageC and C++C and C++
Server operating systemsAIX
FreeBSD
HP-UX
Linux
OS X
server-less Firebird Embedded Server
Solaris
Unix
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Database modelRelational DBMSRelational DBMS Key/Value like access via memcached API
Data schemeyesyes
Typing predefined data types such as float or dateyesyes
Secondary indexesyesyes
SQLyesyes with proprietary extensions
APIs and other access methodsC/C++ API
OLE DB
ADO.NET
JDBC Jaybird
ODBC
ADO.NET
JDBC
ODBC
Supported programming languagesC
C++
Delphi
Java
JavaScript Node.js
Lua
Perl
PHP
Python
Ruby
Ada
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts Stored proceduresPSQLyes proprietary syntax
Triggersyesyes
Partitioning methods Methods for storing different data on different nodesnonehorizontal partitioning in MySQL Cluster
Replication methods Methods for redundantly storing data on multiple nodesnone available via 3rd party productsMaster-master replication
Master-slave replication
MySQL Cluster
MapReducenono
Foreign keys Referential integrityyesyes not for MyISAM storage engine
Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACIDACID not for MyISAM storage engine
Concurrency Support for concurrent manipulation of datayes Features a multi-generational MVCC architecture, readers do not block writersyes table locks or row locks depending on storage engine
Durability Support for making data persistentyesyes
User concepts Access controlUsers with fine-grained authorization conceptUsers with fine-grained authorization concept no user groups or roles
We invite representatives of the system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.
More resources
FirebirdMySQL
Recent citations in the news

Muscle cars to circle I-465 for good cause
24 December 2014, Indianapolis Star

Nashville's public art newly explained, mapped
3 January 2015, The Tennessean

Beyond Proprietary Databases: Helen Borrie on the Future of Firebird
13 June 2004, LinuxInsider.com

LA County's unclaimed dead: How we reported the story
10 November 2014, Los Angeles Times

Open source all the tasks
16 September 2014, opensource.com

provided by Google News

MySQL Cluster: An In-Memory, NoSQL Pioneer?
27 February 2015, InformationWeek

SATA vs. PCIe Solid-State Storage Solutions for MySQL Environments
19 February 2015, InformationWeek

Oracle release open source MySQL Cluster upgrade - Business
27 February 2015, Cloud.com

Fourth Annual Percona Live MySQL Conference and Expo 2015 Features New ...
3 February 2015, Marketwired (press release)

Configuring a MySQL JDBC Connection Pool and JDBC Resource for GlassFish ... - SYS
2 February 2015, CON Media (press release)

provided by Google News

Job opportunities

Database Administrator
Healthcareiq, Palmetto

"Delphi Consultant"
Matrix Technology Group, Cincinnati

Delphi Consultant
IDC Technologies, Cincinnati

Information Systems and Support Personnel
Oregon Employment Department, Tigard

.NET Tech Lead
Pan Asia Resources, Durham

Software Developer (MySQL/Java)
Synergis, Alpharetta

MySQL DBA / Developer
Liberty Personnel Services, Princeton

MySQL DBA
TEKsystems, Seattle

Full Stack PHP/MySQL Developer
Judge Group, San Jose

Software Development Manager- PHP, MySQL, Linux, JavaScript
Cybercoders, Boston




Share this page

Featured Products

The leading Semantic Graph Database - Combine Geospatial, Temporal, and SNA into a single "Golden" query. Free Download.

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

Neo4j, the world's leading graph database, queries connected data 1000x faster than relational databases.
Free Download

Present your product here