SQLite driver

[El KuKu]

I am currently playing with a custom SQLite driver and wanted to know if there are some testers available.

One of the main advantages of SQLite is the availability in PHP so there is no need for an additional database server.

The database will be created by default in the Joomla! root directory, so it is not advised to put it in any other space than a local development environment (for now).

There are some slight modifications to the Joomla! core (Backwards compatible to MySQL of course) that will also be usefull for other database drivers (like Postgres).

The repository is here: https://github.com/elkuku/joomla-cms/tree/sqlite
You may just down load a current snapshot: https://github.com/elkuku/joomla-cms/zipball/master

A small readme that deals with installation instructions is available here: https://github.com/elkuku/joomla-cms/blob/sqlite/readme-sqlite.md

Thanks for your attention,
Nikolai

[El KuKu]

Apoligies: The download link in the first post was wrong:

https://github.com/elkuku/joomla-cms/zipball/sqlite

That's it ;)

[Glenn (GMail)]

Hi Nikolai,

Just ran a quick test install. All ok to the install sample data, was
waiting for some response saying "Install complete" but nothing.
Clicked the next button and received an error dialog....

"The most recent request was denied because it contained an invalid
security token. Please refresh the page and try again."

Refresh of page sent me back to start page of install. Progressed
through to the database page again and now just see the spinning clock
face. Hope this helps.

OS - Windows 7 (unfortunately)
WAMP Server 2.1 (php 5.3.4 and apache 2.2.17)

Glenn

> --
> You received this message because you are subscribed to the Google
> Groups "Joomla! General Development" group.
> To view this discussion on the web, visit
> https://groups.google.com/d/msg/joomla-dev-general/-/EUnG_-V_ke8J.
> To post to this group, send an email to
> joomla-de...@googlegroups.com.
> To unsubscribe from this group, send email to
> joomla-dev-gene...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/joomla-dev-general?hl=en-GB.

[El KuKu]

Please don't click "Install sample data" - as you may notice the
selector beside the button is empty.

The default joomla.sql already includes the sample data for testing
purpose (see the readme ;)).

I already received a successful test result for Win7 so this should
not be the problem (in this case ;))

Thanks a lot for testing,
Nikolai

[Glenn (GMail)]

Hi Nikolai,

Sorry, I can't help myself, I see a button and want to click it. ;)

Ok, successfully installed and looks ok with a brief scim through some of the admin views.  A notice on the system info page (all tabs) "Notice: Undefined property: JDatabaseSqlite::$charset in C:\wamp\www\TestSQLite\libraries\joomla\database\database\sqlite.php on line 527"

Successfully installed one of my "dodgy" components although the database failed as would be expected as it's setup for MySQL and I suspect I would need to change my install sql to be different (sorry I know absolutely nothing about SQLite).

Let me know if there's anything specific you want checked.  Cheers.

Glenn