It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
I wrote about this recently! There's no hard and fast rule -- the problem with erring on the small side is obvious, but if it's too big you waste space which has further effects on how hard the database server has to work. And of course actual values for 'too big' and 'too small' depend entirely on the column itself.
I wrote about this recently! There's no hard and fast rule -- the problem with erring on the small side is obvious, but if it's too big you waste space which has further effects on how hard the database server has to work. And of course actual values for 'too big' and 'too small' depend entirely on the column itself.
So, there is
TEXT
type in Postgres (and obviously SQLite), with not only no size limit, but also better performance as well!