search

sflpro / notifier

The notifications microservice is an independently deployable component intended for sending various types of notifications.
Apache License 2.0
47 stars 13 forks source link

Extend notification property values column length #147

Open mikron opened 4 years ago

mikron commented 4 years ago

There are situations when the email notification property values are longer than varchar 255, would be nice to have this values extended to the 32k or even biger.

mikron commented 4 years ago

This are the comments from documentation of RDBMses PostgreSQL - In any case, the longest possible character string that can be stored is about 1 GB MySQL - 65,535 So I would suggest to update 65,534

dnavre commented 4 years ago

This are the comments from documentation of RDBMses PostgreSQL - In any case, the longest possible character string that can be stored is about 1 GB MySQL - 65,535 So I would suggest to update 65,534

What if we use different limitations on different databases? The only tricky thing is that when exceeding the limit we'll have to detect the error and raise the correct exception.