2 ms·
After I wrote that comment I thought it might be worth submitting this Andl story to HN about Andl-on-Postgres: [0]. They write, "Relational expressions are con
by pjungwir 10y ago
After I wrote that comment I thought it might be worth submitting this Andl story to HN about Andl-on-Postgres: [0]. They write, "Relational expressions are converted into equivalent SQL and passed back to the Postgres SPI interface for execution," so you are right about transpiling. But the software world is more mature than it was 20 years ago, so it seems reasonable for a project to get a toehold by building on top of existing systems. That needn't limit its future growth necessarily. It sounds like Andl will work on more than just Postgres, so I can imagine them eventually building a "native" version too. Using existing RDBMSes is a pretty good way to get an MVP though. :-)
[0] https://news.ycombinator.com/item?id=11802917 https://news.ycombinator.com/item?id=11802917
- smt88 10y ago> Relational expressions are converted into equivalent SQL and passed back to the Postgres SPI interface for execution I actually don't think I like that approach. If I transpile my own queries (meaning I use a query builder), then I can cache the generated SQL. There would be some placeholders for arguments, but the query itself doesn't change. Andl's approach could add significant overhead in certain applications where lots of queries are being executed at once. And then what happens to EXPLAIN support? Is it harder to debug an Andl query?