Create entry

InterBase vs. MySQL

InterBase MySQL + Add column
Category
Preference (33% global votes) (29% global votes)
Website www.​embarcadero.​com/​products/​interbase www.​mysql.​com
License
Design
Database model
Data storage ?
Embeddable Yes Yes
Features
Query language
Data types ?
Conditional entry updates Yes Yes
Map and reduce No No
Unicode Yes Yes
TTL for entries ? No
Compression Yes Yes
Integrity
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
Locking model
Indexing
Secondary Indexes No Yes
Composite keys No Yes
Full text search Yes Yes
Geospatial Indexes ? Yes
Graph support ? No
Distribution
Horizontal scalable ? Yes
Replication No Yes
Replication mode ?
Sharding ? Yes
Shared nothing architecture ? No
Restrictions
Value size max. ? 10 EB
System requirements
Operating system
Native driver ?
Memory minimum ? 11 MB
Architecture
Programming language
More
Brand
Multi-user system Yes Conditional
Database
Price rating ★★★★☆ ★★★★★
Documentation level ★★☆☆☆ ★★★★☆
Free to use Conditional Yes
Active Yes Yes
Online backup Yes Yes
Backup functionality Good Good
Query Cache No Yes
Ease of use ★★★★☆ ★★★★★
Free for commercial use No Yes
Open Source No Yes
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★☆
Does your mom understand it No ?
Description ? Relational database system
Extension/Plug-in ? Yes
Multilingual content ? Yes
Multiple projects ? Yes
Standard compliance ? Yes
Software distribution ?
Object-Relational Mapping (ORM) ? No
Release Date ? May 1995
RESTful ? No
Lines of code ? 1 100 k
Database Connection Pooling ? Yes
Real time analytics ? Conditional
Community Driven ? Good
Web interface ? Yes
Data encryption ? Yes
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)
Download ? dev.​mysql.​com/​downloads/​
In-Place Update ? No
Sorts ? Yes
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
Stored Procedure ? Yes
Concurrency ? Yes
24/7 support ? Yes
Free edition ? Yes
SQL Queries ? Yes
3D Support ? Yes
Monitoring UI ? Yes
Online backup (no locking) ? Yes
CLI` ? Yes
Abstracts complexity of UI Components ? Yes
Point In Time Recovery ? Yes
Does remove features when broken? ? Yes
+ Add row ++
InterBase 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
    darker
    = better
    Legend
  • 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.

Type
Review
Comment