[DBIx-Class-Devel] [Perl5/DBIx-Class] Stop trying to get last_insert_id() from all the columns (#122)

[Vladimir Melnik]

Hello,

Thank you for your time.

I have tables of temporal (bi-temporal, to more precise) data, so a record's states usually imply multiple rows indicating all the states of each record in time. That's why I decided to make a triple PK (`id` + `known_from` + `valid_from`).

I was too innocent thinking it would be a wise idea to identify a record by a triple of fields only. Actually, I've implemented it in my database, but then I had to make this key unique and consider the `id` field as a single-field PK and added a `XXX_id` (where XXX is the same as the table's name) field to identify the instance. It turned out to be giving some pain in further developments, so I had to fall back to the idea of the single-fielded PK (identifying a row itself).

Anyhow, thank you for your attention. Will be looking forward for more cool news about the project, I'm a big fan and a grateful user of DBIx::Class. :)


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/Perl5/DBIx-Class/pull/122#issuecomment-360228546
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20180124/c3ae7041/attachment.htm>