cratedb.com Open in urlscan Pro
151.101.128.207  Public Scan

Form analysis
0 forms found in the DOM

Text Content

This website stores cookies on your computer. These cookies are used to collect
information about how you interact with our website and allow us to remember
you. We use this information in order to improve and customize your browsing
experience and for analytics and metrics about our visitors both on this website
and other media. To find out more about the cookies we use, see our Privacy
Policy

If you decline, your information won’t be tracked when you visit this website. A
single cookie will be used in your browser to remember your preference not to be
tracked.

Settings
Accept Decline


The Guide for Time Series Data Projects is out.

Download now

Skip to content
 * Product
   * Database
     * Overview
     * Multi-model
     * Query examples
     * How to connect
     * Integrations
     * Editions
   * Data models
     * Time-series
     * Document/JSON
     * Vector
     * Full-text
     * Spatial
     * Relational
 * Solutions
   * By industry
     * Energy
     * FMCG
     * Logistics
     * Oil, Gas, Mining
     * Smart cities
     * Technology Platforms
     * Telco
     * Transportation
   * By project type
     * AI/ML
     * Internet of Things
     * Digital twins
     * Real-time analytics
     * Log analysis
     * Database consolidation
 * Customers
 * Resources
   * Community
   * Events
   * Asset library
   * GitHub
   * Blog
   * Support
   * Social channels
 * Documentation

Log In
Get Started
Log In
Get Started


THE ENTERPRISE DATABASE
FOR TIME SERIES,
DOCUMENTS, AND VECTORS

Distributed - Native SQL - Open Source - Ready for AI



Learn more



ENJOY SQL TO QUERY TIME SERIES, DOCUMENT, VECTOR DATA, AND MORE

 
Time-series data JSON data Vector data Text data Geospatial data

        
/* Based on device data, this query returns the average
 * of the battery level for every hour for each device_id
 */
WITH avg_metrics AS (
    SELECT device_id,
       DATE_BIN('1 hour'::INTERVAL, time, 0) AS period,
       AVG(battery_level) AS avg_battery_level
    FROM devices.readings
    GROUP BY 1, 2 
    ORDER BY 1, 2
)
SELECT period,
       t.device_id,
       manufacturer,
       avg_battery_level  
FROM avg_metrics t, devices.info i
WHERE t.device_id = i.device_id 
      AND model = 'mustang'
LIMIT 10;

        
        

Copy

        
+---------------+------------+--------------+-------------------+
|    period     |  device_id | manufacturer | avg_battery_level |
+---------------+------------+--------------+-------------------+
| 1480802400000 | demo000001 |    iobeam    | 49.25757575757576 |
| 1480806000000 | demo000001 |    iobeam    | 47.375            |
| 1480802400000 | demo000007 |    iobeam    | 25.53030303030303 |
| 1480806000000 | demo000007 |    iobeam    | 58.5              |
| 1480802400000 | demo000010 |    iobeam    | 34.90909090909091 |
| 1480806000000 | demo000010 |    iobeam    | 32.4              |
| 1480802400000 | demo000016 |    iobeam    | 36.06060606060606 |
| 1480806000000 | demo000016 |    iobeam    | 35.45             |
| 1480802400000 | demo000025 |    iobeam    | 12                |
| 1480806000000 | demo000025 |    iobeam    | 16.475            |
+---------------+------------+--------------+-------------------+

        
        

Copy
Statement Result
Learn more about CrateDB for time-series data

         
SELECT
    title AS title,
    protagonist['first_name'] AS name,
    date_format(
        '%D %b %Y',
        'GMT',
        protagonist['details']['birthday']
     ) AS born,
    quotation['words'] AS quote
FROM quotes limit 100;

        
        

Copy

        
+---------------+---------+--------------------+
|    event_time | entries |          avg_score |
+---------------+---------+--------------------+
| 1620220260000 |       4 | 1.5798743814229965 |
| 1620220200000 |       8 | 1.7750384211540222 |
| 1620220140000 |      10 | 1.6113891124725341 |
| 1620220080000 |       9 | 1.676726798216502  |
| 1620220020000 |       8 | 1.6908064410090446 |
| 1620219960000 |       8 | 1.690401442348957  |
| 1620219900000 |       7 | 1.7646006005150932 |
| 1620219840000 |       7 | 1.7795820917401994 |
| 1620219780000 |      10 | 1.5844267368316651 |
| 1620219720000 |      13 | 1.5637413492569556 |
+---------------+---------+--------------------+








        
        

Copy
Statement Result
Learn more about CrateDB for JSON data

        
SELECT text, _score
FROM word_embeddings
WHERE knn_match(embedding,[0.3, 0.6, 0.0, 0.9], 2)
ORDER BY _score DESC; 

        
        

Copy

        
|------------------------|--------|
|         text           | _score |
|------------------------|--------|
|Discovering galaxies    |0.917431|
|Discovering moon        |0.909090|
|Exploring the cosmos    |0.909090|
|Sending the mission     |0.270270|
|------------------------|--------|

        
        

Copy
Statement Result
Learn more about CrateDB for vector data

        
SELECT show_id, title, director, country, release_year, rating, _score
FROM "netflix_catalog"
WHERE MATCH(title_director_description_ft, 'title^2 Friday') USING best_fields 
AND type='Movie' 
ORDER BY _score DESC;

        
        

