Silly question, but I'm paranoid and unable to test this while working from home. Multiple computers running the same program. Is there going to be an issue/race condition problems with the DB open connections and close connections running at the same time?
Solved! Go to Solution.
A "good" data base will handle that for you. You will want to have good error handling in your program.
This is generally only an issue with a file based database like MS Access or SQLite. I haven't actually done this, so I can't comment directly, but theoretically server-based databases like MS SQL should handle concurrent connections with no problem.
By the way, DB tools kit,is only for sql server ?
For mysql, which tools we should use ?