Mike Hoskins
|
| Posted: 01/10/2005, 9:24 PM |
|
Will there be SQLite support in any of the upcoming products?
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 01/10/2005, 10:15 PM |
|
I believe that all databases are supported, as long as you use an appropriate ODBC driver. We've seen some databases being used with CCS of which we never heard of and never tested.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Mike Hoskins
|
| Posted: 01/12/2005, 3:03 PM |
|
What I mean is native SQLite support.
I got SQLite working with ODBC just fine. However, that doesn't help me too much if I have a hosting provider that uses Linux/Unix and refuses to support SQLite.
PHP 5 natively supports it, and it's easy to add to just about any language....
ODBC is one option, and it's nice, especially on Windows systems. However, that doesn't help me out 100%.
|
|
|
|
Mike Hoskins
|
| Posted: 01/12/2005, 3:05 PM |
|
Correction:
However, that doesn't help me too much if I have a hosting provider that uses Linux/Unix and refuses to support ODBC....
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/12/2005, 9:45 PM |
|
I see. From this point of view we probably cannot natively support every possible database via native interface in all the programming languages. There are around 100 database+language combinations used by CCS users therefore we have to focus on those common ones. Since yours is the first request of this type that I see you may want to submit a wish/request to the forums or our support. If there is more demand then of course we'd have to look into it. You could also try to select any other database in CCS (let's say MySQL) and then modify the database classes file, like db_mysql.php, to support SQLite instead.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
roeya
Posts: 181
|
| Posted: 01/18/2005, 8:16 AM |
|
I by mistake add new topic but anyway here is the answer:
I currently use SQLite with CCS & perl, I have installed the ODBC driver so CCS will work with the database, and I use DBI connection string that looks like “dbi:SQLite:dbname=/home/www/site/db/data.db”
To do that I use the Design tab in the “Modify Connection/Add New Connection” dialog to the ODBC connection
And I use the Server tab to set the DBI data source name
I run it locally with Win32 for testing and debugging, the target is FreeBSD (a unix variant).
(I think PHP has similar Tab with Database or ODBC connection name where you should set the Database as you would with PHP when using it without CCS)
_________________
http://www.infoneto.com/ |
|
|
|
|
