Hacker News Reader

Comment by julianozen | Hacker News Reader

SELECT * FROM Children WHERE naughty=false;

Little Bobby Tables isn't getting anything for Christmas this year.

Or everything, I guess it depends on how the implementation handles failure conditions.

as you seem to have some inside information can you share some details about the database schema: is naughty field not null or nullable? what about indexing a table on a boolean column?

Niceness is an ENUM

  'not known',
  'nice',
  'naughty',
  'nasty'

Additionally, the nice list is a bitemporal table, and CheckStatus is also an ENUM ( 'nunce', 'once', 'twice', 'more' ). Foreign keys go to the Person and Elf tables.

He's making a database

He's sorting it twice

SELECT * from contacts WHERE

behavior = 'nice'

SQL Clause is coming to town

(Saw it on Facebook, I don't know the source.)

Here is the source: https://twitter.com/KarenMN/status/677111492135661569

Nice try, but everyone knows that Santa keeps his database in 6NF.

Reply on news.ycombinator.com