MariaDB Platform vs. Microsoft Access

Our installation scenario is a MariaDB cluster composed of 3 nodes to achieve high availability in the service and in this way the application that accesses the backend (MariaDB) is always working and is not down at any time.

To achieve high performance of the application when accessing the database, a MariaDB MaxScale has been mounted that acts as a proxy for queries to the database.

Incentivized

Microsoft Access can be easily implemented with training. It doesn't require expert level skill for basic reporting functions - but can be scaled to a complex database with sophisticated users. Its appropriate to consider if excel needs to be used to create reports, or if there are data entry needs - with corresponding reports.

Incentivized

• MariaDB does well with PHP or Python (django) in a web environment. Developers are able to work quickly.
• MariaDB is extremely well documented and has a gigantic support community. If you need ask a question on how to do things you can go to many placces online and find answers quickly.
• MariaDB is fast! Queries with tens of thousands of rows are quick.
• MariaDB is highly compatible with Oracle's MySQL. Basically the same thing but more open and with a brighter future.
• With MariaDB it is so easy to import and export data, and backups are a cinch. This saves me so much time as compared to other RDBMS.

Incentivized

• Generates information about department events, services, orders, etc. quickly and in report form.
• Easy to design forms and reports with drag and drop components. You don't need to know coding.
• The ability to link tables and queries to get all the info needed for forms and reports
• Forms and reports are easy to customize and edit.
• Easily report your data grouped and sorted by any field

Incentivized

• Driver Support - Some third party applications use database drivers that cause unexplained slowness with MariaDB. This can be worked around by using the MySQL drivers, but it's not clear what causes the problem in the first place.
• Support - While online communities are helpful in diagnosing problems, there isn't as much professional documentation/support available for MariaDB as some of the other major database options.
• Data Visualization - It would be helpful if there were more built in options for analyzing statistics and generating reports.

Incentivized

• Generally high learning curve for new users. Especially if they are not comfortable with technology.
• Desktop only program; not available in web-format like other O365 products
• Fewer experienced users, means it's a lot of self-teaching and troubleshooting when you run into an issue

Incentivized

I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.

MariaDB is very usable and stable to be used in production settings as an alternative to MySQL. The shortcomings of SQL are present but well understood in the community, and if the decision were to be made again, I would choose MariaDB over MySQL on future projects.

Incentivized

Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.

Incentivized

I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.

Incentivized

Yes, I would recommend MariaDB Platform support because they answer very fast and with detailed information. They also help you with the design of the storage infrastructure, not only with the maintenance problems. On the other hand, this service is a bit expensive.

Incentivized

While I have never contacted Microsoft directly for product support, for some reason there's a real prejudice against MS Access among most IT support professionals. They are usually discouraging when it comes to using MS Access. Most of this is due to their lack of understanding of MS Access and how it can improve one's productivity. If Microsoft invested more resources towards enhancing and promoting the use of MS Access then maybe things would be different.

Incentivized

there is no key idea, since it is easy to implement Microsoft Access

It did not always compete against these technologies. Most of the time, it was complementing these databases for certain use cases to help provide a much more complete database. This makes more users want to use it to explore new solutions that help users. This is our target and how [we] work with MariaDb.

Incentivized

Microsoft Access is used independently of Microsoft's Office suite (also in use) at our company - the usual applications: Word, Excel, Outlook, etc. and does not really overlap. Microsoft Access was selected as a simple, functional inventory database based on ease of data entry, search functionality and avoiding the need for a separate ERP module.

Incentivized

• MariaDB has saved us enormously on licensing compared to our previous DB software vendor.
• In service, it has enabled us (speaking as the internal DB team here) to provide better service to the other teams in the company as well as our customers, with less staff.
• The level of hardware required for adequate performance, in our environment, has been much lower. Those savings have been substantial, above and beyond savings on licensing and DBA staffing levels.

Incentivized

• Microsoft Access is very low in cost as compared to its competitors and provides value for money spent.
• Comes with Office Suite for your whole organization. Easy to install and use.
• Many people had to shift to Windows in order to use those as there is no Mac version.

Incentivized