4 ms·

This is probably stupid but... would scrapscript[1] be a good base for a DSL aimed at replacing SQL? [1]: https://scrapscript.org/ https://scrapscript.org/ ed

• surprisetalk 3y ago
  Scrapscript author here. I'm a huge fan of PRQL and indeed hope to implement a DSL called "scrounge" later this year. The DSL will be nice to have for codegen and type-safety interop inside of scrapscript, but there's no way it would feel as nice as using PRQL directly.
• hintymad 3y ago
  Maybe, but at least it is not immediately clear to me why scrapscript is better than SQL. The homepage of scrascript says: > Scrapscript is best understood through a few perspectives: > “it’s JSON with types and functions and hashed references” > “it’s tiny Haskell with extreme syntactic consistency” > “it’s a language with a weird IPFS thing” It later says: "Scrapscript solves the software sharability problem." None of the statements addresses the commonly recognized shortcomings of SQLs. In contrast, PRQL's value proposition is clear: it improves the readability and composability of SQL by offering a linear order of transformation through a pipelined structure. In addition, it is based on relational algebra so database professionals can still apply the theoretical framework that they understand and trust to master the language.
  • tacone 3y ago
    Hello, thank you for your answer. There's apparently more in scrapscript than what's written on its homepage. I didn't really meant to compare it to PRQL, but at the same time it probably offers some of the propositions of PRQL: extreme composability, functional programming (so: pipelines) and some more.