logoalt Hacker News

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

22 pointsby linkddlast Sunday at 8:25 AM8 commentsview on HN

Comments

vmsptoday at 4:23 PM

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

show 1 reply
HexDecOctBintoday at 5:13 PM

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.

show 1 reply
DenisDolyalast Sunday at 10:59 AM

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.

show 1 reply
fulafeltoday at 4:46 PM

Is it safe?