DBMS > LokiJS vs. PostgreSQL vs. VelocityDB
System Properties Comparison LokiJS vs. PostgreSQL vs. VelocityDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||LokiJS Xexclude from comparison||PostgreSQL Xexclude from comparison||VelocityDB Xexclude from comparison|
|Primary database model||Document store||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Graph DBMS|
Object oriented DBMS
|Secondary database models||Document store|
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||VelocityDB Inc|
|Initial release||2014||1989 1989: Postgres, 1996: PostgreSQL||2011|
|Current release||12.3, May 2020||7.x|
|License Commercial or Open Source||Open Source||Open Source BSD||commercial|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Any that supports .NET|
|Typing predefined data types such as float or date||no||yes||yes|
|no||yes specific XML-type available, but no XML query functionality.||no|
|Secondary indexes||yes via views||yes||yes|
|SQL Support of SQL||no||yes standard with numerous extensions||no|
native C library
streaming API for large objects
|Triggers||yes||yes||Callbacks are triggered when data changes|
|Partitioning methods Methods for storing different data on different nodes||none||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||none||Source-replica replication other methods possible by using 3rd party extensions|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||none||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no atomic operations within a single collection possible||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes|
|Durability Support for making data persistent||yes Serialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.||yes||yes|
|User concepts Access control||no||fine grained access rights according to SQL-standard||Based on Windows Authentication|
More information provided by the system vendor
|Related products and services|
|3rd parties||pgDash: In-Depth PostgreSQL Monitoring. |
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
2ndQuadrant: Mission Critical Databases.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
CYBERTEC: your professional partner for PostgreSQL services and Data Science based on PostgreSQL since 2000. With offices in Austria, Uruguay, Estonia and Switzerland, CYBERTEC operates worldwide!
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018
|Conferences and events|
PostgreSQL Online Trainings
|Recent citations in the news|
Fast, Lightweight Data Storage for Cordova Apps with LokiJS
NativeScript 6 Goes Webpack All The Way
The world is swimming in open source, but only one company is making any money
provided by Google News
Crunchy Certified PostgreSQL 12 Achieves In Evaluation Status for Common Criteria Certification
Swarm64 Announces Strategic Partnership With Command Prompt, Inc.
maintain a postgresql database using osm2pgsql - Linux & Unix
PostgreSQL Multi-Model Graph Extension Announced
provided by Google News
Jr. QA Analyst Trainee
Data Technician (Full- or Part-Time)
Fall 2020 DNC Technology Internship
Share this page