Open Source JSON Database

<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>Open Source JSON Database</title> <link rel="shortcut icon" href="https://cratedb.com/hubfs/cratedb-favicon.png"> <meta name="description" content="CrateDB is a hyper-fast distributed open source database for complex nested JSON data, leveraging native SQL. JSON data can be combined with multiple other formats."> <style> .cr-header-full-height { height: 100vh; } </style>   <script src="https://cratedb.com/hs-fs/hubfs/hub_generated/template_assets/1/103134656537/1742068679186/template_jquery-3.5.1.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta property="og:description" content="CrateDB is a hyper-fast distributed open source database for complex nested JSON data, leveraging native SQL. JSON data can be combined with multiple other formats."> <meta property="og:title" content="Open Source JSON Database"> <meta name="twitter:description" content="CrateDB is a hyper-fast distributed open source database for complex nested JSON data, leveraging native SQL. JSON data can be combined with multiple other formats."> <meta name="twitter:title" content="Open Source JSON 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/hubfs/hub_generated/template_assets/1/52693799430/1740058011899/template_main.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/template_assets/1/52694827330/1742214320354/template_theme-overrides.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/module_assets/1/55523967869/1742461793258/module_Header_Notif_Bar.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/module_assets/1/52694764069/1742096597657/module_menu-section.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/module_assets/1/53642957898/1743419940815/module_code-tabs.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/module_assets/1/124127418129/1742096666512/module_Related_Content_23.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/module_assets/1/91968152433/1742096657949/module_Accordion_22.min.css">  <style id="hs_editor_style" type="text/css"> .dnd_area-row-2-max-width-section-centering > .row-fluid { max-width: 1240px !important; margin-left: auto !important; margin-right: auto !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: 0px !important; padding-bottom: 0px !important; } .dnd_area-row-4-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-5-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-6-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-6-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; } </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/json"> <meta property="og:url" content="https://cratedb.com/data-model/json"> <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-144922727698 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"> <style> .notification-banner { background-color:#19c0ea; color:#FFFFFF; } .notification-banner p{ color:#FFFFFF; } .notification-banner__button { color:#FFFFFF; background-color:#005980; } .notification-banner__button:hover { color:#FFFFFF; background-color:#009DC7; opacity: 1; } #notif-close svg { fill: #000000; } .notif-bar-enabled .w-canvas { margin-top: 32px; } .sd-summary-title .fa.fa-gear.fa-fw { line-height: inherit; } </style> <script> $(document).ready(function(){ $('body').removeClass('notif-bottom'); var stateKey = "notifSilencea41b62ec54d77611622a5648895c9661"; if (!localStorage[stateKey] || (new Date().getTime() > parseInt(localStorage[stateKey], 10))) { $('body').addClass('notif-bar-enabled'); } var notifbarHeight = $('.notification-banner').outerHeight(); var menuHeight = $('#top').outerHeight(); var totalHeight = menuHeight + notifbarHeight; var headerPadding = notifbarHeight + 80; if($('body.notif-bar-enabled')){ $('.notif-bar-enabled header.header').css('margin-top',notifbarHeight+"px"); $('.notif-bar-enabled header.header-nav:not(.sb-header)').css('margin-top',notifbarHeight+"px"); $('.notif-bar-enabled .body-container-wrapper').css('padding-top',totalHeight+"px"); //$('.notif-bar-enabled #cr-header-resources').css('padding-top',headerPadding+"px"); $('.notif-bar-enabled .cr-clusters-items-wrapper').css('padding-top',notifbarHeight+"px"); if($('body.cr-home')){ $('.notif-bar-enabled .cr-header-full-height').css('padding-top',totalHeight+"px"); } if($('body.notif-bar-enabled .cr-sticky-submenu')){ $('.notif-bar-enabled .cr-sticky-submenu').attr('style', "margin-top: -" + notifbarHeight + "px !important; padding-top: " + notifbarHeight + "px !important;"); } /*if($('.cr-header-full-height')) { //$('.notif-bar-enabled .cr-header-full-height').css('padding-top',totalHeight+"px"); //$('.notif-bar-enabled .cr-header-full-height').attr('style', 'padding-top: calc(' + totalHeight + 'px + 40px) !important') }*/ } $('#notif-close').click(function() { $('.notification-banner').hide(); $('body').removeClass('notif-bar-enabled'); var silenceTime = parseInt('86400000', 10) || 0; if (silenceTime) { localStorage.setItem(stateKey, String(new Date().getTime() + silenceTime)); } $('header.header').css('margin-top',"0"); $('header.header-nav').css('margin-top',"0"); $('.body-container-wrapper').css('padding-top',menuHeight+"px"); $('#cr-header-resources').css('padding-top', "80px"); $('.cr-clusters-items-wrapper').css('padding-top', "0px"); if($('.w-canvas')){ $('.w-canvas').css('padding-top',"65px"); } if($('body.cr-home')){ $('.cr-header-full-height').css('padding-top',"80px"); } if($('.cr-sticky-submenu')){ $('.cr-sticky-submenu').attr('style', "margin-top: -0px !important; padding-top: 0px !important;"); } }); window.dispatchEvent(new Event('resize')); }); </script> <div class="notification-banner row-fluid new"> <div class="page-center"> <p>Webinar on Apr 23rd: Unlocking Real-Time IoT Insights with Kafka, CrateDB & Coreflux</p> <a class="notification-banner__button" href="https://cratedb.com/resources/webinars/lp-wb-unlocking-real-time-iot-insights" target="_blank">Register now</a> <div id="notif-close" class=""> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 352 512" width="11"><path d="M242.7 256l100.1-100.1c12.3-12.3 12.3-32.2 0-44.5l-22.2-22.2c-12.3-12.3-32.2-12.3-44.5 0L176 189.3 75.9 89.2c-12.3-12.3-32.2-12.3-44.5 0L9.2 111.5c-12.3 12.3-12.3 32.2 0 44.5L109.3 256 9.2 356.1c-12.3 12.3-12.3 32.2 0 44.5l22.2 22.2c12.3 12.3 32.2 12.3 44.5 0L176 322.7l100.1 100.1c12.3 12.3 32.2 12.3 44.5 0l22.2-22.2c12.3-12.3 12.3-32.2 0-44.5L242.7 256z"></path></svg> </div> </div> </div> </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/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" 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 active-item" aria-current="page" 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/real-time-analytics-database" class="menu-link" title="Real-time analytics">Real-time analytics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/hybrid-search" class="menu-link" title="Hybrid search">Hybrid search</a> </li> <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 chatbots">AI 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/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> </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="Customer stories">Customer 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"><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"><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-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_16896903067153" 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_16896903067153"> <style> #module_16896903067153.cr-clusters-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16896903067153.cr-clusters-items-wrapper.cr-clusters-limit, .cr-meta-inner { max-width: 1200px; } #module_16896903067153 .cr-clusters-container.cr-customers-header-sub { max-width: 1200px; margin: 0 auto; } #module_16896903067153 .cr-clusters-container { display: flex; align-items: center; } #module_16896903067153 .cr-clusters-header { margin-bottom: 20px; display: flex; align-items: baseline; } #module_16896903067153 .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_16896903067153 .cr-customers-header-sub .cr-clusters-header h1 { max-width: 980px; } #module_16896903067153 .cr-customers-header-sub .cr-clusters-limit-width-headline.cr-clusters-header h1 { max-width: 700px; } #module_16896903067153.cr-clusters-limit .cr-customers-header-sub .cr-clusters-introtext { max-width: 950px; } #module_16896903067153:not(.cr-clusters-limit) .cr-customers-header-sub .cr-clusters-introtext { max-width: 100%; } #module_16896903067153 .cr-clusters-image { flex: 3; } #module_16896903067153 .cr-clusters-image img { height: auto; } #module_16896903067153 .cr-clusters-introtext, #module_16896903067153 .cr-clusters-introtext p, #module_16896903067153 .cr-clusters-introtext span { color: rgba(255, 255, 255, 1.0); font-size: 21px; margin-right: 100px; } #module_16896903067153 .cr-clusters-introtext { max-width: 680px; } #module_16896903067153 .cr-clusters-left { padding-top: 60px; flex: 3; } #module_16896903067153 .cr-header-section { display: block; font-size: 20px; font-weight: 600; color: #19C0EA; } #module_16896903067153 .cr-clusters-arrow { align-self: flex-end; } #module_16896903067153 .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_16896903067153 .cr-clusters-container { flex-direction: column; } #module_16896903067153 .cr-clusters-introtext { font-size: 18px; } #module_16896903067153 .cr-clusters-header h1 { width: auto; max-width: 100%; } #module_16896903067153 .cr-clusters-container { align-items: flex-start; } } @media all and (max-width: 767px) { #module_16896903067153 .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 "> <h1 style="color: rgba(255, 255, 255, 1.0);">JSON Data</h1> </div> <div class="cr-clusters-introtext"> CrateDB supports complex nested JSON payloads with flexible data schema, and indexes all properties automatically for instant querying. </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-3 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_widget_1697632573455" 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"> <h2 style="font-size: 36px;">Instant JSON data querying with SQL</h2> <p style="font-size: 18px;">Hyper-fast. Queries in milliseconds.</p> </div> <button class="tablinks widget_1697632573455-codetabl" onclick="openCodeTabwidget_1697632573455(event, 'widget_1697632573455-Codetab1')" id="widget_1697632573455-defaultOpen"> <span> <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> Single INSERT statement </span> </button> <button class="tablinks widget_1697632573455-codetabl" onclick="openCodeTabwidget_1697632573455(event, 'widget_1697632573455-Codetab2')"> <span> <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> Querying with SELECT statement </span> </button> <button class="tablinks widget_1697632573455-codetabl" onclick="openCodeTabwidget_1697632573455(event, 'widget_1697632573455-Codetab3')"> <span> <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> Bulk INSERT statement </span> </button> </div> <div class="tab tab-body"> <div id="widget_1697632573455-Codetab1" class="tabcontent widget_1697632573455-codetabc"> <div class="tab-container"> <div class="tab-pane show active widget_1697632573455-pane-number1" role="tabpanel" id="widget_1697632573455-Statement1"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> INSERT INTO community_areas(areanumber, name, details) VALUES ( 35, 'DOUGLAS', '{ "description": "The Douglas community area stretches...", "population": 20291, "zipcodes": [ "60609", "60616", "60653" ], "notableresident": { "name": "Ida B. Wells", "bio": "An American investigative journalist, educator and..." } }'::OBJECT ) </code></pre> </code> </pre> </div> <div class="tab-pane widget_1697632573455-pane-number1" role="tabpanel" id="widget_1697632573455-Result1"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"> </code> </pre> </div> </div> </div> <script> function openPillwidget_16976325734551(evt1, widget_1697632573455) { var i, tabcontentwidget_1697632573455, tablinkswidget_1697632573455; tabcontentwidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-pane-number1"); for (i = 0; i < tabcontentwidget_1697632573455.length; i++) { tabcontentwidget_1697632573455[i].style.display = "none"; } tablinkswidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-pill-number1"); for (i = 0; i < tablinkswidget_1697632573455.length; i++) { tablinkswidget_1697632573455[i].className = tablinkswidget_1697632573455[i].className.replace(" active", ""); } document.getElementById(widget_1697632573455).style.display = "block"; evt1.currentTarget.className += " active"; } function openCodeTabwidget_1697632573455(evt1, widget_1697632573455) { var i, tabcontentwidget_1697632573455, tablinkswidget_1697632573455; tabcontentwidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-codetabc"); for (i = 0; i < tabcontentwidget_1697632573455.length; i++) { tabcontentwidget_1697632573455[i].style.display = "none"; } tablinkswidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-codetabl"); for (i = 0; i < tablinkswidget_1697632573455.length; i++) { tablinkswidget_1697632573455[i].className = tablinkswidget_1697632573455[i].className.replace(" active", ""); } document.getElementById(widget_1697632573455).style.display = "block"; evt1.currentTarget.className += " active"; } document.getElementById("widget_1697632573455-defaultOpen").click(); </script> <div id="widget_1697632573455-Codetab2" class="tabcontent widget_1697632573455-codetabc"> <div class="tab-container"> <div class="tab-pane show active widget_1697632573455-pane-number2" role="tabpanel" id="widget_1697632573455-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"> /* Retrieve fields from objects and slice arrays. */ SELECT name, array_slice(details['zipcodes'], 1, 1) as first_zip, details['population'] AS population, details['notableresident']['name'] AS famous_resident FROM community_areas WHERE areanumber = 35; </code></pre> </code> </pre> </div> <div class="tab-pane widget_1697632573455-pane-number2" role="tabpanel" id="widget_1697632573455-Result2"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"><pre><code> +---------+-----------+------------+-----------------+ | name | first_zip | population | famous_resident | +---------+-----------+------------+-----------------+ | DOUGLAS | ["60609"] | 20291 | Ida B. Wells | +---------+-----------+------------+-----------------+<br> </code></pre> <p> </p> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill widget_1697632573455-pill-number2 active" onclick="openPillwidget_16976325734552(event, 'widget_1697632573455-Statement2')">Statement</button> <button class="tab-pill widget_1697632573455-pill-number2" onclick="openPillwidget_16976325734552(event, 'widget_1697632573455-Result2')">Result</button> </div> </div> </div> <script> function openPillwidget_16976325734552(evt2, widget_1697632573455) { var i, tabcontentwidget_1697632573455, tablinkswidget_1697632573455; tabcontentwidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-pane-number2"); for (i = 0; i < tabcontentwidget_1697632573455.length; i++) { tabcontentwidget_1697632573455[i].style.display = "none"; } tablinkswidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-pill-number2"); for (i = 0; i < tablinkswidget_1697632573455.length; i++) { tablinkswidget_1697632573455[i].className = tablinkswidget_1697632573455[i].className.replace(" active", ""); } document.getElementById(widget_1697632573455).style.display = "block"; evt2.currentTarget.className += " active"; } function openCodeTabwidget_1697632573455(evt2, widget_1697632573455) { var i, tabcontentwidget_1697632573455, tablinkswidget_1697632573455; tabcontentwidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-codetabc"); for (i = 0; i < tabcontentwidget_1697632573455.length; i++) { tabcontentwidget_1697632573455[i].style.display = "none"; } tablinkswidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-codetabl"); for (i = 0; i < tablinkswidget_1697632573455.length; i++) { tablinkswidget_1697632573455[i].className = tablinkswidget_1697632573455[i].className.replace(" active", ""); } document.getElementById(widget_1697632573455).style.display = "block"; evt2.currentTarget.className += " active"; } document.getElementById("widget_1697632573455-defaultOpen").click(); </script> <div id="widget_1697632573455-Codetab3" class="tabcontent widget_1697632573455-codetabc"> <div class="tab-container"> <div class="tab-pane show active widget_1697632573455-pane-number3" role="tabpanel" id="widget_1697632573455-Statement3"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> /* Insert documents for two Chicago community areas. Dynamic object schemas allow these two documents to have different structures. */ INSERT INTO community_areas(areanumber, name, details) VALUES ( 35, 'DOUGLAS', '{ "description": "The Douglas community area stretches...", "population": 20291, "zipcodes": [ "60609", "60616", "60653" ], "notableresident": { "name": "Ida B. Wells", "bio": "An American investigative journalist, educator and..." } }'::OBJECT ), ( 41, 'HYDE PARK', '{ "description": "This community area is home to the Museum of Science...", "population": 29456, "notableresident": { "name": "Muhammad Ali", "born": 1942 } }'::OBJECT ); </code></pre> </code> </pre> </div> <div class="tab-pane widget_1697632573455-pane-number3" role="tabpanel" id="widget_1697632573455-Result3"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"> </code> </pre> </div> </div> </div> <script> function openPillwidget_16976325734553(evt3, widget_1697632573455) { var i, tabcontentwidget_1697632573455, tablinkswidget_1697632573455; tabcontentwidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-pane-number3"); for (i = 0; i < tabcontentwidget_1697632573455.length; i++) { tabcontentwidget_1697632573455[i].style.display = "none"; } tablinkswidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-pill-number3"); for (i = 0; i < tablinkswidget_1697632573455.length; i++) { tablinkswidget_1697632573455[i].className = tablinkswidget_1697632573455[i].className.replace(" active", ""); } document.getElementById(widget_1697632573455).style.display = "block"; evt3.currentTarget.className += " active"; } function openCodeTabwidget_1697632573455(evt3, widget_1697632573455) { var i, tabcontentwidget_1697632573455, tablinkswidget_1697632573455; tabcontentwidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-codetabc"); for (i = 0; i < tabcontentwidget_1697632573455.length; i++) { tabcontentwidget_1697632573455[i].style.display = "none"; } tablinkswidget_1697632573455 = document.getElementsByClassName("widget_1697632573455-codetabl"); for (i = 0; i < tablinkswidget_1697632573455.length; i++) { tablinkswidget_1697632573455[i].className = tablinkswidget_1697632573455[i].className.replace(" active", ""); } document.getElementById(widget_1697632573455).style.display = "block"; evt3.currentTarget.className += " active"; } document.getElementById("widget_1697632573455-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_area-row-2-max-width-section-centering 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_1689690959169" 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_1689690959169"> <style> #widget_1689690959169.cr-featuresbox-items-wrapper { /*max-width: 1760px;*/ margin-bottom: 40px; } #widget_1689690959169 .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_1689690959169 .cr-featuresbox-headline { padding-right: 30px; } #widget_1689690959169 .cr-featuresbox-headline h3 { font-size: 28px; font-weight: bold; letter-spacing: -0.64px; margin-top: 0; margin-bottom: 16px; } #widget_1689690959169 .cr-featuresbox-icon img { max-width: 24px !important; position: absolute; /*right: 20px;*/ right: 10px; /*bottom: -24px;*/ top: 10px; opacity: .2; } #widget_1689690959169 .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_1689690959169 .cr-featuresbox-link svg { max-width: 30px; height: auto; margin-right: 24px; position: absolute; right: 0px; z-index: -1; } #widget_1689690959169 .cr-featuresbox-link a, #widget_1689690959169 .cr-featuresbox-link a:visited { width: 100%; height: 100%; display: block; text-decoration: none; } #widget_1689690959169 .cr-featuresbox-link a:hover, #widget_1689690959169 .cr-featuresbox-link a:active { text-decoration: none; } #widget_1689690959169 .cr-featuresbox-text { font-size: 16px; padding-right: 120px; } #widget_1689690959169 .cr-featuresbox-readmore { text-align: right; margin-top: 40px; } #widget_1689690959169 .cr-featuresbox-readmore svg { max-width: 22px; height: auto; margin-left: 5px; } #widget_1689690959169 .cr-featuresbox-container p:last-child { margin-bottom: 0; } #widget_1689690959169 .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_1689690959169 .cr-featuresbox-readmore { text-align: center !important; } #widget_1689690959169 .cr-featuresbox-readmore a { display: inline-block !important; } @media all and (max-width: 767px) { #widget_1689690959169 .cr-featuresbox-container { padding: 20px 30px 20px 30px; } #widget_1689690959169 .cr-featuresbox-text { padding-right: 0px; } #widget_1689690959169 .cr-featuresbox-link { align-items: flex-start; } #widget_1689690959169 .cr-featuresbox-headline { padding-right: 0px; } #widget_1689690959169 .cr-featuresbox-link svg { margin-top: 24px; } #widget_1689690959169 .cr-featuresbox-headline h3 { font-size: 22px; padding-right: 30px; } } </style> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>Simple JSON data storage</h3> </div> <div class="cr-featuresbox-text"> <div> <div> <div data-widget-type="cell" data-x="0" data-w="12"> <div> <div> <div data-widget-type="custom_widget" data-x="0" data-w="12"> <div> <p>CrateDB effortlessly handles JSON objects, allowing storage in <code>OBJECT</code> columns. These columns can contain diverse attributes, nesting levels, and arrays of objects, providing the flexibility required for complex multi-model data structures.</p> </div> </div> </div> </div> </div> </div> </div> </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="cr-quote-image" 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 "> <div class="cr-featuresbox-headline"> <h3>Automatic indexing</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB's indexing strategy, based on a <a href="/product/features/lucene-engine" rel="noopener">Lucene index</a>, automatically generates <a href="/product/features/indexing-columnar-storage-aggregations" rel="noopener">indexes</a> for all attributes regardless of their depth, enabling rapid <a href="/product/features/full-text-search" rel="noopener">search capabilities</a> for stored objects and facilitating efficient updates.</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="cr-quote-image" 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 "> <div class="cr-featuresbox-headline"> <h3>Simple SQL access to JSON</h3> </div> <div class="cr-featuresbox-text"> CrateDB simplifies SQL access to JSON by enabling direct and <a href="/product/features/nested-data-structure" rel="noopener">nested attribute querying</a>, allowing users to navigate and retrieve data seamlessly within JSON structures using <a href="/product/features/native-sql" rel="noopener">native SQL syntax</a>. </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="cr-quote-image" 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 "> <div class="cr-featuresbox-headline"> <h3>Dynamic schema and multi-model approach</h3> </div> <div class="cr-featuresbox-text"> <p>CrateDB's multi-model approach accommodates diverse data types seamlessly, allowing for the smooth integration of various data structures within the database. As JSON objects evolve and new attributes are added dynamically, CrateDB <a href="/product/features/dynamic-schemas" rel="noopener">adjusts the schema automatically</a>. This ensures that all attributes become accessible in <a href="/product/features/native-sql" rel="noopener">SQL queries</a> via the bracket syntax of the form <code>object['attribute']['subattribute']</code>.</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="cr-quote-image" loading="" width="512" height="512" 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 "> <div class="cr-featuresbox-headline"> <h3>Powerful full-text search</h3> </div> <div class="cr-featuresbox-text"> <p>Alongside JSON support, CrateDB empowers users with robust <a href="/product/features/full-text-search" rel="noopener">text search capabilities</a>. This combination of features enables users to perform SQL-based searches within JSON objects efficiently.</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="cr-quote-image" loading="" width="512" height="512" 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 "> <div class="cr-featuresbox-headline"> <h3>Fast NoSQL performance</h3> </div> <div class="cr-featuresbox-text"> CrateDB executes queries on JSON data (and other types of data) <a href="/product/features/query-performance" rel="noopener">extremely fast</a>, ensuring rapid access and retrieval of JSON objects and complex data structures. </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="cr-quote-image" 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-readmore"> <a class="hs-button" href="https://cratedb.com/database"> Learn more about the product </a> </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"> <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-8 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_1736341712814" 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> [id^=widget_1736341712814-details] { /*display: none;*/ position: fixed; top: 0; left: 0; visibility: hidden; opacity: 0; transition: visibility 0s, opacity 0.2s linear; } [id^=widget_1736341712814-details]:target { /*display: block;*/ visibility: visible; opacity: 1; } #widget_1736341712814 input[type=checkbox] { position: absolute; clip: rect(0 0 0 0); } #widget_1736341712814 .popup { width: 100%; height: 100%; z-index: 99999; } #widget_1736341712814 .popup__overlay { position: fixed; z-index: 1; display: block; top: 0; left: 0; height: 100%; width: 100%; background: #000000b3; backdrop-filter: blur(5px); } #widget_1736341712814 .popup__wrapper { background: transparent; border-radius: 8px; left: 50%; max-width: 80vw; padding: 20px 20px 20px; position: fixed; top: 50%; transform: translate(-50%,-50%); width: 80%; z-index: 9; } #widget_1736341712814 .popup__close { position: absolute; top: 16px; right: 26px; } .popup__close svg { width: 24px; height: auto; fill: #19C0EA; } .popup__close:hover svg { opacity: .7; } @media all and (max-width: 768px) { #widget_1736341712814 .popup__close { top: -10px; } #widget_1736341712814 .popup__wrapper { max-width: 90vw; } } </style> <div class="cr-featureboxes-items-wrapper" id="widget_1736341712814"> <style> #widget_1736341712814.cr-featureboxes-items-wrapper { margin: 0 auto; } #widget_1736341712814 .cr-featureboxes-container { display: flex; flex-direction: column; align-items: center; } #widget_1736341712814 .cr-featureboxes-item { display: flex; flex-direction: row-reverse; align-items: center; padding: 10px 0; margin-bottom: 0px; width: 100%; } #widget_1736341712814 .cr-featureboxes-item h2 { font-size: 32px; } #widget_1736341712814 .cr-featureboxes-right-text, #widget_1736341712814 .cr-featureboxes-item p { font-size: 18px; } #widget_1736341712814 .cr-featureboxes-item.cr-featureboxes-top { align-items: flex-start; } #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) { flex-direction: row; } #widget_1736341712814 .cr-featureboxes-container .cr-featureboxes-left { flex: 3; } #widget_1736341712814 .cr-featureboxes-container .cr-featureboxes-right { flex: 2; } /*#widget_1736341712814 .cr-featureboxes-container .cr-featureboxes-item:nth-child(2n) .cr-featureboxes-left { flex: 2; } #widget_1736341712814 .cr-featureboxes-container .cr-featureboxes-item:nth-child(2n) .cr-featureboxes-right { flex: 3; }*/ #widget_1736341712814 .cr-featureboxes-left-image img, #widget_1736341712814 .hs-video-widget, #widget_1736341712814 .cr-fb-cta { padding: 30px; padding-right: 0; } #widget_1736341712814 .cr-featureboxes-item .cr-fb-cta { max-width: 610px; } #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) .cr-featureboxes-left-image img, #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) .hs-video-widget, #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) .cr-fb-cta { padding-left: 0; padding-right: 60px; } #widget_1736341712814 .cr-featureboxes-right { padding: 30px; font-size: 16px; color: #0A2327; letter-spacing: -0.18px; padding-left: 0; } #widget_1736341712814 .cr-featurebox-headline-mobile { display: none; } @media all and (max-width: 767px) { #widget_1736341712814 .cr-featureboxes-container, #widget_1736341712814 .cr-featureboxes-item, #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) { flex-direction: column; } #widget_1736341712814 .cr-featureboxes-item p, #widget_1736341712814 .cr-featureboxes-right-text { font-size: 16px; } #widget_1736341712814 .cr-featureboxes-item { align-items: flex-start; } #widget_1736341712814 .cr-featurebox-headline-desktop { display: none; } #widget_1736341712814 .cr-featurebox-headline-mobile { display: block; } #widget_1736341712814 .cr-featurebox-headline-mobile h2 { margin-bottom: 24px; } #widget_1736341712814 .cr-featureboxes-right { padding: 30px; border-left: none; font-size: 16px; } #widget_1736341712814 .cr-featureboxes-left { min-width: unset; width: 100%; } #widget_1736341712814 .cr-featureboxes-item { margin-bottom: 0; padding: 0px; } #widget_1736341712814 .cr-featureboxes-left-image img, #widget_1736341712814 .hs-video-widget, #widget_1736341712814 .cr-featureboxes-item .cr-fb-cta{ padding: 0; } #widget_1736341712814 .cr-featureboxes-right { padding: 30px 0; } #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) .cr-featureboxes-left-image img, #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) .hs-video-widget, #widget_1736341712814 .cr-featureboxes-item:nth-child(2n) .cr-fb-cta { padding-right: 0; } } </style> <div class="cr-featureboxes-container"> <div class="cr-featureboxes-item "> <div class="cr-featurebox-headline-mobile"> <h3>Demo: Ingesting and querying nested JSON documents with SQL</h3> </div> <div class="cr-featureboxes-left"> <div class="cr-featureboxes-left-image"> <div class="hs-video-widget" data-hsv-embed-id="5a9cae8f-e136-4f47-a409-ecca6938a689"> <div class="hs-video-container" style="max-width: 100%; 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/184659010877" 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="184659010877" data-hsv-full-width="false"></iframe> </div> </div> </div> </div> </div> <div class="cr-featureboxes-right"> <div class="cr-featurebox-headline-desktop"> <h3>Demo: Ingesting and querying nested JSON documents with SQL</h3> </div> <div class="cr-featureboxes-right-text"> Watch the tutorial by Georg Traar, Director of Product Management Cloud Organisation, as he shows how to unleash the power of nested data with CrateDB. </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-9 dnd-section dnd_area-row-4-background-layers dnd_area-row-4-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-10 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_16958836356405" 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_16958836356405"> <style> #module_16958836356405.cr-getstarted-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16958836356405 .cr-getstarted-header { margin-bottom: 32px; display: flex; align-items: center; margin-right: 20px; } #module_16958836356405 .cr-getstarted-item { margin-right: 20px; } #module_16958836356405 .cr-getstarted-items { display: flex; flex-direction: row; } #module_16958836356405 .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_16958836356405 .cr-getstarted-header svg { height: 50px; width: auto; } #module_16958836356405 .cr-getstarted-container.cr-gestarted-inline { display: flex; align-items: center; /*justify-content: space-between;*/ } #module_16958836356405 .cr-gestarted-inline .cr-getstarted-header, #module_16958836356405 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 0px; } @media all and (max-width: 767px) { #module_16958836356405 .cr-getstarted-container.cr-gestarted-inline { display: block; } #module_16958836356405 .cr-gestarted-inline .cr-getstarted-header { margin-bottom: 20px; } #module_16958836356405 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 12px; } #module_16958836356405 .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-11 dnd-section dnd_area-row-5-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-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_widget_1690461611412" 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_1690461611412 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_1690461611412 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="widget_1690461611412" class="cr-headline" style="">Additional resources on JSON data</h2> </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-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-14 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_1699603146269" 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_1699603146269{ } #module_1699603146269 h1 { color: ; } </style> <div class="cr-relatedcontent" id="module_1699603146269"> <div class="content-wrapper"> <div class="cr-relatedcontent-cards"> <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/handling-dynamic-objects-in-cratedb"> Handling Dynamic Objects in CrateDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699603146269_" 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>Video</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="/resources/videos/cratedb-objects"> Fundamentals: Getting Started with CrateDB Objects</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699603146269_" 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>Workshop</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://youtu.be/bD_gJX7F9g8?feature=shared"> CrateDB Workshop Module 4: Modeling Data in CrateDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699603146269_" 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 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_1699623255516" 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_1699623255516{ } #module_1699623255516 h1 { color: ; } </style> <div class="cr-relatedcontent" id="module_1699623255516"> <div class="content-wrapper"> <div class="cr-relatedcontent-cards"> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Tutorial</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/docs/cloud/en/latest/tutorials/object.html#object"> Objects: Analyzing Marketing Data</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699623255516_" 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>Tutorial</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://community.cratedb.com/t/objects-in-cratedb/1188"> Objects in CrateDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699623255516_" 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>Documentation</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/docs/crate/reference/en/latest/general/ddl/data-types.html#json"> JSON data type</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699623255516_" 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>Documentation</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/docs/crate/reference/en/latest/general/builtins/scalar-functions.html#object-functions"> Object functions</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_1699623255516_" 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> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-16 dnd_area-row-6-padding dnd-section dnd_area-row-6-background-layers dnd_area-row-6-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-17 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_17218056548986" 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_17218056548986 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_17218056548986 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="module_17218056548986" class="cr-headline" style="">FAQ</h2> </div> </div> </div> </div> <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_17218056548987" 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 document/JSON 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>A JSON value can be one of several types: an object, array, number, string, Boolean (true or false), or null. Objects within JSON are collections of key-value pairs, and these keys can contain values of any type, including nested objects or arrays. In CrateDB, JSON objects are treated as container data types, allowing for flexible and <a href="/product/features/data-storage" rel="noopener">efficient 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"> How do you store document/JSON 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>Storing document/JSON data efficiently requires a flexible database that can handle various attributes and nesting levels. Databases typically define objects as strict, dynamic, or ignored, depending on whether you want to enforce schemas strictly or allow for dynamic schema updates. This flexibility is crucial for managing complex data structures that involve arrays of objects and different nesting levels. In CrateDB, JSON objects can be stored in OBJECT columns, providing the versatility needed for<a href="/database/multi-model" rel="noopener"> multi-model data storage </a>while maintaining efficient handling and <a href="/product/features/query-performance" rel="noopener">query performance</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 document/JSON 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 database for document/JSON data, consider its ability to efficiently store and query JSON documents, indexing capabilities, and support for dynamic schemas. Databases like CrateDB, MongoDB, Couchbase, and ArangoDB excel in these areas, providing flexibility and efficient querying. CrateDB combines traditional SQL strengths with NoSQL's dynamic properties, treating JSON objects as first-class citizens and allowing for<a href="/product/features/indexing-columnar-storage-aggregations" rel="noopener"> full indexing and aggregation</a> of object properties, regardless of their depth and nested structure.<a href="/blog/handling-dynamic-objects-in-cratedb" rel="noopener"> Learn more ></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 document/JSON 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>Document/JSON data is highly versatile and used across various industries for web applications, APIs, configuration files, data storage, and logging. This format supports flexible, schema-less structures, making it ideal for rapidly changing datasets and complex data models. In CrateDB, JSON data is efficiently stored, indexed, and queried, providing <a href="/product/features/postgresql-wire-protocol" rel="noopener">seamless integration with PostgreSQL clients</a> and robust search capabilities.</p> </div> </main> </div> </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"> <span>© 2025 CrateDB. All rights reserved.</span> </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/hubfs/hub_generated/template_assets/1/52694035002/1742068599464/template_main.min.js"></script> <script src="https://cratedb.com/hs-fs/hubfs/hub_generated/template_assets/1/103135878028/1742068679986/template_prism-core.min.js"></script> <script src="https://cratedb.com/hs-fs/hubfs/hub_generated/template_assets/1/103135878026/1742068679799/template_prism-autoloader.min.js"></script> <script src="https://cratedb.com/hs-fs/hubfs/hub_generated/template_assets/1/53645044755/1742068618452/template_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/hubfs/hub_generated/module_assets/1/52694764069/1742096597657/module_menu-section.min.js"></script>  <script async data-hs-portal-id="19927462" data-hs-ignore="true" data-cookieconsent="ignore" data-hs-page-id="144922727698" src="https://static.hsappstatic.net/video-embed/ex/loader.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://cratedb.com/hs-fs/hubfs/hub_generated/module_assets/1/91968152433/1742096657949/module_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\/json"]); _hsq.push(["setPageId", "144922727698"]); _hsq.push(["setContentMetadata", { "contentPageId": 144922727698, "legacyPageId": "144922727698", "contentFolderId": null, "contentGroupId": null, "abTestId": null, "languageVariantId": 144922727698, "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: "0e64cf70-1530-4ade-8819-090b94344ac7", ticks: 1743429056730, page_id: 144922727698, 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: "144922727698", category_id: 1, folder_id: 0, is_hubspot_user: false } </script> <script defer src="/hs/hsstatic/HubspotToolsMenu/static-1.432/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"); } window.clarity('consent'); }]); // 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

Open Source JSON Database