I see that you defined the `dkim` column as NOT NULL. So what happens when an em... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

dotancohen 22 days ago | parent | context | favorite | on: Gmail to SQLite

I see that you defined the `dkim` column as NOT NULL. So what happens when an email message does not contain the Dkim-Signature header?

hun3 22 days ago | [–]

Probably something like

  Error: stepping, NOT NULL constraint failed: messages.dkim (19)

because, unlike MySQL, SQLite apparently returns SQL NULL for JSON null value.

unsnap_biceps 22 days ago | [–]

As hun3 said, it would throw an error. My mistake in the quick example I put together. I just noticed an unbalanced () as well. Whoops.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact