Forum

Banshee and SQLite

Palatinux

5 november 2011, 02:05

Hi Hugo,

We would like to use SQLite3 as our DB instead of MySQL. But how must we configure Banshee to make it connect to a SQlite3 DB?

Regards,
The Fortress Linux team

Hugo Leisink

7 november 2011, 06:30

Banshee has a SQLite3 driver which uses PHP's SQLite3 class according to the documentation. However, I haven't been able to use this class because it only gives me errors. It looks like that PHP (at least the version I'm using:5.2.4) does not fully support SQLite3 yet.

My advice: stay with MySQL.

Palatinux

9 november 2011, 02:46

Hi Hugo,

I've already made an hardened version of PHP 5.3.9_rc1 (org. version here http://downloads.php.net/johannes/)
and it's working fine under Fortress Linux now with MySQL. Think i'll leave it this way.

BTW, does Banshee uses the Filter function of PHP for (input) validation/sanitation ? (http://www.php.net/manual/en/intro.filter.php) or is it already embedded in the code?

PS. Maybe nice to know this: The "php --stripped" function speeds up the framework a bit after converting.

Hugo Leisink

9 november 2011, 07:32

Banshee doesn't use the Filter function. It has it's own input validation library: libraries/post_data.php.

Palatinux

16 november 2011, 03:30

That's even better.

Thank you very much

Message preview