Create entry

Postgres vs. LMDB

Postgres LMDB + Add column
Description Relational Database System Memory-Mapped, Copy-on-Write
Multi-user system Yes Yes
Extension/Plug-in Yes ?
Operating system
Programming language
Website www.​postgresql.​org symas.​com/​mdb
Multilingual content Yes ?
Database model
Query language
Transactions Yes Yes
Unicode Yes No
Referential integrity Yes No
Price rating ★★★★★ ★★★★★
WYSIWYG-Editor No ?
Standard compliance Yes ?
Sharding No No
Replication Yes No
Map and reduce No No
Revision control Yes No
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Horizontal scalable Yes No
Integrity model
Software distribution
Full text search Yes No
Preference (78% global votes) (57% global votes)
Object-Relational Mapping (ORM) Yes ?
Documentation level ★★★★★ ★★★★★
Lines of code 733 k 7 k
TTL for entries No No
Conditional entry updates Yes No
Composite keys Yes No
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes ?
Compression Yes No
Real time analytics Yes Yes
Creation Date 1989 2009
Community Driven Good Good
Shared nothing architecture Yes ?
Web interface Yes ?
Data encryption Yes ?
Secondary Indexes Yes No
Embeddable No Yes
Geospatial Indexes Yes No
Locking model
Data storage
Replication mode
Native driver
Cloud platform support ?
Online backup Yes Yes
Data types
Partial Index Yes ?
Function Based Index Yes No
Log Yes ?
Download www.​postgresql.​org/​download/​ gitorious.​org/​mdb
Query Cache Yes No
Ease of use ★★★★☆ ★★★★☆
In-Place Update Yes Yes
Free for commercial use Yes Yes
Sorts Yes Yes
Tuneable write concerns Yes ?
Open Source Yes Yes
Triggers Yes ?
Perfomance ★★★★★ ★★★★★
Materialized Views Yes ?
Spring Data Support Yes ?
Geospatial Yes ?
Text Analytics Yes ?
Server Side Java Script Yes ?
JSON Yes Yes
Stored Procedure Yes ?
Free edition Yes ?
SQL Queries Yes ?
Network datatype Yes ?
CLI` Yes ?
But can you use it on a cold rainy night in stoke? Yes ?
Does your boss understand it? Yes ?
Memory minimum ? 64 kB
Release Date ? September 2011
Value size max. ? 4 GB
API ? Basic
Graph support ? No
Implementation flexibility (0% global votes) (50% global votes)
Backup functionality ? Good
Read preferences ? No
Maximum size ? 9.2 EB
Batch Loading ? Yes
Corruption Resistant ? Yes
+ Add row ++
Postgres LMDB
  • 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.