Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
140 lines (107 sloc) 6.19 KB

Tcl extension and Database

Tcl database client 端的相關連結。

TDBC

TDBC is an interface standard for databases and connectivity that aims to make it easy to write portable and secure Tcl scripts that access SQL databases.

The TDBC library provides several C procedures that simplify writing a TDBC driver. They include a procedure that tokenizes a SQL statement, locating variables to be substituted, and a procedure that accepts a SQL state and returns an error class for the interpreter error information.

Tcl 8.6 shipped with four drivers for TDBC:

  • MySQL (tdbc::mysql)
  • ODBC (tdbc::odbc)
  • PostgreSQL (tdbc::postgres)
  • SQLite (tdbc::sqlite)

ORM

  • ORM - Object Relational Model over TDBC

RDBMS

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

You can check Open source SQL engines.

And

NoSQL

A NoSQL (originally referring to "non SQL" or "non relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.

What follows is a basic classification by data model,

  • Key-value
  • Wide-column
  • Document
  • Graph

Below is some Tcl NoSQL clients:

And

Other

我的作品集

下面是我在進行資料庫研究時所寫的 Tcl extension 列表。