hello, searching a photo by dominant colors using mysql is quite simple. assuming that the r,g,b values of the most dominant colors of the photo is already stored in the database, this could be achieved for example by something like: SELECT * FROM colors WHERE ABS(dominant_r - :r) < :threshold AND ABS(dominant_g - :g) < :thresh...
I'm trying to figure out how to order items with matching tags by the number of tags that match. Let's say you have three MySQL tables: tags(tag_id, title) articles(article_id, some_text) articles_tags(tag_id, article_id) Now let's say you have four articles where: article_id = 1 has tags "humor," "funny," and "hilarious." article...
I have a personnel database of 10,000 individuals. I am developing a PHP CMS to manage and search these individuals. One of the complaints about the old system was that you had to search for names by their exact spelling, else no results would return. The old system was using MySQL LIKE statements, which are too exact (and I do not wa...
I'm trying to figure out how I should be reindexing Sphinx. I'm using v 0.9.9, so I don't have the ability to do real-time updates of the index. I think I read somewhere that this can be done using a cron job, and that the index does not need to be entirely rebuilt (so no stopping the daemon). That said, I've never written nor run any c...
I've been working with this all day. But don't get it to work. I can search through CMD and get results on my indexed tables but I have problems trying to understand the sphinxapi for php, i don't even now fully how to write a query and get the results can someone help me to see if this things work. HOW DO WE WRITE A PHP QUERY FOR SP...
Pretty simple question. I have an existing MySQL install on OS X. I want to install the Sphinx engine as a plugin. Is there any straightforward way to do this? ...
The boring, necessary details: I'm on Snow Leopard running MySQL locally. I'm trying to install the Sphinx engine for MySQL like so: mysql> install plugin sphinx soname 'sphinx.so'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library I've Googled everywhere and can't seem to find an actual solution to ...
Im beginning to learn sphinx search php api after running this query <?php include('sphinxapi.php'); $cl = new SphinxClient(); $cl->SetServer( "192.168.0.100", 9312 ); $cl->SetMatchMode( SPH_MATCH_ANY ); $result = $cl->Query( "mimmi", "searchtest" ); if ( $result === false ) { echo "Query failed: " . $cl->Ge...
I'm having to recompile Sphinx (thanks to this issue – if you can help I'd be impressed!). Is the Sphinx beta ready for use in a production environment? I know that Sphinx 0.9.9 has been feature-frozen for a long time, and the Sphinx beta has a number of really wonderful features. But beta is scary. Do I have anything to worry about? ...
I am working on a website project. We have a MySql and a MongoDb base. We want to add a full-text search-engine over these bases (and if it can be linked with PostgreSql it's better). These databases contain multilingual texts but we cannot determine the language. I saw Solr, ElasticSearch and Sphinx, but what is your advice on this ...
Sphinx MySQL search seems to have a limit to the number of items allowed as an array for SetFilter. I had attempted to use: foreach (array_chunk($venues, 4096) as $value) { $sphinx->SetFilter('venue', $value); } But upon checking, this doesn't seem to fix the problem. Any ideas how using Sphinx and the PHP library I am able to g...
Im switching fulltext searching on my site to sphinx. Im going to be using SphinxSE to perform the searches. I created 2 indexes, as specified in the manual: http://www.sphinxsearch.com/docs/manual-0.9.9.html#live-updates It seems to work, and index different stuff in its own index, but Im somewhat confused about how I should handle th...
Im implementing sphinx search engine into my site, thru SpinxSE, its all seems to be working okay, except for one of the sort methods I have on my site, which is "ranking", which can be a negative number. For some reason when I sort it in descending order from highest to lowest, negative numbers appear on top of the list as highest rated...
This is a follow-up question to this question. Sphinx mentions on the downloads page: Note that 'beta' only applies to new features (RT indexes etc), everything else is stable. What is the "etc" in the new features? ...
I'm using Sphinx to search MySQL. One of the results Sphinx returns for a search is M*A*S*H, as in the hit television show. The problem I'm facing is that M*A*S*H is returned for nearly any query made with Sphinx. I'm guessing this is due to the asterisks. If not, then what could the problem be? If the asterisks are causing my probl...
But unluckily it seems I can't get the layer to work, all I see are my local mysql databases, what am I doing wrong? of course I'm connecting to the correct port. It seems that I connect to the default mysql server even if I give a non existant port ...
I added a real-time (RT) index to my sphinx.conf file. I can see it when I connect to Sphinx with mysql -h 127.0.0.1 -P 3312. But when I try to do a command-line search, Shinx adds to the end of the response: index 'drupal_rt': search error: failed to open /var/lib/sphinx/rt_drupal_nodes.sph: No such file or directory. ...
Hey, so I'm wondering if it's possible for Sphinx to weight certain fields of document over others in its results. For example, if I did a search for 'the rock show', is it possible to configure sphinx to give much higher precedence to a song named 'the rock show' over a song which has 'the rock show' in its lyrics? ...
I'm using the "manual" document class of Sphinx and I'm quite happy with how the Latex Output looks like, except for the page header. It contains the title of my paper, as well as a "Release 1". Since I'm writing a paper and not a documentation, I clearly don't need the release information. Unfortunately, it is very hard to find inform...
I am using Sphinx with autodoc for documenting my Django project. Design guys want to have documentation page(s) about all the template tags that are defined in the project. Of course, I can make such a page by enumerating all the template processing functions by hand, but I think it is not DRY, isn't it? In fact, template tag processin...