TECHNOLOGY

MySQL Definition, Functions and Complete MySQL History

Understanding MySQL

Computers are growing so rapidly marked by the many things in this world that are connected to computers. Many new devices have sprung up to support computer performance for the better. There are also so many database management tools today.

Database is a number of data that is processed using special software and packaged neatly on the computer. And one of the tools that can be used to process, store and obtain information on a database is MySQL.

For those of you who are familiar with computers, you must know very well about this tool. But for ordinary people, this tool may be so foreign. For this reason, this time I will discuss the meaning of MySQL, its history and functions plus its advantages and disadvantages.

Understanding MySQL

MySQL is a tool that is used specifically to process SQL (Structured Query Language). SQL is a language used to access relational data rows. The easy way is to access the language in the computer. Because SQL and MySQL are special in nature, only people who are in the IT world are familiar with this language.

If SQL is the language used to access data in the database, then MySQL is a tool or software or tools used to process SQL. SQL is the language, MySQL is the tool. What needs to be understood, MySQl is not the only tool that can process SQL. There are many other tools. Call it Microsoft Access. Both only differ in the way of using and processing the database.

There are several definitions of MySQL that can enrich your knowledge:

  • MySQL is classified as open source software with a General Public License (GPL) license. The GPL is a special license for software for GNU purposes. So it is not wrong if MySQL is widely used in this world. In addition, MySQL is also easy to use.
  • MySQL is a software with a SQL database management system (DBMS) that has the ability to be multithreaded, and multi-user. Even MySQL is able to manage systems with up to 40 databases, which can contain more than 10,000 tables and 500 of them have 7 million rows.
  • Wikipedia defines MySQL as SQL database management system software.

Until now, the owner of the MySQL license is a Swedish commercial company called MySQL Ab. The company was founded by David Axmark, Allan Larsson and Michael “Monty”.

MySQL History

The history of MySQL begins in 1979 when a computer programmer named Michael “Monty” Widenius developed a simple database system which he named UNIREG. At the time this research was conducted Monty was a worker at a company called TcX in Sweden. And it turns out, Monty’s development is getting good results.

In 1994, UNIREG was Used as a Web-Based Application Database

After a long period of development, in 1994 TcX started to develop a web-based application using UNIREG as its database system. Unfortunately, at that time the results were not satisfactory, UNIREG was not suitable to support dynamic databases such as the web.

TcX then tried another alternative by using the mSQL database system (miniSQL). Unfortunately, mSQL doesn’t even support indexing. As a result, mSQL has not very good performance.

Because of these two failures, Monty contacted David Hughes (mSQL programmer) to discuss whether he was interested in developing mSQL in conjunction with UNIREG ISAM to support indexing. Unfortunately, at the time Hughes refused. He wants to develop indexing technology for mSQL version 2.

1995, MySQL Released

From this rejection, TcX, in which there was Monty, developed the concept of a new database system. He developed the UNIREG and mSQL combined database system. So in 1995, a new RDBMS was born which was later named MySQL. Also in 1995, the name TcX no longer existed because it had changed to MySQL AB. AB is the abbreviation for Aktiebolag or the term PT (Limited company) in Sweden.

At the suggestion of David Axmark from Detron HB who is a partner of TcX, he suggested that MySQL be released for free to the public. To support the company’s income, a strategy of selling “support” services is carried out for companies that want to implement MySQL.

MySQL Functions

For those who are used to using SQL, they know very well what MYSQL functions. In general, MYSQL has functions to create, manage and access databases in a structured and automated manner. MySQL’s most prominent ability lies in its ability to manage string data (text based) which can be accessed privately or publicly on a web.

Certainly, almost all web server providers or hosts provide MySQL facilities for web developers to manage databases on their websites. In the web world, the interface or My SQL interface is called phpMyAdmin. Some examples of the use of MySQL can even be found in E-Commerce, Blogs or CMS.

Capabilities of MySQL

As I said earlier, that MySQL is not the only tool for processing SQL. But MySQL is chosen by many users because it has certain features or capabilities.

One of the most notable is MySQl’s multi-platform, GPL-licensed capabilities. That means MySQL can be used by almost all computer OS. Moreover, MySQL’s performance is also quite high in processing queries.

Some other features in MySQL for example:

  • Floats,
  • Double,
  • Charts,
  • Date and others

What’s more, MySQL also supports the use of fields in the form of indexes and has a fairly good level of security.

MySQL Advantages and Disadvantages

MySQL has several advantages that make it widely used by users. Among them:

  • MySQL supports various OS such as Windows, Mac Os X Server, Solaris, Linux, FreeBSD, Amiga, and others.
  • Open Source, so MySQL can be used for free.
  • MySQL can be used by many users at the same time.
  • MySQL has more SQL speed per unit time.
  • MySQL has a variety of application interfaces with API (Application Programming Interface) functions.

Even so, that does not mean that MySQL is without flaws. Some of the shortcomings of MySQL, for example: MYSQL does not support programming language connections and the data that can be handled is not so large and does not support the widowing function.

