Comment Why database abstraction can be a good thing (Score 1) 452
Two reasons why we use a database abstraction in my open source project.
1. We offer support for MySQL, PostgreSQL and Oracle in the product. People want to run it on those databases, and with an abstraction layer we can provide support for them. If you don't abstract out the database, then you're going to have a hard time time getting database independence.
2. Writing testable code. With a database abstraction, you can inject a mock database object and use it to exercise your code without having to actually talk to the database.
1. We offer support for MySQL, PostgreSQL and Oracle in the product. People want to run it on those databases, and with an abstraction layer we can provide support for them. If you don't abstract out the database, then you're going to have a hard time time getting database independence.
2. Writing testable code. With a database abstraction, you can inject a mock database object and use it to exercise your code without having to actually talk to the database.
