read.go

func readRecords() []Post {
	var result []Post
	rows, err := roachConnection.Query("select * FROM posts;")
	if err != nil {
		log.Fatal(err)
	}

	defer rows.Close()

	for rows.Next() {
		var post Post
		if err := rows.Scan(&post.ID, &post.Name, &post.Author, &post.Category, &post.CreatedAt, &post.UpdatedAt); err != nil {
			log.Fatal(err)
		}
		result = append(result, post)
	}

	return result
}