<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel>
        <title>Port of Sphider to PostgreSQL</title>
        <description> Recently, im my work at Ingeniería de Prefabricados S.L. (a company part of the prefabricated concrete group Castelo), we needed a search engine in PHP for our corporative web.

After evaluating a lot of possible options, we found Sphider as the best alternative, because is an out-of-the-box solution with integrated crawler and search engine, buy it works with MySQL as backend.

In our company we prefer PostgreSQL over MySQL, for a lot of things that I’m not going to mention here, so I ported the code to work with PostgreSQL in one morning.

We also changed two things:

    * Now it index uppercase accented characters.
    * Js suggest not to use UTF-8

As a TO-DO, admin database tools were not ported, and the installations cannot be made from the web app.

It can be found here:

[www.alonsoruibal.com]</description>
        <link>http://www.sphider.eu/forum/read.php?3,6258,6258#msg-6258</link>
        <lastBuildDate>Thu, 20 Jun 2013 04:12:58 +0300</lastBuildDate>
        <generator>Phorum 5.2.10</generator>
        <item>
            <guid>http://www.sphider.eu/forum/read.php?3,6258,6258#msg-6258</guid>
            <title>Port of Sphider to PostgreSQL</title>
            <link>http://www.sphider.eu/forum/read.php?3,6258,6258#msg-6258</link>
            <description><![CDATA[ Recently, im my work at Ingeniería de Prefabricados S.L. (a company part of the prefabricated concrete group Castelo), we needed a search engine in PHP for our corporative web.<br />
<br />
After evaluating a lot of possible options, we found Sphider as the best alternative, because is an out-of-the-box solution with integrated crawler and search engine, buy it works with MySQL as backend.<br />
<br />
In our company we prefer PostgreSQL over MySQL, for a lot of things that I’m not going to mention here, so I ported the code to work with PostgreSQL in one morning.<br />
<br />
We also changed two things:<br />
<br />
    * Now it index uppercase accented characters.<br />
    * Js suggest not to use UTF-8<br />
<br />
As a TO-DO, admin database tools were not ported, and the installations cannot be made from the web app.<br />
<br />
It can be found here:<br />
<br />
[<a href="http://www.alonsoruibal.com/desarrollos/sphider-for-postgresql/" rel="nofollow" >www.alonsoruibal.com</a>]]]></description>
            <dc:creator>alberto.ruibal</dc:creator>
            <category>Sphider Mods</category>
            <pubDate>Sat, 20 Jun 2009 18:57:58 +0300</pubDate>
        </item>
    </channel>
</rss>
