Writing SQL Drivers in Hare

A developer built SQL driver modules for the Hare programming language, modeling the design on Go's database/sql package. The hare-sql module defines a vtable-based interface, while hare-sqlite wraps SQLite's C bindings and hare-postgresql implements the PostgreSQL wire protocol directly over TCP, including SCRAM-SHA-256, MD5 and PBKDF2 authentication, with MD5 and PBKDF2 hand-rolled since Hare's crypto library lacks them. A driver registry was removed because two drivers didn't justify it and it forced heap allocation. Errors use errors::opaque_ to preserve driver-specific codes like PostgreSQL's SQLSTATE without a shared string type. A bug was found in net::uri, which fails to parse a password in a URI's userinfo unless the colon is percent-encoded.

Nguồn: https://blainsmith.com/articles/writing-sql-drivers-in-hare. 8 Sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.

Đề xuất cho bạn

SSP Blog2 Hot20 phút6 giờ trước

Typed Graphs, Checked Types: Graph as Code for Agentic Engineering and Data Quality

Agents write faster than humans can review. Typed graphs check every write, checked queries validate every question, and branches keep the human where true is decided.

#architecture#sql#ai-codingNguồn

Hacker News1 Hot6 phút4 giờ trước

Ultorg: The User Interface for Relational Databases

Ultorg is an efficient, spreadsheet-like user interface for relational databases. Query and edit data across tables and relationships, without SQL.

#sql#postgresql#nocodeNguồn

Noted1 Hot4 phút3 giờ trước

Anchor: A Self-Hosted Note-Taking App That Works Offline

Anchor is a self-hosted notes app with offline editing, mobile apps, automatic syncing, note sharing, and Docker support.

#docker#postgresql#self-hostingNguồn

Kogan.com0 Hot10 phút17 giờ trước

Eventually Consistent: How Do We Know the Systems Eventually Agree?

Event-driven systems only agree eventually. Here’s how we check they actually got there: deadlines, data ownership, and a reconciliation job that walks the floor.

#architecture#postgresql#distributed-systemsNguồn

Hacker News69 Hot1 phút8 ngày trước

OccupySaaS

OccupySaaS is a protest movement in code: laid-off developers building clean-room, open-source, drop-in replacements for the SaaS giants. First up: ZeroAuthy (Auth0) and SalesCompel (Salesforce).

#open-source#go#postgresqlNguồn

Planet PostgreSQL4 Hot15 phút1 ngày trước

json vs jsonb in PostgreSQL: size and speed, measured

json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN, and what it changes.

#database#postgresqlNguồn

Milan Jovanović13 Hot10 phút3 ngày trước

Outbox Pattern in .NET With Postgres: Concurrent Workers vs the WAL

An API can save an order and crash before publishing the message that tells other services about it.

#.net#postgresql#distributed-systemsNguồn

RUBYLAND0 Hot3 phút1 ngày trước

A database per git worktree that barely uses any disk space

Postgres 18’s new file_copy_method = clone setting lets you give every git worktree its own copy of your database in seconds, without eating up your disk.

#linux#postgresqlNguồn