FAQ

MySQL is an open source database system that uses structured language query SQL. Essentially, it’s a way for users to store information in data tables and access it extremely quickly and extremely efficiently. When you look in a MySQL database for information, it’s called a query. What makes MySQL particularly effective for web development is that it can auto-cache some queries, so those that happen again and again can happen very quickly without a lot of processing power. These sorts of interactions happen all the time in web development, and is part of the reason for MySQL’s popularity.

Like most things in tech, it depends. It MySQL and PostgreSQL have different strengths and weaknesses. The biggest two strengths of MySQL over PostgreSQL is it’s ubiquity in web development and its comparable speed. It’s also a simpler program. However, PostgreSQL complies with security regulations more and is generally a more feature-rich database. What this means is that if you’re working with triggers, unions, full joints, stored procedures, or need foreign key support then PostgreSQL is the obvious choice.

MySQL though is simpler, works better with web-based servers, and there is a giant support community to answer any conceivable question you can dream up.

All this to say that there isn’t an advantage of always PostgreSQL over MySQL – it’s about using the right too for the job.

MySQL is an open source database system that uses structured language query SQL. Essentially, it’s a way for users to store information in data tables and access it extremely quickly and extremely efficiently. When you look in a MySQL database for information, it’s called a query. What makes MySQL particularly effective for web development is that it can auto-cache some queries, so those that happen again and again can happen very quickly without a lot of processing power. These sorts of interactions happen all the time in web development, and is part of the reason for MySQL’s popularity.

MySQL is an open source database system that uses structured language query SQL. Essentially, it’s a way for users to store information in data tables and access it extremely quickly and extremely efficiently. When you look in a MySQL database for information, it’s called a query. What makes MySQL particularly effective for web development is that it can auto-cache some queries, so those that happen again and again can happen very quickly without a lot of processing power. These sorts of interactions happen all the time in web development, and is part of the reason for MySQL’s popularity.

MySQL is an open source database system that uses structured language query SQL. Essentially, it’s a way for users to store information in data tables and access it extremely quickly and extremely efficiently. When you look in a MySQL database for information, it’s called a query. What makes MySQL particularly effective for web development is that it can auto-cache some queries, so those that happen again and again can happen very quickly without a lot of processing power. These sorts of interactions happen all the time in web development, and is part of the reason for MySQL’s popularity.

Oh course! There are lots and lots of ways to connect to your database other than phpMyAdmin. Secure Shell (SSH) is one example of this, simply using the command line to access and extract what you need. In addition, MySQL can be developed in any popular language, including C and C , Perl, Python, Java, Delphi, Visual Basic, and C#.

A MySQL database query is a question or a request. It’s asking your database something and having it return a result. It’s a little bit like asking a librarian for a book, having them go and get it, and then giving it to you. The only difference is that it’s digital and happens incredibly fast. For example, one table in your MySQL database might log all the details of how many times a certain webpage is viewed. If you wanted to see them, you would send a query for the data values that table. phpMyAdmin would let you then extract that data as a excel spreadsheet.

 

 

When there are so many of these interactions though, like on a website, the time per interaction is incredibly important. Caching is way of reducing that time. At its core, it works by sorting queries together with their answers in the same spot, so that the entire database doesn’t have to be searched. It’s a little like if the librarian knew you were coming in, and had the book already set aside. The reason that you would want to use a query cache is that it can speed up your site dramatically for things that happen on it a lot, which is good for your users and in turn good for you.

Yes, you can. One way to do this is a tool called MySQL Workbench (don’t worry, it’s free). You’ll also need your IP address and cPanel access. The end result is being able to access your databases from your personal computer.