tdbc(3tcl)

✨ NAME ✨

tdbc β€” Tcl Database Connectivity, aka the glow-up your Tcl programs needed to talk to SQL databases πŸ’…


πŸ¦‹ SYNOPSIS πŸ¦‹

package require tdbc 1.0
package require tdbc::driver version

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

πŸ’– DESCRIPTION πŸ’–

okay so bestie, listen. Tcl Database Connectivity (TDBC, for the girlies in a hurry) is a common interface that lets Tcl programs access SQL databases. that's the whole vibe. no cap. 🫢

and like, how does it do that? through a whole squad of database drivers: separate modules, each one adapting Tcl to the interface of one particular database system. so like, one driver per database, each one doing the translating, each one slaying in its own lane. πŸ’…

all of the drivers implement a common series of commands for manipulating the database. and here's the cute part β€” these commands are all named dynamically, because they all represent objects in the database system. it's giving very main character energy, every object gets its own name. ✨

those objects are:

  • connections β€” which represent connections to a database πŸ”Œ
  • statements β€” which represent SQL statements πŸ“
  • result sets β€” which represent the sets of rows that result from executing statements πŸ“Š

all of these have manual pages of their own, listed down there under SEE ALSO. go read them, they're iconic. πŸ‘‘

in addition, TDBC itself has a few service procedures that are chiefly of interest to driver writers. SEE ALSO also enumerates them, because of course it does, it's thorough like that. πŸŽ€


🌈 SEE ALSO 🌈

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

⭐ KEYWORDS ⭐

TDBC, SQL, database, connectivity, connection, resultset, statement


Copyright (c) 2008 by Kevin B. Kenny.


and that's the whole page bestie, no crumbs left. πŸ’–

signing off from the Tcl 8.6 era, on the tdbc(3tcl) page β€” mwah, take care of your databases and they'll take care of you πŸ¦‹βœ¨

πŸ“¦ where this page comes from