<commit_before>title: Try Crate
description: Try Crate from your browser, no installation needed. The Crate Cube is a condensed miniaturized cluster that demonstrates the speed Crate runs SQL queries.

{% extends "base.html" %}

{% block extra_css %}
<link rel="stylesheet" href="{% static '/static/css/crate.terminal.css' %}" />
{% endblock %}

{% block extra_js %}
<script src="{% static '/static/js/ascii-table.js' %}"></script>
<script src="{% static '/static/js/highlight.pack.js' %}"></script>
<script src="{% static '/static/js/crate.js' %}"></script>
{% endblock %}

{% block header %}
<div class="wrapper wrapper-bg-primary">
  <div class="container">
    <div class="row">
      <div class="col-sm-12">
	<h1>Try Crate</h1>
	<p class="lead">Starting with Crate is a piece of cake! Simply try out our demo cluster console ...</p>
      </div>
    </div>
  </div>
</div>
{% endblock %}

{% block body %}
<div class="wrapper wrapper-border">
<div class="container">

  <div class="row">
    <div class="col-lg-12">

      <div class="terminal">
        <div class="terminal-header">
          <EMAIL> | crash
        </div>
        <form class="crate-cli form terminal-body" data-host="https://play.crate.io">
          <pre class="terminal-history"><div class="text-success">Welcome to the Crate Shell (aka CraSh) ...</div></pre>
          <div class="terminal-prompt">
            <input name="input" type="text" class="terminal-prompt" value="cr> " />
          </div>
        </form>
      </div>
      <p>&nbsp;</p>
      <p class="text-right"><a class="btn btn-default" href="/docs/stable/sql/index.html" target="_docs"><i class="fa fa-book"></i> Crate SQL Help &raquo;</a></p>

      <p>&nbsp;</p>

      <p>Start off with exploring existing tables:</p>
      <pre class="tut">select schema_name, table_name, number_of_shard, number_of_replicas
from information_schema.tables where schema_name = 'doc';</pre>
      <p>Select retweeted tweets:</p>
      <pre class="tut">select id, user['id'], text from tweets where user['id'] > 1000000000 limit 10;</pre>
      <p>Count tweets and unique users:</p>
      <pre class="tut">select count(*) as tweets, count(distinct user['id']) as users from tweets;</pre>

      <p>Step by Step:</p><commit_msg>fixed first sql statement on try page<commit_after>title: Try Crate
description: Try Crate from your browser, no installation needed. The Crate Cube is a condensed miniaturized cluster that demonstrates the speed Crate runs SQL queries.

{% extends "base.html" %}

{% block extra_css %}
<link rel="stylesheet" href="{% static '/static/css/crate.terminal.css' %}" />
{% endblock %}

{% block extra_js %}
<script src="{% static '/static/js/ascii-table.js' %}"></script>
<script src="{% static '/static/js/highlight.pack.js' %}"></script>
<script src="{% static '/static/js/crate.js' %}"></script>
{% endblock %}

{% block header %}
<div class="wrapper wrapper-bg-primary">
  <div class="container">
    <div class="row">
      <div class="col-sm-12">
	<h1>Try Crate</h1>
	<p class="lead">Starting with Crate is a piece of cake! Simply try out our demo cluster console ...</p>
      </div>
    </div>
  </div>
</div>
{% endblock %}

{% block body %}
<div class="wrapper wrapper-border">
<div class="container">

  <div class="row">
    <div class="col-lg-12">

      <div class="terminal">
        <div class="terminal-header">
          <EMAIL> | crash
        </div>
        <form class="crate-cli form terminal-body" data-host="https://play.crate.io">
          <pre class="terminal-history"><div class="text-success">Welcome to the Crate Shell (aka CraSh) ...</div></pre>
          <div class="terminal-prompt">
            <input name="input" type="text" class="terminal-prompt" value="cr> " />
          </div>
        </form>
      </div>
      <p>&nbsp;</p>
      <p class="text-right"><a class="btn btn-default" href="/docs/stable/sql/index.html" target="_docs"><i class="fa fa-book"></i> Crate SQL Help &raquo;</a></p>

      <p>&nbsp;</p>

      <p>Start off with exploring existing tables:</p>
      <pre class="tut">select schema_name, table_name, number_of_shards, number_of_replicas
from information_schema.tables where schema_name = 'doc';</pre>
      <p>Select retweeted tweets:</p>
      <pre class="tut">select id, user['id'], text from tweets where user['id'] > 1000000000 limit 10;</pre>
      <p>Count tweets and unique users:</p>
      <pre class="tut">select count(*) as tweets, count(distinct user['id']) as users from tweets;</pre>

      <p>Step by Step:</p>
{'fraction_non_alphanumeric': 0.18330028640669752, 'fraction_numerical': 0.007931262392597489, 'mean_word_length': 3.4729064039408866, 'pattern_counts': {'":': 0, '<': 125, '<?xml version=': 0, '>': 129, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 2, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4185572', 'n_tokens_mistral': 1544, 'n_tokens_neox': 1427, 'n_words': 403}