If in doubt as to which version to download, read this.

Available Downloads

Uses MySQL extension
PHP 7.0 or less
MySQL or MariaDB

Uses MySQLi and MySQLnd extensions
PHP 5.4 or greater
MySQL or MariaDB

Uses PDO
PHP 5.4 or greater
MySQL or MariaDB

Uses PDO
PHP 5.4 or greater
SQLite

Uses PDO
PHP 5.4 or greater
PostgreSQL

Windows port of Catdoc
Binaries and source code
Converts .doc, .ppt, & .xls files to text


Which version should I download?

Sphider 2.2.0 is the recommended version. This version DOES require both the MySQLi and MySQLnd extenstions to PHP. Some hosting providers have DISABLED the MySQLnd extension, particularly for clients using shared hosting. Check with your system administrator or hosting provider to assure that the MySQLnd extension is available.¹ The installed database used is either MySQL or MariaDB.

Sphider 2.2.0 PDO does not use any MySQL extentions, but DOES use PDO (PHP Data Objects). This variation is intended for situations in which the MySQLnd extension has not been made available. Like the "regular" Sphider 2.2.0, the database used is MySQL or MariaDB.

Sphider 2.1.0 for SQLite is like Sphider 2.1.0 PDO (previous PDO version), but instead of the MySQL/MariaDB database type, the SQLite database is targeted. There are no plans to update this to 2.2.0 unless there is a request to do so.

Sphider 2.1.0 for PostgreSQL is like Sphider 2.1.0 PDO (previous PDO version), but instead of the MySQL/MariaDB database type, the PostgreSQL database is targeted. There are no plans to update this to 2.2.0 unless there is a request to do so.

Sphider 1.4.2 is last version to use the now obsolete MySQL extension. There are still a few installations which use an old enough version of PHP that later versions of Sphider using more secure prepared statements just won't work. The good part is that 1.4.2 is usable in those cases. The downside is that it is not as secure and lacks the bug fixes and improvements of later versions. By PHP 7.1, this version will not work. Even some earlier versions of PHP will complain of deprecated code. If your PHP predates 5.4, this is the version for you.


Catdoc is an optional, third party add-on for Windows users who wish to be able to convert *.doc, *.ppt, and *.xls files to text. On Linux systems, check with your system administrtor or hosting provider to see if this feature is available. It is NOT required for the conversion of pdf files to text.

Catdoc is a port to Windows of catdoc, catppt, and xls2csv utilities found in Linux. This is a third-party compilation containing Windows binaries as well as source code. We have done some basic testing from a Windows command prompt. We used a Windows 7 x64 based machine. First, a directory C:\bin\linux2winports was created. From the zip file (provided as a download) we extracted the three exe files and the charsets directory to the directory created. We got 2 errors complaining of the extraction failing to set timestamps on two of the files. Ignore the warnings. The extracted binaries are win32 (for x86), but they worked in our x64 environment. We did not try any of the options but simply a command like "catdoc somefile.doc", "catppt someppt.ppt", and "xls2csv spreadsheet.xls". We received expected outputs, so the port does work, at least on a basic level.

The recommendations are to use the pre-compiled binaries provided, but if you have the know-how to make your own binaries, you are free to do so. The binaries are win32, but it may be possible to use the source to make x64 binaries. We don't know, haven't tried. This package is provided as-is.


Common Text Files

While indexing, Sphider excludes common words from indexing. If you wish to see what those words are, check your Sphider installation for include/common.txt. This is a simple text file listing the excluded words. The problem is, this is a list of English words. If you are indexing a site in some other language, it becomes pretty useless.

While you may replace common.txt with another of your own making, here are a couple of pre-made lists which can be substituted for common.txt. Simply rename the existing common.txt to something like en_common.txt, and rename one of these to common.txt.

The number of pre-made lists is short, but feel free to make your own, and maybe even share them!

Common French words

Common German words

Common Spanish words


NOTE 1: Download, extract, and run this script.
This will tell you which Sphider you can use.

You can also create a script:
  <?php
  phpinfo();
  ?>
Upload this to you server and run it. If you get results like this (with "mysqli" and "mysqlnd" sections, you are good.
PHP Info screen shot