DEV Community

Discussion on: What database do you use at work?

Collapse
 
_garybell profile image
Gary Bell

There's a few dotted around in some odd applications. We have:

  • MySQL
  • MariaDB
  • Redis
  • Microsoft SQL Server
  • Access

I only support the MySQL, MariaDB, and Redis applications; but I have a project (starting next year) to migrate the applications on Access to something slightly more sensible.

Collapse
 
bretthancox profile image
bretthancox

Access is like mold; once it's in, you have to work hard to get it out. If you give people Access they will turn it into business-critical functionality, but without the support and testing necessary. The worst part is the inevitable "Why aren't you supporting this?"

Collapse
 
_garybell profile image
Gary Bell

The team who implemented it are very aware that it's not supported by IT, as are the directors. I work for a very understanding company in that respect. Any issues with that database are their own.

The team who implemented and manage that one are also the ones driving a build into a standard company platform. Mainly so their full team can use it at the same time. They have the business rules documented, as well as their processes, so they are well placed to help and test a properly built version.

Again, I'm really lucky with the business I work for.