Stargate-REST-API:users_keyspace

Number of APIs: 29

This Stargate REST API example collection/scenario/data model is named Users Keyspace.

It contains a sample schema and queries for Stargate's REST API using:

keyspace: users_keyspace
table: users

It is documented here, make sure to read before using this collection.

Stargate requires a Cassandra cluster. Stargate is deployable to bare metal, VMs, Docker/Compose, EKS, GKE, K8ssandra.io and DataStax Enterprise.

Development mode will install a Cassandra DB for you locally with non-production / desktop development settings.

On Astra DB, both Cassandra and Stargate are automatically setup (and managed) for you.

Most desktop development is free with Astra DB's 80GB Free Monthly plan. Sign up in a few clicks, no credit card is required.

What is Stargate?

What is Apache Cassandra?

What is Astra DB?

  1. init request - Init request GET https://api.getpostman.com/collections/17930693-47ab5f0d-407e-48cf-aa11-c51d129f1eef

  2. authenticate - Create a auth token (Stargate OSS only) POST {{base_auth_url}}{{auth_api}}

  3. create schema - Create a keyspace with replica set to 1 (Stargate OSS only) POST {{base_rest_url}}{{rest_schema}}

  4. create schema - Create a user-defined type (UDT) called address POST {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/types

  5. insert data - Put user: Mookie Betts evaluation update PUT {{base_rest_url}}{{rest_api}}/{{rkeyspace}}/{{rtable}}/:id

  6. create schema - Create a table users POST {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables

  7. create schema - Create a column address (UDT) POST {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables/{{rtable}}/columns

  8. create schema - Change the column firstname to first PUT {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables/{{rtable}}/columns/:colname

  9. create schema - Change the column first back to firstname PUT {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables/{{rtable}}/columns/:newcolname

  10. create schema - Create table index country_idx (TUPLE) POST {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables/{{rtable}}/indexes