# HyperSQL Reviews **Vendor:** The hsqldb Development Group **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.0/5.0 **Total Reviews:** 22 ## About HyperSQL HSQLDB (HyperSQL DataBase) is a SQL relational database software written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. ## HyperSQL Reviews ### 1. HyperSQL is lightweight database offering great flexibility. **Rating:** 4.5/5.0 stars **Reviewed by:** Mohini S. | Data Scientist, Enterprise (> 1000 emp.) **Reviewed Date:** April 15, 2023 **What do you like best about HyperSQL?** HyperSQL is a lightweight database management system built to enhance flexibility in writing SQL queries and ease database management. It is easy to install and use. It is based on Java and offers a transactional and fast multi-threaded engine with memory and disk-based tables. HyperSQL can flexibly use disk and run in memory completely using faster structures. **What do you dislike about HyperSQL?** HyperSQL is unsuitable for projects with large transactional datasets and shows performance issues with multiple tables. The JDBC connection can get affected when querying large dataset. Overall, the user needs to spend more time understanding the database's error reporting. **What problems is HyperSQL solving and how is that benefiting you?** HyperSQL is an excellent lightweight relational database that can be used with web applications for smaller projects requiring less investment and a quicker development cycle. It offers excellent flexibility and can be plugged into the MVCC framework. ### 2. excellent tool and simple to use **Rating:** 4.0/5.0 stars **Reviewed by:** Julie J. | Ruby Ralls Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 16, 2019 **What do you like best about HyperSQL?** It is a really simple to use tools which may be employed by any form of user for its ease once configuring and putting in. It is written in java and its absolutely multithreaded all told modes. This is the right tool for users or firms that have atiny low or medium info. It is compatible with the MVCC dealings management models. **What do you dislike about HyperSQL?** one of its main faults is that its use is usually recommended solely in little or medium information bases and also the question becomes a touch slow once there are several open tables. Recommendations to others considering the merchandise Do not use this tool in giant information base **What problems is HyperSQL solving and how is that benefiting you?** It is terribly helpful for any form of project, either desktop or net, within which you've got to use a tiny low info and it's additionally a really simple tool to put in and use. ### 3. Very convenient relational database and easy to integrate with all types of data. **Rating:** 3.5/5.0 stars **Reviewed by:** Yash S. | Google Cloud Platform Student Innovator for Google via Vaco, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** February 25, 2019 **What do you like best about HyperSQL?** First thing that comes to mind is the fact that since it is written in Java, it can easily be tweaked. It is a fully managed Relational Database and it offers transactional consistency which is comparable to deploying the database into the cloud. It works and supports a multithreaded environment and there's some synchronization mechanisms incorporated which avoid any issues relating to race conditions. **What do you dislike about HyperSQL?** This database is very problematic for debugging as error reporting is very poor. This puts the onus on the user to dig into the code to find out where an exception is coming from instead of actually using the error text. One example is a simple right hand truncation error where text is too long for the column width. This results in the error message "data exception: string data, right truncation" in which neither the column nor the text value causing the problem is highlighted. Thus, a programmer has to look at all the text columns and text values to check which is causing the problem. That is a major waste of time and constitutes an obnoxious approach to programming. There are plenty of other examples like this so if you can avoid this DB do so until the authors decide that error reporting is important. **Recommendations to others considering HyperSQL:** Using it to improve transactional consistency like Cloud Spanner in the GCP. **What problems is HyperSQL solving and how is that benefiting you?** Colloboration and database orchestration with the Google CLoud Platform is extremely easy. The SQL like queries are realized with Cloud SQL and due to this, we incorporate it along with other open source DBMS namely PostGRESQL. ### 4. Fast & Lightweight open-source database for developers **Rating:** 4.0/5.0 stars **Reviewed by:** Lakshay S. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** February 24, 2019 **What do you like best about HyperSQL?** HyperSQL is one of the most lightweight database programs available across the internet. It provides users with great flexibility in the creation of SQL queries and handling and managing the databases. Few of the prominent features preferred by myself are as follows: 1. Completely multi-threaded that provides the users an amazing speed of working and query execution. 2. Easy configuration of databases along with handling and management. 3. Ability to manage the executing statements by canceling the long-running queries. 4. Support for transaction management through 2PL and MVCC. **What do you dislike about HyperSQL?** There is little standard compliance that leads to low portability of code. The query becomes slow as the database grows and multiple tables are opened up in different windows thus it is good for small and medium-sized databases. **Recommendations to others considering HyperSQL:** I would definitely recommend it to all fellow software engineers and managers who are on the verge of starting up the whole project and requires easy to use and configure programmable DB that is written in Java and supports the features of multi-threading and concurrency management. **What problems is HyperSQL solving and how is that benefiting you?** Simplifies the process of installation and configuration of databases for beginners providing easy to use interface. Amazingly fast for small and medium-sized projects providing easy recovery and backup options. ### 5. Small and fast multi-threaded databases engine **Rating:** 4.5/5.0 stars **Reviewed by:** Shanika R. | SR Full Stack Softwarpere Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 12, 2019 **What do you like best about HyperSQL?** It is fully multi-threaded in all modes and supports the MVCC transaction control models. It supports the broadest range of SQL standard features seen in any open source databases engine **What do you dislike about HyperSQL?** It is only suitable for small databases and lacks many other areas as robustness and availability. **Recommendations to others considering HyperSQL:** For larger data, usefully mature DBMS like SQL / Oracle. **What problems is HyperSQL solving and how is that benefiting you?** We are using it to maintain a database of medium-sized companies. It is very fast and easy to install. ### 6. Needfull One for Small and Medium Databases **Rating:** 4.5/5.0 stars **Reviewed by:** sooraj b. | Cheif Technical Officer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 27, 2019 **What do you like best about HyperSQL?** HyperSql is very easy and simple to install and configure even for beginners it can be configured fast. it's very suitable for small companies having a small database, it uses MVCC transaction control models, it is much faster in in pc environment than any other **What do you dislike about HyperSQL?** exception handling is not much easy, we want to search the entire code for errors, it's not suitable for a large amount of data handling, larger data causes large time to execute **What problems is HyperSQL solving and how is that benefiting you?** managing data of small space companies is very easy. no need for experts to maintain ### 7. Hyper SQL - Easy to utilize and best appropriate for little databases **Rating:** 3.5/5.0 stars **Reviewed by:** Paul M. | Software Analyst , Mid-Market (51-1000 emp.) **Reviewed Date:** February 27, 2019 **What do you like best about HyperSQL?** Hyper Sql is anything but difficult to work on notwithstanding for the amateurs as it is very simple to set up or introduce having easy to understand interface. **What do you dislike about HyperSQL?** Its scalability is constrained. You can pick this for small scale applications/database as it were. **What problems is HyperSQL solving and how is that benefiting you?** HyperSql is valuable in our firm when we produce for little scale applications in light of the fact that with Hyper SQL it ie simple to oversee information all the more productively with much better execution ### 8. Amazing instrument and simple to utilize **Rating:** 4.0/5.0 stars **Reviewed by:** Maynard H. | Senior Q/A Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 27, 2019 **What do you like best about HyperSQL?** It is an exceptionally simple to utilize instruments which can be utilized by a client for its simplicity when designing and introducing. **What do you dislike about HyperSQL?** One of its principle deficiencies is that its utilization is prescribed just in little or medium information bases imagine a scenario in which we need it for greater information bases. its of no utilization at that point. **What problems is HyperSQL solving and how is that benefiting you?** It is valuable for a task, either work area or web, in which you need to utilize a little database. ### 9. Excessively lightweight **Rating:** 4.0/5.0 stars **Reviewed by:** Dale C. | Junior Web Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2019 **What do you like best about HyperSQL?** Setup is momentary and is lightweight. I like the activity methods of the database and would favor the record based mode in the event that you need constant stockpiling. **What do you dislike about HyperSQL?** Not reasonable for a lot of information. It is fitting to utilize databases, for example, PostgreSQL and MySQL. **What problems is HyperSQL solving and how is that benefiting you?** Improvement of a mechanization structure inside the association, containing different parts that interface with a typical database. ### 10. Hyper SQL - Easy to use and best suitable for small databases **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** January 11, 2019 **What do you like best about HyperSQL?** Hyper Sql is very easy to operate on even for the beginners as it is quite easy to set up or install having user friendly interface. It is best suitable for small firms having light weight database. It supports multiprocessing of query execution with proper lock control methods. **What do you dislike about HyperSQL?** Its scalibility is limited. You can opt this for smal scale applications/ database only. **Recommendations to others considering HyperSQL:** Its very useful software for small scale applications as data maintenance is very eas **What problems is HyperSQL solving and how is that benefiting you?** HyperSql is very useful in our firm when we develop for small scale applications because with Hyper SQL it ie easy to manage data more efficiently with much better performance. So its an highly recommended software to every firm especially to those who deals with small applications. ### 11. SQL is Best **Rating:** 3.5/5.0 stars **Reviewed by:** Mohamed A. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 27, 2019 **What do you like best about HyperSQL?** HyperSQL makes utilizing and making SQL databases too simple. We have utilized various SQL projects and this has been the best up until now **What do you dislike about HyperSQL?** The SQL database can end up defiled if your not watchful and that will hurt your records and PC **What problems is HyperSQL solving and how is that benefiting you?** Capacity our SQL information ### 12. Database assistant **Rating:** 4.5/5.0 stars **Reviewed by:** Sanjeet K. | Senior Quality Assurance Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 25, 2019 **What do you like best about HyperSQL?** Customize SQL engine, easily to use with large amount of data.Easy to operate. **What do you dislike about HyperSQL?** Error reporting technique should be better.Slower query and takes longer time to shut down. **What problems is HyperSQL solving and how is that benefiting you?** Maintaining the database for our company. It's extremely fast and easy to use. ### 13. Nice for managing large data **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** February 19, 2019 **What do you like best about HyperSQL?** This system is amazing to work with a large amount of data. We used to manage internal users data at Snapdeal with this amazing tool. **What do you dislike about HyperSQL?** Ofcourse, queries can get tedious, you need to consider the clusters and the impact of query before actually running it. **Recommendations to others considering HyperSQL:** Give better memory management warnings while writing queries(in case user writes a really heavy query) and a better details of realtime ETA. **What problems is HyperSQL solving and how is that benefiting you?** It certainly simplifies the task of managing a large amount of data. ### 14. Hypersql for quering data for visualization **Rating:** 3.0/5.0 stars **Reviewed by:** Nirav L. | Data entry analyst, Enterprise (> 1000 emp.) **Reviewed Date:** February 25, 2019 **What do you like best about HyperSQL?** HyperSql offers a multi threaded and transactional database engine with in-memory and disk-based tables **What do you dislike about HyperSQL?** The powerful SQl command line slows down the system **What problems is HyperSQL solving and how is that benefiting you?** Data visualization for the warehouse and helping the inventory team for real time analysis ### 15. lightweight and compatible for being an application made in Java **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** February 24, 2019 **What do you like best about HyperSQL?** Something important is that it is an application not a database manager, although others see it as a lightweight database engine It is ideal for testing without having to connect to a database manager. **What do you dislike about HyperSQL?** None, does what is required to manage a database **What problems is HyperSQL solving and how is that benefiting you?** It is the closest and lightest I have ever known to help me handle information through SQL statements in an embedded and independent database engine form in my applications. ### 16. Good product to use for Java **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Small-Business (50 or fewer emp.) **Reviewed Date:** April 17, 2019 **What do you like best about HyperSQL?** Works with SQL and with Java products and supports new functions **What do you dislike about HyperSQL?** It should be more user friendly so that non technical people can understand it better **What problems is HyperSQL solving and how is that benefiting you?** I used it with Java and for standard compliance issues ### 17. Fast database engine **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** February 01, 2019 **What do you like best about HyperSQL?** It is written in java. It offers fast, small database engine and offers both in memory and disc based tables. **What do you dislike about HyperSQL?** slower query and takes longer to shutdown when there are lots of tables. **What problems is HyperSQL solving and how is that benefiting you?** Embedded and server mode are available. It includes minimal web server, command line and GUI management tools. It is used as database in open source software projects. ### 18. Hypersql review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 24, 2019 **What do you like best about HyperSQL?** HyperSQL executes completely in memory and it is very fast. It is smaller in size and offers both in memory and disk tables. **What do you dislike about HyperSQL?** It is not suitable for production environment. **What problems is HyperSQL solving and how is that benefiting you?** I uses HyperSQL for evaluating softwares and PCs. ### 19. Great lightweight SQL engine **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Networking | Enterprise (> 1000 emp.) **Reviewed Date:** December 01, 2017 **What do you like best about HyperSQL?** HyperSQL is a very good small SQL engine that I use for in house tool developments. It has a small foot print, to make the java executable manageable. HSQL database is generally much faster in a desktop environment when compared to other standard database engines. **What do you dislike about HyperSQL?** Error reporting needs to be improved for this database. It does not show the exact text which is posing problems. User needs to search the code and find out where an exception is coming from instead of actually using the error text to find it out. **Recommendations to others considering HyperSQL:** Best database engine for small scale projects. Beginners can use this engine for self implemented projects without overhead installations. **What problems is HyperSQL solving and how is that benefiting you?** Extremely useful for small data projects. Easy to install and use ### 20. The database is reliable and of high performance **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** October 17, 2017 **What do you like best about HyperSQL?** 1. HyperSQL database supports lots of SQL Standard features; 2. It offers fast multithreaded database engine. 3. enable cross platform. **What do you dislike about HyperSQL?** First need a Java environment to run HSQLDB **Recommendations to others considering HyperSQL:** HyperSQL is easy to learn, and has stable and excellent performance. Recommend. **What problems is HyperSQL solving and how is that benefiting you?** Create new databases to finish project and learn. ### 21. Small and fast multithreaded database engine **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 01, 2016 **What do you like best about HyperSQL?** Its fully multithreaded in all modes and supports both lolockck based and MVCC transaction control models. It supports widest range of sql standard features seen in any open source database engine **What do you dislike about HyperSQL?** Its just for small databases and lacks in many other areas like robustness and scalability. **Recommendations to others considering HyperSQL:** For larger data use full fledged dbms like sql/oracle. **What problems is HyperSQL solving and how is that benefiting you?** We are using it maintaning the database for mid size company.its extremely fast and easy to install. ### 22. Lightweight, ideal for small scale applications **Rating:** 4.5/5.0 stars **Reviewed by:** Rohit V. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 15, 2015 **What do you like best about HyperSQL?** Setup is instantaneous and is lightweight. I like the operation modes of the database and would prefer the file based mode in case you need persistent storage. In case of temporary storage, use 'in memory' mode. Useful to bundle this database with the product and provide it to users that do not have any database installed. **What do you dislike about HyperSQL?** Not suitable for large amounts of data. It is advisable to use databases such as PostgreSQL and MySQL.. **Recommendations to others considering HyperSQL:** Lightweight and easy to use. **What problems is HyperSQL solving and how is that benefiting you?** Development of an automation framework within the organization, comprising of multiple components that connect to a common database. Using HyperSQL, the end-user need not have a pre-installed database, making the product setup quite simple. - [View HyperSQL pricing details and edition comparison](https://www.g2.com/products/hypersql/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-13+08%3A28%3A36+-0500&secure%5Bsession_id%5D=95bb2952-b10b-458c-89e8-7f11edcc4053&secure%5Btoken%5D=19ff0ac26245dadaf627d269acd0e639a63fc6e31cc0d4e61035997004fbbdde&format=llm_user) ## HyperSQL Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top HyperSQL Alternatives - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - 4.4/5.0 (643 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,574 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (926 reviews)