Re:SQLite is all you need for durable workflows
by pseudalopex on Friday May 29, 2026 @05:54PM
(#48329817)
This could enforce dates are strings. They wanted to enforce dates are dates I thought.
[ Parent
| on HN ]
Re:SQLite is all you need for durable workflows
by simonw on Friday May 29, 2026 @06:29PM
(#48330162)
create table events (
id integer primary key,
name text not null,
event_date text not null check (
-- YYYY-MM-DD
event_date glob '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]'
and date(event_date) is not null
and date(event_date) = event_date
)
);
In Python that raises this error if the date is invalid: sqlite3.IntegrityError: CHECK constraint failed:
event_date glob '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]'
Re:SQLite is all you need for durable workflows
by pseudalopex on Friday May 29, 2026 @08:27PM
(#48331084)
I see. The strict tables page did not mention the date and time functions.
Python would show the 1st line always? Or the failed part?
This is unreasonable for a very common type I think.