What databases have you worked with? Why did you choose PostgreSQL?

I have worked with various databases, including MySQL, Oracle, MongoDB, and PostgreSQL.

The choice of PostgreSQL is due to several reasons:

• Reliability and compliance with SQL standards — PostgreSQL strictly follows standards, which simplifies portability and support.
• Extensibility — the ability to create custom data types, functions, and operators.
• Support for complex queries and transactions — a powerful engine for handling large volumes of data.
• Active community and open source — continuous development and no licensing restrictions.

Example of connecting to PostgreSQL in Java using JDBC:

String url = "jdbc:postgresql://localhost:5432/mydb";
String user = "user";
String password = "password";

try (Connection conn = DriverManager.getConnection(url, user, password)) {
    // Working with the database
} catch (SQLException e) {
    e.printStackTrace();
}