HSQLDB supports different database modes, which determine how the database operates and how it can be accessed. The main database modes in HSQLDB are :
In-Process (Embedded) Mode : In this mode, the database engine runs within the same Java Virtual Machine (JVM) as the application using it. The database is typically created and managed programmatically by the application. Embedded mode is suitable for small-scale applications where the database is tightly integrated with the application logic and does not need to be accessed by other processes or applications.
Server Mode : In server mode, the HSQLDB database operates as a standalone server process, independent of the application using it. Multiple client applications can connect to the database server over a network, allowing concurrent access and multi-user support. Server mode is suitable for client-server applications, web applications, and scenarios where the database needs to be accessed by multiple processes or applications simultaneously.
Each database mode in HSQLDB has its advantages and use cases :Embedded Mode :
* Simple deployment: No separate database server process is required.
* Tight integration: The database is closely integrated with the application logic.
* Single-user access: Typically used for single-user desktop applications or small-scale embedded systems.
Server Mode :
* Multi-user support: Allows multiple clients to access the database concurrently.
* Network access: Clients can connect to the database server over a network.
* Scalability: Suitable for applications requiring scalability and concurrent access.
