Conexión a bases de datos con next.jdbc

Welcome to connecting Clojure with databases! Most real-world applications need to store and retrieve data, and databases are central to this.

In this lesson, you'll learn how to use next.jdbc, Clojure's popular library, to interact with various databases.

next.jdbc is a modern, idiomatic Clojure wrapper for JDBC (Java Database Connectivity). JDBC is the standard Java API for connecting to relational databases.

• It simplifies database operations.
• It provides a clean, functional interface.
• It's fast and efficient.
• It supports a wide range of databases (PostgreSQL, MySQL, H2, SQLite, etc.).

Before we write any code, we need to add next.jdbc and a database driver to our project's dependencies. We'll use H2, an in-memory database, for easy examples.

Add these to your deps.edn file:

To connect to a database, you need a JDBC URL. This string tells next.jdbc (and the underlying JDBC driver) how to find and connect to your database.

For an in-memory H2 database, a common URL looks like this:

• jdbc:h2:mem:testdb: Connects to an H2 database named 'testdb' in memory.
• jdbc:sqlite:my-data.db: Connects to a SQLite file.
• jdbc:postgresql://localhost/mydb: Connects to a PostgreSQL database.

A datasource is an object that represents a connection pool or factory for database connections. It's usually created once and reused.

next.jdbc's get-datasource function takes a map of connection parameters, including the JDBC URL.

After getting a datasource, you can obtain a connection. It's crucial to close connections after use to free up resources.

Clojure's with-open macro is perfect for this. It ensures that resources like database connections are automatically closed when they go out of scope.

Let's see how to establish and close a database connection using next.jdbc and an in-memory H2 database. Run this code:

Once connected, you can execute SQL queries. next.jdbc provides functions like jdbc/execute! for DDL (Data Definition Language) and DML (Data Manipulation Language) operations, and jdbc/execute-one! for queries expecting a single row result.

Queries are passed as vectors, with the SQL string followed by any parameters.

Now, let's create a table and insert some data into our in-memory H2 database, then query it. Notice how execute! returns a vector of maps.

What is the primary purpose of using with-open when dealing with database connections in Clojure?

You've taken the first step into database interaction with Clojure!

• We introduced next.jdbc as a powerful library for database access.
• You learned how to add necessary dependencies (next.jdbc and a JDBC driver like H2).
• We covered JDBC URLs and how to establish a datasource and connection.
• You saw how with-open ensures connections are properly managed.
• Finally, we executed basic DDL and DML queries using jdbc/execute!.

Next, we'll dive deeper into CRUD operations!