Time Series Database

<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>Time Series Database</title> <link rel="shortcut icon" href="https://cratedb.com/hubfs/cratedb-favicon.png"> <meta name="description" content="Distributed open source time series database, leveraging native SQL. You can combine multiple other data formats to get any type of real-time analytics."> <style> .cr-header-full-height { height: 100vh; } </style>   <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103134656537/1676853350416/sf2-crate/js/jquery-3.5.1.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta property="og:description" content="Distributed open source time series database, leveraging native SQL. You can combine multiple other data formats to get any type of real-time analytics."> <meta property="og:title" content="Time Series Database"> <meta name="twitter:description" content="Distributed open source time series database, leveraging native SQL. You can combine multiple other data formats to get any type of real-time analytics."> <meta name="twitter:title" content="Time Series Database"> <style> a.cta_button{-moz-box-sizing:content-box !important;-webkit-box-sizing:content-box !important;box-sizing:content-box !important;vertical-align:middle}.hs-breadcrumb-menu{list-style-type:none;margin:0px 0px 0px 0px;padding:0px 0px 0px 0px}.hs-breadcrumb-menu-item{float:left;padding:10px 0px 10px 10px}.hs-breadcrumb-menu-divider:before{content:'›';padding-left:10px}.hs-featured-image-link{border:0}.hs-featured-image{float:right;margin:0 0 20px 20px;max-width:50%}@media (max-width: 568px){.hs-featured-image{float:none;margin:0;width:100%;max-width:100%}}.hs-screen-reader-text{clip:rect(1px, 1px, 1px, 1px);height:1px;overflow:hidden;position:absolute !important;width:1px} </style> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52693799430/1721897980656/sf2-crate/css/main.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52694827330/1729004392151/sf2-crate/css/theme-overrides.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/55523967869/1722426745670/module_55523967869_Header_Notif_Bar.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52694764069/1701097527939/module_52694764069_menu-section.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/53642957898/1710775451648/module_53642957898_code-tabs.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52697609066/1633080952018/module_52697609066_advanced-richtext.min.css"> <link rel="stylesheet" href="https://cdn2.hubspot.net/hub/-1/hub_generated/module_assets/-35056501883/1732641106642/module_-35056501883_Video.min.css"> <style> #oembed_container-module_17218147704668 .oembed_custom-thumbnail_icon svg { fill: #19c0ea; } </style> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/53152974980/1676852665553/module_53152974980_advanced-section-css.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/124127418129/1716804134819/module_124127418129_Related_Content_23.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/91968152433/1731315229164/module_91968152433_Accordion_22.min.css">  <style id="hs_editor_style" type="text/css"> .dnd_area-row-0-force-full-width-section > .row-fluid { max-width: none !important; } .module_17131818324486-flexbox-positioning { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-align: center !important; -ms-flex-pack: start; display: flex !important; flex-direction: column !important; align-items: center !important; justify-content: flex-start; } .module_17131818324486-flexbox-positioning > div { max-width: 100%; flex-shrink: 0 !important; } .module_17218147893535-flexbox-positioning { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-align: center !important; -ms-flex-pack: start; display: flex !important; flex-direction: column !important; align-items: center !important; justify-content: flex-start; } .module_17218147893535-flexbox-positioning > div { max-width: 100%; flex-shrink: 0 !important; } .module_17104114473437-flexbox-positioning { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-align: center !important; -ms-flex-pack: start; display: flex !important; flex-direction: column !important; align-items: center !important; justify-content: flex-start; } .module_17104114473437-flexbox-positioning > div { max-width: 100%; flex-shrink: 0 !important; } /* HubSpot Non-stacked Media Query Styles */ @media (min-width:768px) { .dnd_area-row-3-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .dnd_area-row-4-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .dnd_area-row-6-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .dnd_area-row-7-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .dnd_area-row-9-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .cell_17131818324483-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17131818324483-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17131818324482-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17131818324482-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17218147704663-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17218147704663-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17218147704662-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17218147704662-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17218147893533-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17218147893533-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17218147893532-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17218147893532-vertical-alignment > div { flex-shrink: 0 !important; } .cell_1721814797429-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_1721814797429-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17104114473432-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17104114473432-vertical-alignment > div { flex-shrink: 0 !important; } .cell_1695628590024-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_1695628590024-vertical-alignment > div { flex-shrink: 0 !important; } } /* HubSpot Styles (default) */ .dnd_area-row-0-background-layers { background-image: url('https://cratedb.com/hubfs/cr-header-mesh.jpg') !important; background-position: center center !important; background-size: cover !important; background-repeat: no-repeat !important; } .dnd_area-row-2-padding { padding-top: 40px !important; padding-bottom: 20px !important; } .dnd_area-row-2-background-layers { background-image: linear-gradient(rgba(243, 243, 243, 1), rgba(243, 243, 243, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-3-padding { padding-top: 20px !important; padding-bottom: 40px !important; } .dnd_area-row-4-padding { padding-top: 20px !important; } .dnd_area-row-5-margin { margin-bottom: 20px !important; } .dnd_area-row-5-background-layers { background-image: linear-gradient(rgba(241, 241, 241, 1), rgba(241, 241, 241, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-6-padding { padding-top: 20px !important; padding-bottom: 40px !important; } .dnd_area-row-7-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-8-padding { padding-top: 40px !important; padding-bottom: 0px !important; } .dnd_area-row-8-background-layers { background-image: linear-gradient(rgba(243, 243, 243, 1), rgba(243, 243, 243, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-9-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-10-padding { padding-top: 20px !important; } .dnd_area-row-11-background-layers { background-image: linear-gradient(rgba(243, 243, 243, 1), rgba(243, 243, 243, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-12-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-13-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-13-hidden { display: none !important; } /* HubSpot Styles (mobile) */ @media (max-width: 767px) { .dnd_area-row-1-padding { padding-top: 50px !important; padding-bottom: 50px !important; } .dnd_area-row-3-padding { padding-bottom: 40px !important; } .dnd_area-row-4-padding { padding-bottom: 40px !important; } .dnd_area-row-6-padding { padding-bottom: 40px !important; } .dnd_area-row-7-padding { padding-bottom: 40px !important; } } </style>  <script> var _hsp = window._hsp = window._hsp || []; window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} var useGoogleConsentModeV2 = true; var waitForUpdateMillis = 1000; if (!window._hsGoogleConsentRunOnce) { window._hsGoogleConsentRunOnce = true; gtag('consent', 'default', { 'ad_storage': 'denied', 'analytics_storage': 'denied', 'ad_user_data': 'denied', 'ad_personalization': 'denied', 'wait_for_update': waitForUpdateMillis }); if (useGoogleConsentModeV2) { _hsp.push(['useGoogleConsentModeV2']) } else { _hsp.push(['addPrivacyConsentListener', function(consent){ var hasAnalyticsConsent = consent && (consent.allowed || (consent.categories && consent.categories.analytics)); var hasAdsConsent = consent && (consent.allowed || (consent.categories && consent.categories.advertisement)); gtag('consent', 'update', { 'ad_storage': hasAdsConsent ? 'granted' : 'denied', 'analytics_storage': hasAnalyticsConsent ? 'granted' : 'denied', 'ad_user_data': hasAdsConsent ? 'granted' : 'denied', 'ad_personalization': hasAdsConsent ? 'granted' : 'denied' }); }]); } } gtag('js', new Date()); gtag('set', 'developer_id.dZTQ1Zm', true); gtag('config', 'G-6J80J11VFJ'); </script> <script async src="https://www.googletagmanager.com/gtag/js?id=G-6J80J11VFJ"></script>   <script> var _hsp = window._hsp = window._hsp || []; window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} var useGoogleConsentModeV2 = true; var waitForUpdateMillis = 1000; var hsLoadGtm = function loadGtm() { if(window._hsGtmLoadOnce) { return; } if (useGoogleConsentModeV2) { gtag('set','developer_id.dZTQ1Zm',true); gtag('consent', 'default', { 'ad_storage': 'denied', 'analytics_storage': 'denied', 'ad_user_data': 'denied', 'ad_personalization': 'denied', 'wait_for_update': waitForUpdateMillis }); _hsp.push(['useGoogleConsentModeV2']) } (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-WHMDSK'); window._hsGtmLoadOnce = true; }; _hsp.push(['addPrivacyConsentListener', function(consent){ if(consent.allowed || (consent.categories && consent.categories.analytics)){ hsLoadGtm(); } }]); </script>  <link rel="canonical" href="https://cratedb.com/data-model/time-series"> <meta property="og:url" content="https://cratedb.com/data-model/time-series"> <meta name="twitter:card" content="summary"> <meta http-equiv="content-language" content="en">    <meta property="og:image" content="https://cratedb.com/hubfs/cr-featured-image-23.jpg"> <meta property="og:image:width" content="1200"> <meta property="og:image:height" content="630"> <meta property="og:image:alt" content="CrateDB - Data Insights at Scale"> <meta name="generator" content="HubSpot"></head> <body class="">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-WHMDSK" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="body-wrapper hs-content-id-124476846895 hs-site-page page "> <div id="hs_cos_wrapper_Header_Notif_Bar" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"></div> <div data-global-resource-path="sf2-crate/templates/partials/header-landify.html"> <header class="header" style="color: #ffffff ;" id="top"> <a href="#main-content" class="header__skip">Skip to content</a> <div class="header__container content-wrapper"> <div class="header__logo header__logo--main"> <div id="hs_cos_wrapper_site_logo" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-logo" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <span id="hs_cos_wrapper_site_logo_hs_logo_widget" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_logo" style="" data-hs-cos-general-type="widget" data-hs-cos-type="logo"><a href="/" id="hs-link-site_logo_hs_logo_widget" style="border-width:0px;border:0px;"><img src="https://cratedb.com/hubfs/CrateDB-logo-blue-white.svg" class="hs-image-widget " height="204" style="height: auto;width:1433px;border-width:0px;border:0px;" width="1433" alt="CrateDB logo" title="CrateDB logo" loading="eager"></a></span> </div> </div> <div class="header_nav_column" style="text-align: center ;"> <div class="header_nav"> <div class="header--toggle header__navigation--toggle"></div> <div class="header__close--toggle"></div> <div class="header__navigation header--element"> <div id="hs_cos_wrapper_navigation-primary" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <nav aria-label="Main menu" class="navigation-primary"> <ul class="submenu level-1"> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link active-branch" title="Product">Product</a> <ul class="submenu level-2"> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Database">Database</a> <ul class="submenu level-3"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database" class="menu-link" title="Overview">Overview</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/cloud" class="menu-link" title="CrateDB Cloud">CrateDB Cloud</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/self-managed" class="menu-link" title="CrateDB Self-Managed">CrateDB Self-Managed</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/sql-examples" class="menu-link" title="SQL examples">SQL examples</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/integrations" class="menu-link" title="Integrations">Integrations</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/security" class="menu-link" title="Security">Security</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link active-branch" title="Data models">Data models</a> <ul class="submenu level-3"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/time-series" class="menu-link active-item" aria-current="page" title="Time-series">Time-series</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/json" class="menu-link" title="Document/JSON">Document/JSON</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/vector" class="menu-link" title="Vector">Vector</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/full-text" class="menu-link" title="Full-text">Full-text</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/geospatial" class="menu-link" title="Spatial">Spatial</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/relational" class="menu-link" title="Relational">Relational</a> </li> </ul> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Use cases">Use cases</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/ai-ml-database" class="menu-link" title="AI/ML integration">AI/ML integration</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/chatbots/" class="menu-link" title="AI-powered chatbots">AI-powered chatbots</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/iot-database" class="menu-link" title="Internet of Things">Internet of Things</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/digital-twins-database" class="menu-link" title="Digital twins">Digital twins</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/geospatial-analytics" class="menu-link" title="Geospatial analytics">Geospatial analytics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/log-database" class="menu-link" title="Log & event analysis">Log & event analysis</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/database-consolidation" class="menu-link" title="Database consolidation">Database consolidation</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Industries">Industries</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/energy" class="menu-link" title="Energy">Energy</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/financial-services" class="menu-link" title="Financial Services">Financial Services</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/fmcg" class="menu-link" title="FMCG">FMCG</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/logistics" class="menu-link" title="Logistics">Logistics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/manufacturing" class="menu-link" title="Manufacturing">Manufacturing</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/oil-gas-mining" class="menu-link" title="Oil, gas & mining">Oil, gas & mining</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/smart-cities" class="menu-link" title="Smart city solutions">Smart city solutions</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/tech-platforms" class="menu-link" title="Technology platforms">Technology platforms</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/telco" class="menu-link" title="Telco">Telco</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/transportation" class="menu-link" title="Transportation">Transportation</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Resources">Resources</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/stories" class="menu-link" title="User stories">User stories</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/academy" class="menu-link" title="Academy">Academy</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/library" class="menu-link" title="Asset library">Asset library</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/blog" class="menu-link" title="Blog">Blog</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/event" class="menu-link" title="Events">Events</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Developer">Developer</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="/docs/guide/home/" class="menu-link" title="Documentation">Documentation</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/drivers-tools" class="menu-link" title="Drivers and tools">Drivers and tools</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/community" class="menu-link" title="Community">Community</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://github.com/crate/crate/" class="menu-link" target="_blank" rel="noopener" title="GitHub">GitHub</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/support" class="menu-link" title="Support">Support</a> </li> </ul> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/pricing" class="menu-link" title="Pricing">Pricing</a> </li> </ul> </nav></div> <div class="header__cta__column mb"> <div class="header__cta"> <div id="hs_cos_wrapper_module_161720035400929" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="ly-cta-div header-icons"> <div class="cr-gh-header"> <a href="https://github.com/crate/" title="Follow CrateDB on GitHub" rel="noreferrer" target="_blank"> <svg version="1.0" height="20" width="20" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="github5" role="img"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg> </a> </div> <div class="cr-gh-header cr-search-header"> <a href="/search" class="search-btn menu-link" title="Search on cratedb.com"> <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewbox="0 0 512 512"><path d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376c-34.4 25.2-76.8 40-122.7 40C93.1 416 0 322.9 0 208S93.1 0 208 0S416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg> </a> </div> </div> <div class="ly-cta-div" style="margin-right:0;"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="140734001567"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLN26yv8kQRp2WAoeOu9bNBbkLvTvRFUszq%2FYx5PHh5KDMckqiVw13YriNZl%2FdwfLQhIBdngdVl9Lx2IjudAdjrNLPdfhOwxbALtLSGiVSiJme4GD1HjmmjV%2BLWcWF9BI7hRc97dyKGXNt5JHxSRJoHlvLASH5kuFKzd92WI2YJWJb%2BFVwL%2FkowhjQ7LStla2KXRfev%2Bt5hHZ6w0AIdYbL%2Bw5TrWqqtyhZwdCt8vhgIqhu3f3Em59QiBrX4OknB3IvxW9zy0KkmILmwktRj%2BbA%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-140734001567 cta-btn login-cta menu-link " data-hubspot-cta-id="140734001567"> Log In </a> </div> </div> <div class="ly-cta-div"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178336831256"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIJe21Dd%2BqMBXuwhUEwIxeKvQRteMuuvBgS0cjHs7WtGTrDP%2FOCVzg%2F92IOl9VbWfNtTIu%2FKC6mz8pqjKES7LqJM2rA5K6VXfMhvFaG4WQW2LFPe9AVNyYpYDsMuKe%2FlqIfbRifuiV29ECfFn%2BRra2Unad4SCh6ECtacrskeaY%2FWA%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178336831256 cr-btn-div cr-btn-2 " data-hubspot-cta-id="178336831256"> Start free </a> </div> </div> <style> .ly-cta-div a.cta-btn.login-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn.signup-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn{ display:inline-block; position:relative; padding:10px 25px; font-family:sans-serif; transition: all .4s ease; line-height:21px; border-radius:5px; cursor:pointer; text-decoration:none; font-weight: 600; } .ly-cta-div a.cta-btn:hover{ opacity:.7; } .cr-gh-header.cr-search-header { padding: 0; margin-right: 0; } div#hs_cos_wrapper_module_161720035400929 { display: inline-block; } </style></div> </div> </div> </div> </div> </div> <div class="header__cta__column lg"> <div class="header__cta"> <div id="hs_cos_wrapper_module_161720035400929" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="ly-cta-div header-icons"> <div class="cr-gh-header"> <a href="https://github.com/crate/" title="Follow CrateDB on GitHub" rel="noreferrer" target="_blank"> <svg version="1.0" height="20" width="20" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="github5" role="img"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg> </a> </div> <div class="cr-gh-header cr-search-header"> <a href="/search" class="search-btn menu-link" title="Search on cratedb.com"> <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewbox="0 0 512 512"><path d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376c-34.4 25.2-76.8 40-122.7 40C93.1 416 0 322.9 0 208S93.1 0 208 0S416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg> </a> </div> </div> <div class="ly-cta-div" style="margin-right:0;"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="140734001567"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLN26yv8kQRp2WAoeOu9bNBbkLvTvRFUszq%2FYx5PHh5KDMckqiVw13YriNZl%2FdwfLQhIBdngdVl9Lx2IjudAdjrNLPdfhOwxbALtLSGiVSiJme4GD1HjmmjV%2BLWcWF9BI7hRc97dyKGXNt5JHxSRJoHlvLASH5kuFKzd92WI2YJWJb%2BFVwL%2FkowhjQ7LStla2KXRfev%2Bt5hHZ6w0AIdYbL%2Bw5TrWqqtyhZwdCt8vhgIqhu3f3Em59QiBrX4OknB3IvxW9zy0KkmILmwktRj%2BbA%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-140734001567 cta-btn login-cta menu-link " data-hubspot-cta-id="140734001567"> Log In </a> </div> </div> <div class="ly-cta-div"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178336831256"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIJe21Dd%2BqMBXuwhUEwIxeKvQRteMuuvBgS0cjHs7WtGTrDP%2FOCVzg%2F92IOl9VbWfNtTIu%2FKC6mz8pqjKES7LqJM2rA5K6VXfMhvFaG4WQW2LFPe9AVNyYpYDsMuKe%2FlqIfbRifuiV29ECfFn%2BRra2Unad4SCh6ECtacrskeaY%2FWA%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178336831256 cr-btn-div cr-btn-2 " data-hubspot-cta-id="178336831256"> Start free </a> </div> </div> <style> .ly-cta-div a.cta-btn.login-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn.signup-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn{ display:inline-block; position:relative; padding:10px 25px; font-family:sans-serif; transition: all .4s ease; line-height:21px; border-radius:5px; cursor:pointer; text-decoration:none; font-weight: 600; } .ly-cta-div a.cta-btn:hover{ opacity:.7; } .cr-gh-header.cr-search-header { padding: 0; margin-right: 0; } div#hs_cos_wrapper_module_161720035400929 { display: inline-block; } </style></div> </div> </div> </div> </header></div> <main id="main-content" class="body-container-wrapper"> <div class="container-fluid body-container body-container--about"> <div class="row-fluid-wrapper"> <div class="row-fluid"> <div class="span12 widget-span widget-type-cell " style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-1 dnd_area-row-0-force-full-width-section dnd_area-row-0-background-layers dnd-section dnd_area-row-0-background-image"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-2 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16892366900963" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="cr-clusters-items-wrapper " id="module_16892366900963"> <style> #module_16892366900963.cr-clusters-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16892366900963.cr-clusters-items-wrapper.cr-clusters-limit, .cr-meta-inner { max-width: 1200px; } #module_16892366900963 .cr-clusters-container.cr-customers-header-sub { max-width: 1200px; margin: 0 auto; } #module_16892366900963 .cr-clusters-container { display: flex; align-items: center; } #module_16892366900963 .cr-clusters-header { margin-bottom: 20px; display: flex; align-items: baseline; } #module_16892366900963 .cr-clusters-header h1 { letter-spacing: -2.04px; max-width: 620px; margin-right: 20px; margin-bottom: 0px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.2; } #module_16892366900963 .cr-customers-header-sub .cr-clusters-header h1 { max-width: 980px; } #module_16892366900963 .cr-customers-header-sub .cr-clusters-limit-width-headline.cr-clusters-header h1 { max-width: 700px; } #module_16892366900963.cr-clusters-limit .cr-customers-header-sub .cr-clusters-introtext { max-width: 950px; } #module_16892366900963:not(.cr-clusters-limit) .cr-customers-header-sub .cr-clusters-introtext { max-width: 100%; } #module_16892366900963 .cr-clusters-image { flex: 3; } #module_16892366900963 .cr-clusters-image img { height: auto; } #module_16892366900963 .cr-clusters-introtext, #module_16892366900963 .cr-clusters-introtext p, #module_16892366900963 .cr-clusters-introtext span { color: rgba(255, 255, 255, 1.0); font-size: 21px; margin-right: 100px; } #module_16892366900963 .cr-clusters-introtext { max-width: 680px; } #module_16892366900963 .cr-clusters-left { padding-top: 60px; flex: 3; } #module_16892366900963 .cr-header-section { display: block; font-size: 20px; font-weight: 600; color: #19C0EA; } #module_16892366900963 .cr-clusters-arrow { align-self: flex-end; } #module_16892366900963 .cr-clusters-arrow svg { max-width: 40px; height: auto; } .cr-landingpage-header { margin-bottom: 78px; } .cr-landingpage-header .dnd-column { padding: 0; } .cr-header-meta-bar { background: rgb(8, 29, 36); opacity: 1; padding: 20px 20px; position: absolute; bottom: -146px; left: 0; right: 0; margin-left: -20px; margin-right: -20px; } .cr-header-meta-bar > div > div { display: flex; font-family: Inter; font-weight: 600; font-size: 16px; line-height: 20px; letter-spacing: 0px; color: #FFFFFF; opacity: 1; } .cr-meta-inner { display: flex; flex-direction: row; align-items: center; justify-content: flex-start; margin: 0 auto; } .cr-meta-item { display: flex; align-items: center; margin-right: 30px; } .cr-meta-item img { margin-right: 10px; } .cr-header-speaker-image img { border-radius: 50%; max-width: 80px !important; } .cr-header-speaker-name { letter-spacing: -0.56px; color: #FFFFFF; font-size: 18px; line-height: 24px; font-weight: bold; font-family: Inter; text-align: center; margin-bottom: 2px; } .cr-header-speakers { display: flex; flex-direction: row; margin-top: 80px; } .cr-header-speakers-item:last-child { margin-left: 50px; } .cr-header-speaker-title { letter-spacing: -0.36px; color: #e3b15b; font-size: 16px; line-height: 20px; font-family: Inter; font-weight: 500; text-align: center; } .cr-header-speaker-image { text-align: center; } .cr-header-multipurpose { position: relative; } /*@media all and (min-width: 1200px) { .cr-header-speaker-image img { max-width: 100% !important; } }*/ @media all and (max-width: 1200px) { } @media all and (max-width: 980px) { #module_16892366900963 .cr-clusters-container { flex-direction: column; } #module_16892366900963 .cr-clusters-introtext { font-size: 18px; } #module_16892366900963 .cr-clusters-header h1 { width: auto; max-width: 100%; } #module_16892366900963 .cr-clusters-container { align-items: flex-start; } } @media all and (max-width: 767px) { #module_16892366900963 .cr-clusters-introtext { margin-right: 0; } .cr-header-meta-bar > div > div { flex-direction: column; text-align: center; font-size: 14px; } .cr-meta-item { margin-right: 10px; } .cr-header-speakers { margin-top: 40px; } } </style> <div class="cr-clusters-container cr-customers-header-sub"> <div class="cr-clusters-left"> <span class="cr-header-section">Product > Data models</span> <div class="cr-clusters-header cr-clusters-limit-width-headline"> <h1 style="color: rgba(255, 255, 255, 1.0);">Time Series Data</h1> </div> <div class="cr-clusters-introtext"> CrateDB allows to query complex time series data in milliseconds, while leveraging the simplicity of SQL. You can easily enrich your time series data with other types of data, handle high ingest rates, and store years of history. </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-3 dnd_area-row-1-padding dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-4 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_1689240411468" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="horizontal-code-tab line-numbers"> <div class="tab tab-head"> <div class="heading-content"> <div style="text-align: left;"> </div> <h2 style="font-size: 24px;">Time series data querying with SQL</h2> <p style="font-size: 18px;">Hyper-fast. Results in milliseconds.</p> <p style="font-size: 18px;"><span style="color: #000000;"> </span></p> </div> <button class="tablinks module_1689240411468-codetabl" onclick="openCodeTabmodule_1689240411468(event, 'module_1689240411468-Codetab1')" id="module_1689240411468-defaultOpen"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Hourly average</button> <button class="tablinks module_1689240411468-codetabl" onclick="openCodeTabmodule_1689240411468(event, 'module_1689240411468-Codetab2')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Gap analysis</button> <button class="tablinks module_1689240411468-codetabl" onclick="openCodeTabmodule_1689240411468(event, 'module_1689240411468-Codetab3')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Number per day</button> <button class="tablinks module_1689240411468-codetabl" onclick="openCodeTabmodule_1689240411468(event, 'module_1689240411468-Codetab4')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Average temperature</button> </div> <div class="tab tab-body"> <div id="module_1689240411468-Codetab1" class="tabcontent module_1689240411468-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_1689240411468-pane-number1" role="tabpanel" id="module_1689240411468-Statement1"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> /* Based on device data, this query returns the average * of the battery level for every hour for each device_id */ WITH avg_metrics AS ( SELECT device_id, DATE_BIN('1 hour'::INTERVAL, time, 0) AS period, AVG(battery_level) AS avg_battery_level FROM devices.readings GROUP BY 1, 2 ORDER BY 1, 2 ) SELECT period, t.device_id, manufacturer, avg_battery_level FROM avg_metrics t, devices.info i WHERE t.device_id = i.device_id AND model = 'mustang' LIMIT 10; </code></pre> </code> </pre> </div> <div class="tab-pane module_1689240411468-pane-number1" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_1689240411468-Result1"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> +---------------+------------+--------------+-------------------+ | period | device_id | manufacturer | avg_battery_level | +---------------+------------+--------------+-------------------+ | 1480802400000 | demo000001 | iobeam | 49.25757575757576 | | 1480806000000 | demo000001 | iobeam | 47.375 | | 1480802400000 | demo000007 | iobeam | 25.53030303030303 | | 1480806000000 | demo000007 | iobeam | 58.5 | | 1480802400000 | demo000010 | iobeam | 34.90909090909091 | | 1480806000000 | demo000010 | iobeam | 32.4 | | 1480802400000 | demo000016 | iobeam | 36.06060606060606 | | 1480806000000 | demo000016 | iobeam | 35.45 | | 1480802400000 | demo000025 | iobeam | 12 | | 1480806000000 | demo000025 | iobeam | 16.475 | +---------------+------------+--------------+-------------------+ </code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_1689240411468-pill-number1 active" onclick="openPillmodule_16892404114681(event, 'module_1689240411468-Statement1')">Statement</button> <button class="tab-pill module_1689240411468-pill-number1" onclick="openPillmodule_16892404114681(event, 'module_1689240411468-Result1')">Result</button> </div> </div> </div> <script> function openPillmodule_16892404114681(evt1, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pane-number1"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pill-number1"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt1.currentTarget.className += " active"; } function openCodeTabmodule_1689240411468(evt1, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabc"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabl"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt1.currentTarget.className += " active"; } document.getElementById("module_1689240411468-defaultOpen").click(); </script> <div id="module_1689240411468-Codetab2" class="tabcontent module_1689240411468-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_1689240411468-pane-number2" role="tabpanel" id="module_1689240411468-Statement2"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> /* To identify gaps on the readings, the following queries generates a series * and by joining it with the original data, you can spot any gap */ with avg_battery AS ( SELECT battery_level, time FROM devices.readings WHERE device_id = 'demo000007' AND time > 1480118400000 AND time < 1480301200000 ORDER BY 2 ), all_hours AS ( SELECT generate_series(1480118430000,1480301200000,'30 second'::interval) AS generated_hours ) SELECT time, generated_hours, battery_level FROM all_hours LEFT JOIN avg_battery ON generated_hours = time ORDER BY 2 LIMIT 20; </code></pre> </code> </pre> </div> <div class="tab-pane module_1689240411468-pane-number2" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_1689240411468-Result2"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> +---------------+---------------+---------------+ | time | hours | battery_level | +---------------+---------------+---------------+ | 1480118430000 | 1480118430000 | 67 | | 1480118460000 | 1480118460000 | 66 | | 1480118490000 | 1480118490000 | 66 | | 1480118520000 | 1480118520000 | 66 | | 1480118550000 | 1480118550000 | 66 | | 1480118580000 | 1480118580000 | 66 | | 1480118610000 | 1480118610000 | 65 | | 1480118640000 | 1480118640000 | NULL | | 1480118670000 | 1480118670000 | 65 | | 1480118700000 | 1480118700000 | 65 | | 1480118730000 | 1480118730000 | 65 | | 1480118760000 | 1480118760000 | 65 | | 1480118790000 | 1480118790000 | 65 | | 1480118820000 | 1480118820000 | 65 | | 1480118850000 | 1480118850000 | 65 | | 1480118880000 | 1480118880000 | 65 | | 1480118910000 | 1480118910000 | 65 | | 1480118940000 | 1480118940000 | 65 | | 1480118970000 | 1480118970000 | NULL | | 1480119000000 | 1480119000000 | NULL | +---------------+---------------+---------------+ </code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_1689240411468-pill-number2 active" onclick="openPillmodule_16892404114682(event, 'module_1689240411468-Statement2')">Statement</button> <button class="tab-pill module_1689240411468-pill-number2" onclick="openPillmodule_16892404114682(event, 'module_1689240411468-Result2')">Result</button> </div> </div> </div> <script> function openPillmodule_16892404114682(evt2, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pane-number2"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pill-number2"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt2.currentTarget.className += " active"; } function openCodeTabmodule_1689240411468(evt2, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabc"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabl"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt2.currentTarget.className += " active"; } document.getElementById("module_1689240411468-defaultOpen").click(); </script> <div id="module_1689240411468-Codetab3" class="tabcontent module_1689240411468-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_1689240411468-pane-number3" role="tabpanel" id="module_1689240411468-Statement3"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> /* Based on device data, this query returns the number of battery charges * per day for a given device_id */ WITH aux_charging AS ( SELECT time, DATE_BIN('P1D'::INTERVAL,time,0) AS day, battery_status, LAG(battery_status) OVER (PARTITION BY device_id ORDER BY time) AS prev_battery_status FROM devices.readings WHERE device_id = 'demo000001' ORDER BY time ), count_start_charging AS ( SELECT day, (case when battery_status <> prev_battery_status then 1 else 0 end) AS start_charging FROM aux_charging ORDER BY 1 ) SELECT day, sum(start_charging) as charges_number FROM count_start_charging GROUP BY 1 ORDER BY 1; </code></pre> </code> </pre> </div> <div class="tab-pane module_1689240411468-pane-number3" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_1689240411468-Result3"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> +---------------+---------------+ | count_charges | day | +---------------+---------------+ | 2 | 1479168000000 | | 4 | 1479254400000 | | 2 | 1479340800000 | | 10 | 1479427200000 | | 7 | 1479600000000 | | 8 | 1479686400000 | | 6 | 1479772800000 | | 11 | 1479859200000 | | 5 | 1480032000000 | | 7 | 1480118400000 | | 6 | 1480204800000 | | 10 | 1480291200000 | | 3 | 1480464000000 | | 3 | 1480550400000 | | 7 | 1480636800000 | | 2 | 1480723200000 | +---------------+---------------+ </code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_1689240411468-pill-number3 active" onclick="openPillmodule_16892404114683(event, 'module_1689240411468-Statement3')">Statement</button> <button class="tab-pill module_1689240411468-pill-number3" onclick="openPillmodule_16892404114683(event, 'module_1689240411468-Result3')">Result</button> </div> </div> </div> <script> function openPillmodule_16892404114683(evt3, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pane-number3"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pill-number3"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt3.currentTarget.className += " active"; } function openCodeTabmodule_1689240411468(evt3, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabc"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabl"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt3.currentTarget.className += " active"; } document.getElementById("module_1689240411468-defaultOpen").click(); </script> <div id="module_1689240411468-Codetab4" class="tabcontent module_1689240411468-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_1689240411468-pane-number4" role="tabpanel" id="module_1689240411468-Statement4"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> /* Based on device data, this query returns the average of the battery temperature * for each OS version */ SELECT device_info['os_name'], avg(battery_temperature) FROM "devices"."readings" GROUP BY 1 LIMIT 100;</code></pre> </code> </pre> </div> <div class="tab-pane module_1689240411468-pane-number4" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_1689240411468-Result4"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> <span data-code-lang="sql" data-ds--code--code-block=""><code> +---------+--------------------------+ | os_name | avg(battery_temperature) | +---------+--------------------------+ | 4.4.4 | 90.85937893039049 | | 5.1.0 | 90.86754559738132 | | 6.0.1 | 90.84230101265824 | | 5.0.0 | 90.8574802739726 | +---------+--------------------------+ </code></span></code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_1689240411468-pill-number4 active" onclick="openPillmodule_16892404114684(event, 'module_1689240411468-Statement4')">Statement</button> <button class="tab-pill module_1689240411468-pill-number4" onclick="openPillmodule_16892404114684(event, 'module_1689240411468-Result4')">Result</button> </div> </div> </div> <script> function openPillmodule_16892404114684(evt4, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pane-number4"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-pill-number4"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt4.currentTarget.className += " active"; } function openCodeTabmodule_1689240411468(evt4, module_1689240411468) { var i, tabcontentmodule_1689240411468, tablinksmodule_1689240411468; tabcontentmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabc"); for (i = 0; i < tabcontentmodule_1689240411468.length; i++) { tabcontentmodule_1689240411468[i].style.display = "none"; } tablinksmodule_1689240411468 = document.getElementsByClassName("module_1689240411468-codetabl"); for (i = 0; i < tablinksmodule_1689240411468.length; i++) { tablinksmodule_1689240411468[i].className = tablinksmodule_1689240411468[i].className.replace(" active", ""); } document.getElementById(module_1689240411468).style.display = "block"; evt4.currentTarget.className += " active"; } document.getElementById("module_1689240411468-defaultOpen").click(); </script> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-5 dnd_area-row-2-background-layers dnd_area-row-2-padding dnd_area-row-2-background-color dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-6 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1689240066243" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-featuresbox-items-wrapper" id="widget_1689240066243"> <style> #widget_1689240066243.cr-featuresbox-items-wrapper { /*max-width: 1760px;*/ margin-bottom: 40px; } #widget_1689240066243 .cr-featuresbox-container { background: #fff; margin: 30px auto 20px; position: relative; padding: 30px 40px 30px 40px; box-shadow: 0px 8px 22px #0000001C; border: 1px solid #FFFFFF1C; overflow: hidden; transition: box-shadow 0.3s ease-in-out; } #widget_1689240066243 .cr-featuresbox-headline { padding-right: 30px; } #widget_1689240066243 .cr-featuresbox-headline h3 { font-size: 28px; font-weight: bold; letter-spacing: -0.64px; margin-top: 0; margin-bottom: 16px; } #widget_1689240066243 .cr-featuresbox-icon img { max-width: 24px !important; position: absolute; /*right: 20px;*/ right: 10px; /*bottom: -24px;*/ top: 10px; opacity: .2; } #widget_1689240066243 .cr-featuresbox-link { position: absolute; top: 0; right: 0; bottom: 0; left: 0; display: block; z-index: 9; display: flex; justify-content: space-between; align-items: center; } #widget_1689240066243 .cr-featuresbox-link svg { max-width: 30px; height: auto; margin-right: 24px; position: absolute; right: 0px; z-index: -1; } #widget_1689240066243 .cr-featuresbox-link a, #widget_1689240066243 .cr-featuresbox-link a:visited { width: 100%; height: 100%; display: block; text-decoration: none; } #widget_1689240066243 .cr-featuresbox-link a:hover, #widget_1689240066243 .cr-featuresbox-link a:active { text-decoration: none; } #widget_1689240066243 .cr-featuresbox-text { font-size: 16px; padding-right: 120px; } #widget_1689240066243 .cr-featuresbox-readmore { text-align: right; margin-top: 40px; } #widget_1689240066243 .cr-featuresbox-readmore svg { max-width: 22px; height: auto; margin-left: 5px; } #widget_1689240066243 .cr-featuresbox-container p:last-child { margin-bottom: 0; } #widget_1689240066243 .cr-featuresbox-readmore a { font-size: 18px; color: #19C0EA; text-decoration: none; font-weight: bold; display: flex; justify-content: flex-end; align-items: center; } #widget_1689240066243 .cr-featuresbox-readmore { text-align: center !important; } #widget_1689240066243 .cr-featuresbox-readmore a { display: inline-block !important; } @media all and (max-width: 767px) { #widget_1689240066243 .cr-featuresbox-container { padding: 20px 30px 20px 30px; } #widget_1689240066243 .cr-featuresbox-text { padding-right: 0px; } #widget_1689240066243 .cr-featuresbox-link { align-items: flex-start; } #widget_1689240066243 .cr-featuresbox-headline { padding-right: 0px; } #widget_1689240066243 .cr-featuresbox-link svg { margin-top: 24px; } #widget_1689240066243 .cr-featuresbox-headline h3 { font-size: 22px; padding-right: 30px; } } </style> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>Columnar storage</h3> </div> <div class="cr-featuresbox-text"> CrateDB can easily accommodate hundreds of columns in a single table. It uses a <a href="/product/features/indexing-columnar-storage-aggregations#columnar-storage" rel="noopener">columnar storage</a> format, which is highly efficient for time series data storage. Columnar data storage allows for faster <a href="/product/features/query-performance" rel="noopener">query performance</a>, especially when aggregating data over long periods or subsets of the data. </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>High cardinality</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB offers robust support for <a href="/product/features/partitioning" rel="noopener">time partitioning</a>. It enables data to be stored long-term without any need for aggregation or down-sampling. This is crucial because the original, un-aggregated data often contains granular details that may be lost during aggregation. By preserving this level of detail, you get enhanced flexibility to revisit historical data for new insights, or conduct precise forecasting, which is crucial to strategic decision-making processes.</p> <p>With CrateDB, you can also move your old partitions to slow but cheap spinning disks, while keeping the most recent data on fast SSDs, all while retaining fast query speed for most recent data, and not loosing any details in older data.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>Time series functionality</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB includes built-in time-series functionality, such as window functions and time-based indexes. These features make it easier to query and analyze the data, and can improve <a href="/product/features/query-performance" rel="noopener">query performance</a>.</p> <ul> <li><strong><code>LEAD</code></strong> and <strong><code>LAG</code> </strong>functions, with <code>IGNORE NULLS</code> option, to fill and extrapolate missing data.</li> <li><code><strong>DATE_BIN</strong></code> function to resample the data and use the same intervals on the time axis.</li> <li><code><strong>WINDOW</strong></code> function.</li> <li><strong><code>JOIN</code> </strong>operator to easily combine time series data in one table and corresponding metadata in another table. This avoids pushing too much data in your application.</li> </ul> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>Much more than a time series database</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB offers a much broader scope; it is <a href="/product/features/flexible-data-modeling" rel="noopener">built for multiple types of data</a> and you can combine them all into the same database: time series, JSON, vector, full-text, geospatial, BLOB and relational. This way, you can easily cover most of your needs, without investing in some new costly technology that needs complex maintenance and data synchronization.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>SQL interface</h3> </div> <div class="cr-featuresbox-text"> CrateDB is a database supporting native SQL, which is the most familiar and powerful query language for many developers. This makes it easy to query and analyze without needing to learn a new query language or tool. Getting instant analytics is very straightforward. CrateDB also provides a HTTP endpoint to submit SQL queries. </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>Integrations</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB integrates seamlessly with popular modern data visualization tools like Grafana, or libraries like Matplotlib. It also offers compatibility with the Java- and Python-based data ecosystem and corresponding libraries and frameworks such as pandas, Dask, or Spark, to facilitate efficient analysis and visualization of time series data. </p> <p><a data-stringify-link="https://cratedb.com/integrations" href="/integrations" rel="noopener noreferrer" delay="150">View a sample list of integrations ></a></p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>Distributed architecture</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB is a <a href="/product/features/distributed-database" rel="noopener">distributed database</a> that can <a href="/product/features/speed-and-scalability" rel="noopener">scale horizontally</a> across multiple nodes. This makes it an ideal fit for time series workloads, which often involve handling large volumes of data from multiple different sources (sensors, IoT gateways, CRM, ERP...) that need to be ingested, enriched and processed on the fly to serve many simultaneous data consumers in real-time.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container cr-ul-bullets"> <div class="cr-featuresbox-headline"> <h3>Open source</h3> </div> <div class="cr-featuresbox-text"> CrateDB open source licensing model leverages the power of an active community and brings your licensing costs down. Whether you want complete peace of mind with the SaaS model or deploy the product yourself, we have the <a href="/product/pricing/plans" rel="noopener">right option for you</a> if you decide to go for a fast and scalable open source time series database. </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-7 dnd-section dnd_area-row-3-padding dnd_area-row-3-vertical-alignment"> <div class="row-fluid "> <div class="span6 widget-span widget-type-cell cell_17131818324482-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="0" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-8 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget module_17131818324486-flexbox-positioning dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17131818324486" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-cta" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_module_17131818324486_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_cta" style="" data-hs-cos-general-type="widget" data-hs-cos-type="cta"><div class="hs-cta-embed hs-cta-simple-placeholder hs-cta-embed-160701170698" style="max-width:100%; max-height:100%; width:564px;height:295px" data-hubspot-wrapper-cta-id="160701170698"> <a href="/hs/cta/wi/redirect?encryptedPayload=AVxigLJh37pD8MZzQ7g0ugpG2uLSDaL8NvJMGxy4xsDPpaOrMpwxQPgFZ1UrI8BHecnSTV%2FUFhHAE665SHWU2H1FTQ32EPOY6vwdIN4EGNR5vOMQQKm2PwkG11%2FdYWHoA0Olf%2Bg9zM8t1sHEvgtcOGDfXUWzO%2FY156XqBYrXNrWFUyqXH30WtMrKamAVZqPSKZEkCr3sqSw1lTzJ1%2ByyykAPzFjj9ygs4w%3D%3D&webInteractiveContentId=160701170698&portalId=19927462" target="_blank" rel="noopener" crossorigin="anonymous"> <img alt="Whitepaper" Guide for Time Series Data Projects" loading="lazy" src="https://no-cache.hubspot.com/cta/default/19927462/interactive-160701170698.png" style="height: 100%; width: 100%; object-fit: fill" onerror="this.style.display='none'"> </a> </div> </span></div> </div> </div> </div> </div> <div class="span6 widget-span widget-type-cell cell_17131818324483-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="6" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-9 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17131818324489" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_module_17131818324489_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h3>Guide for time series data projects</h3> <p>This comprehensive guide covers the different key aspects of time series data projects. It is divided in 3 distinct white papers. Part 1: data modeling, storage, lifecycle; Part 2: ingestion, indexing, analysis, and optimization; Part 3: visualization, and advanced analysis through machine learning.</p> <p></p><div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="160701195100"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIZU1Au1kXu0oGN%2F%2FsfqE%2BUD2l82BSvT8t05HgLDA87uJpPUmK15O3JeJpDrBGfwZzP5Y6%2F%2Bu586EEEeABAaslNoqgcCbVCw%2BsnNRo09esFvSKOnIbqQdHE7tCAGNt3NBt2F69HUhHhbYTYKSfUg9edZa1azi9%2Bydto7Fc9kRpdMvQDn0NhuE4lqhneBXCpeaVSiEoqZcfTU%2Bv6XX%2FShQDaK7NyaQ%3D%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-160701195100 hs-button " data-hubspot-cta-id="160701195100"> Download now </a> </div><p></p></span> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-10 dnd-section dnd_area-row-4-padding dnd_area-row-4-vertical-alignment"> <div class="row-fluid "> <div class="span6 widget-span widget-type-cell cell_17218147704662-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="0" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-11 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218147704665" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_module_17218147704665_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h3>Demo: Querying heterogeneous time-series data with SQL</h3> <p>In this video, discover how to effortlessly create a table and seamlessly import weather data into CrateDB. Witness the power of CrateDB's time-series query capabilities in action with the weather dataset, showcasing the dynamic schema flexibility. Dive deeper into CrateDB's multi-modal features with demonstrations on handling JSON, geospatial data, and conducting full-text searches.</p></span> </div></div> </div> </div> </div> </div> <div class="span6 widget-span widget-type-cell cell_17218147704663-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="6" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-12 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218147704668" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="hs-video-widget" data-hsv-embed-id="42ffc91c-e7b0-4127-835d-b3fc6a4fa9c4"> <div class="hs-video-container" style="max-width: 1920px; margin: 0 auto;"> <div class="hs-video-wrapper" style="position: relative; height: 0; padding-bottom: 56.25%"> <iframe data-hsv-src="https://play.hubspotvideo.com/v/19927462/id/165817308419?play_button_color=19c0ea" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="165817308419" data-hsv-play-button-color="19c0ea" data-hsv-width="1920" data-hsv-height="1080" data-hsv-full-width="false"></iframe> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-13 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218147704669" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div data-module="advanced-section" class="module-section-options" id="module-section-options-822919"> </div> <script id="module-section-options-822919"> if( window._fr == null) { window._fr = []; } if( window._fr.sections == null) { window._fr.sections = []; } var options = { 'moduleID': 'module-section-options-822919', 'enable': 'true', 'layout':{ }, 'typography': { }, 'background': { }, 'advanced': { 'css_classes' : 'cr-reverse' } }; window._fr.sections.push(options); </script></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-14 dnd-section dnd_area-row-5-margin dnd_area-row-5-background-layers dnd_area-row-5-background-color"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-15 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17120586271744" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-getstarted-items-wrapper" id="module_17120586271744"> <style> #module_17120586271744.cr-getstarted-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_17120586271744 .cr-getstarted-header { margin-bottom: 32px; display: flex; align-items: center; margin-right: 20px; } #module_17120586271744 .cr-getstarted-item { margin-right: 20px; } #module_17120586271744 .cr-getstarted-items { display: flex; flex-direction: row; } #module_17120586271744 .cr-getstarted-header h2 { letter-spacing: -2.04px; color: #0A2327; margin-right: 30px; margin-bottom: 0; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; } #module_17120586271744 .cr-getstarted-header svg { height: 50px; width: auto; } #module_17120586271744 .cr-getstarted-container.cr-gestarted-inline { display: flex; align-items: center; /*justify-content: space-between;*/ } #module_17120586271744 .cr-gestarted-inline .cr-getstarted-header, #module_17120586271744 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 0px; } @media all and (max-width: 767px) { #module_17120586271744 .cr-getstarted-container.cr-gestarted-inline { display: block; } #module_17120586271744 .cr-gestarted-inline .cr-getstarted-header { margin-bottom: 20px; } #module_17120586271744 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 12px; } #module_17120586271744 .cr-getstarted-header svg { height: 30px; margin-bottom: 12px; } } </style> <div class="cr-getstarted-container cr-gestarted-inline"> <div class="cr-getstarted-header"> <h2>Curious to learn more?</h2> </div> <div class="cr-getstarted-items"> <div class="cr-getstarted-item"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178354041242"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLJ2fYtuisS6upchjYnFUMioD42cAqgEegnt3kQGe4xeqtdi9DMaB7GxLBxBHrHrv6GBnKYkmXvVXiK7LF%2FpfRtylwh%2FTzzkRzROz050BPrfs%2FLahkmb74ko3Zk70ABDL0Z0vwh6dpz6t6ouKwE8THbfIPF8qvzEKvkU05rTB4vSQ%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178354041242 hs-button " data-hubspot-cta-id="178354041242"> Start free </a> </div> </div> <div class="cr-getstarted-item"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178354187893"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLJGHG2p3DrfPDYxmBgP02fw4GVz%2BC0HVp9F%2FgZN6UbFZ%2Bx%2FGYCTkGtSsxZ8E8C5nuQ8Ee9Qx2JQgimQGTvHqWBbr5U4SPElO01wmFIO75Kdqb5bcm5xvp0HAEA1J1FvLtGc9nk8ZyvG%2FT3tnPx5qX%2Fv4fqu81EU6o5BnBEmdw%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178354187893 hs-button " data-hubspot-cta-id="178354187893"> Contact us </a> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-16 dnd_area-row-6-padding dnd_area-row-6-vertical-alignment dnd-section"> <div class="row-fluid "> <div class="span6 widget-span widget-type-cell cell_17218147893532-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="0" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-17 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget module_17218147893535-flexbox-positioning dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218147893535" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-cta" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_module_17218147893535_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_cta" style="" data-hs-cos-general-type="widget" data-hs-cos-type="cta"><div class="hs-cta-embed hs-cta-simple-placeholder hs-cta-embed-154010709398" style="max-width:100%; max-height:100%; width:564px;height:317px" data-hubspot-wrapper-cta-id="154010709398"> <a href="/hs/cta/wi/redirect?encryptedPayload=AVxigLKg3S929CC2k4TL5jmdHQRzegeZy8D92ZifS6GdYLNAAVwKZdLwNyfL8uJ6UY17ze%2BCTA0mbBlEvSqXpZWgBUxtHL6t4iE5ZRMxihf9z4tSfI9cyBp6es%2BuX2fO030vfejnEvlQYU5OmHnzjyLehPach01bdWvieWOFaUVJk%2B3vK0L4UAPAYoTgnh7Nb0Ctth1TsjIWtk0mthA%3D&webInteractiveContentId=154010709398&portalId=19927462" target="_blank" rel="noopener" crossorigin="anonymous"> <img alt="Top 8 Most Asked Questions around Time-series Databases" loading="lazy" src="https://no-cache.hubspot.com/cta/default/19927462/interactive-154010709398.png" style="height: 100%; width: 100%; object-fit: fill" onerror="this.style.display='none'"> </a> </div> </span></div> </div> </div> </div> </div> <div class="span6 widget-span widget-type-cell cell_17218147893533-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="6" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-18 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218147893537" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_module_17218147893537_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h3>Top 8 most asked questions</h3> <p>Discover some of the common questions around time-series databases, including their advantages over traditional databases, best practices for managing them, and the industries that can benefit the most from their adoption. This white paper contains 8 essential things you need to know about time-series databases. </p> <p></p><div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="153599597170"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLKLhY9K1%2FD%2BBRRg6I9SmJDzpJXx0pMO2Ch6onIzVLQ5i9oxmsNlmW6rWEiNLykCW6tA9g6LPTBI2ZjV0USNKOJYKLMKDbzeev6u47k7Qwicd9%2Blih9liEnOCKTERiOks5jHkq5NBrqsawm%2BBhzlegkLkFW0Z3OTFUK1Bu6xj2u5iFekE0xNC0slkQ0xKP%2BMraWuP37XJlAbfDY%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-153599597170 hs-button " data-hubspot-cta-id="153599597170"> Download now </a> </div><p></p></span> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-19 dnd_area-row-7-vertical-alignment dnd-section dnd_area-row-7-padding"> <div class="row-fluid "> <div class="span6 widget-span widget-type-cell cell_17104114473432-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="0" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-20 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17104114473435" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_module_17104114473435_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h3>Time series online course</h3> <p>The free CrateDB Advanced Time Series course will teach you all you need to know about using CrateDB for time series data. Once you’ve completed this course you’ll be ready to get your certificate and tackle your first time series project with CrateDB. </p> <p></p><div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="173846246186"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLKu%2FNtl5mH30O57PHjTHlBuZGYCzqdL3Sl7Mc1dML1%2Fcd68MYwAxA8ax3%2BQfqr2rqPBwxHyJHnpKsovf4VbROgsbrSOciiz6Wk%2Bng4IPvqfHK5itUfsQZB%2Fq6Z4YBqNq5QweVELVLU7KUXaJ3eYX%2FjSiHNUjUMHwnEtWZglVzQYq5wlwC5%2Fy%2BM2spCfsG8fQeNi%2Fy2rdf1uw8l2AmNNxEaHtwWDfPi6jOKCj4jOAs0fkZM2Fv2dnBxaf1U%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-173846246186 hs-button " data-hubspot-cta-id="173846246186"> Explore </a> </div><p></p></span> </div></div> </div> </div> </div> </div> <div class="span6 widget-span widget-type-cell cell_1721814797429-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="6" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-21 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget module_17104114473437-flexbox-positioning dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17104114473437" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-cta" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_module_17104114473437_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_cta" style="" data-hs-cos-general-type="widget" data-hs-cos-type="cta"><div class="hs-cta-embed hs-cta-simple-placeholder hs-cta-embed-173846246229" style="max-width:100%; max-height:100%; width:1200px;height:675px" data-hubspot-wrapper-cta-id="173846246229"> <a href="/hs/cta/wi/redirect?encryptedPayload=AVxigLKkwqWt86%2Fy9Mh6PaRD%2F1uReTNBc6IXGD9VCYonQLFUkYK9boAuo1%2BVBNWWBkuAAzgM%2Bmnh9nIMz278%2Fn008qZhzT1mXVNk3g8bwaZ11SaQUiPSYypgFV8%2FbCj6pJwf1jPf03bio3hnoEg0rK9IJAoLARQSozBkU6mNf1b3M4zBLKoAlQA3CndsU0x3uDfO98hTQu2IWuJ6RmAbIfuIKFIe5fhmPdHGuQz%2B8%2FW3jLKPs6md%2FgaW6GVxmqA%3D&webInteractiveContentId=173846246229&portalId=19927462" target="_blank" rel="noopener" crossorigin="anonymous"> <img alt="Advanced Time Series Course: learn.cratedb.com" loading="lazy" src="https://no-cache.hubspot.com/cta/default/19927462/interactive-173846246229.png" style="height: 100%; width: 100%; object-fit: fill" onerror="this.style.display='none'"> </a> </div> </span></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-22 dnd-section dnd_area-row-8-background-layers dnd_area-row-8-padding dnd_area-row-8-background-color"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-23 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17120581628597" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_module_17120581628597_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h2>Additional resources on time series</h2></span></div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-24 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17120581628598" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_17120581628598{ } #module_17120581628598 h1 { color: ; } </style> <div class="cr-relatedcontent" id="module_17120581628598"> <div class="content-wrapper"> <div class="cr-relatedcontent-cards"> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>White Paper</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/resources/white-papers/lp-wp-cratedb-vs-influxdb"> Time-Series Data at Scale: A Comparative Study of CrateDB and InfluxDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_17120581628598_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Blog</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/blog/independent-time-series-benchmark-confirms-cratedb-top-tier-performance"> Independent Time Series Benchmark Confirms CrateDB’s Top-Tier Performance</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_17120581628598_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Page</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/data-model/time-series/choosing-the-right-time-series-database"> Choosing the Right Time Series Database</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_17120581628598_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Page</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/data-model/time-series/time-series-data"> Time Series Data: Context, Modeling, Storage, and Lifecycle</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_17120581628598_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Page</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/data-model/time-series/ingestion"> Time Series Data: Ingestion, Indexing, Analysis and Optimization</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_17120581628598_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Page</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/data-model/time-series/data-visualization"> Time Series Data: Visualization, EDA, Forecasting, and Anomaly Detection</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_17120581628598_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-25 dnd-section dnd_area-row-9-padding dnd_area-row-9-vertical-alignment"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell cell_1695628590024-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-26 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_1699285940420" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_1699285940420 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; margin-bottom: 0px !important; margin-top: 0px !important; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; margin-bottom: 0px !important; margin-top: 0px !important; } @media all and (max-width: 767px) { #module_1699285940420 h2.cr-headline { font-size: 20px; margin-bottom: 20px; margin-bottom: 0px !important; margin-top: 0px !important; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="module_1699285940420" class="cr-headline" style="">User stories</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-27 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1729007651138" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-customer-quote" id="widget_1729007651138"> <style> #widget_1729007651138{ } #widget_1729007651138.cr-customer-quote { /*max-width: 1760px;*/ margin: 0 auto; } #widget_1729007651138 .cr-customer-quote-item { box-shadow: 6px 7px 11px #00000015; overflow: auto; position: relative; margin-bottom: 40px; /*height: 400px;*/ width: 100%; } #widget_1729007651138 .cr-customer-quote-item::before { background: transparent linear-gradient(126deg, #F3F3F3 0%, #FFFFFF 100%) 0% 0% no-repeat padding-box; content: ''; display: block; height: 100%; position: absolute; width: 100%; z-index: -1; } #widget_1729007651138 .cr-customer-quote-item-inner { display: flex; flex-direction: column; justify-content: space-between; padding: 0px 0 0px 30px; height: 100%; } #widget_1729007651138 .cr-customer-quote-logo { flex-grow: 1; margin-top: 20px; } #widget_1729007651138 .cr-customer-quote-quotee-image img { height: 400px !important; width: auto; position: absolute; right: 0; top: 0; max-height: 100%; } #widget_1729007651138 .cr-customer-quote-quotee-image { float: right; /*width: 0;*/ } #widget_1729007651138 .cr-customer-quote-logo img { max-height: 60px; max-width: 250px !important; object-fit: contain; object-position: left; } #widget_1729007651138 .cr-customer-quote-quote { padding: 20px; box-shadow: 0px 8px 22px #0000001C; margin-bottom: 30px; } #widget_1729007651138 .cr-customer-quote-text { max-width: 600px; font-size: 20px; line-height: 1.3; font-weight: 500; } #widget_1729007651138 .cr-customer-quote-quotee { margin-bottom: 40px; } /* usecase overrides */ #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-item-inner { flex-direction: row; } #widget_1729007651138 .cr-customer-quote-section-usecase.cr-customer-quote-item { min-height: 400px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase { max-width: 300px; margin-top: 80px; padding-top: 80px; /*padding-bottom: 80px;*/ border-right: 1px solid #E2E2E2; padding-right: 48px; } #widget_1729007651138 .cr-customer-quote-cagetories { margin-bottom: 24px; color: #E3B15B; font-size: 16px; font-weight: 600; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-valign .cr-customer-quote-logo { flex-grow: 0; margin-top: 40px; position: absolute; top: 0; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-left:not(.cr-customer-quote-valign) .cr-customer-quote-usecase { margin-top: -30px; padding-top: 50px; padding-bottom: 30px; border-right: 1px solid #E2E2E2; padding-right: 48px; margin-bottom: 30px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-left:not(.cr-customer-quote-valign) .cr-customer-quote-quote { margin-top: 80px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-quote { padding: 0; box-shadow: none; margin-bottom: 0; margin-right: 40px; margin-top: 30px; } /*#widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-center:not(.cr-customer-quote-valign) .cr-customer-quote-quote { margin-top: 0; padding: 40px 0 0px; }*/ #widget_1729007651138 .cr-customer-quote-text p:last-child { margin-bottom: 0; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-center:not(.cr-customer-quote-valign) { flex-grow: 1; display: flex; position: relative; flex-direction: column; align-items: start; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-text, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-text p, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase p { font-size: 14px; max-width: 530px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-center { flex-grow: 1; display: flex; position: relative; flex-direction: column; align-items: start; justify-content: center; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-left { margin-right: 40px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-quotee-image img { max-height: 100% !important; width: 100%; position: relative; right: 0; top: 0; object-fit: cover; height: 100% !important; min-width: 18vw; max-width: 350px !important; min-height: 400px; height: 100%; } #widget_1729007651138 .cr-customer-quote-item.cr-customer-quote-section-quote { height: 400px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-quotee-image { float: none; height: 100%; object-fit: cover; width: auto; overflow: hidden; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-cagetories span { margin-right: 15px; } #widget_1729007651138 .button-group.filters-button-group { margin-bottom: 24px; } #widget_1729007651138 .button-group button { background-color: #19C0EA; margin-bottom: 4px; border: 1px solid #19C0EA; border-radius: 4px; color: #fff; padding: 8px 20px; font-size: 16px; border-radius: 0; opacity: 1; transition: all .3s; } #widget_1729007651138 .button-group button:hover, #widget_1729007651138 .button-group button.is-checked { opacity: 1; background-color: #E3B15B; border: 1px solid #E3B15B; } #widget_1729007651138 .cr-customer-quote-readmore { position: relative; margin-bottom: 40px; text-align: right; margin-top: 40px; } #widget_1729007651138 .cr-customer-quote-readmore a, #widget_1729007651138 .cr-customer-quote-readmore a:visited{ padding: 10px 26px; background-color: #19C0EA; color: #fff; font-weight: bold; text-decoration: none; font-size: 14px; text-transform: uppercase; border: 2px solid transparent; transition: all .2s ease-in-out; } #widget_1729007651138 .cr-customer-quote-readmore a:hover, #widget_1729007651138 .cr-customer-quote-readmore a:active, #widget_1729007651138 .cr-customer-quote-readmore a:focus{ background-color: #ffffff; color: #19C0EA; text-decoration: none; border: 2px solid #19C0EA; } @media all and (max-width: 1080px) { #widget_1729007651138 .cr-customer-quote-quotee-image { display: none; } #widget_1729007651138 .cr-customer-quote-item, #widget_1729007651138 .cr-customer-quote-section-usecase.cr-customer-quote-item{ height: auto; min-height: unset !important; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-text, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-text p, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase p, #widget_1729007651138 .cr-customer-quote-text { font-size: 14px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-center:not(.cr-customer-quote-valign) { padding-top: 20px; padding-bottom: 20px; } } @media all and (max-width: 980px) { #widget_1729007651138 .cr-customer-quote-item.cr-customer-quote-section-quote { height: auto; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-text, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-text p, #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase p, #widget_1729007651138 .cr-customer-quote-text { font-size: 14px !important; } } @media all and (min-width: 769px) { .cr-customer-quote-section-quote .cr-customer-quote-logo { margin-bottom: 10px; } } @media (max-width: 767px) { #widget_1729007651138 { } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-item-inner { flex-direction: column; } #widget_1729007651138 .cr-customer-quote-item-inner { padding: 0px 15px 0px 15px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-left { margin-right: 0px; } #widget_1729007651138.cr-customer-quote { padding: 0; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-center:not(.cr-customer-quote-valign) { flex-direction: column; align-items: normal; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-valign .cr-customer-quote-logo { margin-top: 30px; position: relative; margin-bottom: 20px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-usecase { margin-top: 20px; padding-top: 0; padding-bottom: 0px; border-right: none; padding-right: 0px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-quote { padding: 0; box-shadow: none; margin-bottom: 30px; padding-top: 15px; margin-right: 0px; border-top: 1px solid #E2E2E2; margin-top: 0px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-left:not(.cr-customer-quote-valign) .cr-customer-quote-usecase { border-right: none; margin-top: 20px; padding-top: 0; padding-bottom: 15px; padding-right: 0; margin-bottom: 0px; } #widget_1729007651138 .cr-customer-quote-section-usecase .cr-customer-quote-center:not(.cr-customer-quote-valign) { padding-top: 0; padding-bottom: 0; } #widget_1729007651138 .cr-customer-quote-readmore { position: relative; right: unset; bottom: unset; margin-left: 0px; margin-bottom: 30px; text-align: left !important; margin-top: 0px; } #widget_1729007651138 .cr-customer-quote-logo { margin-top: 20px; margin-bottom: 20px; } } </style> <div class="cr-customer-quote-items"> <div class="cr-customer-quote-item cr-customer-quote-section-usecase "> <div class="cr-customer-quote-item-inner"> <div class="cr-customer-quote-left "> <div class="cr-customer-quote-logo"> <span class="cr-customer-quote-cagetories" style="display: block;"> Supply chain & Logistics </span> <img src="https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=272&height=75&name=customer-logo-tgw.png" alt="TGW-Logo" loading="lazy" width="272" height="75" style="height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=136&height=38&name=customer-logo-tgw.png 136w, https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=272&height=75&name=customer-logo-tgw.png 272w, https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=408&height=113&name=customer-logo-tgw.png 408w, https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=544&height=150&name=customer-logo-tgw.png 544w, https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=680&height=188&name=customer-logo-tgw.png 680w, https://cratedb.com/hs-fs/hubfs/logos/customers/customer-logo-tgw.png?width=816&height=225&name=customer-logo-tgw.png 816w" sizes="(max-width: 272px) 100vw, 272px"> </div> <div class="cr-customer-quote-usecase"> <div id="hs_cos_wrapper_widget_1729007651138_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="use_case_description">TGW Logistics Group is one of the leading international suppliers of material handling solutions. As systems integrator, TGW plans, produces and implements complex logistics centres, from mechatronic products and robots to control systems and software. <br><br>Using CrateDB, TGW accelerates data aggregation and access from warehouse systems worldwide, resulting in increased database performance. The system can handle over 100,000 messages every few seconds.</div> </div> </div> <div class="cr-customer-quote-center cr-customer-quote-valign"> <div class="cr-customer-quote-quote"> <div class="cr-customer-quote-text" style="color: rgba(255, 255, 255, 1.0);"> <div id="hs_cos_wrapper_widget_1729007651138_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="quote_text"><p>"CrateDB is a highly scalable database for time series and event data with a very fast query engine using standard SQL". <br><br></p> <p><strong>Alexander Mann</strong><br>Owner Connected Warehouse Architecture<br>TGW Logistics Group</p></div> </div> </div> <div class="cr-customer-quote-readmore"> <a href="https://cratedb.com/stories/tgw-logistics">Read more</a> </div> </div> <div class="cr-customer-quote-right"> <div class="cr-customer-quote-quotee-image"> <img src="https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=760&height=428&name=TGW-Warehouse-2.jpg" alt="TGW-Warehouse-2" loading="lazy" width="760" height="428" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=380&height=214&name=TGW-Warehouse-2.jpg 380w, https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=760&height=428&name=TGW-Warehouse-2.jpg 760w, https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=1140&height=642&name=TGW-Warehouse-2.jpg 1140w, https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=1520&height=856&name=TGW-Warehouse-2.jpg 1520w, https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=1900&height=1070&name=TGW-Warehouse-2.jpg 1900w, https://cratedb.com/hs-fs/hubfs/TGW-Warehouse-2.jpg?width=2280&height=1284&name=TGW-Warehouse-2.jpg 2280w" sizes="(max-width: 760px) 100vw, 760px"> </div> </div> </div> </div> <div class="cr-customer-quote-item cr-customer-quote-section-usecase "> <div class="cr-customer-quote-item-inner"> <div class="cr-customer-quote-left "> <div class="cr-customer-quote-logo"> <span class="cr-customer-quote-cagetories" style="display: block;"> Construction </span> <img src="https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=200&height=101&name=Thomas-Concrete-Group-logo.png" alt="Thomas-Concrete-Group-logo" loading="lazy" width="200" height="101" style="height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=100&height=51&name=Thomas-Concrete-Group-logo.png 100w, https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=200&height=101&name=Thomas-Concrete-Group-logo.png 200w, https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=300&height=152&name=Thomas-Concrete-Group-logo.png 300w, https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=400&height=202&name=Thomas-Concrete-Group-logo.png 400w, https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=500&height=253&name=Thomas-Concrete-Group-logo.png 500w, https://cratedb.com/hs-fs/hubfs/Thomas-Concrete-Group-logo.png?width=600&height=303&name=Thomas-Concrete-Group-logo.png 600w" sizes="(max-width: 200px) 100vw, 200px"> </div> <div class="cr-customer-quote-usecase"> <div id="hs_cos_wrapper_widget_1729007651138_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="use_case_description">Thomas Concrete Group is the world- leader organization in the construction industry with 150+ concrete plants and 2,100+ employees. They use CrateDB both for tracking of their delivery trucks and tracking the curing of the concrete in real-time.</div> </div> </div> <div class="cr-customer-quote-center cr-customer-quote-valign"> <div class="cr-customer-quote-quote"> <div class="cr-customer-quote-text" style="color: rgba(255, 255, 255, 1.0);"> <div id="hs_cos_wrapper_widget_1729007651138_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="quote_text"><p>"Thanks to CrateDB's great indexing, dedicated data types, and subsequent great performance, we could execute an event and data-driven architecture, with the performance and scalability necessary for storing time-series data over time. The SQL query syntax capability of CrateDB also played a part in achieving this great outcome, as it made it easy for the team to write good performing queries using existing know-how. CrateDB is now an integral part of our big data streaming architecture and it is delivering as promised."</p> <p><strong>Kristoffer Axelsson</strong><br>Principal Solution Architect<br>Thomas Concrete Group</p></div> </div> </div> <div class="cr-customer-quote-readmore"> <a href="https://cratedb.com/stories/thomas-concrete-group">Read more</a> </div> </div> <div class="cr-customer-quote-right"> <div class="cr-customer-quote-quotee-image"> <img src="https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=626&height=455&name=Thomas.jpg" alt="Thomas" loading="lazy" width="626" height="455" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=313&height=228&name=Thomas.jpg 313w, https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=626&height=455&name=Thomas.jpg 626w, https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=939&height=683&name=Thomas.jpg 939w, https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=1252&height=910&name=Thomas.jpg 1252w, https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=1565&height=1138&name=Thomas.jpg 1565w, https://cratedb.com/hs-fs/hubfs/Thomas.jpg?width=1878&height=1365&name=Thomas.jpg 1878w" sizes="(max-width: 626px) 100vw, 626px"> </div> </div> </div> </div> <div class="cr-customer-quote-item cr-customer-quote-section-usecase "> <div class="cr-customer-quote-item-inner"> <div class="cr-customer-quote-left "> <div class="cr-customer-quote-logo"> <span class="cr-customer-quote-cagetories" style="display: block;"> Entertainment </span> <img src="https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=829&height=120&name=digitaldomain-logo-1.png" alt="digitaldomain-logo-1" loading="lazy" width="829" height="120" style="height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=415&height=60&name=digitaldomain-logo-1.png 415w, https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=829&height=120&name=digitaldomain-logo-1.png 829w, https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=1244&height=180&name=digitaldomain-logo-1.png 1244w, https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=1658&height=240&name=digitaldomain-logo-1.png 1658w, https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=2073&height=300&name=digitaldomain-logo-1.png 2073w, https://cratedb.com/hs-fs/hubfs/digitaldomain-logo-1.png?width=2487&height=360&name=digitaldomain-logo-1.png 2487w" sizes="(max-width: 829px) 100vw, 829px"> </div> <div class="cr-customer-quote-usecase"> <div id="hs_cos_wrapper_widget_1729007651138_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="use_case_description">Digital domain is a global leader in visual effects, interactive content and creating “virtual humans” for use in films and live events. Rather than use a commercial monitoring system, they chose to build their own performance monitoring solution. They use CrateDB to process a lot of system metrics data (time series) in real time and to support streaming log analytics, which required search capability.</div> </div> </div> <div class="cr-customer-quote-center cr-customer-quote-valign"> <div class="cr-customer-quote-quote"> <div class="cr-customer-quote-text" style="color: rgba(255, 255, 255, 1.0);"> <div id="hs_cos_wrapper_widget_1729007651138_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="quote_text"><p>"I'm glad it's SQL behind those charts. If I had to use Elasticsearch to answer new questions, we wouldn't be nearly as responsive to new requirements."</p> <p> </p> <p><strong>Joe Hacobian</strong><br>Infrastructure Engineer<br>Digital Domain</p></div> </div> </div> <div class="cr-customer-quote-readmore"> <a href="https://cratedb.com/stories/digital-domain">Read more</a> </div> </div> <div class="cr-customer-quote-right"> <div class="cr-customer-quote-quotee-image"> <img src="https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=626&height=455&name=Digital-domain.jpg" alt="Digital-domain" loading="lazy" width="626" height="455" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=313&height=228&name=Digital-domain.jpg 313w, https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=626&height=455&name=Digital-domain.jpg 626w, https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=939&height=683&name=Digital-domain.jpg 939w, https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=1252&height=910&name=Digital-domain.jpg 1252w, https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=1565&height=1138&name=Digital-domain.jpg 1565w, https://cratedb.com/hs-fs/hubfs/Digital-domain.jpg?width=1878&height=1365&name=Digital-domain.jpg 1878w" sizes="(max-width: 626px) 100vw, 626px"> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-28 dnd-section dnd_area-row-10-padding"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-29 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1729780977558" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="cr-related-post-items-wrapper" id="widget_1729780977558"> <style> #widget_1729780977558.cr-related-post-items-wrapper { margin: 0 auto; } #widget_1729780977558 .hs-related-blog-item { min-width: 0; background: #fff; /*margin: 10px 15px;*/ display: flex; flex-direction: column; box-shadow: 6px 7px 11px 6px #00000015; max-width: 580px; } .hs-related-blog-featured-image { max-width: 100%; } /* container */ .hs-related-blog-module { display:block; } /* columns */ .hs-related-blog-module > * { padding:1rem; } /* tablet breakpoint */ @media (min-width:768px) { .hs-related-blog-module { display: grid; grid-auto-rows: 1fr; grid-template-columns: repeat(3,1fr); grid-gap: 24px; } } .cr-related-posts-container-inner .hs_cos_wrapper_type_related_blog_posts > div, .cr-recent-container { display: grid; grid-gap: 40px; grid-template-columns: repeat(3, 1fr); } .related-blog-title h3 { letter-spacing: -1px; font-weight: 600; font-size: 20px; margin-bottom: 2px; margin-top: 6px; } .related-blog-item img { max-width: 100%; } a.related-blog-title:hover, a.related-blog-title:focus, a.related-blog-title:active { text-decoration: none !important; } .blog-index_post_timestamp { margin-bottom: 4px; margin-top: 4px; } .related-blog-post-summary { font-size: 16px; } .cr-related-readmore { font-size: 16px !important; margin-top: 10px; } a.related-blog-title:hover h3 { color: var(--cr-primary-color) !important; } p.cr-meta-content { margin-bottom: 8px; } .related-meta { padding: 10px 20px 20px; } .cr-related-tag a { text-transform: uppercase; color: var(--cr-primary-color) !important; display: inline-block; font-size: .875rem; font-weight: 700; letter-spacing: 1px; margin-right: 5px; } .cr-related-tag { display: inline-block; margin-bottom: 4px; } @media all and (max-width: 980px) { .cr-related-posts-container-inner .hs_cos_wrapper_type_related_blog_posts > div, .cr-recent-container { grid-template-columns: auto auto; } } @media all and (max-width: 600px) { .cr-related-posts-container-inner .hs_cos_wrapper_type_related_blog_posts > div, .cr-recent-container { grid-template-columns: auto; } } </style> <div class="cr-related-posts-container-outer"> <h2>Related blog posts</h2> <div class="cr-related-posts-container-inner"> <div class="cr-related-posts-container-inner cr-recent-container"> <div class="related-blog-item hs-related-blog-item"> <a class="related-blog-image-url" href="https://cratedb.com/blog/independent-time-series-benchmark-confirms-cratedb-top-tier-performance"><img loading="lazy" src="https://cratedb.com/hubfs/time%20series%20speed-2.png" alt="time series benchmark"></a> <div class="related-meta"> <div class="cr-related-tag"><a href="https://cratedb.com/blog/tag/benchmarks">Benchmarks</a></div> <div class="cr-related-tag"><a href="https://cratedb.com/blog/tag/performance">Performance</a></div> <div class="cr-related-tag"><a href="https://cratedb.com/blog/tag/time-series-data">time series data</a></div> <a class="related-blog-title" href="https://cratedb.com/blog/independent-time-series-benchmark-confirms-cratedb-top-tier-performance"><h3>Independent Time Series Benchmark Confirms CrateDB’s Top-Tier Performance</h3></a> <span class="related-blog-date blog-index_post_timestamp">2024-09-02</span> <p class="cr-meta-content">CrateDB continues to deliver impressive results in the latest TSBS benchmark conducted by Nyrkio. Compared to MongoDB and InfluxDB, CrateDB excels in both ingestion capabilities and complex ad hoc ...</p> <p class="cr-related-readmore read_more_holder"><a href="https://cratedb.com/blog/independent-time-series-benchmark-confirms-cratedb-top-tier-performance">Read more</a></p> </div> </div> <div class="related-blog-item hs-related-blog-item"> <a class="related-blog-image-url" href="https://cratedb.com/blog/guide-to-time-series-data-analysis-in-cratedb-best-tutorials"><img loading="lazy" src="https://cratedb.com/hubfs/data%20historians%20vs%20time%20series.png" alt="guide to time series data analysis"></a> <div class="related-meta"> <div class="cr-related-tag"><a href="https://cratedb.com/blog/tag/tutorial">Tutorial</a></div> <div class="cr-related-tag"><a href="https://cratedb.com/blog/tag/time-series-data">time series data</a></div> <a class="related-blog-title" href="https://cratedb.com/blog/guide-to-time-series-data-analysis-in-cratedb-best-tutorials"><h3>Guide to Time-Series Data Analysis in CrateDB: Best Tutorials</h3></a> <span class="related-blog-date blog-index_post_timestamp">2023-11-29</span> <p class="cr-meta-content">Are you looking for a way to store and analyze your time-series data efficiently? In this blog post, we'll list the best tutorials for getting started with time-series data analysis in CrateDB.</p> <p class="cr-related-readmore read_more_holder"><a href="https://cratedb.com/blog/guide-to-time-series-data-analysis-in-cratedb-best-tutorials">Read more</a></p> </div> </div> <div class="related-blog-item hs-related-blog-item"> <a class="related-blog-image-url" href="https://cratedb.com/blog/data-historians-vs-time-series-databases"><img loading="lazy" src="https://cratedb.com/hubfs/data%20historians%20vs%20time%20series%20databases.gif" alt="data historians vs time series databases"></a> <div class="related-meta"> <div class="cr-related-tag"><a href="https://cratedb.com/blog/tag/time-series-data">time series data</a></div> <a class="related-blog-title" href="https://cratedb.com/blog/data-historians-vs-time-series-databases"><h3>Data Historians vs Time Series Databases: A Comparative Analysis</h3></a> <span class="related-blog-date blog-index_post_timestamp">2023-11-02</span> <p class="cr-meta-content">Choosing your data storage solution is a critical decision for your business. How data is collected, stored, and analyzed can impact how you harness the full potential of your data, the operations, ...</p> <p class="cr-related-readmore read_more_holder"><a href="https://cratedb.com/blog/data-historians-vs-time-series-databases">Read more</a></p> </div> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-30 dnd_area-row-11-background-layers dnd-section dnd_area-row-11-background-color"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-31 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_1712058437011" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-getstarted-items-wrapper" id="module_1712058437011"> <style> #module_1712058437011.cr-getstarted-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_1712058437011 .cr-getstarted-header { margin-bottom: 32px; display: flex; align-items: center; margin-right: 20px; } #module_1712058437011 .cr-getstarted-item { margin-right: 20px; } #module_1712058437011 .cr-getstarted-items { display: flex; flex-direction: row; } #module_1712058437011 .cr-getstarted-header h2 { letter-spacing: -2.04px; color: #0A2327; margin-right: 30px; margin-bottom: 0; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; } #module_1712058437011 .cr-getstarted-header svg { height: 50px; width: auto; } #module_1712058437011 .cr-getstarted-container.cr-gestarted-inline { display: flex; align-items: center; /*justify-content: space-between;*/ } #module_1712058437011 .cr-gestarted-inline .cr-getstarted-header, #module_1712058437011 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 0px; } @media all and (max-width: 767px) { #module_1712058437011 .cr-getstarted-container.cr-gestarted-inline { display: block; } #module_1712058437011 .cr-gestarted-inline .cr-getstarted-header { margin-bottom: 20px; } #module_1712058437011 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 12px; } #module_1712058437011 .cr-getstarted-header svg { height: 30px; margin-bottom: 12px; } } </style> <div class="cr-getstarted-container cr-gestarted-inline"> <div class="cr-getstarted-header"> <h2>Documentation and tutorials</h2> </div> <div class="cr-getstarted-items"> <div class="cr-getstarted-item"> <p></p><div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="162913511955"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIOKecqIuTBsUy5AKmTisCChtoH4jIlodkNVpqy3VmKiuplpVRjnagqOLrkiTRPls5%2FXUoNcU1yTrOM36jZbc6LtSZxEqYKW%2FlDPW20iaHlo%2BB%2BdKYEiQ5oZyLlszRXvWHtiZzHCvBiWs%2FGXGz%2BV0fTJB2nh6EKop1XdfknkXO2vYwWsRMp%2BADvbt3VyK1G1BOkLBcASguO5sehjYfw&portalId=19927462" target="_blank" class="hs-inline-web-interactive-162913511955 hs-button " data-hubspot-cta-id="162913511955"> Learn more </a> </div><p></p> </div> <div class="cr-getstarted-item"> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-32 dnd_area-row-12-padding dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-33 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218048077786" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_17218048077786 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; } @media all and (max-width: 767px) { #module_17218048077786 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="module_17218048077786" class="cr-headline" style="">FAQ</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-34 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218048077787" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="hs-accordion hs-accordion-regular cr-accordion " itemscope itemtype="https://schema.org/FAQPage"> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> What is a time series data format? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>Time-series data is a sequence of data points organized chronologically, illustrating how variables change over time. This format is characterized by patterns such as trends, seasonal variations, and irregularities. Effective time-series data management can significantly enhance query performance and data analysis. CrateDB supports time-series data with built-in functionalities like <a href="/docs/crate/reference/en/latest/general/builtins/window-functions.html#window-functions" rel="noopener">window functions</a> and<a href="/docs/crate/reference/en/latest/general/ddl/fulltext-indices.html" rel="noopener"> time-based indexes</a>, making it easier to analyze and query the data efficiently.</p> </div> </main> </div> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> What are examples of time series data? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>Examples of time series data include temperature readings, stock prices, population growth, monthly subscriptions, quarterly sales, and interest rates. CrateDB supports time series data and offers a comprehensive solution by allowing the integration of multiple data types such as <a href="/data-model/json" rel="noopener">JSON</a>, <a href="/data-model/json" rel="noopener">vector</a>, <a href="/data-model/full-text" rel="noopener">full-text</a>, <a href="/data-model/geospatial" rel="noopener">geospatial</a>, <a href="/product/features/blob-data" rel="noopener">BLOB</a>, and<a href="/data-model/relational" rel="noopener"> relational data</a>, minimizing the need for additional technologies and complex maintenance.</p> </div> </main> </div> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> How do you store time series data? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>Efficient storage of time series data is essential, considering factors like data volume, speed, query requirements, and scalability. The primary storage solutions include time-series databases, NoSQL databases, relational databases, and data warehouses, each offering unique strengths and limitations. CrateDB is designed to handle complex time series data with the <a href="/product/features/native-sql" rel="noopener">simplicity of SQL</a>, allowing for <a href="/product/features/data-import" rel="noopener">high ingest rates </a>and integration of <a href="/database/multi-model" rel="noopener">various data types</a>, making it an ideal choice for storing and querying extensive time series data efficiently. <a href="/blog/how-to-store-time-series-data" rel="noopener">Read more about time series data storage ></a></p> </div> </main> </div> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> Which database is best for time series data? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>When choosing a time-series database, consider factors such as performance, scalability, query language capabilities, data model flexibility, security, maintainability, and reliability. Examples of time-series databases include CrateDB, InfluxDB, KX, and Timescale. CrateDB stands out as a <a href="/product/features/distributed-database" rel="noopener">distributed database</a> that can <a href="/product/features/speed-and-scalability" rel="noopener">scale horizontally across multiple nodes</a>, making it especially suited for handling large volumes of time-series data from diverse sources in real-time. <a href="/blog/best-time-series-databases" rel="noopener">Learn how to choose the best database for time series data ></a></p> </div> </main> </div> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> What is the use of time series data? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> Time-series data analysis allows us to analyze and understand how variables change over time. It is widely used across various industries, such as manufacturing, transportation and logistics, and the energy sector. Regardless of the industry, time-series data is crucial for enabling data-driven decision-making. With CrateDB, you can easily enrich your time series data with other data types, handle high ingest rates, and store years of history. <a href="/resources/white-papers/lp-wp-warehouse-logistics" rel="noopener">Read how TGW Logistics Group uses CrateDB as their modern time series database ></a> </div> </main> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-35 dnd_area-row-13-padding dnd_area-row-13-hidden dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-36 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1689581807947" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div data-module="advanced-section" class="module-section-options" id="module-section-options-858903"> </div> <script id="module-section-options-858903"> if( window._fr == null) { window._fr = []; } if( window._fr.sections == null) { window._fr.sections = []; } var options = { 'moduleID': 'module-section-options-858903', 'enable': 'true', 'layout':{ }, 'typography': { }, 'background': { }, 'advanced': { 'css_classes' : 'cr-ul-arrows' } }; window._fr.sections.push(options); </script></div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-37 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1689257464253" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #widget_1689257464253 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; } @media all and (max-width: 767px) { #widget_1689257464253 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="widget_1689257464253" class="cr-headline" style="">101 for Time-Series databases</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-38 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1689257093800" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_widget_1689257093800_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><ul> <li>What is a time series database?</li> <li>Key criteria for selecting a time series database.</li> </ul></span> </div></div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <input type="hidden" name="breadcrumb" value=""> </main> <div data-global-resource-path="sf2-crate/templates/partials/footer-landify.html"> <footer class="footer" id="cr-footer"> <div class="footer-overlay-color" style="background-color: transparent;"> <div class="footer__container content-wrapper footer_firstrow"> <div class="row-fluid"> <div class="span12"> <div class="row-fluid footer-widget"> <div class="span3 footer-widget-content"> <div class="footer_logo"> <img src="https://cratedb.com/hubfs/19927462/CrateDB-logo-blue-white.svg" class="hs-image-widget" loading="lazy" style="width:154px;border-width:0px;border:0px;" alt="CrateDB Logo" title="White CrateDB Logo" width="154" height="22"> </div> <div class="footer__social"> <div id="hs_cos_wrapper_footer_social" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> .social-links { -webkit-box-align: center; -ms-flex-align: center; align-items: center; display: -webkit-box; display: -ms-flexbox; display: flex; -ms-flex-wrap: wrap; flex-wrap: wrap; -webkit-box-pack: center; -ms-flex-pack: center; justify-content: center; } .social-links__icon { background-color: #494A52; border-radius: 50%; display: -webkit-inline-box; display: -ms-inline-flexbox; display: inline-flex; height: 40px; margin: 0 5px; position: relative; width: 40px; } .social-links__icon:hover, .social-links__icon:focus { background-color: #21222A; } .social-links__icon:active { background-color: #71727A; } .social-links__icon svg { fill: #FFF; height: 15px; left: 50%; position: absolute; top: 50%; -webkit-transform: translate(-50%, -50%); -ms-transform: translate(-50%, -50%); transform: translate(-50%, -50%); width: auto; } .social-links__icon:hover svg, .social-links__icon:focus svg, .social-links__icon:active svg { fill: #FFF; } /* Overrides 2021 -j */ .social-links__icon { height: 25px; width: 25px; margin: 0 8px; } </style> <div class="social-links"> <a class="social-links__link nav-link" href="https://twitter.com/cratedb" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" aria-labelledby="X Twitter1" role="img"><title id="X Twitter1">Follow us on Twitter</title><g id="X Twitter1_layer"><path d="M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z" /></g></svg></span> <span class="injected hidden">Follow us on Twitter</span> </a> <a class="social-links__link nav-link" href="https://www.linkedin.com/company/crateio/" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__2" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 448 512" aria-labelledby="LinkedIn In2" role="img"><title id="LinkedIn In2">Follow us on GitHub</title><g id="LinkedIn In2_layer"><path d="M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z" /></g></svg></span> <span class="injected hidden">Follow us on GitHub</span> </a> <a class="social-links__link nav-link" href="https://www.youtube.com/@CrateDB" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__3" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 576 512" aria-labelledby="YouTube3" role="img"><title id="YouTube3">Follow us on YouTube</title><g id="YouTube3_layer"><path d="M549.655 124.083c-6.281-23.65-24.787-42.276-48.284-48.597C458.781 64 288 64 288 64S117.22 64 74.629 75.486c-23.497 6.322-42.003 24.947-48.284 48.597-11.412 42.867-11.412 132.305-11.412 132.305s0 89.438 11.412 132.305c6.281 23.65 24.787 41.5 48.284 47.821C117.22 448 288 448 288 448s170.78 0 213.371-11.486c23.497-6.321 42.003-24.171 48.284-47.821 11.412-42.867 11.412-132.305 11.412-132.305s0-89.438-11.412-132.305zm-317.51 213.508V175.185l142.739 81.205-142.739 81.201z" /></g></svg></span> <span class="injected hidden">Follow us on YouTube</span> </a> <a class="social-links__link nav-link" href="https://github.com/crate/crate" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__4" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="GitHub4" role="img"><title id="GitHub4">Follow us on GitHub</title><g id="GitHub4_layer"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z" /></g></svg></span> <span class="injected hidden">Follow us on GitHub</span> </a> </div></div> </div> </div> <div id="hs_cos_wrapper_module_16142721378942" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Company </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_1.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/company/leadership" rel="noopener">Leadership</a></li> <li><a class="nav-link" href="https://cratedb.com/company/team" rel="noopener">Team</a></li> <li><a class="nav-link" href="https://cratedb.com/company/investors" rel="noopener">Investors</a></li> <li><a class="nav-link" href="https://cratedb.com/company/career" rel="noopener">Career</a></li> <li><a class="nav-link" href="https://cratedb.com/event" rel="noopener">Events</a></li> <li><a class="nav-link" href="https://cratedb.com/press" rel="noopener">Newsroom</a></li> <li><a class="nav-link" href="https://cratedb.com/company/media-kit" rel="noopener">Media kit</a></li> </ul></div> </div> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Ecosystem </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_2.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/partners" rel="noopener">Partners</a></li> <li><a class="nav-link" href="https://cratedb.com/product/editions/startups" rel="noopener">Startups</a></li> <li><a class="nav-link" href="https://cratedb.com/integrations" rel="noopener">Integrations</a></li> </ul></div> </div> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Contact </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_3.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/contact" rel="noopener">Contact us</a></li> <li><a class="nav-link" href="https://cratedb.com/contact/offices" rel="noopener">Offices</a></li> <li><a class="nav-link" href="https://cratedb.com/database/security#contact" rel="noopener">Security</a></li> <li><a class="nav-link" href="https://cratedb.com/support" rel="noopener">Support</a></li> </ul></div> </div> </div> </div> </div> </div> </div> </div> <div class="footer-second-row-overlay" style="background-color: transparent;"> <div class="footer__container content-wrapper footer_copyright"> <div class="footer__copyright"> <div id="hs_cos_wrapper_footer_copyright_text" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_footer_copyright_text_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="text">© 2024 CrateDB. All rights reserved.</span></div> </div> <div class="hs_cos_wrapper_widget"> <ul> <li> | </li> <li><a href="/legal" class="nav-link">Legal</a> | </li> <li><a href="/legal/privacy-policy" class="nav-link">Privacy Policy</a> | </li> <li><a href="/legal/imprint" class="nav-link">Imprint</a></li> </ul> </div> </div> </div> </footer> </div> </div>  <script defer src="/hs/hsstatic/content-cwv-embed/static-1.1293/embed.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52694035002/1710167292109/sf2-crate/js/main.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103135878028/1676853638526/sf2-crate/js/prism-core.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103135878026/1676853638465/sf2-crate/js/prism-autoloader.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/53645044755/1688038947921/sf2-crate/js/prism.min.js"></script> <script> var hsVars = hsVars || {}; hsVars['language'] = 'en'; </script> <script src="/hs/hsstatic/cos-i18n/static-1.53/bundles/project.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52694764069/1701097527096/module_52694764069_menu-section.min.js"></script>  <script defer src="https://js.hubspot.com/web-interactives-embed.js" type="text/javascript" id="hubspot-web-interactives-loader" data-loader="hs-previewer" data-hsjs-portal="19927462" data-hsjs-env="prod" data-hsjs-hublet="na1"></script>  <script src="https://cdn2.hubspot.net/hub/-1/hub_generated/module_assets/-35056501883/1732641105613/module_-35056501883_Video.min.js"></script>  <script async data-hs-portal-id="19927462" data-hs-ignore="true" data-cookieconsent="ignore" data-hs-page-id="124476846895" src="https://static.hsappstatic.net/video-embed/ex/loader.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/53152974980/1676852664722/module_53152974980_advanced-section-css.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/91968152433/1731315228445/module_91968152433_Accordion_22.min.js"></script>  <script type="text/javascript"> var _hsq = _hsq || []; _hsq.push(["setContentType", "standard-page"]); _hsq.push(["setCanonicalUrl", "https:\/\/cratedb.com\/data-model\/time-series"]); _hsq.push(["setPageId", "124476846895"]); _hsq.push(["setContentMetadata", { "contentPageId": 124476846895, "legacyPageId": "124476846895", "contentFolderId": null, "contentGroupId": null, "abTestId": null, "languageVariantId": 124476846895, "languageCode": "en", }]); </script> <script type="text/javascript" id="hs-script-loader" async defer src="/hs/scriptloader/19927462.js"></script>  <script type="text/javascript"> var hsVars = { render_id: "62505f65-1cc5-4fe6-bbe1-353b22480f4f", ticks: 1732721137929, page_id: 124476846895, content_group_id: 0, portal_id: 19927462, app_hs_base_url: "https://app.hubspot.com", cp_hs_base_url: "https://cp.hubspot.com", language: "en", analytics_page_type: "standard-page", scp_content_type: "", analytics_page_id: "124476846895", category_id: 1, folder_id: 0, is_hubspot_user: false } </script> <script defer src="/hs/hsstatic/HubspotToolsMenu/static-1.354/js/index.js"></script> <script type="text/javascript"> // Log the analytics category consent status of the current visitor to the console var _hsp = window._hsp = window._hsp || []; // analytics _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.analytics == true) { //console.log("analytics cookies enabled"); /* clarity */ (function(c,l,a,r,i,t,y){ c[a]=c[a]||function(){(c[a].q=c[a].q||[]).push(arguments)}; t=l.createElement(r);t.async=1;t.src="https://www.clarity.ms/tag/"+i; y=l.getElementsByTagName(r)[0];y.parentNode.insertBefore(t,y); })(window, document, "clarity", "script", "dyojgmowl8"); } }]); // advertisement _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.advertisement == true) { //console.log("advertisement cookies enabled"); //Google Tag Manager set ad_storage window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} // Update Tagmanager to grant consent for Ads trigger gtag('consent', 'update', { 'ad_user_data': 'granted', 'ad_personalization': 'granted', 'ad_storage': 'granted', 'analytics_storage': 'granted' }); //End Google Tag Manager } }]); // functionality _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.functionality == true) { //console.log("functionality cookies enabled"); } }]); </script> </body></html>

CINXE.COM

Time Series Database