Problems? Is your data what you think it is? | |
PerlMonks |
Re: [OT] SQL "on duplicate key" custom actionby perlfan (Vicar) |
on Oct 13, 2021 at 01:02 UTC ( [id://11137458]=note: print w/replies, xml ) | Need Help?? |
It depends on what DB, but it's basically the following to "ignore" it,
Some track the attempts, though; using the equivalent to a column named Attempts. But I am not sure how useful that is in practice tbh: > Since I can choose the DB, what is your opinion on MySQL vs. Postgres?
It really depends; frankly I don't do anything these days that even requires a DB server so usually I go with DBD::SQLite. That has it's own things to deal with (forks, etc) but it makes my life a lot easier not to have to maintain DB servers and all that stuff. YMMV based on the application though.
Most relevant from the YMMV link, SQLite does not compete with client/server databases. SQLite competes with fopen().
In Section
Seekers of Perl Wisdom
|
|