all AI news
Optimal SQLite settings for Django
June 13, 2024, 5:04 a.m. |
Simon Willison's Weblog simonwillison.net
Optimal SQLite settings for Django
Giovanni Collazo put the work in to figure out settings to make SQLite work well for production Django workloads. WAL mode and a busy_timeout of 5000 make sense, but the most interesting recommendation here is "transaction_mode": "IMMEDIATE" to avoid locking errors when a transaction is upgraded to a write transaction.
Giovanni's configuration depends on the new "init_command" support for SQLite PRAGMA options introduced in Django 5.1alpha.
Via Lobste.rs
django errors figure production recommendation sense sqlite work workloads
More from simonwillison.net / Simon Willison's Weblog
Wikipedia Manual of Style: Linking
1 day, 4 hours ago |
simonwillison.net
Quoting Matt Levine
2 days, 13 hours ago |
simonwillison.net
Val Vibes: Semantic search in Val Town
2 days, 16 hours ago |
simonwillison.net
Jobs in AI, ML, Big Data
Senior Data Engineer
@ Displate | Warsaw
Director of Data Science (f/m/x)
@ AUTO1 Group | Berlin, Germany
Business Intelligence Analyst I [BI Analyst I]
@ Capitec Bank | Stellenbosch, Western Cape, ZA
Data Governance Associate Director
@ Publicis Groupe | London, United Kingdom
Technical Lead - Power BI
@ Birlasoft | INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI, IN
Data Analyst
@ FirstRand Corporate Centre | 1 First Place, Cnr Simmonds & Pritchard Streets, Johannesburg, 2001