To put it simply, you can't rely on the Last Insert ID with SQLite3 the way you can with MySQL.
Rather than rewrite everything in a more laborious way, I switched back to MySQL.
#Database #Programming #Webdev #Coding #MySQL #SQLite
Negative12DollarBill on Nostr: Oof. This really bit me on a project I'm working on. I thought I would seamlessly ...
Oof. This really bit me on a project I'm working on. I thought I would seamlessly switch over databases in a few minutes.
To put it simply, you can't rely on the Last Insert ID with SQLite3 the way you can with MySQL.
Rather than rewrite everything in a more laborious way, I switched back to MySQL.
#Database #Programming #Webdev #Coding #MySQL #SQLite
To put it simply, you can't rely on the Last Insert ID with SQLite3 the way you can with MySQL.
Rather than rewrite everything in a more laborious way, I switched back to MySQL.
#Database #Programming #Webdev #Coding #MySQL #SQLite