### SQL Playground Example

Source: https://citadeldb.dev/demo

Example SQL commands to create a table, insert data, and select from it in the SQL Playground.

```sql
CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);
INSERT INTO users (id, name) VALUES (1, 'Alice'), (2, 'Bob');
SELECT * FROM users;
```

--------------------------------

### Basic CitadelDB Usage

Source: https://citadeldb.dev/

Example of creating a database, opening a connection, executing SQL commands, and querying data using CitadelDB and its SQL bindings.

```rust
use citadel::DatabaseBuilder;
use citadel_sql::Connection;

let db = DatabaseBuilder::new("my.db")
    .passphrase(b"secret")
    .create()?;

let mut conn = Connection::open(&db)?;
conn.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);")?;
conn.execute("INSERT INTO users (id, name) VALUES (1, 'Alice');")?;
let result = conn.query("SELECT * FROM users;")?;
```

--------------------------------

### Add CitadelDB to your project

Source: https://citadeldb.dev/

Add CitadelDB and its SQL bindings to your Cargo.toml file.

```bash
cargo add citadeldb citadeldb-sql
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.