News for hackers. Stuff that matters.
Re:The seven programming ur-languages (2021) by curiousllama on Thursday May 04, 2023 @02:05PM (#35819645)
Yes it does. It’s a fun problem to make a sudoku solver

https://technology.amis.nl/it/solving-a-sudoku-with-one-sql-...

Re:The seven programming ur-languages (2021) by ngruhn on Thursday May 04, 2023 @02:58PM (#35820412)
Ok fair enough. I suspect that's a pretty non-standard/rarely-used feature though. If you learn SQL you likely won't encounter this and I still contest the idea that SQL is a good entry into the logic paradigm.

SQL and Prolog are both relational. That's very unique to both. But SQL is all about querying databases. Prolog can also be used and understood as a database querying language but it's also very strong for

- parsers

- interpreters

- expert systems

- solving combinatorial problems

If you really want to you can probably use SQL for that too. Or any language for that matter. But going out and learning SQL won't naturally expose you to these applications and how well the logic paradigm lends itself to them.

Re:The seven programming ur-languages (2021) by castorp on Thursday May 04, 2023 @04:03PM (#35821310)
> I suspect that's a pretty non-standard/rarely-used feature though. If you learn SQL you likely won't encounter this

Recursive common table expressions are part of the SQL standard (since 1999) and are quite frequently used to traverse hierarchical data (aka "adjacency list").

It is part of basically all (good) SQL tutorials - at least in the "advanced" part.

Re:The seven programming ur-languages (2021) by blowski on Thursday May 04, 2023 @04:58PM (#35821987)
I don't remember using recursion in a real project, but I built a HN clone on top of Postgres, with the following query:

    WITH RECURSIVE thread(id, parent_id, user_id, post_id, timestamp, text, depth) AS (
      SELECT id, parent_id, user_id, post_id, timestamp, text, 0
      FROM comments
      WHERE user_id = 1
        AND parent_id IS NULL
      UNION ALL
      SELECT c.id, c.parent_id, c.user_id, c.post_id, c.timestamp, c.text, t.depth + 1
      FROM comments c
      JOIN thread t ON c.parent_id = t.id
      WHERE c.user_id != t.user_id
    )
    SELECT * FROM thread ORDER BY timestamp ASC;
Re:The seven programming ur-languages (2021) by epgui on Friday May 05, 2023 @12:18AM (#35825173)
I wrote a recursive CTE to do a tree traversal on a parent-child “relationship” table a few weeks ago at work.

They do come up!