title: MariaDB 10.0 with SphinxSE
body: <p>I have a question about integrating Sphinx with MariaDB 10.0.  The db comes packaged with the SphinxSE storage engine, but I'm having trouble finding detailed information about how to set this up. Consider the following scenario:</p>
  
  <p>I have a book-selling app using a database with the following tables: "Book", "Listing", and "School". A "listing" contains a relationship to a single book and a single school. A "book" contains several columns, most importantly "title" and "author". I would like to perform full-text searches on the "Book" table using Sphinx, and a typical query might go something like this (in pseudo-SQL): "Find all books whose title contains the string 'Harry P' for which a current listing exists at Harvard University". </p>
  
  <p>According to MariaDB's <a href="https://mariadb.com/kb/en/mariadb/about-sphinxse/" rel="nofollow" title="mariadb docs">article</a>: "you need to create a special ENGINE=SPHINX 'search table', and then SELECT from it with full text query..." - so does this mean that Sphinx cannot access/index my existing MariaDB tables at all? Must I recreate my "Book" table as a SphinxSE table? If this is the case, how do I specify relationships between this table and my other non-Sphinx tables (Listing, School, etc)? The above article gives a very simple JOIN example, but I'm still confused. If all "books" are stored in a Sphinx table, can MariaDB access this table for different types of queries (where a full-text search is not needed)?</p>
  
  <p>As a related question, what would be a good way to enable Sphinx to index both the Title and the Author of the books? The app will always specify which field is being queried.</p>
  
  <p>Any help would be greatly appreciated, because hours of searching and reading has still left me mostly in the dark on this topic.</p>