[ Apache ... Reviews ](https://www.g2.com/products/apache-derby/reviews) [ Apache ... Reviews ](https://www.g2.com/products/apache-derby/reviews) # Apache Derby Features ##### ## Database Features (7) Storage Availability Stability Scalability Security Data Manipulation Query Language Show More ##### ## Support (4) Text Search Provides support for international character sets and full text search. Data Types Supports multiple data types like primitive, structured, document etc. Languages Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. Operating Systems Available on multiple operating systems like Linux, Windows, MacOS etc. Show More ##### ## Security (4) Database Locking Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. Access Control Allows permissions to be granted or revoked in the database, schema or table levels. Encryption Built-in native encryption with enterprise key management. Authentication Provides multi-factor authentication with certificates. Show More ##### ## Performance (5) Disaster Recovery Provides data recovery functionality to protect and restore data in a database. Data Concurrency Allows multi-version concurrency control. Workload Management Handles workloads, from single machines to data warehouses or web services with many concurrent users. Advanced Indexing Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. Query Optimizer Helps interpret SQL queries and determine the fastest method of execution. Show More ##### ## Management (4) Data Schema Data is organized as a set of tables with columns and rows like a table structure. Query Language Allows users to create, update and retrieve data in a database. ACID - Complaint Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. Data Replication Provides log-based or/and trigger-based replication. Show More ## Top-Rated Alternatives [ ![MySQL](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_240340edca859994ec71e4490aa20022/mysql.png "MySQL") MySQL 4.4/5(1,679) ](https://www.g2.com/products/mysql/reviews) [ ![SQLite](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_cf27b7c50adc61e4d44c2ef887f29fa3/sqlite.gif "SQLite") SQLite 4.3/5(261) ](https://www.g2.com/products/sqlite/reviews) [ ![PostgreSQL](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_251be2af3ae607c45c14e816eaa1cf41/postgresql.png "PostgreSQL") PostgreSQL 4.4/5(684) ](https://www.g2.com/products/postgresql/reviews) [ View All Alternatives ](https://www.g2.com/products/apache-derby/competitors/alternatives) Apache Derby Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_cf27b7c50adc61e4d44c2ef887f29fa3/sqlite.gif "Product Avatar Image") SQLite 4.3/5(261) [ Compare Now ](https://www.g2.com/compare/apache-derby-vs-sqlite) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_240340edca859994ec71e4490aa20022/mysql.png "Product Avatar Image") MySQL 4.4/5(1,679) [ Compare Now ](https://www.g2.com/compare/apache-derby-vs-mysql) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_be7892f62be5fe631662c5cc854eb801/hypersql.png "Product Avatar Image") HyperSQL 4/5(22) [ Compare Now ](https://www.g2.com/compare/apache-derby-vs-hypersql) ##### Categories on G2 [ Relational Databases ](https://www.g2.com/categories/relational-databases) ##### Explore More [ Top tools for collaborative recruitment workflows ](https://www.g2.com/discussions/top-tools-for-collaborative-recruitment-workflows)[ What is the best solution for remote hiring interviews? ](https://www.g2.com/discussions/what-is-the-best-solution-for-remote-hiring-interviews)[ What practice management system offers the best analytics features? ](https://www.g2.com/discussions/what-practice-management-system-offers-the-best-analytics-features) [ Best big data solutions for predictive analytics ](https://www.g2.com/discussions/best-big-data-solutions-for-predictive-analytics)[ Best open-source or free AI code generation tools for prototyping on a budget ](https://www.g2.com/discussions/best-open-source-or-free-ai-code-generation-tools-for-prototyping-on-a-budget)[ What legal billing software supports multiple currencies and rates? ](https://www.g2.com/discussions/what-legal-billing-software-supports-multiple-currencies-and-rates) Show More [ Top tools for collaborative recruitment workflows ](https://www.g2.com/discussions/top-tools-for-collaborative-recruitment-workflows)[ What is the best solution for remote hiring interviews? ](https://www.g2.com/discussions/what-is-the-best-solution-for-remote-hiring-interviews)[ What practice management system offers the best analytics features? ](https://www.g2.com/discussions/what-practice-management-system-offers-the-best-analytics-features) [ Best big data solutions for predictive analytics ](https://www.g2.com/discussions/best-big-data-solutions-for-predictive-analytics)[ Best open-source or free AI code generation tools for prototyping on a budget ](https://www.g2.com/discussions/best-open-source-or-free-ai-code-generation-tools-for-prototyping-on-a-budget)[ What legal billing software supports multiple currencies and rates? ](https://www.g2.com/discussions/what-legal-billing-software-supports-multiple-currencies-and-rates)