Difference Between Web Developer, Web Designer and WebMaster

Do you know what a Web Developer, Web Designer and WebMaster are? They are both related to a web, but please note that Web Developers, Web Designers and WebMasters are DIFFERENT! The meaning alone is different, let alone the task, isn’t it.. But there are still many people who think that Web Developer, Web Designer and WebMaster are the same. That’s wrong though. Instead of being confused about the difference between Web Developer, Web Designer and WebMaster.

Let’s discuss the differences between Web Developer, Web Designer and WebMaster

Web Developer

Web Developer

A web developer is someone who deals with the creation of a website. A Web Developer creates web-based applications using programming languages. The task of the Web Developer is to be the liaison of all the resources needed for website creation. Among others, such as creating databases, managing domains, creating dynamic web displays, and many more tasks from a Web Developer. Their task will end if the website created is ready for use and there are no problems using the website.

In making web-based applications, a programming language is needed that must be thoroughly understood by Web Developers, such as JavaScript, PHP, ASP, Python, Java, MySQL, and others. Because they have been confused with complicated programming languages, it can be said that a Web Developer doesn’t think much about the appearance of the website. Not thinking about the appearance of the website does not mean the resulting display is messy, yes, they will only make the website look dynamic. Then what about website design? Isn’t a website that is comfortable to look at also needed to make visitors feel at home on your website? To design the web to be more beautiful and comfortable is the task of the Web Designer.

Web Designer

Web Designer

Then what about website design? Isn’t a website that is comfortable to look at also needed to make visitors feel at home on your website? To design the web to be more beautiful and comfortable is the task of the Web Designer. Yes, this is where the task of the web designer begins. A web designer is someone who works with the visual elements of a website. They are in charge of beautifying the appearance of web pages.

Web designers often work with visual images, color, animation, video, and more to multimedia. They are more familiar with Client Side Scripting such as HTML, CSS, and JavaScript. Web designers will usually beautify the appearance of the website by manipulating the usual image that has been edited first using Adobe PhotoShop, CorelDraw, etc. If the appearance of your website is still not attractive, you can ask for help from a web designer.

WebMaster

WebMaster here serves as both as above. In addition, the WebMaster is also tasked with maintaining the web applications that are used. WebMaster’s tasks may be more and still long, yes, than Web Developers and Web Designers. They are the ones who will later manage the website, keeping the website always accessible or not down. And it’s possible if a WebMaster is also in charge of taking care of SEO, website content, to marketing the website. WebMaster will also manage the work of web developers and web designers, to test the usability of the web applications created.

In conclusion, Web Developer refers more to the logical ability to manage web-based applications, Web Designer refers more to artistic ability and creativity to beautify web pages, while WebMaster refers to logical, artistic abilities, and experience in dealing with common problems that exist in the web world.

5 Programming Languages in Website Development

Learning development pages can take a lot of time until you really understand it well. Before considering spending a lot of time, energy and money studying formally why not just learn the programming language?

5 Programming Languages ​​For Website Development

PHP

Before computerized marketing mushroomed as it is today, the term PHP had already gained global fame. PHP is a programming language that was born in 1994. Even though he is not young anymore, PHP is still used by many companies ranging from small to large-scale companies.

One of the reasons PHP is still popular is because its configuration methods are so flexible. PHP also supports a variety of website servers which means users can choose according to their needs. If it is inappropriate for website server A, it means that you can choose and apply website server B or others.

Java

When working with a Jakarta computerization agency, they may introduce you to Java. What is Java and when was this programming language born? Java was first present since 1990 and adapts various orientations, one of which is open object oriented.

Java has many advantages, one of which is building desktop applications. Of the many programming languages, learning Java is a great start to building pages.

Ruby

Building a page is not easy because it requires a lot of formulas and programs in it. When looking for a programming language, most people will remember Ruby.

Ruby is a programming language with a simple syntax structure. Internationally, the use of Ruby in the digitalization arena is quite high, especially to support third-party company technology. Not only does it offer a simple syntax, Ruby also carries an open source concept that makes it really user friendly.

CSS and HTML

Experts are used to implementing and processing high-level programming languages ​​to meet the computerized marketing needs of a company website. In contrast to the average beginner who uses HTML and CSS as the main programming language.

Why? Both programming languages ​​do not require much time and skill to master. The sections or attributes of HTML and CSS are also really simple but really useful for page development.

JavaScript

Except for Java, people also know JavaScript. JavaScript is a programming language that we can almost always get in a browser or page. The implementation of JavaScript is right on target to visually increase the attractiveness of games, mobile applications and pages.

Its multi-tasking performance makes companies interested in using it in various web-based programming projects. Another plus, JavaScript tends to apply less memory resources so it doesn’t increase the company’s budget.

Learning programming languages ​​is one of the technical practices that companies should go through when it comes to maximizing websites. Without understanding the programming language, it will be difficult for companies to work on development pages according to the nature and provisions of user-friendliness.