Hacker News new | ask | show | jobs
by chousuke 1714 days ago
I think supporting multiple databases is an antipattern for most software (open source or not). Being able to change the database driver does not qualify as support.

If you really do want to support multiple databases, you need to write code with all of them in mind and test with them, not just leave it to users to find all the bugs when they change the DB driver to something no-one else actually uses.

1 comments

I disagree. If you don't need any database-specific funtionality, are OK with the least-common denominator, why not?

I run a large number of open-source software privately. It would be a way smaller number if I couldn't use them with Postgres.

Many users and projects will start on sqlite but as they mature migrate to clustered instances of a hosted database. It's great that this can be supported without each project implementing every DB.

I have been the user hitting a bug (which I was able to submit a fix for) in the scenario you describe. I much prefer that to not using the software at all or setting up a MySQL instance.