Copy

        
+---------+------------------------------------+-------------------+----------------------+--------------+--------+-----------+
| show_id | title                              | director          | country              | release_year | rating | _score    |
+---------+------------------------------------+-------------------+----------------------+--------------+--------+-----------+
|  s1674  | Black Friday                       | Anurag Kashyap    | India                | 2004         | TV-MA  | 5.6455536 |
|  s6805  | Friday the 13th                    | Marcus Nispel     | United States        | 2009         | R      | 3.226806  |
|  s1038  | Tuesdays & Fridays                 | Taranveer Singh   | India                | 2021         | TV-14  | 3.1089375 |
|  s7494  | Monster High: Friday Night Frights | Dustin McKenzie   | United States        | 2013         | TV-Y7  | 3.0620003 |
|  s3226  | Little Singham: Mahabali           | Prakash Satam     | NULL                 | 2019         | TV-Y7  | 3.002901  |
|  s8233  | The Bye Bye Man                    | Stacy Title       | United States, China | 2017         | PG-13  | 2.9638999 |
|  s8225  | The Brawler                        | Ken Kushner       | United States        | 2019         | TV-MA  | 2.8108454 |
+---------+------------------------------------+-------------------+----------------------+--------------+--------+-----------+
        
        

Copy
Statement Result
Learn more about CrateDB for text data

        
/* Based on the location of the International Space Station, 
 * this query returns the 10 closest capital cities from 
 * the last known position 
 */
SELECT city as "City Name",
       country as "Country",
       DISTANCE(i.position, c.location)::LONG / 1000 AS "Distance [km]"
FROM demo.iss i
CROSS JOIN demo.world_cities c
WHERE capital = 'primary'
      AND ts = (SELECT MAX(ts) FROM demo.iss)
ORDER BY 3 ASC
LIMIT 10;

        
        

Copy

        
+--------------+-----------------------------------+---------------+
|  City Name   |             Country               | Distance [km] |
+--------------+-----------------------------------+---------------+
|    Papeete   |         French Polynesia          |      3386     |
|    Avarua    |           Cook Islands            |      3708     |
|  Wellington  |            New Zealand            |      4565     |
|     Alofi    |                Niue               |      4628     |
|  Nuku‘alofa  |               Tonga               |      4887     |
|  Pago Pago   |          American Samoa           |      5063     |
|   Santiago   |               Chile               |      5112     |
|     Apia     |               Samoa               |      5182     |
|    Stanley   | Falkland Islands (Islas Malvinas) |      5266     |
|     Suva     |               Fiji                |      5611     |
+--------------+-----------------------------------+---------------+

        
        

Copy
Statement Result
Learn more about CrateDB for geospatial data


ADOPT AN EASY-TO-USE DATABASE THAT SCALES WITH YOUR BUSINESS


ANY TYPE OF DATA

Structured, semi-structured, unstructured, time-series, geospatial, BLOB


RESPONSE TIME IN MILLISECONDS

Even for complex ad-hoc queries


NATIVE SQL

For query simplicity and quick onboarding


AGGREGATIONS ON THE FLY

Even with complex joins, large datasets and historical data


FLEXIBLE DATA SCHEMA

Editable on the fly at runtime


POSTGRESQL WIRE PROTOCOL

For 3rd party integrations


FULL-TEXT AND VECTOR SEARCH

No need for any extra database and easy integration with AI/ML frameworks


MASSIVELY SCALABLE

From one to hundreds of nodes


OPEN SOURCE

No vendor lock-in / Power of the community


SIMPLIFY YOUR DATABASE OPERATIONS


HIGH AVAILABILITY

Automatic failover, recovery and replication


MULTIPLE DEPLOYMENT MODELS

DBaaS or self-managed / Edge extension


COST-EFFICIENT ARCHITECTURE

No need to combine and synchronize different databases / Low carbon footprint

Learn more


EMBRACE MULTIPLE DATA USE CASES


AI/ML

Integrate with popular AI/ML frameworks. Leverage full-text and vector search
for meaningful insights.


INTERNET OF THINGS

Ingest, enrich and query high volume of sensor data in real-time, where your
data resides.


DIGITAL TWINS

Reduce development efforts and optimize TCO for digital twin implementations.


REAL-TIME ANALYTICS

Get immediate access to your data for informed decisions in real-time.


LOG ANALYSIS

Store all your logs into a single database and make instant queries with SQL.


DATABASE CONSOLIDATION

Keep a single source of truth updated in near real-time with all types of  data
in one place.


INTRODUCTION TO CRATEDB


KEY CONCEPTS, ARCHITECTURE, AND LIVE DEMO

Watch the recording


UPCOMING EVENTS

May 28, 2024 14:00 - 15:00 CET
Webinar


DIGITAL TWINS & GEN AI ON AZURE

Explore how TGW, a global leader in logistics automation, digitally transformed
warehouse operations using Azure.

Online


May 30, 2024 09:15 - 13:00 CET
Meetup


CRATEDB EUROPEAN TOUR PARIS

The CrateDB European City Tour is a series of local technical events focused on
solving a complex data use case through several hands-on activities,...


View all upcoming events and recent recordings


GET STARTED NOW

Get Started
Talk to an expert
Follow us on Twitter Follow us on Twitter Follow us on GitHub Follow us on
GitHub Follow us on Facebook Follow us on Facebook Follow us on YouTube Follow
us on YouTube Follow us on GitHub Follow us on GitHub Follow us on GitHub Follow
us on GitHub



COMPANY

 * Leadership
 * Team
 * Investors
 * Career
 * Events
 * Newsroom
 * Media kit


ECOSYSTEM

 * Partners
 * Startups
 * Integrations


CONTACT

 * Contact us
 * Offices
 * Security
 * Support

© 2024 CrateDB. All rights reserved.
 *  |
 * Legal |
 * Privacy Policy |
 * Imprint