PostgreSQL and Oracle...
I've been working on updating the CFDatabaseBase classes. My main concern this week was getting Postgre and Oracle up and running.
More after the jump...
Postgre was an easy one. The API is really straight forward and nice to use. The only reason it's not out yet is that on windows, I'm having a hard time getting the dll's to be included in the plugin and not have the user keep them next to the app or in some place windows searches for dll's. I'm starting to think that i need to dive into the source code and compile the client libs right into the plugin. I don't really want to do that. PostgreSQL is a really large beast and the code is not that friendly when it gets separated from it's family. I'll see what i can do. I know RealSoftware rewrote the whole thing...
Oracle is a completely different story. The libraries are fairly easy to use, at least the instant client libraries are easy to use. Still, i have the same problem as with Postgre, but this time xplat. The libs are dynamic, thus i cannot compile them into the plugin. And this time, there is no source available. So we are probably going to be stuck with the libraries following the applications. On the mac i don't really mind, you can just put them in the frameworks folder, not much of a hassle. On windows, they'll just be hanging around wherever you put them, hopefully, your app will load them up successfully.
Any suggestions on the oracle implementation are wanted, needed, welcome!
Now I have a question for you. What other databases would you like to be implemented in the CFDatabasePlugin?
More after the jump...
Postgre was an easy one. The API is really straight forward and nice to use. The only reason it's not out yet is that on windows, I'm having a hard time getting the dll's to be included in the plugin and not have the user keep them next to the app or in some place windows searches for dll's. I'm starting to think that i need to dive into the source code and compile the client libs right into the plugin. I don't really want to do that. PostgreSQL is a really large beast and the code is not that friendly when it gets separated from it's family. I'll see what i can do. I know RealSoftware rewrote the whole thing...
Oracle is a completely different story. The libraries are fairly easy to use, at least the instant client libraries are easy to use. Still, i have the same problem as with Postgre, but this time xplat. The libs are dynamic, thus i cannot compile them into the plugin. And this time, there is no source available. So we are probably going to be stuck with the libraries following the applications. On the mac i don't really mind, you can just put them in the frameworks folder, not much of a hassle. On windows, they'll just be hanging around wherever you put them, hopefully, your app will load them up successfully.
Any suggestions on the oracle implementation are wanted, needed, welcome!
Now I have a question for you. What other databases would you like to be implemented in the CFDatabasePlugin?
Comments
No comments yet
Add Comment