DB-EnginesExtremeDB Active Replication featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft Access vs. Postgres-XL vs. Sqrrl

System Properties Comparison Microsoft Access vs. Postgres-XL vs. Sqrrl

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMicrosoft Access  Xexclude from comparisonPostgres-XL  Xexclude from comparisonSqrrl  Xexclude from comparison
Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.
DescriptionMicrosoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. infoThe Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)Based on PostgreSQL enhanced with MPP and write-scale-out cluster featuresAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelRelational DBMSRelational DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score114.17
Rank#11  Overall
#7  Relational DBMS
Score0.53
Rank#224  Overall
#110  Relational DBMS
Websitewww.microsoft.com/­en-us/­microsoft-365/­accesswww.postgres-xl.orgsqrrl.com
Technical documentationdeveloper.microsoft.com/­en-us/­accesswww.postgres-xl.org/­documentation
DeveloperMicrosoftAmazon infooriginally Sqrrl Data, Inc.
Initial release19922014 infosince 2012, originally named StormDB2012
Current release1902 (16.0.11328.20222), March 201910 R1, October 2018
License infoCommercial or Open Sourcecommercial infoBundled with Microsoft OfficeOpen Source infoMozilla public licensecommercial
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++CJava
Server operating systemsWindows infoNot a real database server, but making use of DLLsLinux
macOS
Linux
Data schemeyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes infoXML type, but no XML query functionality
Secondary indexesyesyesyes
SQL infoSupport of SQLyes infobut not compliant to any SQL standardyes infodistributed, parallel query executionno
APIs and other access methodsADO.NET
DAO
ODBC
OLE DB
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languagesC
C#
C++
Delphi
Java (JDBC-ODBC)
VBA
Visual Basic.NET
.Net
C
C++
Delphi
Erlang
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresyes infosince Access 2010 using the ACE-engineuser defined functionsno
Triggersyes infosince Access 2010 using the ACE-engineyesno
Partitioning methods infoMethods for storing different data on different nodesnonehorizontal partitioningSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.
Foreign keys infoReferential integrityyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infobut no files for transaction loggingACID infoMVCCAtomic updates per row, document, or graph entity
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infobut no files for transaction loggingyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.no
User concepts infoAccess controlno infoa simple user-level security was built in till version Access 2003fine grained access rights according to SQL-standardCell-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,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Microsoft AccessPostgres-XLSqrrl
DB-Engines blog posts

MS Access drops in DB-Engines Ranking
2 May 2013, Paul Andlinger

Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking
3 December 2012, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Survey: MS Patients, Nurses Prefer Sensoready Pen for Injecting Kesimpta
17 February 2021, Multiple Sclerosis News Today

Director of Monitoring, Evaluation, Adaptation, and Learning (MEAL)
26 February 2021, ReliefWeb

Web Development Vs. Software Development: Know the Difference
5 February 2021, Customer Think

Ebola Response Consultants
23 February 2021, ReliefWeb

Assistant Manager, Business Support, Corporate Solutions
23 February 2021, eFinancialCareers

provided by Google News

Building a scalable PostgreSQL solution
14 April 2019, Packt Hub

When PostgreSQL Doesn't Scale Well Enough
18 April 2016, DZone News

The States Can't Blockchain - CoinDesk
1 March 2020, Coindesk

PostgreSQL vs. Hadoop
20 August 2016, DZone News

Citus Data open sources tool for scalable, transactional Postgres – Gigaom
4 December 2014, Gigaom

provided by Google News

User And Entity Behavior Analytics Market Technological Progress, Regional Outlook by players – Niara Inc, Sqrrl Data,Inc, Rapid7, Varonis Systems, Bay Dynamics, Exabeam, Bottomline Technologies,Inc, Observe IT, Gurucul, Splunk Inc., Securonix, Dtex Systems
25 February 2021, NeighborWebSJ

Artificial Intelligence in Security Market 2021 by Technology Advancement and Business Outlook – IBM Corporation, Cisco Systems Inc, etc – KSU | The Sentinel Newspaper
11 February 2021, KSU | The Sentinel Newspaper

User And Entity Behavior Analytics Market Dynamics, Forecast, Global Analysis of Players – Bottomline Technologies?Inc, Niara Inc, Varonis Systems, Sqrrl Data?Inc, Bay Dynamics, Exabeam, Rapid7, Splunk Inc., Securonix, Observe IT, Dtex Systems, Gurucul
22 February 2021, NY Market Reports

Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
23 January 2018, CNBC

FinTech Changing the Future of Asset Management Sector
25 February 2021, BW Businessworld

provided by Google News

Job opportunities

General Clerk I
Koniag, Inc., Covington, TN

GIS Specialist I
Anne Arundel County, MD, Annapolis, MD

Sr MS Access Developer
Fully Staffed, Atlanta, GA

General Clerk I
Koniag, Inc., Annapolis, MD

General Clerk I
Koniag, Inc., Mc Queeney, TX

Security Operations and Incident Response Deputy Lead
ShorePoint, Bethesda, MD

Mid Level Security Engineer
XOR Security, Falls Church, VA

jobs by Indeed




Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here