> ## Documentation Index > Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Compare TimescaleDB editions > See the difference between the TimescaleDB Community and TimescaleDB Apache 2 editions export const CLOUD_LONG = 'Tiger Cloud'; export const COMPANY = 'Tiger Data '; export const TDB_COMMUNITY = 'TimescaleDB Community Edition'; export const TDB_APACHE = 'TimescaleDB Apache 2 Edition'; export const TIMESCALE_DB = 'TimescaleDB'; The following versions of {TIMESCALE_DB} are available: * {TDB_APACHE} * {TDB_COMMUNITY} ## {TDB_APACHE} {TDB_APACHE} is available under the [Apache 2.0 license][apache-license]. This is a classic open source license, meaning that it is completely unrestricted - anyone can take this code and offer it as a service. You can install {TDB_APACHE} on your own on-premises or cloud infrastructure and run it for free. You can sell {TDB_APACHE} as a service, even if you're not the main contributor. You can modify the {TDB_APACHE} source code and run it for production use. ## {TDB_COMMUNITY} {TDB_COMMUNITY} is the advanced, best, and most feature complete version of {TIMESCALE_DB}, available under the terms of the [{COMPANY} License (TSL)][timescale-license]. For more information about the {COMPANY} license, see [this blog post][license-blog]. Many of the most recent features of {TIMESCALE_DB} are only available in {TDB_COMMUNITY}. You can install {TDB_COMMUNITY} in your own on-premises or cloud infrastructure and run it for free. {TDB_COMMUNITY} is completely free if you manage your own service. You cannot sell {TDB_COMMUNITY} as a service, even if you are the main contributor. You can modify the {TDB_COMMUNITY} source code and run it for production use. Developers using {TDB_COMMUNITY} have the "right to repair" and make modifications to the source code and run it in their own on-premises or cloud infrastructure. However, you cannot make modifications to the {TDB_COMMUNITY} source code and offer it as a service. You can access a hosted version of {TDB_COMMUNITY} through [{CLOUD_LONG}][cloud], a cloud-native platform for time-series and real-time analytics. ## Feature comparison | Features | TimescaleDB Apache 2 Edition | TimescaleDB Community Edition | | ------------------------------------------------------------------------------------------------ | ---------------------------- | ----------------------------- | | **Hypertables and chunks** | | | | [CREATE TABLE][create-table] | ✅ | ✅ | | [create\_hypertable][create_hypertable] | ✅ | ✅ | | [show\_chunks][show_chunks] | ✅ | ✅ | | [drop\_chunks][drop_chunks] | ✅ | ✅ | | [split\_chunk][split_chunk] | ❌ | ✅ | | [reorder\_chunk][reorder_chunk] | ❌ | ✅ | | [move\_chunk][move_chunk] | ❌ | ✅ | | [add\_reorder\_policy][add_reorder_policy] | ❌ | ✅ | | [attach\_tablespace][attach_tablespace] | ✅ | ✅ | | [detach\_tablespace()][detach_tablespace] | ✅ | ✅ | | [detach\_tablespaces()][detach_tablespaces] | ✅ | ✅ | | [show\_tablespaces][show_tablespaces] | ✅ | ✅ | | [set\_chunk\_time\_interval][set_chunk_time_interval] | ✅ | ✅ | | [set\_integer\_now\_func][set_integer_now_func] | ✅ | ✅ | | [add\_dimension()][add_dimension] | ✅ | ✅ | | [create\_index (Transaction Per Chunk)][create_index-transaction-per-chunk] | ✅ | ✅ | | [hypertable\_size][hypertable_size] | ✅ | ✅ | | [hypertable\_detailed\_size][hypertable_detailed_size] | ✅ | ✅ | | [hypertable\_index\_size][hypertable_index_size] | ✅ | ✅ | | [chunks\_detailed\_size][chunks_detailed_size] | ✅ | ✅ | | [SkipScan][skipscan] | ❌ | ✅ | | Distributed hypertables: sunsetted in TimescaleDB v2.14.x | ❌ | ❌ | | **Hypercore** | | | | [ALTER TABLE (Hypercore)][alter-table-hypercore] | ❌ | ✅ | | [add\_columnstore\_policy][add_columnstore_policy] | ❌ | ✅ | | [remove\_columnstore\_policy][remove_columnstore_policy] | ❌ | ✅ | | [convert\_to\_columnstore][convert_to_columnstore] | ❌ | ✅ | | [convert\_to\_rowstore][convert_to_rowstore] | ❌ | ✅ | | [hypertable\_columnstore\_settings][hypertable_columnstore_settings] | ❌ | ✅ | | [hypertable\_columnstore\_stats][hypertable_columnstore_stats] | ❌ | ✅ | | [chunk\_columnstore\_settings][chunk_columnstore_settings] | ❌ | ✅ | | [chunk\_columnstore\_stats][chunk_columnstore_stats] | ❌ | ✅ | | **Continuous aggregates** | | | | [CREATE MATERIALIZED VIEW (Continuous Aggregate)][create-materialized-view-continuous-aggregate] | ❌ | ✅ | | [ALTER MATERIALIZED VIEW (Continuous Aggregate)][alter-materialized-view-continuous-aggregate] | ❌ | ✅ | | [DROP MATERIALIZED VIEW (Continuous Aggregate)][drop-materialized-view-continuous-aggregate] | ❌ | ✅ | | [add\_continuous\_aggregate\_policy()][add_continuous_aggregate_policy] | ❌ | ✅ | | [refresh\_continuous\_aggregate][refresh_continuous_aggregate] | ❌ | ✅ | | [remove\_continuous\_aggregate\_policy()][remove_continuous_aggregate_policy] | ❌ | ✅ | | **Data retention** | | | | [add\_retention\_policy][add_retention_policy] | ❌ | ✅ | | [remove\_retention\_policy][remove_retention_policy] | ❌ | ✅ | | **Jobs and automation** | | | | [add\_job][add_job] | ❌ | ✅ | | [alter\_job][alter_job] | ❌ | ✅ | | [delete\_job][delete_job] | ❌ | ✅ | | [run\_job][run_job] | ❌ | ✅ | | **Hyperfunctions** | | | | [approximate\_row\_count][approximate_row_count] | ✅ | ✅ | | [first][first] | ✅ | ✅ | | [last][last] | ✅ | ✅ | | [histogram][histogram] | ✅ | ✅ | | [time\_bucket][time_bucket] | ✅ | ✅ | | [time\_bucket\_ng (experimental feature)][time_bucket_ng-experimental-feature] | ✅ | ✅ | | [time\_bucket\_gapfill][time_bucket_gapfill] | ❌ | ✅ | | [locf][locf] | ❌ | ✅ | | [interpolate][interpolate] | ❌ | ✅ | | [percentile\_agg][percentile_agg] | ❌ | ✅ | | [approx\_percentile][approx_percentile] | ❌ | ✅ | | [approx\_percentile\_rank][approx_percentile_rank] | ❌ | ✅ | | [rollup][rollup] | ❌ | ✅ | | [max\_val][max_val] | ❌ | ✅ | | [mean][mean] | ❌ | ✅ | | [error][error] | ❌ | ✅ | | [min\_val][min_val] | ❌ | ✅ | | [num\_vals][num_vals] | ❌ | ✅ | | [uddsketch][uddsketch] | ❌ | ✅ | | [tdigest][tdigest] | ❌ | ✅ | | [time\_weight][time_weight] | ❌ | ✅ | | [rollup][rollup-1] | ❌ | ✅ | | [average][average] | ❌ | ✅ | | **Informational Views** | | | | [timescaledb\_information.chunks][timescaledb_informationchunks] | ✅ | ✅ | | [timescaledb\_information.continuous\_aggregates][timescaledb_informationcontinuous_aggregates] | ✅ | ✅ | | [timescaledb\_information.compression\_settings][timescaledb_informationcompression_settings] | ✅ | ✅ | | [timescaledb\_information.data\_nodes][timescaledb_informationdata_nodes] | ✅ | ✅ | | [timescaledb\_information.dimension][timescaledb_informationdimension] | ✅ | ✅ | | [timescaledb\_information.hypertables][timescaledb_informationhypertables] | ✅ | ✅ | | [timescaledb\_information.jobs][timescaledb_informationjobs] | ✅ | ✅ | | [timescaledb\_information.job\_stats][timescaledb_informationjob_stats] | ✅ | ✅ | | **Administration functions** | | | | [timescaledb\_pre\_restore][timescaledb_pre_restore] | ✅ | ✅ | | [timescaledb\_post\_restore][timescaledb_post_restore] | ✅ | ✅ | | [get\_telemetry\_report][get_telemetry_report] | ✅ | ✅ | | [dump\_meta\_data][dump_meta_data] | ✅ | ✅ | | **Compression replaced by Hypercore** | | | | [ALTER TABLE (Compression)][alter-table-compression] | ❌ | ✅ | | [add\_compression\_policy][add_compression_policy] | ❌ | ✅ | | [remove\_compression\_policy][remove_compression_policy] | ❌ | ✅ | | [compress\_chunk][compress_chunk] | ❌ | ✅ | | [decompress\_chunk][decompress_chunk] | ❌ | ✅ | | [hypertable\_compression\_stats][hypertable_compression_stats] | ❌ | ✅ | | [chunk\_compression\_stats][chunk_compression_stats] | ❌ | ✅ | [add_columnstore_policy]: /api-reference/timescaledb/hypercore/add_columnstore_policy [add_compression_policy]: /api-reference/timescaledb/compression/add_compression_policy [add_continuous_aggregate_policy]: /api-reference/timescaledb/continuous-aggregates/add_continuous_aggregate_policy [add_dimension]: /api-reference/timescaledb/hypertables/add_dimension [add_job]: /api-reference/timescaledb/jobs-automation/add_job [add_reorder_policy]: /api-reference/timescaledb/hypertables/add_reorder_policy [add_retention_policy]: /api-reference/timescaledb/data-retention/add_retention_policy [alter-materialized-view-continuous-aggregate]: /api-reference/timescaledb/continuous-aggregates/alter_materialized_view [alter-table-compression]: /api-reference/timescaledb/compression/alter_table_compression [alter-table-hypercore]: /api-reference/timescaledb/hypercore/alter_table [alter_job]: /api-reference/timescaledb/jobs-automation/alter_job [apache-license]: https://github.com/timescale/timescaledb/blob/master/LICENSE-APACHE [approx_percentile]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [approx_percentile_rank]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [approximate_row_count]: /api-reference/timescaledb/hyperfunctions/approximate_row_count [attach_tablespace]: /api-reference/timescaledb/hypertables/attach_tablespace [average]: /api-reference/timescaledb-toolkit/time_weight [chunk_columnstore_settings]: /api-reference/timescaledb/hypercore/chunk_columnstore_settings [chunk_columnstore_stats]: /api-reference/timescaledb/hypercore/chunk_columnstore_stats [chunk_compression_stats]: /api-reference/timescaledb/compression/chunk_compression_stats [chunks_detailed_size]: /api-reference/timescaledb/hypertables/chunks_detailed_size [cloud]: /deploy-and-operate/tiger-cloud [compress_chunk]: /api-reference/timescaledb/compression/compress_chunk [convert_to_columnstore]: /api-reference/timescaledb/hypercore/convert_to_columnstore [convert_to_rowstore]: /api-reference/timescaledb/hypercore/convert_to_rowstore [create-materialized-view-continuous-aggregate]: /api-reference/timescaledb/continuous-aggregates/create_materialized_view [create-table]: /api-reference/timescaledb/hypertables/create_table [create_hypertable]: /api-reference/timescaledb/hypertables/create_hypertable [create_index-transaction-per-chunk]: /api-reference/timescaledb/hypertables/create_index [decompress_chunk]: /api-reference/timescaledb/compression/decompress_chunk [delete_job]: /api-reference/timescaledb/jobs-automation/delete_job [detach_tablespace]: /api-reference/timescaledb/hypertables/detach_tablespace [detach_tablespaces]: /api-reference/timescaledb/hypertables/detach_tablespaces [drop-materialized-view-continuous-aggregate]: /api-reference/timescaledb/continuous-aggregates/drop_materialized_view [drop_chunks]: /api-reference/timescaledb/hypertables/drop_chunks [dump_meta_data]: /api-reference/timescaledb/administration [error]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [first]: /api-reference/timescaledb/hyperfunctions/first [get_telemetry_report]: /api-reference/timescaledb/administration [histogram]: /api-reference/timescaledb/hyperfunctions/histogram [hypertable_columnstore_settings]: /api-reference/timescaledb/hypercore/hypertable_columnstore_settings [hypertable_columnstore_stats]: /api-reference/timescaledb/hypercore/hypertable_columnstore_stats [hypertable_compression_stats]: /api-reference/timescaledb/compression/hypertable_compression_stats [hypertable_detailed_size]: /api-reference/timescaledb/hypertables/hypertable_detailed_size [hypertable_index_size]: /api-reference/timescaledb/hypertables/hypertable_index_size [hypertable_size]: /api-reference/timescaledb/hypertables/hypertable_size [interpolate]: /api-reference/timescaledb/hyperfunctions/time_bucket_gapfill [last]: /api-reference/timescaledb/hyperfunctions/last [license-blog]: https://www.tigerdata.com/blog/how-we-are-building-a-self-sustaining-open-source-business-in-the-cloud-era [locf]: /api-reference/timescaledb/hyperfunctions/time_bucket_gapfill [max_val]: /api-reference/timescaledb-toolkit/percentile-approximation/tdigest [mean]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [min_val]: /api-reference/timescaledb-toolkit/percentile-approximation/tdigest [move_chunk]: /api-reference/timescaledb/hypertables/move_chunk [num_vals]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [percentile_agg]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [refresh_continuous_aggregate]: /api-reference/timescaledb/continuous-aggregates/refresh_continuous_aggregate [remove_columnstore_policy]: /api-reference/timescaledb/hypercore/remove_columnstore_policy [remove_compression_policy]: /api-reference/timescaledb/compression/remove_compression_policy [remove_continuous_aggregate_policy]: /api-reference/timescaledb/continuous-aggregates/remove_continuous_aggregate_policy [remove_retention_policy]: /api-reference/timescaledb/data-retention/remove_retention_policy [reorder_chunk]: /api-reference/timescaledb/hypertables/reorder_chunk [rollup-1]: /api-reference/timescaledb-toolkit/time_weight [rollup]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch [run_job]: /api-reference/timescaledb/jobs-automation/run_job [set_chunk_time_interval]: /api-reference/timescaledb/hypertables/set_chunk_time_interval [set_integer_now_func]: /api-reference/timescaledb/hypertables/set_integer_now_func [show_chunks]: /api-reference/timescaledb/hypertables/show_chunks [show_tablespaces]: /api-reference/timescaledb/hypertables/show_tablespaces [skipscan]: /manage-data/query-data/skipscan [split_chunk]: /api-reference/timescaledb/hypertables/split_chunk [tdigest]: /api-reference/timescaledb-toolkit/percentile-approximation/tdigest [time_bucket]: /api-reference/timescaledb/hyperfunctions/time_bucket [time_bucket_gapfill]: /api-reference/timescaledb/hyperfunctions/time_bucket_gapfill [time_bucket_ng-experimental-feature]: /api-reference/timescaledb/hyperfunctions/time_bucket_ng [time_weight]: /api-reference/timescaledb-toolkit/time_weight [timescale-license]: https://github.com/timescale/timescaledb/blob/master/tsl/LICENSE-TIMESCALE [timescaledb_informationchunks]: /api-reference/timescaledb/informational-views/chunks [timescaledb_informationcompression_settings]: /api-reference/timescaledb/informational-views/compression_settings [timescaledb_informationcontinuous_aggregates]: /api-reference/timescaledb/informational-views/continuous_aggregates [timescaledb_informationdata_nodes]: /api-reference/timescaledb/informational-views/data_nodes [timescaledb_informationdimension]: /api-reference/timescaledb/informational-views/dimensions [timescaledb_informationhypertables]: /api-reference/timescaledb/informational-views/hypertables [timescaledb_informationjob_stats]: /api-reference/timescaledb/informational-views/job_stats [timescaledb_informationjobs]: /api-reference/timescaledb/informational-views/jobs [timescaledb_post_restore]: /api-reference/timescaledb/administration [timescaledb_pre_restore]: /api-reference/timescaledb/administration [uddsketch]: /api-reference/timescaledb-toolkit/percentile-approximation/uddsketch