Database Chart
|
MySQL |
PostgreSQL |
Access |
|
| Details | The most widely used database management system. It is well suited for mission-critical systems and embedding into mass deployed software. | An object-relational database system with many advanced features found in commercial products. | A popular database management system used to create and maintain various applications that function on the Windows operating system. |
| Advantages | -fast and efficient -very scalable -includes multi-user functions |
– plenty of support – stable and reliable – cross platform |
– reliable support – integrates with several Microsoft products – capable of porting to other database types |
| Disadvantages | – lacks sub-selects – lacks foreign key constraints – lacks stored procedures |
– limited in stored procedures – lacks foreign key constraints |
– doesn’t work well with multiple users – doesn’t work well with multiple Access databases – hosting may be more expensive |
| This type of Database is for you if… | Your business requires a heavy load but you do not have a lot of money to invest into it. | Your business consists of multiple users handling mission-critical tasks. | Your business requires a powerful database that’s as easy to use as a Microsoft Office application. |
| Our recommendation | LunarPages | HostMonster | Omnis |
| « DreamHost Reviews | Nexx Web Hosting Reviews » |
: 
: 
Loading ...
Thank you for the information provided. I have to clear my doubt here. Most of the people use MySql and PostgreSQL. They both have some disadvantages in the stored linked procedures. But Access does not have any disadvantage mentioned here like this. Does that mean Access is far more efficient than the two?
Report This
Was this review helpful to you? :
0 
0