Create entry

Berkeley DB vs. MySQL

Berkeley DB MySQL + Add column
Category
Preference (43% global votes) (29% global votes)
Website www.​oracle.​com/​database/​b…b/​index.​html 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 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 No Yes
Revision control ? Yes
Locking model ?
Indexing
Secondary Indexes Yes Yes
Composite keys Yes Yes
Full text search Yes Yes
Geospatial Indexes No Yes
Graph support No No
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding No No
Shared nothing architecture ? Yes
Restrictions
Value size max. 4 GB 10 B
System requirements
Operating system
Native driver
Memory minimum ? 11 MB
Architecture
Programming language
More
Description key/value database Relational database system
Brand
Multi-user system Yes Conditional
Documentation level ★★★★☆ ★★★★☆
Lines of code 1 748 k 1 100 k
Distributed Counter Yes ?
Free to use Yes Yes
Active Yes Yes
Creation Date 1994 1995
Community Driven Good Good
Log Yes Yes
Download www.​oracle.​com/​technetwor…iteId=ocomen dev.​mysql.​com/​downloads/​
Free for commercial use No Yes
Sorts Yes Yes
Corruption Resistant No ?
Extension/Plug-in ? Yes
Database ?
Multilingual content ? Yes
Price rating ? ★★★★☆
Multiple projects ? Yes
Standard compliance ? Yes
Software distribution ?
Object-Relational Mapping (ORM) ? No
Release Date ? 1995
RESTful ? No
Database Connection Pooling ? Yes
Real time analytics ? Conditional
Web interface ? Yes
Data encryption ? Yes
Cloud platform support ?
Online backup ? Yes
Partial Index ? Yes
Function Based Index ? Yes
Key length max ? 3 072
Implementation flexibility (0% global votes) (18% global votes)
Backup functionality ? Good
Query Cache ? Yes
Ease of use ? ★★★★★
In-Place Update ? No
Tuneable write concerns ? Yes
Open Source ? Yes
Triggers ? Yes
Perfomance ? ★★★★☆
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
Stored Procedure ? Yes
Concurrency ? Yes
24/7 support ? No
Free edition ? Yes
SQL Queries ? Yes
Monitoring UI ? Yes
Online backup (no locking) ? Yes
CLI` ? Yes
Abstracts complexity of UI Components ? Yes
; drop table users; ? No
+ Add row ++
Berkeley DB 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