profile picture

2 pages tagged with "sqlite3"

Testing Crystal SQLite3 PRAGMAs usage and some HTTP benchmarks 👨‍🚀🚀

February 11, 2023 - 1317 words - 7 mins
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

Setting SQLite3 PRAGMA's automatically with crystal-sqlite3

January 14, 2023 - 641 words - 4 mins
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