SnappyData Community Edition (Open Source)¶
Starting with the 1.3.0 release, SnappyData Community Edition gets close to the erstwhile TIBCO ComputeDB Enterprise Edition in terms of the features. Apart from the GemFire connector (that depends on non-OSS Pivotal GemFire jars), the 1.3.0/1.3.1 Community Editions exceed the previous TIBCO ComputeDB Enterprise Edition 1.2.0 in both features and performance. You can find a list of new features and performance improvements in the release notes.
The features hitherto available only in Enterprise edition - Off-heap storage for column tables, Approximate Query Processing, LDAP-based Authentication and Authorization, ODBC driver, to name a few - are now available in SnappyData (community edition) as well.
The high level capabilities of the Community Edition are listed in the following table:
| Feature | Available |
|---|---|
| Mutable Row and Column Store | X |
| Compatibility with Spark | X |
| Shared Nothing Persistence and HA | X |
| REST API for Spark Job Submission | X |
| Fault Tolerance for Driver | X |
| Access to the system using JDBC Driver | X |
| CLI for backup, restore, and export data | X |
| Spark console extensions | X |
| System Performance/behavior statistics | X |
| Support for transactions in Row tables | X |
| Support for indexing in Row tables | X |
| Support for snapshot transactions in Column tables | X |
| Online compaction of column block data | X |
| Transparent disk overflow of large query results | X |
| Support for external Hive meta store | X |
| SQL extensions for stream processing | X |
| SnappyData sink for structured stream processing | X |
| Structured Streaming user interface | X |
| Runtime deployment of packages and jars | X |
| Scala code execution from SQL (EXEC SCALA) | X |
| Out of the box support for cloud storage | X |
| Support for Hadoop 3.2 | X |
| SnappyData Interpreter for Apache Zeppelin | X |
| Synopsis Data Engine for Approximate Querying | X |
| Support for Synopsis Data Engine from TIBCO Spotfire® | X |
| ODBC Driver with High Concurrency | X |
| Off-heap data storage for column tables | X |
| CDC Stream receiver for SQL Server into SnappyData | X |
| Row Level Security | X |
| Use encrypted password instead of clear text password | X |
| Restrict Table, View, Function creation even in user’s own schema | X |
| LDAP security interface | X |
| GemFire connector |