Hacker News new | ask | show | jobs
by parenthesis 6083 days ago
SQLite is: http://www.sqlite.org/datatype3.html
2 comments

Hey, is there anyone out there that uses SQLite and actually uses it's "duck typing" feature to some effect?

I'm using it, but I still declare my "column affinity" and store values with the proper types. I don't put strings in my number columns, for example. I can't even imagine a good reason for that.

And it's a fantastic free (public domain licensing anyone?) embedded dB with readily available support and custom dev services at the end of the phone.