6 ms·
The usage of a timestamp (stored as a TEXT column!) as a primary key sets off every single alarm bell I have in my head. This is a shockingly poor decision, and
by dpratt 6y ago
The usage of a timestamp (stored as a TEXT column!) as a primary key sets off every single alarm bell I have in my head. This is a shockingly poor decision, and a terrible way to enforce semantic uniqueness.
- jacques_chester 6y agoYou needn't worry, friend, you can just ON CONFLICT DO NOTHING. That's how financial records are meant to be kept, I believe.