DBMS > FileMaker vs. OpenSearch vs. Postgres-XL
System Properties Comparison FileMaker vs. OpenSearch vs. Postgres-XL
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||FileMaker Xexclude from comparison||OpenSearch Xexclude from comparison||Postgres-XL Xexclude from comparison|
|Description||FileMaker is a cross-platform RDBMS that includes a GUI frontend.||A distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache Lucene||Based on PostgreSQL enhanced with MPP and write-scale-out cluster features|
|Primary database model||Relational DBMS||Search engine||Relational DBMS|
|Secondary database models||Vector DBMS||Document store|
|Developer||FileMaker a subsidiary of Apple||Amazon Web Services|
|Initial release||1983||2021||2014 since 2012, originally named StormDB|
|Current release||19.4.1, November 2021||2.5.0, January 2023||10 R1, October 2018|
|License Commercial or Open Source||commercial||Open Source Apache Version 2.0||Open Source Mozilla public license|
|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.
|Aiven for OpenSearch: Fully managed open source search and analytics suite including search engine, NoSQL document database, and visualization interface.|
|Server operating systems||iOS client part only|
|All OS with a Java VM||Linux|
|Data scheme||yes||schema-free Flexible type definitions. Once a type is defined, it is persistent||yes|
|Typing predefined data types such as float or date||yes||yes||yes|
|yes A http query request can return the data in XML format||yes XML type, but no XML query functionality|
|Secondary indexes||yes||yes All search fields are automatically indexed||yes|
|SQL Support of SQL||yes via plugins||SQL-like query language||yes distributed, parallel query execution|
|APIs and other access methods||Filemaker WebDirect|
RESTful HTTP/JSON API
native C library
streaming API for large objects
|Supported programming languages||PHP||Go|
Ruby Elasticsearch client
|Server-side scripts Stored procedures||yes||yes||user defined functions|
|Triggers||yes||yes by using the 'percolation' feature||yes|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding||horizontal partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication, warm standby since Version 14||yes|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency Synchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, all||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||no||ACID MVCC|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|User concepts Access control||simple rights management via user accounts and connection to external directory services||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||OpenSearch is a highly scalable and extensible open-source software suite for search,...|
|Competitive advantages||Distributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...|
|Typical application scenarios||OpenSearch is used across a broad range of search, analytics, and observability applications....|
|Licensing and pricing models||The OpenSearch Project offers open source software licensed under Apache License...|
|Related products and services|
|3rd parties||Aiven for OpenSearch comes with OpenSearch Dashboards included, giving a fully-featured user interface and visualization platform for your data.
|Recent citations in the news|
No Code Platform Software Market Share, Size and Forecast to ...
Low-Code Development Platforms Software Market Analysis, 2031
[New Study] 2023 Low-Code Development Platforms Software ...
No-Code Development Platforms Software Market is Expected to ...
Global Rapid Application Development (RAD) Software Market Opportunity [2023-2030] | Market Cap Expected
provided by Google News
37signals claims cloud repatriation saved it $1m
Somehow OpenSearch has succeeded
Vector Engine for Amazon Opensearch Serverless Now in Preview
Oracle CloudWorld 2023: a rundown of Big Red's latest news
AWS Announces Amazon OpenSearch Ingestion for Streamlined ...
provided by Google News
Building a scalable PostgreSQL solution
Переход с Oracle на PostgreSQL: подробное руководство по ...
每日一博- MPP（Massively Parallel Processing，大规模并行处理 ...
PostgreSQLをスケールアウトさせるには？ | NTTデータ
provided by Google News
Operations Assistant - Audio - Open to remote
FileMaker Associate Developer (Open to Remote)
Security Guard 3pm -11pm
Infrastructure Engineer (Remote) - US
OpenSearch and VectorSearch Full Stack Developer
OpenSearch/ElasticSearch Administrator (Remote)
Database / Systems Engineer
Share this page