Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Support for multiple SQL implementations

Name: Anonymous 2008-06-08 13:57

so if you're writing a piece of software which you want to be able to handle communication with databases on multiple sql implementations, what method would you use?

i've been thinking about two so far and not sure which one to pick, or if there are more, basically to either write ansi sql code or whatever, not use any implementation specific special features so my sql queries work with a sql function wrapper and always execute properly

the method i'm leaning more towards right now is to keep ALL sql queries stored in a file, configuration, and have different queries and database schemes for the implementations i'd like to support

i like the second method even though it's more work, because i only want support for the biggest ones, like mysql, postgres and maybe mssql, and i don't even know that much about mssql so i could prolly reuse some of the mysql queries by setting it as a default, or postgres, so if a query doesn't exist in the mssql set, it uses the corresponding mysql query

Name: Anonymous 2008-06-09 6:18

>>3
i don't want to use a prebuilt wrapper because i'm getting paid a lot of money for this and i plan to resell it, would be bad if at some point a client says "hey but this is code you just took from this other project"

also i don't see a problem in writing this myself because it's just php so it's a breeze

so basically the best suggestion i get here is to use standard sql, which goes against me first choice so now i have some serious pondering to do, thanks for the help jerks

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List