SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (id INTEGER PRIMARY KEY, date TEXT, col TEXT);
✓
INSERT INTO TABLENAME (date, col) VALUES
  ('2022-01-01', 'sometext'), 
  ('2022-02-01', 'moretext'); 
✓
SELECT * FROM tablename;


id
date
col


1
2022-01-01
sometext

2
2022-02-01
moretext


CREATE TRIGGER no_more_rows BEFORE INSERT ON tablename
BEGIN
   SELECT RAISE(ABORT, 'No more rows allowed');
END;
✓
CREATE TRIGGER no_updates BEFORE UPDATE ON tablename
BEGIN
  SELECT
    CASE
      WHEN NEW.col IS NOT old.col THEN RAISE(ABORT, 'Update of col is not allowed')
    END;
END;
✓
INSERT INTO tablename (date, col) VALUES
  ('2022-03-01', 'newtext');

{
  "code": "SQLITE_CONSTRAINT_TRIGGER"
}


UPDATE tablename SET col = 'updated text' WHERE id = 1;

{
  "code": "SQLITE_CONSTRAINT_TRIGGER"
}


UPDATE tablename SET date = '2022-04-01' WHERE id = 1;
✓