CG/SQL – SQL dialect compiler to C for sqlite3 mimicking stored procedures

CG/SQL – SQL dialect compiler to C for sqlite3 mimicking stored procedures(ricomariani.github.io)

24 points by linkdd 106 days ago | 9 comments

vmsp 102 days 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."

DenisDolya 106 days 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.

pjmlp 102 days 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.

dfox 102 days ago | | |

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

HexDecOctBin 102 days 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.

thesz 101 days 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

fulafel 102 days ago |

Is it safe?