tdbc(n)

✨ NAME ✨

Okay bestie, welcome to tdbc(n) — Tcl Database Connectivity, aka TDBC. It’s the common interface for Tcl programs to access SQL databases, and it’s giving main character energy fr fr 💅.

✨ SYNOPSIS ✨

Copy-paste era, no cap 🫶:

package require tdbc 1.0
package require tdbc::driver version

tdbc::driver::connection create db ?-option value...?

✨ DESCRIPTION ✨

So what is TDBC? It’s a common interface for Tcl programs to access SQL databases. It’s implemented by a series of database drivers: separate modules, each of which adapts Tcl to the interface of one particular database system. All of the drivers implement a common series of commands for manipulating the database. These commands are all named dynamically, since they all represent objects in the database system. The objects include:

• connections — represent connections to a database 💖
• statements — represent SQL statements 🎀
• result sets — represent the sets of rows that result from executing statements ✨

All of these have manual pages of their own, listed under SEE ALSO — go read the whole friend group, iykyk 🦋.

In addition, TDBC itself has a few service procedures that are chiefly of interest to driver writers. SEE ALSO also enumerates them. Driver writers stay winning 👑.

✨ SEE ALSO ✨

The linked besties, periodt 💅:

• Tdbc_Init(3)
• tdbc::connection(n)
• tdbc::mapSqlState(n)
• tdbc::resultset(n)
• tdbc::statement(n)
• tdbc::tokenize(n)
• tdbc::mysql(n)
• tdbc::odbc(n)
• tdbc::postgres(n)
• tdbc::sqlite3(n)

✨ KEYWORDS ✨

The vibe-check words, literally 🌈:

• TDBC
• SQL
• database
• connectivity
• connection
• resultset
• statement

✨ COPYRIGHT ✨

Copyright (c) 2008 by Kevin B. Kenny. — respect the copyright, bestie 💜

Footer sign-off, bestie 🫶: source/version is Tcl 8.6, the manual is tdbc(n), and there’s no date printed in the footer — so that’s the whole tea ☕💖.