Basically, I have developed a PostgreSQL-based application which "in theory" could have its database software swapped out, but probably would cause a million headaches if I actually attempted to. I'm trying to determine if the other SQL database softwares (I frankly don't care about non-SQL ones in the least, because they seem too different for me to bother with them in this life) have the following concepts:
- "handle database" (such as "postgres", which must be used to connect when there is no other database or when certain operations are to be done to the actual database)
- "database name"
I guess I'm fairy sure already about all the points except for the 5th. The concept of a "handle database" seems like it might be PG-only. If such is the case, I'm not sure how I should handle that, but I'm awaiting your answers before I make a decision.
I have a good mind to just forget about ever supporting other database softwares, but the way my system is structured basically forces me to at least try to "genericize" the communication with the database with functions called "database_" rather than "PostgreSQL_". (Even when the queries sent to these functions would only work on PG...)