Welcome to our narrative tutorial
Trouble is brewing on the planet of Aittador. An evil Star Sorcerer named Brog is plotting destruction, and soon it will be up to a few brave souls to defeat him. Grab your laser gun and follow this narrative tutorial, where you’ll learn how to build a Typescript sample app on CockroachCloud.
How it works:
Today is a dark day. The evil Star Sorcerer named Brog, who’s been plaguing the planet of Aittador for years, attacked the capital city and kidnapped your best friend, Sam. The sorcerer retreated to the Obsidian Mountains with the threat he’ll be back to destroy the planet once and for all. You’re the only one brave enough to track him down.
Task #1: Gather your hoverbike and laser gun
You’re ready to embark on your quest! You bid farewell to your friends and family, hop on your hoverbike, and head towards the Obsidian Mountains.
After an arduous journey into the Obsidian Mountains, where you used your skills with a laser gun to fight off flesh-eating bats and one very large lizard, you find Brog’s tower. The tower is guarded by two droids who soon fall victim to your wiley bribes. They give you crucial information in exchange for your hoverbike.
Turns out you’ve arrived just in time. Tonight, Brog will use star magic to steal Sam’s soul and gain the power he needs to destroy the planet. The droids, who are giddy with excitement about their new bike, help you distract Brog. You sneak into the tower.
Task #1: Disable the cyber lock on Sam’s prison cell
Once your CockroachCloud cluster is created, the Connection info dialog displays. Use the information provided in the dialog to set up your cluster connection for the SQL user that was created by default:
Phew, that was close! You and Sam manage to flee the cave while Brog is distracted, and you run down the mountain.
Huddling on the barren slopes of the lower Obsidian Mountains, you and Sam recount your adventures. While captive, Sam learned that Shime Stones, radioactive rocks found deep in the Fire Spits, are the only thing that can kill Brog. You must journey to the Fire Spits and find several hundred blue, green, and red stones to defeat the sorcerer.
Before you start your journey, you’ve got to buy a new hoverbike and a vault—a box that can safely store radioactive material.
Task #1: Head to the nearest town to buy a hoverbike and a vault
Task #2: Journey to the Fire Spits
cockroach sql --url 'postgresql://emily:
vaultdatabase that your application will use:
CREATE DATABASE vault;
You’ve made it to the Fire Spits! Ash rains down, fires burn, and lava pits bubble. Suddenly your hoverbike stops working. Its machinery is clogged by ash. You and Sam continue on foot, searching for Shime Stones.
There—you see colorful glowing lights between boulders! The smoke is choking you and your boots are melting, but now isn’t the time to stop. You must prepare the vault, and then you and Sam must quickly collect as many blue, green, and red stones as possible.
Task #1: Prepare the vault
ormconfig.tsfile, and edit the ORM configuration parameters:
hostwith the name of the CockroachCloud Free host (e.g.,
portwith the port to your cluster.
usernamewith the username from the connection string.
passwordwith the password for your user.
databasewith the database that you created earlier, suffixed with the name of the cluster (e.g.,
fs.readFileSync('certs/cc-ca.crt').toString()call to use the path to the
cc-ca.crtfile that you downloaded from the CockroachCloud Console.
Task 2: Collect the Shime Stones
npm install pg --save
Collected 1000 blue Shime Stones.
Collected 250 green Shime Stones.
Collected 400 red Shime Stones.
You collected the stones! Relief surges through you, before you realize your hoverbike is broken. How will you and Sam get back to the city? Suddenly, an ear-splitting shriek tears open the sky. A gigantic beast circles overhead, half eagle and half robot. It’s Vaskralla, a legendary monster of Aittador. But instead of eating you, she tells you to hop on her back, because Brog is attacking the capital at this very moment.
Your beloved planet stretches out below as you fly over the empty plains, dark Obsidian Mountains, and lush valley that holds the capital. Then you spot smoke and red flames burning the city. It’s Star Sorcerer fire!
Vaskralla swoops between the towers searching for Brog. Buildings collapse and smoke billows. Far below on the streets, people run for their lives screaming. There—a lone figure stands atop City Hall. Hovercraft swarm around the sorcerer, shooting lasers, but the lasers bounce right off him. You must defeat Brog now or never.
You shoot the Shime Stones from the vault. They hit Brog in the chest, vaporizing him. The red fires snuff out. Silence falls over the city, and you realize you did it. You saved Aittador!
You and Sam are awarded Aittador’s highest honors, and the city throws a lavish party to celebrate. You invite the droids, who arrive on your old hoverbike. You invite Vaskralla, who terrifies everyone but turns out to be a great dancer. The party runs all night and into the next day, because for the first time in years, the planet of Aittador is safe.
Task #1: Celebrate with your peers
Task #2: Choose your next adventure
This is only the beginning of your journey. You’re a recognized hero now, so you can conquer whatever you want!