April 2021
Beginner
336 pages
5h 32m
English
Content preview from Go Programming Language For Dummies
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 17
Working with Databases
IN THIS CHAPTER
Getting the MySQL server ready to go
Retrieving, adding, modifying, and deleting a record in the MySQL database
Any application worth its salt needs to store its data persistently somewhere. Unless you’re writing a “Hello, World!” application, chances are, your application will deal with data. You need a place to store that data efficiently so you can retrieve it easily the next time you need to access it.
When it comes to database servers, you have lots of choices. Here are some of the popular database servers currently available:
- IBM Db2
- Microsoft SQL Server
- MongoDB
- MySQL
- Oracle Database
- PostgreSQL
Although Go can access any of these database servers, I can’t cover all these products in this chapter, so I focus on MySQL because it’s one of the more popular databases for web-based applications.
In this chapter, I show you how to use Go to store your data in databases. You discover how to set up a MySQL database server, create a database and table, and configure it for use with Go.
Setting Up a MySQL Database Server
MySQL has several paid editions designed for commercial use, but you can use the free version, MySQL Community Server, for both development and commercial use. The free version has all the features that you would ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.