DB-EnginesInstaclustr banner English
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Firebird vs. HyperSQL

System Properties Comparison Firebird vs. HyperSQL

Please select another system to include it in the comparison.

Our visitors often compare Firebird and HyperSQL with SQLite, MySQL and PostgreSQL.

Editorial information provided by DB-Engines
NameFirebird  Xexclude from comparisonHyperSQL infoalso known as HSQLDB  Xexclude from comparison
DescriptionFirebird is an open source RDBMS forked from Borland's InterBaseMultithreaded, transactional RDBMS written in Java infoalso known as HSQLDB
Primary database modelRelational DBMSRelational DBMS
Additional database modelsKey-value storeKey-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#29  Overall
#17  Relational DBMS
Rank#51  Overall
#29  Relational DBMS
Technical documentationwww.firebirdsql.org/­en/­reference-manualshsqldb.org/­web/­hsqlDocsFrame.html
DeveloperFirebird Foundation
Initial release2000 infoAs fork of Borland's InterBase2001
Current release3.0.2, March 20172.4.0, April 2017
License infoCommercial or Open SourceOpen Source infoInitial Developer's Public LicenseOpen Source infobased on BSD license
Cloud-based infoOnly available as a cloud servicenono
Implementation languageC and C++Java
Server operating systemsAIX
server-less infoFirebird Embedded Server
All OS with a Java VM infoEmbedded (into Java applications) and Client-Server operating modes
Data schemeyesyes
Typing infopredefined data types such as float or dateyesyes
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.no
Secondary indexesyesyes
SQL infoSupport of SQLyesyes
APIs and other access methodsC/C++ API
JDBC infoJaybird
Supported programming languagesC
JavaScript infoNode.js
All languages supporting JDBC/ODBC
Server-side scripts infoStored proceduresPSQLJava, SQL
Partitioning methods infoMethods for storing different data on different nodesnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesnone infoavailable via 3rd party productsnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID
Concurrency infoSupport for concurrent manipulation of datayes infoFeatures a multi-generational MVCC architecture, readers do not block writersyes
Durability infoSupport for making data persistentyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlUsers with fine-grained authorization conceptfine grained access rights according to SQL-standard

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.

3rd party products and services

We invite representatives of 3rd party vendors to contact us for presenting information about their offerings here.

More resources
FirebirdHyperSQL infoalso known as HSQLDB
Recent citations in the news

Strong demand with Holstein bulls to 4500gns at Kilrea
15 January 2018, Farming Life

Stilata la gara, impegnando 323.118,24 euro, per il servizio per 4 anni di assistenza, manutenzione e fornitura delle ...
15 January 2018, Lamezia Informa (Comunicati Stampa)

The Datsun Should Have Been A Bond. It Became A Monument Instead
21 December 2017, Jalopnik

The Firebird Project's Firebird Relational Database
29 July 2016, Linux Journal

Firebird Database Version 3.0 Released
25 April 2016, iProgrammer

provided by Google News

HyperSQL 2.0:期待5年,新版本终于发布
19 June 2010, InfoQ: 时刻关注企业软件开发领域的变化与创新

DataGrip 1.0: A New IDE for DBs and SQL
31 December 2015, DZone News

Typesafe Announces Scala Language Integrated Connection Kit
8 August 2012, Dr. Dobb's

JetBrains Releases DataGrip 1.0 for SQL DBAs and Developers
24 December 2015, InfoQ.com

JetBrains' IDE für Datenbank-Entwickler ist fertig
17 December 2015, Heise Newsticker

provided by Google News

Job opportunities

Software Engineering Associate - Entry level
Lockheed Martin, Moorestown, NJ

Moorestown, NJ - Software Engineering Intern
Lockheed Martin, Moorestown, NJ

Sales Support Engineer, IPM
Iron Mountain, Norcross, GA

Senior Java Developer
Crescent Solutions, Arlington, VA

jobs by Indeed

Share this page

Featured Products

Neo4j logo

Get your step-by-step guide comparing RDBMS to graph databases, including data models, query languages, and deployment strategies.

Datastax logo

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

Couchbase logo

Power, flexibility & scale.
All open source.
Get started now.

RavenDB logo

.NET & Linux,
try the next level in performance with RavenDB 4.0 where Speed meets ACID.
Free download.

Present your product here