Tell about databases — what have you worked with and are currently working with?

In my practice, I have worked with different types of databases:

• Relational databases (SQL): PostgreSQL, MySQL. Used them for storing structured data with transactional integrity. For example, in projects with financial operations or CRM.

• NoSQL databases: MongoDB, Redis. Used MongoDB for storing documents with flexible schemas, Redis as a cache and for session storage.

• Time-series databases: InfluxDB for collecting and analyzing metrics and logs.

Currently, I mainly work with PostgreSQL and Redis. In Go, I use the database/sql libraries with drivers for PostgreSQL, and for Redis — go-redis. An important aspect is query optimization, schema migrations, and ensuring fault tolerance.

Example of connecting to PostgreSQL in Go:

import (
    "database/sql"
    _ "github.com/lib/pq"
)

func connect() (*sql.DB, error) {
    connStr := "user=postgres dbname=mydb sslmode=disable"
    return sql.Open("postgres", connStr)
}