ADVANTAGES AND DISADVANTAGES OF USING MYSQL

MYSQL

MySQL is free and open source software under the terms of the GNU General Public Liconsored by Swedish company MySQL AB, which was acquired by Sun Micro systems.
MySQL is used by many popular Website Design Company in Bangalore .Here some of the Advantages of using MYSQL

ADVANTAGES OF USING  MYSQL

It's easy to use

MySQL is very easy to install, and thanks to third party tools that can be added to the database, setting up the implementation is a relatively simple task. In addition, it is the easiest database to work with. Until you understand the language, you should not get into many problems.

Open Source (Sort)

The acquisition of Oracle Sun Microsystems (and by association, MySQL) has met with some controversy from the development community. The common fear is that Oracle will turn the tool into a closed, proprietary ecosystem. Fortunately, although Oracle has somewhat tightened its grip on MySQL, it can still be considered an open source database option, as the code is still available online for free.

Portable

MySQL stored procedures are small, because when we write our stored procedure in SQL, we know that it runs on every site that MySQL runs on, the operating system without forcing an additional runtime-environment package or setting the permissions to run the program.



DISADVANTAGES OF USING MYSQL


 Increased memory usage

If we use multiple stored procedures, the memory usage of each connection using stored procedures will increase significantly.

Difficult to maintain 

Creating and maintaining stored procedures is not easy. Creating and maintaining stored procedures often requires a specialized skill set that is not available to all application developers. This can lead to problems in both the application development and maintenance phases.

 The default package in MySQL is case-insensitive

This is not an issue, but I think this strange default is an indication that it is aimed at entertainment-developers rather than professionals. This is a big assumption, but I think any professional would compare a database by default to strings for identification (i.e. using binary compilation).

 Handling tables during transactions causes indirect commits.

While this may not seem sad at first glance, you will notice that if changing / creating tables is an intrinsic part of your application, you cannot work under ACID conditions.
Website Development Company in Bangalore

Comments

Post a Comment

Popular posts from this blog

W3 CSS vs BOOTSTRAP WHICH FRAMEWORK IS BEST?

W3 CSS W3.CSS is a modern CSS framework with built-in response,which is widely used in Website Development Company in Bangalore   It supports a mobile-first format that is responsive by default, and is smaller and faster than a similar CSS framework. Uses only standard CSS (no jQuery or JavaScript library). Accelerates and facilitates web development. By default it supports modern responsive design (mobile first). Provides CSS equality for all browsers. Features : Smaller and faster than other CSS framework. It is easy to learn and easy to use than any other CSS framework. Uses only standard CSS (no jQuery or JavaScript library). Accelerates mobile HTML applications. Bootstrap Bootstrap is the most popular HTML, CSS and Javascript framework for building responsive, mobile first websites. With Bootstrap, a Website Design Company in Bangalore can access built-in layouts, text and image formatting, colors, themes, buttons, and menus. . User interfaces are simple to ...
Read more

WHAT IS SSL AND PURPOSE OF USING SSL CERTIFICATES IN WEBSITES

What is SSL? SSL creates associate degree encrypted association between your internet server and your visitors applications program Why Do I Need SSL? SSL helps to prevent intrusive entities such as attackers or ISPs from damaging the data sent between your websites and your users' browsers. This is important in protecting sensitive information, such as credit card numbers, but it also protects your site from malware and prevents others from injecting ads into your sources. here are the reason why many Website Devolpment Company in Bangalore suggesting SSL certificates while developing websites for thier clients. The Purpose of Using SSL Certificates 1. SSL Encrypts Important Information The primary reason for using SSL is to encrypt important information transmitted over the Internet so that it is only accessible to the intended recipient. This is important because the information you send over the Internet is transmitted from computer to computer to get to...
Read more

ADVANDAGE AND DISADVANDAGE OF RUBY ON RAILS FRAMEWORK IN WEB DEVELOPMENT

What is Ruby on Rails? Rails is a development tool that provides web developers with a framework for all the code they write. Rails Framework helps many Website Development Company in Bangalore to create websites and applications because it makes it easy to narrow down common repetitive tasks.Another characteristic of Rails is that the stress on relaxing application style.REST (Representative State Transfer) is a style of software architecture based on the client-server relationship. This promotes a logical framework within applications, which means they can easily be expressed as an API (application programming interface). Advantages of Ruby on Rails 1.Rails has a strong focus on testing and has a good test framework. 2.The Ruby code is very readable and often self-documenting. This reduces the need for writing separate documents, increases productivity, and makes it easier for other developers to take on existing projects 3.Rails traditions make it easier for ...
Read more