SQLite from PHP in Uniform Server 3.3

[rickh57]

I've downloaded Uniform Server 3.3 for use on a thumb drive. From looking through this board (See here), I understood that SQLite would be included in this version of the server. However, I've been unable to use it from within PHP, either directly (using sqlite_open, etc), or via PEAR's DB module. Pages using MySQL work great, but it would be nice to not have to run MySQL just to test some basic database functionality.

 

Is there something that I need to enable in my PHP configuration in order to use SQLite?

 

Thanks,

Rick

[olajideolaolorun]

Though SQLite Automatically comes with PHP 5, you will still need to set some things up for it to work.

 

We could not add them to 3.3 because of space and size... so it is being made a plugin.

[rickh57]

Thanks for the information. Do you have an estimate for when that plug in will be available?

[olajideolaolorun]

No... i basically do not have an estimate for anything right now.... too busy and no internet connection at home.... though we may be getting it next month.

[rickh57]

Is there any update as to when the sqlite plugin will be available? Is there anything that I can do to help get this created?

 

Thanks,

Rick

[Thequestion]

I was going to ask the same question above yesterday about SQLite, but I experimented a bit and found a solution to make it work. I wrote a article Here on how to do it.

[olajideolaolorun]

Thanks.. Good Job. Now, they can get SQLite Manager themselves and install it with it to manage the database.

[julmot]

The link is down and SQLite is still not implemented....

[Neophitus]

Use pdo sqlite for connection. To create the database I recommend the SQLiteStudio:

 

http://sqlitestudio.pl/