qwertydog

5 ms·

1. 1.▲
   by qwertydog 6mo ago

   Great post - thanks. I think the columns in the index you suggested in the pre-pg12 section are in the wrong order (that index would get used)
2. 2.▲
   by qwertydog 2y ago

   SQL NULL is also coerced to different boolean values depending on context e.g. in a WHERE clause NULL is coerced to false, whereas in a CHECK constraint NULL is coerced to true https://dbfiddle.uk/C5JqMP8O
3. 3.▲
   by qwertydog 2y ago

   Just saw this. I see you've already pushed a fix on GitHub thanks. I can't see object ID's being included in the script, so I assume multiple objects with similar names will all be treated as the "same" object e.g.
4. 4.▲
   by qwertydog 2y ago

   Ah sorry my bad, I should have read the full script. The script fails though if object names contain double quotes e.g. https://dbfiddle.uk/y-C6Da07
5. 5.▲
   by qwertydog 2y ago

   Just checked out the MS SQL script. I believe it's vulnerable to SQL injection via table/column/view/index/schema names (however unlikely that may be). You might want a disclaimer not to run the script with object n
6. 6.▲
   by qwertydog 7y ago

   I think the main issue is the play store is off limits i.e. no existing android apps