SQLite utility functions and DDL helpers.
SQLite utility functions and DDL helpers.
(analyze-database datasource)(analyze-database datasource table-name)Update SQLite database statistics for better query planning.
Args: datasource: SQLite datasource table-name: Optional specific table name
Returns: nil - side effects only
Update SQLite database statistics for better query planning. Args: datasource: SQLite datasource table-name: Optional specific table name Returns: nil - side effects only
(autoincrement-primary-key)Get SQLite autoincrement primary key definition.
Use with caution - AUTOINCREMENT has performance implications.
Get SQLite autoincrement primary key definition. Use with caution - AUTOINCREMENT has performance implications.
(boolean-column-type)Get SQLite boolean column type definition.
SQLite doesn't have native boolean type, uses INTEGER.
Get SQLite boolean column type definition. SQLite doesn't have native boolean type, uses INTEGER.
(create-database-url database-path & [options])Create SQLite JDBC URL from file path.
Args: database-path: Path to SQLite database file options: Optional map of connection parameters
Returns: JDBC URL string
Create SQLite JDBC URL from file path. Args: database-path: Path to SQLite database file options: Optional map of connection parameters Returns: JDBC URL string
(database-info datasource)Get SQLite database information and settings.
Args: datasource: SQLite datasource
Returns: Map with database information
Get SQLite database information and settings. Args: datasource: SQLite datasource Returns: Map with database information
(explain-query datasource query-map)(explain-query datasource query-map query-plan?)Get SQLite query execution plan.
Args: datasource: SQLite datasource query-map: HoneySQL query map query-plan: Optional - use 'query-plan' for detailed analysis
Returns: Vector of execution plan steps
Get SQLite query execution plan. Args: datasource: SQLite datasource query-map: HoneySQL query map query-plan: Optional - use 'query-plan' for detailed analysis Returns: Vector of execution plan steps
(integer-primary-key)Get SQLite integer primary key definition.
INTEGER PRIMARY KEY in SQLite is an alias for ROWID.
Get SQLite integer primary key definition. INTEGER PRIMARY KEY in SQLite is an alias for ROWID.
(list-indexes datasource)(list-indexes datasource table-name)List all indexes in SQLite database.
Args: datasource: SQLite datasource table-name: Optional specific table name
Returns: Vector of index information maps
List all indexes in SQLite database. Args: datasource: SQLite datasource table-name: Optional specific table name Returns: Vector of index information maps
(list-tables datasource)List all tables in SQLite database.
Args: datasource: SQLite datasource
Returns: Vector of table names
List all tables in SQLite database. Args: datasource: SQLite datasource Returns: Vector of table names
(reindex-database datasource)(reindex-database datasource index-name)Rebuild SQLite indexes for better performance.
Args: datasource: SQLite datasource index-name: Optional specific index name
Returns: nil - side effects only
Rebuild SQLite indexes for better performance. Args: datasource: SQLite datasource index-name: Optional specific index name Returns: nil - side effects only
(timestamp-column-type)Get SQLite timestamp column type definition.
SQLite stores timestamps as TEXT in ISO8601 format.
Get SQLite timestamp column type definition. SQLite stores timestamps as TEXT in ISO8601 format.
(uuid-column-type)Get SQLite UUID column type definition.
SQLite stores UUIDs as TEXT.
Get SQLite UUID column type definition. SQLite stores UUIDs as TEXT.
(vacuum-database datasource)(vacuum-database datasource into-file)Vacuum SQLite database to reclaim space and defragment.
Args: datasource: SQLite datasource into-file: Optional file path for VACUUM INTO operation
Returns: nil - side effects only
Vacuum SQLite database to reclaim space and defragment. Args: datasource: SQLite datasource into-file: Optional file path for VACUUM INTO operation Returns: nil - side effects only
(varchar-uuid-column-type)Get SQLite varchar UUID column type definition.
Get SQLite varchar UUID column type definition.
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |