Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Welcome to H2, a Java SQL database designed for efficient data management. In its embedded mode, an application can access the database directly within the same Java Virtual Machine (JVM) using JDBC, making it the quickest and simplest connection method available. However, a drawback of this setup is that the database can only be accessed by one virtual machine and class loader at a time. Like other modes, it accommodates both persistent and in-memory databases without restrictions on the number of simultaneous database accesses or open connections. On the other hand, the mixed mode combines features of both embedded and server modes; the initial application that connects to the database operates in embedded mode while simultaneously launching a server to enable other applications in different processes or virtual machines to access the same data concurrently. This allows local connections to maintain the high speed of the embedded mode, whereas remote connections may experience slight delays. Overall, H2 provides a flexible and robust solution for various database needs.
Description
Perst is an open source, dual-licensed object-oriented embedded database management system (ODBMS) created by McObject. It comes in two versions: one designed as an all-Java embedded database and another tailored for C# applications within the Microsoft .NET Framework. This database system enables developers to efficiently store, sort, and retrieve objects, ensuring high speed while maintaining low memory and storage requirements. By utilizing the object-oriented features of both Java and C#, Perst showcases a significant performance edge in benchmarks like TestIndex and PolePosition when compared to other embedded database solutions in Java and .NET. One of its standout capabilities is its ability to store data directly in Java and .NET objects, which eliminates the need for translation typical in relational and object-relational databases, thereby enhancing run-time performance. With a compact core comprised of only five thousand lines of code, Perst demands minimal system resources, making it an attractive option for resource-constrained environments. This efficiency not only benefits developers but also contributes to the overall responsiveness of applications utilizing the database.
API Access
Has API
No
API Access
Has API
Yes
Integrations
.NET
No
Airtool
Yes
C#
No
Chat2DB
Yes
DOT Anonymizer
Yes
DataGrip
Yes
DbVisualizer
Yes
DigDash
Yes
Java
No
Metabase
Yes
Integrations
.NET
Yes
Airtool
No
C#
Yes
Chat2DB
No
DOT Anonymizer
No
DataGrip
No
DbVisualizer
No
DigDash
No
Java
Yes
Metabase
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
Free
Free Trial
Yes
Free Version
Yes
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
Yes
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
Yes
In Person
Yes
Vendor Details
Company Name
H2
Website
www.h2database.com/html/main.html
Vendor Details
Company Name
McObject
Founded
2001
Country
United States
Website
www.mcobject.com/perst/
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No
Relational Database
ACID Compliance
No
Data Failure Recovery
No
Multi-Platform
No
Referential Integrity
No
SQL DDL Support
No
SQL DML Support
No
System Catalog
No
Unicode Support
No