Multiple databases and complex queries
The program I am looking to create will use a PHP front end to create, read, update, and delete from multiple databases. The context is a medical practice management program that is web based.
Not only is the ability to create these databases important (e.g. a client information DB including info like name, address, phone number, etc) but also I would like to retain the ability to search using any and all parameters when trying to look up a client. It's also worth mentioning that there will be multiple user created databases such as a client database, a patient database, inventory and charge code database, among others.
My questions to you all are:
Is SQL the right choice for this application?
If so, what would be the most efficient and best performing way to structure such a database?
Any other thoughts?