Create entry

firebird vs. MySQL

firebird MySQL + Add column
Preference 50% votes 50% votes
Website www.​firebirdsql.​org www.​mysql.​com
Database model
Data storage
Embeddable Yes Yes
Query language
Data types
Conditional entry updates Yes Yes
Map and reduce No No
Unicode Yes Yes
TTL for entries ? No
Compression ? Yes
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes Yes
Revision control Yes Yes
Locking model
Secondary Indexes Yes Yes
Composite keys Yes Yes
Full text search ? Yes
Geospatial Indexes ? Yes
Graph support Yes No
Horizontal scalable No Yes
Replication No Yes
Replication mode ?
Sharding ? Yes
Shared nothing architecture Yes No
Value size max. 32 TB 10 EB
System requirements
Operating system
Native driver
Memory minimum 2 MB 11 MB
Programming language
Description Relational Database Management System Relational database system
Multi-user system Yes Conditional
Multilingual content Yes Yes
Price rating ★★★★☆ ★★★★★
WYSIWYG-Editor Yes ?
Multiple projects Yes Yes
Software distribution
Release Date 24ᵗʰ March 2013 May 1995
Documentation level ★★★★☆ ★★★★☆
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics Yes Conditional
Web interface Yes Yes
Data encryption Yes Yes
Online backup Yes Yes
Download www.​firebirdsql.​org/​en/​fi…-2-5-2-upd1/​ dev.​mysql.​com/​downloads/​
Backup functionality Good Good
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★★★
Free for commercial use Yes Yes
Sorts Yes Yes
Open Source Yes Yes
Triggers Yes Yes
Perfomance ★★★☆☆ ★★★★☆
ORM Join Support Yes ?
Stored Procedure Yes Yes
Free edition Yes Yes
Monitoring UI Yes Yes
CLI` Yes Yes
¿Es una Cagada? No ?
Brand ?
Extension/Plug-in ? Yes
Standard compliance ? Yes
Object-Relational Mapping (ORM) ? No
RESTful ? No
Lines of code ? 1 100 k
Community Driven ? Good
API ? Good
Cloud platform support ?
Partial Index ? Yes
Function Based Index ? Yes
Key length max ? 3 072
Log ? Yes
Implementation flexibility (0% global votes) (21% global votes)
In-Place Update ? No
Tuneable write concerns ? Yes
Cloud-enabled ? Yes
Multivariate Testing ? No
Materialized Views ? No
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Geospatial ? Yes
Text Analytics ? Yes
Server Side Java Script ? No
JSON ? Yes
Flexible Table(Schema) ? No
Geo-distributed ? No
Concurrency ? Yes
24/7 support ? Yes
SQL Queries ? Yes
3D Support ? Yes
Online backup (no locking) ? Yes
Abstracts complexity of UI Components ? Yes
Point In Time Recovery ? Yes
Does remove features when broken? ? Yes
+ Add row ++
firebird MySQL
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.