DBMS > Drizzle vs. PostgreSQL vs. Sqrrl
System Properties Comparison Drizzle vs. PostgreSQL vs. Sqrrl
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Drizzle Xexclude from comparison||PostgreSQL Xexclude from comparison||Sqrrl Xexclude from comparison|
|Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.|
|Description||MySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||Adaptable, secure NoSQL built on Apache Accumulo|
|Primary database model||Relational DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Document store|
Wide column store
|Secondary database models||Document store|
|Developer||Drizzle project, originally started by Brian Aker||PostgreSQL Global Development Group www.postgresql.org/developer||Amazon originally Sqrrl Data, Inc.|
|Initial release||2008||1989 1989: Postgres, 1996: PostgreSQL||2012|
|Current release||7.2.4, September 2012||12.0, October 2019|
|License Commercial or Open Source||Open Source GNU GPL||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.
|Server operating systems||FreeBSD|
|Typing predefined data types such as float or date||yes||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||yes specific XML-type available, but no XML query functionality.|
|SQL Support of SQL||yes with proprietary extensions||yes standard with numerous extensions||no|
|APIs and other access methods||JDBC||ADO.NET|
native C library
streaming API for large objects
RESTful HTTP API
|Supported programming languages||C|
C using GLib
|Server-side scripts Stored procedures||no||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||no|
|Triggers||no hooks for callbacks inside the server can be used.||yes||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding making use of Hadoop|
|Replication methods Methods for redundantly storing data on multiple nodes||Master-master replication|
|Master-slave replication other methods possible by using 3rd party extensions||selectable replication factor making use of Hadoop|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||yes|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency Document store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.|
|Foreign keys Referential integrity||yes||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||Atomic updates per row, document, or graph entity|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no|
|User concepts Access control||Pluggable authentication mechanisms e.g. LDAP, HTTP||fine grained access rights according to SQL-standard||Cell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||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!|
SQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.
DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
pgDash: In-Depth PostgreSQL Monitoring.
Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.
2ndQuadrant: PostgreSQL Solutions for the Enterprise.
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
MySQL won the April ranking; did its forks follow?
PostgreSQL is the DBMS of the Year 2018
|Recent citations in the news|
Introducing PostgREST, a REST API for any PostgreSQL database written in Haskell
NoSQL Market 2019 Trend - Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database
Microsoft announces reserved capacity offerings for six more Azure services
Greenplum 6 review: Jack of all trades, master of some
provided by Google News
[Tech30] These industry veterans’ startup encourages millennials to save and invest money smartly
User And Entity Behavior Analytics Market 2019-2025 | Rapid7, Varonis Systems, Gurucul, Niara, Inc, Sqrrl Data
Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
Meet memory expert Chester Santos (and other top stories of the day)
Cloud Database Security Market-Segmented By Solution (IAM, Cloud Data and CDN), By End-User Vertical (BFSI, Retail, Government), and Region-Growth, Trends and Forecasts (2019-2023)
provided by Google News
Database Administrator, Digital Commerce Platform
Database Administrator, Junior
Systems Analyst/Product Administrator, Bureau of Application Development and Database Administration
Oracle Database Administrator II
ENTRY LEVEL Software Developer - Full Stack Developer
Cybersecurity Threat Hunter
NASA Cyber Hunt Analyst
Information Security Analyst
Network Security Engineer
Security Operations Center (SOC) Analyst (Night Shift)
Share this page