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 ? No
Shared nothing architecture ? Yes
Value size max. ? 10 B
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
WYSIWYG-Editor Yes ?
Multiple projects Yes Yes
Software distribution
Release Date 24ᵗʰ March 2013 1995
Documentation level ★★★★☆ ★★★★☆
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics Yes Conditional
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
¿Es una Cagada? No ?
Brand ?
Extension/Plug-in ? Yes
Price rating ? ★★★★☆
Standard compliance ? Yes
Object-Relational Mapping (ORM) ? No
RESTful ? No
Lines of code ? 1 100 k
Creation Date ? 1995
Community Driven ? Good
Web interface ? Yes
Data encryption ? Yes
Cloud platform support ?
Partial Index ? Yes
Function Based Index ? Yes
Key length max ? 3 072
Log ? Yes
Implementation flexibility (0% global votes) (18% 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
Max rows in query result ? 1 000 000
Concurrency ? Yes
24/7 support ? No
SQL Queries ? Yes
Online backup (no locking) ? Yes
CLI` ? Yes
Abstracts complexity of UI Components ? Yes
; drop table users; ? No
+ 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.