Articles with the tag "databases"

In Java, it is pretty common to see libraries that use method chaining (aka the builder pattern) to construct resources. For example, we might construct a user by doing something like: User user = new User.Builder() .name("Michael Scott") .email("michael@dundermifflin.com") .role("manager") .nickname("Best Boss") .build(); Builders are handy for a variety of reasons, but in the example above we are using a builder in order to define a subset of our User attributes before constructing the user object.

One of the most common change requests I get with my Web Development course is to stop using GORM, and instead use the database/sql package that is part of Go’s standard library. When I receive feedback like this I often respond asking, “Why?” Why do they feel the database/sql package would be better suited for their education? Why do they feel ORMs will be problematic long term? I don’t ask these questions to be snarky or because I don’t care; I ask because I truly want to understand a problem before I look for solutions, and oftentimes people will tell you their problem is X, when in reality X is only a symptom of a deeper problem.

Learn how to query for multiple records using Go's database/sql package by querying for several users in a users table.

In this article we cover how to query for a single record using Go's database/sql package, including handling the ErrNoRows error.

A short tutorial that teaches how to update and delete records stored in an SQL database table using raw SQL statements.

In this guide we walk through installing PostgreSQL 9.6 along with the command line tools on Mac OS X (10.7 or later).