Skip to content
Better HN
Top
Best
Ask
Show
New
Jobs
Search
⌘K
0 points
atemerev
9y ago
0 comments
Save
Share
No more than DELETE FROM ... WHERE ... wait, where is WHERE?
0 comments
2 comments · 2 top-level
top
newest
oldest
philsnow
9y ago
Even this can be made safe(r) if you only only only connect to your database nthrough a proxy that sanitizes queries. IIRC vitess adds an implicit LIMIT 10 to queries that don't have a limit.
cdmckay
9y ago
A simple solution is to not allow UPDATE or DELETE statements without a WHERE clause.
j
/
k
navigate · click thread line to collapse