544 Posts in 1404 Topics by 235 members
|Go to End|
8 September 2009 at 10:06am
I'm a pretty new SS user (today), but normally I use professionally Joomla and Drupal.
Here in Europe (Italy for me) a typical business with SMI Companies and Local Public Organizations is "try&buy" site development, i.e. you prepare a prototype site, show its use to the customer and let him play for a while before signing/refusing the contract. Typically I don't have any phisical contact with the prospect until he/she call me for signing, nor I want to give a prospect access to my network. Luckily, for this kind of business we can use some Web Hosting Providers offering free web space (100-200 MB) with PHP5 support only (if you want MySql you have to sign a contract and to pay). With these features, I can use only CMSs working with flat files/SQLite and that can easily switch to MySql at any moment. Of course, if a site prepared with say XYZcms is accepted, that site will go on with XYZcms.
As of yesterday, after a couple of attempts with LaniusCMS, I was studying Xaraya for this job: but now that I've seen SilverStripe I feel the urgency to switch to it. Is there any possibility to have SS on SQLite?
Thank you in advance - pls accept my compliments for the excellent job
6 October 2009 at 12:10am
Unfortunately I don't think Silverstripe will run easily on SQLite, although I would love this feature!
You could try setting up an account with a free MYSQL database provider. For example: http://www.freemysql.net/v2/
There are a few of these providers around, I haven't used them myself, and so wouldn't recommend them for a high usage site, but for a prototype I can't see how this would be an issue.
12 March 2010 at 12:54am Last edited: 12 March 2010 12:58am
SQLite support has just recently been added, but it hasn't been tested much on real projects.
However, it has been passing the Sapphire core unit tests suite made up of 700~ tests so far, which is very promising!
If you want to try it out, check out a development copy of SilverStripe 2.4 (http://svn.silverstripe.com/open/phpinstaller/branches/2.4 from SVN) and add the sqlite3 module (or check it out via http://svn.silverstripe.com/open/modules/sqlite3/trunk).
Installation option 2 or 3 on this page should then get you started once you've done this.
The installer doesn't quite work with it yet, but it's on the way.
Any issues, file them in http://open.silverstripe.org, there's a component "Modules - sqlite3" you can file against.
|Go to Top|