How to query SQL database from Prolog and use the queried result as facts?

[Osiris Xu]

Is it possible to couple Prolog to Relational Databases, SQL for example, and use commands like the following

   ancestor(X, Y) :- SQL('SELECT CHILD, PARENT INTO X, Y
                                    FROM FATHER WHERE CHILD =X').
   ancestor(X, Y) :- father(X, Z), ancestor(Z,Y).

to query SQL database from Prolog and use the queried result as facts?

[norbert...@gmail.com]

See for example: http://www.swi-prolog.org/pack/list?p=sql_compiler 

[Carlo Capelli]

Take a look at library(odbc), here for instance.

Syntax is different than what you show, and of course you need ODBC installed,
OTOH it works with whatever DB has a driver - nearly all.

About your syntax: I think will be difficult you find any compiler for a 'mixed' recursive query - but I could be wrong

Carlo

--
You received this message because you are subscribed to the Google Groups "SWI-Prolog" group.
To unsubscribe from this group and stop receiving emails from it, send an email to swi-prolog+...@googlegroups.com.
Visit this group at http://groups.google.com/group/swi-prolog.
For more options, visit https://groups.google.com/d/optout.