adding a record only if it doesn't already exist

[rebred]

I'd like to add a name to the DB only if it's not already in the DB

if the record is already in the DB I'd like to answer 'sorry the record already existexists'

CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL
);
INSERT INTO users (name)
SELECT :name WHERE :name IS NOT NULL;
SELECT name AS title FROM users;
SELECT 'form' AS component, 'Add name:' AS title;
SELECT 'name' AS name, TRUE AS required;

[lovasoa]

You can use sql conflict handling primitives. For instance in postgres:

• https://www.postgresql.org/docs/current/sql-insert.html#SQL-ON-CONFLICT