CG/SQL – SQL dialect compiler to C for sqlite3 mimicking stored procedures (opens in new tab)

(ricomariani.github.io)

24 pointslinkdd1mo ago9 comments

9 comments

vmsp1mo ago

I'm guessing this is a fork of Facebook's abandoned library? https://github.com/facebookincubator/CG-SQL

From the repo: "Meta continues to make periodic ad hoc contributions to this fork and merge corrections back to their private repo. The maintainer thanks Meta for this continued informal cooperation."

DenisDolya1mo ago

CG-SQL = an attempt to give C what Python has had for a long timeconvenient “scripted” work with the database, but without losing speed.This is cool.

pjmlp1mo ago

Oracle was already doing this in the 1990's with Pro*C.

https://docs.oracle.com/cd/A97630_01/win.920/a96111/intro.ht...

Sybase and Informix also used to have something similar.

dfox1mo ago

PostgreSQL has this: https://www.postgresql.org/docs/current/ecpg.html

1 more reply

HexDecOctBin1mo ago

I always wonder why SQLite didn't expose a programmatic way for creating a query (as opposed to parsing SQL statements). Given that it was designed to be embedded, it seems to me that it would have made far more sense to provide an API based interface. Then, for example, stored procedures would just be function pointers passed as callbacks.

thesz1mo ago

SQLite was a library for TCL, implementing "sqlite" command, and from TCL one can use it in a variety of interesting ways, approaching and even surpassing "stored procedures" concept.

For example, it is easy to create SQL function using TCL: https://sqlite.org/tclsqlite.html#the_function_method

fulafel1mo ago

Is it safe?

j / k navigate · click thread line to collapse