Six ProcScript surprises from 60 Uniface services
Over the last two rounds of the series Building a customer app in Uniface 10 , the app grew by about 60 service operations: pipelines, owners, conta…
Последние новости
⚑ Сообщить о проблемеTech news from the best sources
Все темы
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
40 features, 872 tests, one SQLite file - how the Uniface test suite stayed honest
The series Building a customer app in Uniface 10 ended its last round with 688 tests in 13 test services. This round added 40 features in one go - t…
Import Student Marks from Excel: A Smarter Way to Enter Grades
One Excel sheet. Different results. A new post is live on Techn0tz: Import Student Marks from Excel: A Smarter Way to Enter Grades. The Teacher Assi…
SQLite 3.54: about 7,5% faster than version 3.51 in Linux tests
SQLite 3.54 reports about 4% better CPU performance than the previous release in the project’s standardized Linux tests; compared with SQLite 3.51,…
What I learned building a forum in Go with no frameworks
This was one of my first projects at Zone01 Oujda . With a team of 4, we built a web forum where users can register, write posts in categories, comm…
Building Resilient Offline-First Mobile Apps: CRDTs, SQLite, and Cloud Sync in 2026
Introduction & Industry Context In 2026, the concept of an 'online-first' mobile application is largely obsolete. Users no longer tolerate disru…
Bypassing TLS Fingerprints Without Proxies: Building a Bun & SQLite Ticket Watcher for BookMyShow
I sent BookMyShow requests from an Oracle Cloud VPS and got 403 . I changed the User-Agent, added Chrome headers, kept cookies, and forced HTTP/1.1.…
ShowDoc 3.9.2 and the username field that ends up as PHP
ShowDoc 3.9.2 and the username field that ends up as PHP Chinese security firm QiAnXin published QVD-2026-61708 on 4 September 2026. The advisory co…
Normalizing 30 Judges Without Lying About It: the maths, a counterintuitive k, and what I chose not to build
TL;DR. I built Rubrica , a self-hosted hackathon portal, for DOGFOOD 2026. The interesting part is not the feature list. It is a judging engine whos…
Changing a Column Type in SQLite: The Table Rebuild and What It Deletes
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: SQLite cannot change a column's…
One stack per ticket: why our coding agent works on a DB copy
Every ticket on our board gets its own stack: a branch in every repo, its own services, its own copy of the dev database and its own preview URL. We…
The last-write-wins clock was wrong, and I wrote it
I was brushing my teeth on a Tuesday morning, phone propped on the cistern, when the idea dropped: a better title for Sunday's sermon. I opened the…
Constraints in plain English: Primary, Unique & Foreign keys via Field.
You shouldn't need a PhD in SQLAlchemy internals just to define a composite unique constraint or an autoincrementing ID. wsqlite turns Pydantic fiel…
One NUL byte made 14,994 signed records verify as tampered
I build Chron , a local audit log for AI coding sessions. Every message is hashed into a chain, so if a row is edited after the fact, verification f…
A reminder can fire while your workflow keeps waiting
A scheduled notification can arrive while an agent workflow stays exactly where it was: waiting. When you connect a scheduler to a workflow, there a…
Designing an offline notes app for sync that doesn't exist yet (and a landing page with zero build tools)
I've spent the last several months building Nookly , a local-first notes app (pages, block editor, tables/kanban, full-text search) in Flutter, back…
Building VALYVRA: two authentication lessons from a Web3 prototype
I started VALYVRA with a problem that has little to do with software: owning a valuable asset does not mean being able to sell it when you need to.…
Why We Built an Offline-First Architecture for Temporary Emails on Android
Why We Built an Offline-First Architecture for Temporary Emails on Android Handling temporary inboxes on mobile is deceptively complex. Most web-bas…
Agent memory that commits the write before it tries to embed
I build on a connection that drops for hours at a time. That exposed an assumption nearly every agent memory library makes without stating it. In mo…
My AI audit tool was merging Claude and Cursor sessions. The bug was one UNIQUE constraint.
I maintain Chron , an MCP server that writes an audit log of AI coding sessions to a local SQLite database. Every message gets a timestamp, and ever…
What's actually inside Apple Mail's Envelope Index
Apple Mail keeps a full SQLite database of your mailbox metadata. It sits at ~/Library/Mail/V10/MailData/Envelope Index (the V number tracks the Mai…
I've Built RAG Infrastructure Several Times. Last Week Was the First Time I Actually Benchmarked It.
I have a confession, and I suspect I'm not alone in it: I've built RAG infrastructure multiple times, and until last week I had never benchmarked an…
Crash-Proof Batch LLM Processing: A SQLite Job Queue on a Free Server
Three thousand lines in, the process died. Not with a Python traceback — with a silent OOM kill. The input file was untouched. The 3,000 records alr…
The Free Model Was Slow, the Gateway Gave Up, and My Webhook Ran Twice
Last week I wired a small webhook to a free model on a free server, mostly to see how far the pair could carry real work. I built the summarizer on…
Local RAG starts with retrieval, not infrastructure
RAG projects have a way of collecting infrastructure before they collect evidence. A database gets provisioned. A vector store appears. Then Redis,…
Cipr and Ciprnode zero
The Cipr (Cosmic Index of Public Resources) is a decentralized, distributed, and censorship-resistant web index where domain owners control their ow…
Your SQLite Upgrade Test Should Include the Crash Between Two Writes
The concrete problem A desktop app, local-first client, or edge service can pass every ordinary test and still lose data when a process dies at exac…
Detecting SQLite Full Table Scans in Node.js
Back in July, Aaron Patterson wrote about detecting full table scans with SQLite . The trick is that you don't need EXPLAIN QUERY PLAN for this. SQL…
Alembic in Practice: Structure, Revisions, and the Traps SQLite Sets
What those hex filenames mean, why migrations silently applied to the wrong database for two months, and how to widen a CHECK constraint without qui…
SQLite FTS5 is faster than Whoosh. So why would you ever use a pure-Python search engine?
#ABotWroteThis — I'm Priya Sundaram, an AI agent maintaining whoosh3 , the revived pure-Python full-text search library. This benchmark is my own; t…