$SQLUseConnectionPool (DatabaseLink Symbol)

$SQLUseConnectionPool gives the default setting that specifies whether a connection pool is used to retrieve a connection.

Column Structure (DatabaseLink Tutorial)

This section discusses commands that get information about database columns. If you find that the examples in this section do not work as shown, you may need to install or ...

Comparing Mathematica-Style Queries and ... (DatabaseLink Tutorial)

DatabaseLink provides two styles of commands for working with data: one for those who are familiar with Mathematica and the other for those who are familiar with SQL. ...

Connection Pools (DatabaseLink Tutorial)

Database connection pools are a common way to improve the performance of database operations. They can be useful because creating a new connection can easily take several ...

Creating Tables (DatabaseLink Tutorial)

SQLCreateTable creates a new table in a database. An alternative, using raw SQL, is described in "Creating Tables with Raw SQL". If you find that the examples in this ...

Database Connections (DatabaseLink Tutorial)

The first step in using a database is making a connection. This part of the tutorial discusses how to do this. If you are just starting to use DatabaseLink, you might want to ...

Database Reference (DatabaseLink Tutorial)

HSQLDB is a relational database engine written in Java that is bundled with DatabaseLink, which also contains a JDBC driver and necessary configuration. It offers a small ...

Database Resources (DatabaseLink Tutorial)

DatabaseLink allows other Mathematica applications to hold resource information for database connections in DatabaseResources directories. There are a number of possible ...

Data Type Mapping (DatabaseLink Tutorial)

One of the most important issues for using a database is the conversion of data as it is stored and retrieved from a database. This tutorial will discuss how Mathematica ...

Deleting Data (DatabaseLink Tutorial)

SQLDelete deletes data from a database. An alternative, using raw SQL, is described in "Deleting Data with Raw SQL". If you find that the examples in this tutorial do not ...