{"results":[{"role":"subject","uri":"https://justatheory.com/2005/11/which-sql-book","title":"What Advanced SQL Book Should I Buy?","description":"So, what advanced SQL book should I buy? I’ve learned a lot about SQL over the last year or so, but I’m sure that Josh Berkus is tired of being my own personal advanced SQL reference. So I’d like to really learn more about triggers, stored procedures, rules, views, and whatnot, what they’re best used for and when to use them. And other typical database features that I’m not familiar with, of course.","date":1773394465954,"image":null},{"role":"object","uri":"https://octothorp.es/~/sqlite","title":null,"description":null,"image":null},{"role":"subject","uri":"https://blog.balthazar-rouberol.com/pinning-your-sqlite-version-across-environments","title":"Pinning your SQLite version across environments","description":"A walkthrough of how to pin an sqlite version and feature set accross multiple environments, architectures and OSes.","date":1760760445046,"image":null},{"role":"subject","uri":"https://justatheory.com/2013/04/sqitch-sqlite","title":"Sqitch: Now with SQLite Support","description":null,"date":1751094693673,"image":null},{"role":"subject","uri":"https://justatheory.com/2005/03/mysql-replace-considered-harmful","title":"MySQL's REPLACE Considered Harmful","description":null,"date":1750979648189,"image":null},{"role":"subject","uri":"https://justatheory.com/2005/10/sqlite-perl-aggregates","title":"Custom SQLite Aggregates in Perl","description":"About a year ago, Josh Berkus was reviewing some Bricolage SQL code, looking to optimize it for PostgreSQL. One of the things he noticed was that we were fetching a lot more rows for an object than we needed to. The reason for this is that an object might be associated with one or more groups, and to get back a list of all of the group IDs, we were getting multiple rows. For example, if I wanted to fetch a single story with the ID 10, I might get back rows like this:","date":1746261962116,"image":null},{"role":"subject","uri":"https://justatheory.com/2013/07/upcoming-sqitch-improvements","title":"Notes on Upcoming Sqitch Improvements","description":null,"date":1743703883106,"image":null},{"role":"subject","uri":"https://justatheory.com/2006/01/add-sqlite-regexen","title":"Add Regular Expression Operator to SQLite","description":null,"date":1743294274213,"image":null},{"role":"subject","uri":"https://justatheory.com/2004/11/sqlite-foreign-key-triggers","title":"Enforce Foreign Key Integrity in SQLite with Triggers","description":"After some some Googling and experimentation, I’ve figured out how to enforce foreign key constraints in SQLite. I got most of the code from Cody Pisto’s sqlite_fk utility. I couldn’t get it to work, but the essential code for the triggers was in its fk.c file, so I just borrowed from that (public domain) code to figure it out.","date":1740850081860,"image":null},{"role":"subject","uri":"https://justatheory.com/2009/02/markdown-table-rfc","title":"RFC: A Simple Markdown Table Format","description":null,"date":1740295062305,"image":null}]}