Re^2: Perl DBI and Foreign Keys

in reply to Re: Perl DBI and Foreign Keys
in thread Perl DBI and Foreign Keys

Thanks!
I wanted to hear from somebody who had used this function.
My target DB's are MySQL and SQLite. If I have code that works with both of those DB's, I'm fine.
It appears that last_insert_id will work with both of these DB's.

I did consider the write, then read back to get the auto id, but that is rather goofy sounding and may not be possible in certain situations.

I'm starting a new project using SQlite. The DB access is just a tiny part, but an important part.

Comment on Re^2: Perl DBI and Foreign Keys

Replies are listed 'Best First'.
Re^3: Perl DBI and Foreign Keys by hdb (Monsignor) on Apr 08, 2019 at 12:30 UTC
And if you do not like last_insert_id, you can always build an index generator yourself, like `max( index_column ) + 1`.	[reply] [d/l]
Re^4: Perl DBI and Foreign Keys by Marshall (Canon) on Apr 08, 2019 at 12:45 UTC
I don't think that would work as a substitute for last_insert_id due to race conditions with multiple writers. I can read a table. Calculate the number of rows. And wind up with a different number of rows than you read doing the same thing if somebody else inserted a row during this process.	[reply]
Re^5: Perl DBI and Foreign Keys by soonix (Canon) on Apr 08, 2019 at 12:55 UTC
what if it's wrapped within a transaction?	[reply]
Re^6: Perl DBI and Foreign Keys by afoken (Chancellor) on Apr 09, 2019 at 23:24 UTC
Re^3: Perl DBI and Foreign Keys by dsheroh (Monsignor) on Apr 09, 2019 at 07:29 UTC
I wanted to hear from somebody who had used this function. My target DB's are MySQL and SQLite. In that case, since it wasn't explicitly stated before: I have personally used `last_insert_id` with both MySQL and SQLite.	[reply] [d/l]
Re^3: Perl DBI and Foreign Keys by afoken (Chancellor) on Apr 09, 2019 at 18:37 UTC
See also ~~Re: SELECT LAST_INSERT_ID does not work~~ SELECT LAST_INSERT_ID does not work. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]

In Section Seekers of Perl Wisdom