You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Issuing .schema from the sqlite prompt immediately spoils the answer by showing the trigger logic.
SQLite does not seem to have a portable hash function, but the answer could at least be obfuscated against accidental viewing using hex(); i.e. change the trigger condition to
CASE WHEN hex(new.value) = '4A657....
The text was updated successfully, but these errors were encountered:
Issuing
.schema
from the sqlite prompt immediately spoils the answer by showing the trigger logic.SQLite does not seem to have a portable hash function, but the answer could at least be obfuscated against accidental viewing using
hex()
; i.e. change the trigger condition toThe text was updated successfully, but these errors were encountered: