[Xerte] Re: Xerte Toolkits - installation and management special

[David Goodwin]

On 27/05/14 16:37, Tom Reijnders wrote:
> FYI
>
> I'll make sure to be present as well.
>
> Ron, we should discuss David Goodwins solution to using sqlite, before
> the meeting. I understand what he's trying to accomplish, but don't know
> whether it's the best way forward.
>

My aim was to validate that XOT was no longer 'hooked' on MySQL or the 
mysql_ functions from PHP -- which are apparently scheduled for 
deprecation beginning in PHP 5.6 (release imminent).


Swapping it to SQLite was an easy way of validating this, and the 
auto-setup stuff was an added because I could....


It is the case that database_library.php could (perhaps should?) use 
PDO, in which case there'd be no need for the separate 
database_library_sqlite.php file. Making such a change to 
database_library.php shouldn't be difficult - I just haven't done it.


I wasn't sure if there'd be an issue with me changing the database 
backend to be PDO based. PDO has been around since PHP v5.1. Is it 
therefore safe to use/depend on?


David.

-- 
Pale Purple Ltd

PHP Web application development and support

http://www.palepurple.co.uk
@PalePurpleLtd
07792 380669 / 0845 0046746