News for hackers. Stuff that matters.
Re:Ask HN: Excel vs SQL by keecham on Friday January 13, 2012 @12:39PM (#3461491)
Thank you for your input.

In terms of database normalization, doesn't that usually require redundancy (repeated columns / records)? We have that once over two columns, but otherwise there are no repeats - each entry is unique.

Pardon my ignorance, not much experience with database software as is clearly evident haha.

Re:Ask HN: Excel vs SQL by swasheck on Friday January 13, 2012 @12:45PM (#3461521)
Well, existing redundancy is an indicator that a structure can be normalized right now. I guess the way I conceptualize normalization is that it reduces the possibility of storing redundant data now, or in the future.

Not saying that it is 100% effective and fool-proof ... just the ideal.

BTW, here is the php manual entry for sqlite http://php.net/manual/en/book.sqlite.php