After you’ve created a database in SQLite Cloud, you can start writing data to it. You can write data to your cluster using the SQLite Cloud UI, API, or client libraries.

Writing data with the SQLite Cloud UI

Navigate to the Studio tab from the left-hand navigation. From here, you can run SQL commands directly on your cluster. If needed, use the dropdown menus to select the database and table where you want to insert or update data.

Alternatively, you can also interact directly with the table view to add new records or update existing ones without writing SQL manually.

Example

-- If you haven't selected a database yet, run the USE DATABASE command
USE DATABASE <your-database-name>.sqlite; 
-- Create your table
CREATE TABLE sports_cars (sc_id INTEGER PRIMARY KEY, sc_make TEXT NOT NULL, sc_year INTEGER NOT NULL);
-- Insert data into your table
INSERT INTO sports_cars (sc_make, sc_year) VALUES ('Ferrari', 2021);

Writing data with the Weblite API

You can use the Weblite API to run SQL commands against your cluster. Here is an example cURL request:

curl -X 'POST' \
  'https://<your-project-id>.<your-hosted-zone>.gateway.sqlite.cloud/v2/weblite/sql' \
  -H 'Content-Type: application/json' \
  -H 'Authorization: Bearer <your-api-key>' \
  -d '{"sql": "<your-sql-here>", "database": "<database-name>"}'

Writing data with client libraries

To write data to your cluster using a client library, use the INSERT INTO SQL command.

import { Database } from '@sqlitecloud/drivers';

const db = new Database('sqlitecloud://<your-project-id>.<your-hosted-zone>.sqlite.cloud:<your-host-port>?apikey=<your-api-key>')
db.exec('USE DATABASE <your-database-name>.sqlite;')
db.exec('CREATE TABLE sports_cars (sc_id INTEGER PRIMARY KEY, sc_make TEXT NOT NULL, sc_year INTEGER NOT NULL);')
db.commit()
const insertData = async () => await db.sql('INSERT INTO sports_cars (sc_make, sc_year) VALUES (?, ?)', 'Ferrari', 2021);

insertData().then((res) => console.log(res));
// "OK"