[Xapian-discuss] Can be Xapian used to perform standard SQL statements?

[David G Ortega]

Hi Olly,

thanks for the answer. Probably I have not been clear in my question. I know
that Xapian is not  a database. In the features says
 "You can also index data from any SQL or other RDBMS supported by the Perl
DBI module <http://dbi.perl.org/>. That includes MySQL, PostgreSQL, SQLite,
Oracle, DB2, MS SQL, LDAP, and ODBC"

I undestand that Xapian can connect to those databases throught the Perl DBI
module. The question is can I perform regular SQL statements using xapian?
similar than this?

QString sql = "INSERT INTO table (column1) VALUES (value1)";
Xapian::Query query = ...

and do an statement.

Thanks

2010/12/11 Olly Betts <olly at survex.com>

> On Sat, Dec 11, 2010 at 01:06:54AM +0100, David G Ortega wrote:
> > My question is, can Xapian be used to perform standard SQL statements
> like
> > inserts or updates? I undestand that Xapian does it when you perform a
> query
> > or save a document but I haven't seen how to perform direct SQL
> statements.
> > These would be useful for me since I wouln't have to maintain the
> database
> > driver that I actually expose to javascript focusing only in Xapian.
>
> Xapian isn't an SQL database.
>
> It's not a relational database either, so I think trying to implement an
> SQL
> layer over the top would be problematic - the SQL model doesn't really fit
> well.
>
> Cheers,
>     Olly
>



-- 
David