2 pages tagged with "sqlite3"

Wanted to test the PRAGMA changes to crystal-sqlite3 and perform some simple HTTP benchmarks, just for fun 😊 This uses the work shown on previous TIL, and the code from [PR #85][pr-85]. ▶️ Similar to previous TIL, I made a recording of this test (and the errors) 💣 here. 1. A simple HTTP app that use… read more

For a project in Crystal using SQLite3 (crystal-sqlite3), I wanted to automate setting PRAGMAs on the database connection without having to leverage on DB#setup_connection and hardcoding values in my code. So, instead of doing this: require "sqlite3" DB.open "sqlite3:file.db" do… read more