top | item 42174870

(no title)

evgskv | 1 year ago

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);

discuss

order

foobarqux|1 year ago

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

evgskv|1 year ago

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!