Getting Started with Database SDKs

To begin, ensure you have Node.js installed. You can install the necessary SDK packages via npm or yarn.

npm install @azure/cosmos @azure/arm-sql @azure/arm-postgresql @azure/arm-mysql @azure/arm-sqlmi

For authentication, we recommend using the `@azure/identity` package, which supports various authentication flows including service principals and managed identities.

npm install @azure/identity

Azure Cosmos DB

Azure Cosmos DB is a globally distributed, multi-model database service. The `@azure/cosmos` package enables you to interact with Cosmos DB containers, items, and queries.

Example: Connecting to Cosmos DB

import { CosmosClient } from "@azure/cosmos";
import { DefaultAzureCredential } from "@azure/identity";

const endpoint = "YOUR_COSMOS_DB_ENDPOINT";
const credential = new DefaultAzureCredential();

// If using a key directly (not recommended for production)
// const endpoint = "YOUR_COSMOS_DB_ENDPOINT";
// const key = "YOUR_COSMOS_DB_KEY";
// const client = new CosmosClient({ endpoint, key });

const client = new CosmosClient(endpoint, credential);

async function main() {
    const database = client.database("myDatabase");
    const container = database.container("myContainer");
    console.log("Connected to Cosmos DB!");
}

main().catch(error => console.error(error));
                    

Azure SQL Database

Azure SQL Database is a fully managed relational database service built on SQL Server. The `@azure/arm-sql` package allows you to manage SQL Database resources programmatically.

Example: Creating a SQL Database (Management)

import { SqlManagementClient } from "@azure/arm-sql";
import { DefaultAzureCredential } from "@azure/identity";

const subscriptionId = "YOUR_SUBSCRIPTION_ID";
const resourceGroupName = "myResourceGroup";
const serverName = "my-sql-server";
const databaseName = "my-sample-db";

const credential = new DefaultAzureCredential();
const client = new SqlManagementClient(credential, subscriptionId);

async function createDatabase() {
    const result = await client.databases.beginCreateOrUpdateAndWait(
        resourceGroupName,
        serverName,
        databaseName,
        {
            location: "eastus",
            sku: { name: "Basic" }
        }
    );
    console.log(`Database ${result.name} created successfully.`);
}

// createDatabase().catch(error => console.error(error));
                    

Note: For data operations within Azure SQL Database, you would typically use a SQL client library like mssql.

Azure Database for PostgreSQL

Leverage the power of PostgreSQL in a fully managed cloud environment. The `@azure/arm-postgresql` package helps in managing PostgreSQL server resources.

Azure Database for MySQL

Connect your applications to a managed MySQL database service. The `@azure/arm-mysql` package is used for managing MySQL server resources.

Azure SQL Managed Instance

Azure SQL Managed Instance offers near 100% compatibility with the latest SQL Server Enterprise Edition. The `@azure/arm-sqlmi` package facilitates its management.