I tried to replicate this in SQLite. The first few steps worked OK, e.g. https:/... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		simonw on March 7, 2023 \| parent \| context \| favorite \| on: Stochastic gradient descent written in SQL I tried to replicate this in SQLite. The first few steps worked OK, e.g. https://lite.datasette.io/?json=https://gist.github.com/simo... (I replaced "figures" with "raw" due to the way Datasette Lite assigns a default table name to the imported JSON) But the more complex recursive queries gave me this error and I'm not sure how to work around it: `recursive reference in a subquery: state` E.g. https://lite.datasette.io/?json=https://gist.github.com/simo...

Lemaxoxo on March 7, 2023 [–]

That's too bad, I would have expected it to work out of the box. Other than rewriting the query in a different way, I'm not sure I see an easy workaround. Are you still working on this?

simonw on March 8, 2023 | [–]

No I managed to drag myself away from it and get back to what I'd been intending to work on!

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact