4 ms·
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
by foobarqux 2y ago
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.
- evgskv 2y agoTo connect to a database file use: @AttachDatabase("db_prefix", "your_file.db"); # Then you can query from it: Q(..r) :- db_prefix.YourTable(..r);
- foobarqux 2y agoThank you. You can't do Q(..r) in sqlite right? That's what I read in the tutorial.
- evgskv 2y agoAh, 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!
- kukkeliskuu 2y agoThey are very responsive in the repo discussions, just ask questions there.