{"repo":"crystal-lang/crystal-sqlite3","free":true,"listed":false,"github":"https://github.com/crystal-lang/crystal-sqlite3","clone":"git clone https://github.com/crystal-lang/crystal-sqlite3.git","description":"SQLite3 bindings for Crystal","language":"Crystal","stars":161,"topics":["crystal","sqlite3","database","driver"],"license":"MIT","category":"databases-storage","readme_excerpt":"crystal-sqlite3 SQLite3 bindings for Crystal. Check crystal-db for general db driver documentation. crystal-sqlite3 driver is registered under sqlite3:// uri. Installation Add this to your application's shard.yml : Usage DB::Any Time is implemented as TEXT column using SQLite3::DATE FORMAT SUBSECOND format (or SQLite3::DATE FORMAT SECOND if the text does not contain a dot). Bool is implemented as INT column mapping 0 / 1 values. Setting PRAGMAs You can adjust certain SQLite3 PRAGMAs automatically when the connection is created by using the query parameters: The following is the list of supported options: Name Connection key --------------------------- ----------------- [Busy Timeout][pragma-to] busy timeout [Cache Size][pragma-cs] cache size [Foreign Keys][pragma-fk] foreign keys [Journal Mode][pragma-jm] journal mode [Synchronous][pragma-sync] synchronous [WAL autocheckoint][pragma-walck] wal autocheckpoint Please note there values passed using these connection keys are passed directly to SQLite3 without check or evaluation. Using incorrect values result in no error by the library. [pragma-to]: https://www.sqlite.org/pragma.html#pragma busy timeout [pragma-cs]: https://www.sqlite.org/pragma.html#pragma cache size [pragma-fk]: https://www.sqlite.org/pragma.html#pragma foreign keys [pragma-jm]: https://www.sqlite.org/pragma.html#pragma journal mode [pragma-sync]: https://www.sqlite.org/pragma.html#pragma synchronous [pragma-walck]: https://www.sqlite.org/pragma.html#pragma wal","default_branch":null,"files":null,"tree":[],"storefront":"/r/crystal-lang","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/crystal-lang/crystal-sqlite3/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}