Actions are exactly what they say -- they do something! You can think of actions to be like shell commands: you run a command with arguments and you get some corresponding output.
HEYA you ran in the earlier document? Yup, that's an action. All kind of quering in Skytable is done through actions. Actions are classified into two kinds:
- DDL (Data definition language) Actions: These actions enable us to interact with the structures that store our data
- DML (Data manipulation language) Actions: These actions enable us to access and manipulate the data stored in our database
If you're coming from a SQL background, you might be used to the DML way of things. That's right, DML actions are similar. Let us try out a few basic DML actions (don't worry — you'll learn about DDL in the next few documents).
SET action lets us assign a key to a value (in a key/value table). For example:
SET x 100
will assign the key
100. But how do we get it?
GET action lets us fetch keys. For example:
will return the
100 that we set in the last step.
UPDATE action lets us update the values of keys. For example:
UPDATE x 200
will update the value of
DEL action lets us remove keys from the database. For example:
will remove the key
x from the database.
Didn't we just do a Create-Read-Update-Delete? The infamous CRUD! Now that you know some basic actions, you can take a look at the full index of actions.