GoKawiil
Tech News
APSW (Another Python SQLite Wrapper) is an open-source library that exposes the complete SQLite C API to Python, including features like full text search, sessions, virtual tables, VFS, JSON, and CArray. It supports CPython 3.10 and later, works with synchronous code and async frameworks, and is distributed via PyPI and GitHub under an OSI-approved open source license.
A new release of Thoreau BASIC, a modernized dialect of the language, introduces built-in commands for file browsing (GETFILES) and interactive list selection (SELECTBOX) with mouse and keyboard support. It also adds STATEWRITE/STATELOAD for checksummed variable checkpointing, CRC32 and TEXTSTATS utilities, and a SYSTEMINFO$ function reporting CPU, AVX2/SSE2 support and build details. The update also includes JIT improvements for floating-point and complex/quaternion/octonion math, plus a RUN fix to avoid stack growth on restart.
Makepad creator Rik Arends built a 3D navigable tool that renders up to 2.5 million lines of source code at over 120 frames per second, initially requiring 21GB of RAM before optimizations to indexing and streaming compression brought usage down to 3.5GB. He also tested loading Chromium's 51-million-line codebase, which took about 60 seconds.
Archiv is a newly launched app that lets users photograph mundane items—fire hydrants, furniture, food—and automatically arranges them into a stylized, gallery-like personal catalog. The tool blends photography and organization, giving users a portable, aesthetically curated record of objects they encounter.