4 replies to this topic

[redl]

Hi ! I just discovered your fabulous work ! It's really awesome !

I was wondering if it would be possible to port that to work with SQLite databases ? I had a quick look at the source, but I guess this is a bit over my level...

I know it is more difficult to get SQLite's databases metadata, but even with less functionality, your script would be very useful !

Thanks !

[steveoc]

grocery_CRUD is built on top of CodeIgniter ... which in turn provides the actual database drivers for a range of different DBs - including SQLite.

If you edit
application/config/database.php

and set the appropriate line to sqllite, it should work !
(should be line 55)

$db['default']['dbdriver'] = 'sqllite';

According to the doco, it should also work with :
['dbdriver'] The database type. ie: mysql. Currently supported: mysql, mysqli, postgre, odbc, mssql, sqlite, oci8

Having said that, there are several internal database calls that grocery_CRUD uses to determine the layout of tables and types of fields - any one of these _may_ be a source of incompatibility, but it does look OK from here. (Havent actually tried to use SQLLite yet)

Have a read of this thread for more info on what may be needed to get it working thoroughly with other databases :
http://www.grocerycr...__fromsearch__1

Try that and let us know how it goes.

[web-johnny]

With SQLLite doesn't work completely.

You can though try to use the set_model function to use your custom model for sqllite, without changing the actual core of grocery_CRUD. There is still not anyone yet to have this model to send it to you or have a link of it.
And to create it, its really easy. Just follow the ERRORS

[wenkhairu]

I was wondering it will work great if we use some custom model in codeigniter, i have made it with SQLServer 2005 before, with some line of code in grocery_crud library it will work

[rolo2012]

I made this model for sqlite3
http://www.grocerycr...rt-for-sqlite3/