Developer builds LuaDB, a pure Lua relational database engine with B+Tree indexing

·1 views

A developer has released LuaDB, a fully embeddable relational database management system written entirely in pure Lua without any C extensions or external dependencies. The project was built from scratch and features slotted 4KB binary pages along with B+Tree-based primary and secondary indexing. LuaDB also implements a Write-Ahead Log (WAL) for data durability and supports the Postgres wire protocol for compatibility. The source code has been published publicly on GitHub under the username jncastilho.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Node.js Pattern: Use Cron as Trigger and Durable Queue for Background Jobs

A software engineering pattern recommends separating job scheduling from job execution by using a cron trigger to enqueue a small, idempotent job record, while dedicated queue workers handle the actual long-running work. The key principle is that a scheduler should only determine when a job becomes eligible, not manage its entire execution lifetime. Each scheduled occurrence is treated as a unique data record using a stable idempotency key, ensuring that duplicate trigger runs refer to the same logical job and only one execution proceeds. A lease mechanism further prevents duplicate processing by workers claiming jobs for a defined time window. The article includes a Go-based interface-driven code example to illustrate the protocol, noting the same envelope-and-claim approach applies equally to Node.js services.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why Moving a Monitor Across a Room Cut Incident Recovery Time by 40%

A software team spent three weeks building thousands of lines of observability code to track API performance, yet users consistently detected outages before the engineering team did. A newly hired operations engineer resolved this not by writing code, but by relocating the monitoring dashboard to the customer support office, reducing mean time to recovery by 40%. The anecdote is used to argue that the tech industry's fixation on code output metrics — such as lines written or commit counts — obscures technology's core purpose: solving real problems. The author contends that equating technical skill solely with coding is a cultural and educational bias, comparable to measuring a writer's quality by typing speed. To illustrate the point further, the author describes bypassing an AI model's safety mechanisms entirely through structured natural-language dialogue, with zero lines of code written.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Non-Coder PM Grows API Gateway from $30 to $8,880 Monthly Revenue in Six Months

A product manager with no coding ability built an AI model aggregator called apimodels.app entirely using AI coding agents, growing monthly revenue from $30 to $8,880 across six months. The platform now handles nearly 300,000 API calls per month, offering a single OpenAI-compatible key for 182 AI models covering text, image, video, and audio. The founder attributes the growth to two core priorities: competitive pricing and system reliability, deliberately avoiding paid advertising throughout. A key early lesson involved dropping a suspiciously cheap upstream video provider whose requests returned no errors but quietly delivered degraded output, silently killing user retention. The business now operates on a strict policy of using only official model channels, defining 'cheap' as the lowest verified-quality price rather than the lowest possible cost.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Degrade or fail fast? The answer depends on whether the error is reversible

A software engineering analysis examines how distributed systems with multiple interdependent services should handle partial failures. The core principle proposed is that services should degrade gracefully only when a wrong guess is reversible, such as serving a stale product catalog, while services must fail fast when errors can cause irreversible harm, like overselling inventory. Using a six-service e-commerce pipeline as a case study, the author argues that a single universal failure policy applied across all services is fundamentally flawed. For example, inventory checks must refuse requests outright during downtime to prevent overselling, whereas a settlement service can safely queue events and catch up later without affecting the buyer experience. The framework centers not on service importance but on whether the business can recover from acting on incorrect or missing data.

0 comments Read more at DEV Community