Function init_sqlite_to_postgres 

pub async fn init_sqlite_to_postgres(
    sqlite_path: &str,
    target_url: &str,
) -> Result<()>

Initial replication from SQLite to PostgreSQL

Performs one-time migration of SQLite database to PostgreSQL target using JSONB storage:

1. Validates SQLite file exists and is readable
2. Validates PostgreSQL target connection
3. Lists all tables from SQLite database
4. For each table:
   • Converts rows to JSONB format
   • Creates JSONB table in PostgreSQL
   • Batch inserts all data

All SQLite data is stored as JSONB with metadata:

• id: Original row ID (from ID column or row number)
• data: Complete row as JSON object
• _source_type: “sqlite”
• _migrated_at: Timestamp of migration

Arguments

• sqlite_path - Path to SQLite database file (.db, .sqlite, or .sqlite3)
• target_url - PostgreSQL connection string for target (Seren) database

Returns

Returns Ok(()) if migration completes successfully.

Errors

This function will return an error if:

• SQLite file doesn’t exist or isn’t readable
• Cannot connect to target PostgreSQL database
• Table conversion fails
• Database creation or insert operations fail

Examples

init_sqlite_to_postgres(
    "database.db",
    "postgresql://user:pass@seren.example.com/targetdb"
).await?;