Getting Started

Getting Started

Please use this guide as a starting tutorial on how to use Hyprcubd.

The Console is where you administer your account. You must be authenticated to use the console. Hyprcubd uses magic-links in order to authenticate users.

Log into the console

Log into the console by entering your email. Follow the instructions in the email. More details are here.

Create your first database

A database in Hyprcubd is just a logical grouping of tables. You need to create at least one in order to create a table.

  1. Select “Databases” from the left hand navigation.
  2. Click “Create your first database” or the “Create New” button.
  3. Enter a name for your new database. Databases are logical groupings of tables.
  4. Click “Create”. This will then take you to a listing of tables within your database.

Create your first table

A table in Hyprcubd is a collection of data modeled after a schema just like a SQL database such as MySQL or PostgreSQL. Let’s create one now.

  1. Create a table by clicking “Create one now” or the “Create Table” button.
  2. The New Table form will be displayed. Here you need to enter a table name and add extra columns. The “time” column is the only required column.
  3. To add a column, type the name of the column and select its type then click the “+” button.
  4. When finished adding columns, click the “Create” button. Please allow at least 30-60 seconds for the table resources to be created. If this takes longer, please contact support via the in-app chat.
  5. You should see the following when your table is being created.
  6. When the table is done being created, the status will switch to “Running”. Now you can click on the table to go into the detailed view.
  7. Metadata about your table is displayed at the top. A limit query is executed to display some data in your table. Right now, you don’t have any data in your table.
  8. Follow the “Browser” link at the bottom or select it from the navigation bar to the left.

Using the Browser

The browser is a playground for you to interact with your table. You can do INSERT or SELECT queries. Your database is automatically selected for you.

  1. Try selecting just time. Our example table is called tweet.
    SELECT time FROM tweet
    
  2. Click “Run”
  3. The details about the query run are displayed below the Run button and the data is displayed in a table format below the query input field. The “Time” is the amount of time spent by the database once the query was received. This does not include network latency that can add overhead. To see round-trip latency, hover over the time field.
  4. Since there is no data, let’s insert a row:
    INSERT INTO tweet (time, id, author, hashtag) VALUES ('2020-04-26 12:22:00', 1, 1, 'sqlrocks')
    

    Again, you should see the server processing time as well as the rows affected.

  5. Now we will query again using the same query as above. This will return one row:
    SELECT time FROM tweet
    
  6. We can also select more than one column:
    SELECT time, id, author, hashtag FROM tweet