MovR

​

Overview

• The movr dataset, which contains rows of data that populate tables in the movr database. The movr dataset is built into cockroach demo and cockroach workload.
• The MovR application, a fully-functional vehicle-sharing application, written in Python. All of MovR application source code is open-source, and available on the movr GitHub repository.

​

The movr database

​

Generating schemas and data for MovR

$ cockroach demo movr

1. Start a secure or insecure local cluster.
2. Use cockroach workload to load the movr dataset:
   $ cockroach workload init movr 'postgresql://root@localhost:26257?sslcert=certs%2Fclient.root.crt&sslkey=certs%2Fclient.root.key&sslmode=verify-full&sslrootcert=certs%2Fca.crt'
   
   $ cockroach workload init movr 'postgresql://root@localhost:26257?sslmode=disable'
   
3. Use cockroach sql to open an interactive SQL shell and set movr as the current database:
   $ cockroach sql --certs-dir=certs --host=localhost:26257
   
   > USE movr;
   
   $ cockroach sql --insecure --host=localhost:26257
   
   > USE movr;
   

​

How the MovR application works

1. A user loads the app and sees the 25 closest vehicles. For example:
   > SELECT id, city, status FROM vehicles WHERE city='amsterdam' limit 25;
   
2. The user signs up for the service. For example:
   > INSERT INTO users (id, name, address, city, credit_card)
     VALUES ('66666666-6666-4400-8000-00000000000f', 'Mariah Lam', '88194 Angela Gardens Suite 60', 'amsterdam', '123245696');
   
3. In some cases, the user adds their own vehicle to share. For example:
   > INSERT INTO vehicles (id, city, type, owner_id,creation_time,status, current_location, ext)
     VALUES ('ffffffff-ffff-4400-8000-00000000000f', 'amsterdam', 'skateboard', '66666666-6666-4400-8000-00000000000f', current_timestamp(), 'available', '88194 Angela Gardens Suite 60', '{"color": "blue"}');
   
4. More often, the user reserves a vehicle and starts a ride, applying a promo code, if available and valid. For example:
   > SELECT code FROM user_promo_codes WHERE user_id ='66666666-6666-4400-8000-00000000000f';
   
   > UPDATE vehicles SET status = 'in_use' WHERE id='bbbbbbbb-bbbb-4800-8000-00000000000b';
   
   > INSERT INTO rides (id, city, vehicle_city, rider_id, vehicle_id, start_address,end_address, start_time, end_time, revenue)
     VALUES ('cd032f56-cf1a-4800-8000-00000000066f', 'amsterdam', 'amsterdam', '66666666-6666-4400-8000-00000000000f', 'bbbbbbbb-bbbb-4800-8000-00000000000b', '70458 Mary Crest', '', TIMESTAMP '2020-10-01 10:00:00.123456', NULL, 0.0);
   
5. During the ride, MovR tracks the location of the vehicle. For example:
   > INSERT INTO vehicle_location_histories (city, ride_id, timestamp, lat, long)
     VALUES ('amsterdam', 'cd032f56-cf1a-4800-8000-00000000066f', current_timestamp(), -101, 60);
   
6. The user ends the ride and releases the vehicle. For example:
   > UPDATE vehicles SET status = 'available' WHERE id='bbbbbbbb-bbbb-4800-8000-00000000000b';
   
   > UPDATE rides SET end_address ='33862 Charles Junctions Apt. 49', end_time=TIMESTAMP '2020-10-01 10:30:00.123456', revenue=88.6
     WHERE id='cd032f56-cf1a-4800-8000-00000000066f';
   

​

Extended examples

​

Develop and deploy a global application

1. MovR: A Global Application Use-case
2. Create a Multi-region Database Schema
3. Set up a Virtual Environment for Developing Global Applications
4. Develop a Global Application
5. Deploy a Global Application

​

See also

• Learn CockroachDB SQL
• Build an App with CockroachDB
• Features in Preview