A database driver is the communication boundary between an application and a database. It sends queries and returns database state in a collection-friendly form, such as a list of maps. section 10.1
The driver need not dictate the application’s data manipulation. A SQL query retrieves rows, while generic functions can continue to manipulate those rows as data collections. section 10.1
Common ways to cross the database boundary include:
- Use node-postgres to interface with PostgreSQL from JavaScript. section 10.1
- Use JDBC in Java, optionally converting a result set into a list of maps. section 10.1
- Defer detailed type handling until serialization, where a JSON schema can validate the returned structure. section 10.1
Book search
A driver executes a title search against the books table and returns matching rows containing title, ISBN, and publication year. The application can then serialize the result as JSON.
