: (
2026-05-10 18:50 UTC
Replies (6)
-
@Hadriscus@jlai.lu 2026-05-10 18:59
What do you use instead of booleans ? floats ?
-
@TootSweet@lemmy.world 2026-05-10 20:02
create table boolean ( id integer primary key, name text not null unique ) insert into boolean (name) values ('true'); insert into boolean (name) values ('false'); create table document ( id integer primary key, name text not null unique, body text not null, is_archived not null integer, foreign key (is_archived) references boolean (id) on delete cascade on update no action ); Solved. Bonus: DBAs hate this one weird trick that can free up incredible amounts of disk space by deleting just two rows.
-
@RustyNova@lemmy.world 2026-05-10 19:03
I think you got the wrong caption. It’s the world if SQLite supported multiple concurent writes. Stupid transaction deadlocks…
-
@lambisio@feddit.cl 2026-05-10 22:56
I can live without Booleans I think… what saddens me more than nothing else is the lack of more proper treatment for Decimal-like types.
-
@altphoto@lemmy.today 2026-05-11 07:36
But that’s IFF.
-
@dalakkin@lemmy.world 2026-05-10 22:00
If it just supported sorting by random with a seed..