Where are files containing database connection and operations located in the project structure?

In Go projects, files responsible for connecting to and working with databases are usually placed in a separate folder, such as db, database, or repository.

This folder may contain:

• initialization of the database connection (for example, creating an sql.DB object or a client for NoSQL);
• functions or methods for executing queries;
• data access layers (DAO, repositories).

Example structure:

project/
├── cmd/
├── internal/
│   ├── database/
│   │   ├── connection.go
│   │   ├── user_repository.go
│   │   └── product_repository.go
│   └── service/
└── pkg/

In connection.go, an object for the connection is usually created and exported, which is then used in repositories to execute queries.