DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > FileMaker vs. mSQL vs. Oracle vs. PostGIS

System Properties Comparison FileMaker vs. mSQL vs. Oracle vs. PostGIS

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFileMaker  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparisonOracle  Xexclude from comparisonPostGIS  Xexclude from comparison
DescriptionFileMaker is a cross-platform RDBMS that includes a GUI frontend.mSQL (Mini SQL) is a simple and lightweight RDBMSWidely used RDBMSSpatial extension of PostgreSQL
Primary database modelRelational DBMSRelational DBMSRelational DBMSSpatial DBMS
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score52.80
Rank#21  Overall
#14  Relational DBMS
Score1.51
Rank#173  Overall
#85  Relational DBMS
Score1247.52
Rank#1  Overall
#1  Relational DBMS
Score29.81
Rank#28  Overall
#1  Spatial DBMS
Websitewww.claris.com/­filemakerhughestech.com.au/­products/­msqlwww.oracle.com/­databasepostgis.net
Technical documentationwww.claris.com/­resources/­documentationdocs.oracle.com/­en/­databasepostgis.net/­documentation
DeveloperFileMaker infoa subsidiary of AppleHughes TechnologiesOracle
Initial release1983199419802005
Current release19.4.1, November 20214.4, October 202121c, January 20213.3.2, November 2022
License infoCommercial or Open Sourcecommercialcommercial infofree licenses can be providedcommercial inforestricted free version is availableOpen Source infoGPL v2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC and C++C
Server operating systemsiOS infoclient part only
Linux
OS X
Windows
AIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data schemeyesyesyes infoSchemaless in JSON and XML columnsyes
Typing infopredefined data types such as float or dateyesyesyesyes
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 infoA http query request can return the data in XML formatnoyesyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyes infovia pluginsA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggersyes infowith proprietary extensionsyes
APIs and other access methodsFilemaker WebDirect
JDBC
ODBC
JDBC
ODBC
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Supported programming languagesPHPC
C++
Delphi
Java
Perl
PHP
Tcl
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Server-side scripts infoStored proceduresyesnoPL/SQL infoalso stored procedures in Java possibleuser defined functions
Triggersyesnoyesyes
Partitioning methods infoMethods for storing different data on different nodesnonenoneSharding, horizontal partitioningyes infobased on PostgreSQL
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replication, warm standby infosince Version 14noneMulti-source replication
Source-replica replication
yes infobased on PostgreSQL
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono infocan be realized in PL/SQLno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACID infoisolation level can be parameterizedACID
Concurrency infoSupport for concurrent manipulation of datayesnoyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'no
User concepts infoAccess controlsimple rights management via user accounts and connection to external directory servicesnofine grained access rights according to SQL-standardyes infobased on PostgreSQL

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
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

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

More resources
FileMakermSQL infoMini SQLOraclePostGIS
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Spatial database management systems
6 April 2021, Matthias Gelbmann

show all

Recent citations in the news

No-Code Development Platforms Software Market 2022 Segments ...
6 February 2023, Trending in Pakistan

Claris’s Plans for FileMaker Bode Well for Individual Users
23 August 2022, TidBITS

Claris FileMaker Pro & FileMaker Server updated with macOS Ventura compatibility
30 November 2022, AppleInsider

Claris Is Renaming FileMaker
2 September 2022, Daring Fireball

Apple subsidiary Claris releases FileMaker 19.5 with new features and improvements
17 June 2022, 9to5Mac

provided by Google News

Make Your MySQL Server More Secure With These 7 Steps - MUO
1 December 2022, MakeUseOf

Writing a Web Service in Perl
13 July 2018, PCQuest

Higher Education PS rules out ghost students before PAC - Zambia
29 November 2018, diggers.news

provided by Google News

Monitoring Oracle Servers With Checkmk
31 January 2023, Linux Journal

Oracle is on a mission to become the 'Netflix of AI'
1 February 2023, SiliconANGLE News

Red Hat and Oracle expand collaboration to bring Red Hat Enterprise Linux to Oracle Cloud Infrastructure
7 February 2023, ZAWYA

IBM boosts Power CPU core count…for Oracle
17 January 2023, Network World

Oracle Named a Leader and Positioned Highest for Ability to ...
30 January 2023, PR Newswire

provided by Google News

Job opportunities

Practice Manager
DrSnip - The Vasectomy Clinic, Seattle, WA

Processor
Tubs To Go!, Inc., Lynnwood, WA

Data Entry Specialist (REMOTE OPPORTUNITY)
DISA Global Solutions, Remote

Join Codence (open application)
Codence, Denver, CO

LN Concerts, Ticketing & Systems Administrator
Live Nation, Remote

Developer
Medical Guardian LLC, Philadelphia, PA

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here