Which database should I choose to begin studying

Started by Socialmarketing, Dec 13, 2022, 04:00 AM

Previous topic - Next topic

SocialmarketingTopic starter

What's the best database to start with as a beginner? I heard that MySQL is commonly used, but I'm having trouble finding a version for Win-64 on the download page. Can you recommend a good guide for beginners?

It turns out that you don't need to download the database separately. Instead, you need to uncomment the desired line in php.ini.

I've been trying to connect to the database using the following code:

try {
    $dbh = new PDO('mysql:dbname=db_name;host=localhost', 'login', 'password');
} catch (PDOException $e) {
    die($e->getMessage());
}

However, I keep getting an error message that says "SQLSTATE[HY000] [2002] The connection is not established because the destination computer rejected the connection request." I suspect that I need to start the database server first, but I'm not sure how to do that.

Do you think I need to register host=localhost:4000 instead of host=localhost? I tried that, but the page doesn't reload at all now.
  •  

blueangelhost

To begin with, it's important to understand the correct terminology such as "DBMS" and "database server." As a beginner, it's recommended to use the "native" extension - mysqli.

If you're using virtual hosting, the entire standard set of popular tools is already provided for you. However, if you're using a dedicated server (VDS), you'll need to install and configure it yourself.

Check out this link https://dev.mysql.com/downloads/installer/ for database installation and setup instructions. Additionally, this link https://dev.mysql.com/doc/refman/8.0/en/ provides documentation on various concepts related to databases.
  •  

alvinwright

Nowadays, most advanced databases support a wide range of data storage types. One such example is MS SQL Server, which supports relational, columnar, and graph data storage options. Key-value storage is also widely used. Additionally, the support of XML and JSON allows for the possibility of it being attributed to document-oriented databases.

It's worth noting that understanding the different types of data storage options can greatly benefit companies in terms of optimizing their data management systems. By selecting the right type of database for their specific needs, businesses can increase efficiency and reduce costs.
  •