Enum Drivers 

pub enum Drivers {
    Postgres,
    SQLite,
    MySQL,
}

Supported database driver types.

This enum represents the different database backends that Bottle ORM can work with. The driver type is automatically detected from the connection URL and used to generate appropriate SQL syntax for each database system.

Variants

• Postgres - PostgreSQL database (9.5+)
• SQLite - SQLite database (3.x)
• MySQL - MySQL or MariaDB database (5.7+/10.2+)

SQL Dialect Differences

Different drivers use different SQL syntax:

• Placeholders:

  • PostgreSQL: $1, $2, $3 (numbered)
  • SQLite/MySQL: ?, ?, ? (positional)

• Type Casting:

  • PostgreSQL: $1::UUID, $2::TIMESTAMPTZ
  • SQLite/MySQL: Automatic type inference

• Schema Queries:

  • PostgreSQL: information_schema tables
  • SQLite: sqlite_master system table
  • MySQL: information_schema tables

Example

match db.driver {
    Drivers::Postgres => println!("Using PostgreSQL"),
    Drivers::SQLite => println!("Using SQLite"),
    Drivers::MySQL => println!("Using MySQL"),
}

Variants

Postgres

PostgreSQL driver.

Used for PostgreSQL databases. Supports advanced features like:

• UUID native type
• JSONB for JSON data
• Array types
• Full-text search
• Advanced indexing (GiST, GIN, etc.)

SQLite

SQLite driver.

Used for SQLite databases (both in-memory and file-based). Characteristics:

• Lightweight and embedded
• Single-file database
• Limited concurrent write support
• Good for development and small applications

MySQL

MySQL driver.

Used for MySQL and MariaDB databases. Features:

• Wide compatibility
• Good performance for read-heavy workloads
• Mature ecosystem
• ACID compliance (with InnoDB)

Trait Implementations

impl Clone for Drivers

fn clone(&self) -> Drivers

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Drivers

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Copy for Drivers