Does any adodb-specialist know, how to modify CMSMS?
Thanks!
I would like to use SQLite
I would like to use SQLite
I would love sqlite support... however...
I use the adodb extension Data Dictionary to create tables and such and have them be cross platform. There is no data dictionary driver for Sqlite, I'm sure because they don't support some stuff like the ALTER command. Until someone writes that driver, you're kind of out of luck.
If you can get the tables created, then it's just a matter of grabbing the regular adodb sqlite driver, putting it into lib/adodb/drivers dir and changing the dbms line in config.php to 'sqlite'.
I use the adodb extension Data Dictionary to create tables and such and have them be cross platform. There is no data dictionary driver for Sqlite, I'm sure because they don't support some stuff like the ALTER command. Until someone writes that driver, you're kind of out of luck.
If you can get the tables created, then it's just a matter of grabbing the regular adodb sqlite driver, putting it into lib/adodb/drivers dir and changing the dbms line in config.php to 'sqlite'.
-
100rk
I would like to use SQLite
...and putting file 'datadict-generic.inc.php' into 'lib/adodb/datadict' also...
Thanks Wishy,
You are right - cross platform is important and nobody knows anything about usage sql command 'ALTER TABLE' (for upgrade scripts) in future... But You (and all of us) can use 'ChangeTableSQL($tabname, $flds)' and 'AlterColumnSQL($tabname, $flds)' ADODB functions instead of SQL 'ALTER TABLE'
I have no time for investigation about '$taboptarray = array('mysql' => 'TYPE=MyISAM');' from most of modules in ADODB manual right now, but I will do it. You know, to be prefectly honest I was hoping for full SQLite support include installation/upgrade, and I was waiting for any how-to experiences without necessity write my own MySQL -> SQLite script.
So, I am thinking about some module named 'Migration', because this strict cross-platform rule is important only in installation/upgrade time
Thanks Wishy,
You are right - cross platform is important and nobody knows anything about usage sql command 'ALTER TABLE' (for upgrade scripts) in future... But You (and all of us) can use 'ChangeTableSQL($tabname, $flds)' and 'AlterColumnSQL($tabname, $flds)' ADODB functions instead of SQL 'ALTER TABLE'
I have no time for investigation about '$taboptarray = array('mysql' => 'TYPE=MyISAM');' from most of modules in ADODB manual right now, but I will do it. You know, to be prefectly honest I was hoping for full SQLite support
include installation/upgrade, and I was waiting for any how-to experiences without necessity write my own MySQL -> SQLite script.So, I am thinking about some module named 'Migration', because this strict cross-platform rule is important only in installation/upgrade time
-
100rk
I would like to use SQLite
Oh, I see I was wrong with ChangeTableSQL ang AlterColumnSQL command....
So module 'Migration' is in my todo list
So module 'Migration' is in my todo list
