# datahike-sqlite.konserve ## default-table [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L22-L22) --- ## sqlite-bulk-insert-batch-size [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L24-L24) --- ## default-sqlite-pragmas [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L25-L32) --- ## with-write-tx ```clojure (with-write-tx db f) ``` Wrapper around the with-write-tx macro, for use in situations where we cannot use macros directly. [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L34-L38) --- ## init-db ```clojure (init-db db-spec) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L40-L46) --- ## create-statement ```clojure (create-statement table) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L48-L49) --- ## upsert-statement ```clojure (upsert-statement table id header meta value) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L51-L55) --- ## select-exists-statement ```clojure (select-exists-statement table id) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L57-L58) --- ## delete-row-statement ```clojure (delete-row-statement table store-key) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L60-L61) --- ## select-row-statement ```clojure (select-row-statement table id) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L63-L64) --- ## select-rows-statement ```clojure (select-rows-statement table ids) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L66-L69) --- ## select-ids-statement ```clojure (select-ids-statement table ids) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L71-L74) --- ## select-table-exists-statement ```clojure (select-table-exists-statement table) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L76-L77) --- ## select-all-ids-statement ```clojure (select-all-ids-statement table) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L79-L80) --- ## delete-rows-statement ```clojure (delete-rows-statement table store-keys) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L82-L85) --- ## update-id-statement ```clojure (update-id-statement table from to) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L87-L88) --- ## multi-insert-statement ```clojure (multi-insert-statement table batch-size) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L90-L98) --- ## copy-row-statement ```clojure (copy-row-statement table to from) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L100-L104) --- ## delete-store-statement ```clojure (delete-store-statement table) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L106-L107) --- ## change-row-id ```clojure (change-row-id db table from to) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L109-L113) --- ## read-all ```clojure (read-all db table id) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L115-L122) --- ## ->SQLiteRow ```clojure (->SQLiteRow db key data cache) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L129-L171) --- ## SQLiteRow [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L129-L171) --- ## map->SQLiteRow ```clojure (map->SQLiteRow m) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L129-L171) --- ## ->SQLiteTable ```clojure (->SQLiteTable db-spec db table) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L195-L276) --- ## SQLiteTable [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L195-L276) --- ## map->SQLiteTable ```clojure (map->SQLiteTable m) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L195-L276) --- ## prepare-spec ```clojure (prepare-spec db-spec opts-table) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L278-L282) --- ## connect-store ```clojure (connect-store db-spec & {:keys [opts] :as params}) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L284-L301) --- ## release ```clojure (release store env) ``` Closes the SQLite database connection pools. [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L303-L310) --- ## delete-store ```clojure (delete-store db-spec & {:keys [table opts]}) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L312-L317) --- ## store-exists? ```clojure (store-exists? db-spec & {:keys [table opts]}) ``` [source,window=_blank](https://github.com/outskirtslabs/datahike-sqlite/blob/main/src/datahike_sqlite/konserve.clj#L319-L329)