TopicTracker
From simonwillison.netView original
TranslationTranslation

SQLite 3.53.0

SQLite 3.53.0 is a major release with accumulated improvements including ALTER TABLE support for NOT NULL and CHECK constraints, new json_array_insert() function, and CLI enhancements via a new Query Results Formatter library.

Related stories

  • A developer has created a near real-time sync tool for Apple Notes that exports changes as markdown and versions them in git-based cloud storage. The service provides collaboration features like sharing and commenting, with a macOS app handling the sync process.

  • 本文探讨了Claude Opus模型从4.6版本升级到4.7版本时,其系统提示(system prompt)发生的关键变化。这些修改反映了模型能力的演进和对用户交互方式的优化,对开发者理解模型行为具有重要意义。

  • An early-career software engineer with strong programming skills asks how to improve at the more managerial aspects of software engineering, including design documentation, decision tracking, infrastructure planning, and compliance work.

  • Recoonlytics is a tool that automatically cleans messy CSV or Excel data by detecting column types, removing duplicates, fixing missing values, and generating statistics and visualizations. The goal is to transform raw data into usable insights in seconds without manual preprocessing.