Concurrent Access and Databases.
Without going into details I'm doing a project which involves a client program which makes requests to a server program that is listening for TCP requests. After the server parses the request, it spawns a service thread which obtains a lock on a data structure held in the server program. When the data is altered in that structure, then it adds or removes the corresponding data in the server via SQL queries.
From what I understand it is a safe way to modify the data on the server when multiple clients request a change, but what I wnat to know is do databases inherently have a method to handle concurrent queries to change data? Say if I got rid of the server/service thread portion which models the data in the database, and just had the clients performing queries concurrently, would the database be able to handle it?
I'm not going to actually use it this way because the data modeled in the server program is necessary for the actual implementation of the system, but I was just curious to see what the limits of a database are.