Consider using a trigger for timestamps

luckyframework / avram

A Crystal database wrapper for reading, writing, and migrating Postgres databases.

https://luckyframework.github.io/avram/

MIT License

164 stars 64 forks source link

Consider using a trigger for timestamps #337

Open paulcsmith opened 4 years ago

paulcsmith commented 4 years ago

https://x-team.com/blog/automatic-timestamps-with-postgresql/

bdtomlin commented 4 years ago

I like it! One of the great things about being committed to PostgreSQL is the ability to do stuff like this.

paulcsmith commented 4 years ago

Agreed!! This is really why I don't think Avram will ever support other databases. Too many goodies in PG and I don't want to be slowed down with figuring out multiple ways to do everything.

I'd like to document how to use other ORMs if you really need mysql or something (legacy databases, corp reqs, etc.) but for now though just PG seems to be a good way to go!