Logica – Declarative logic programming language for data

Re:Logica – Declarative logic programming language for data by foobarqux on Sunday November 17, 2024 @07:20AM (#42163817)

How do you connect to an existing database so that you can query it? There are examples of how you can specify an "engine" which will create a new database and use it as a backend for executing queries but I want to query existing data in an sqlite database.

[ Parent | on HN ]

Re:Logica – Declarative logic programming language for data by evgskv on Monday November 18, 2024 @12:48PM (#42174870)

To connect to a database file use:

  @AttachDatabase("db_prefix", "your_file.db");
  # Then you can query from it:
  Q(..r) :- db_prefix.YourTable(..r);

[ Parent | on HN ]

Re:Logica – Declarative logic programming language for data by foobarqux on Monday November 18, 2024 @03:35PM (#42176667)

Thank you. You can't do Q(..r) in sqlite right? That's what I read in the tutorial.

[ Parent | on HN ]

Re:Logica – Declarative logic programming language for data by evgskv on Monday November 18, 2024 @07:50PM (#42179022)

Ah, yes, you're right! Please do:

  # ...
  Q(your_column) :- example_db.YourTable(your_column:);

You can query multiple columns of course. Feel free to start threads in Discussions of the repo with whatever questions you have!

[ Parent | on HN ]

Re:Logica – Declarative logic programming language for data by kukkeliskuu on Tuesday November 19, 2024 @05:34AM (#42181953)

They are very responsive in the repo discussions, just ask questions there.

[ Parent | on HN ]