Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
CG/SQL – SQL dialect compiler to C for sqlite3 mimicking stored procedures (ricomariani.github.io)
24 points by linkdd 27 days ago | hide | past | favorite | 9 comments


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."


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.


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.



Thanks for the heads up.


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.


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


Is it safe?




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: