Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Hosting Requirements

What you need to consider when choosing a hosting provider and plan.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Europe: needs for SQLite support for try&buy installations


Reply

3 Posts   1916 Views

Avatar
robocap

8 September 2009 at 10:06am Community Member, 1 Post

Hi,
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

Avatar
Mo

6 October 2009 at 12:10am Community Member, 509 Posts

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.

Cheers,

Mo

Avatar
Sean

12 March 2010 at 12:54am (Last edited: 12 March 2010 12:58am), Forum Moderator, 921 Posts

Hi guys,

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 [url=http://silverstripe.org/sqlite-database/]sqlite3 module[/url] (or check it out via http://svn.silverstripe.com/open/modules/sqlite3/trunk).

Installation option 2 or 3 on [url=http://doc.silverstripe.org/doku.php?id=modules:sqlite]this page[/url] 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 [url]http://open.silverstripe.org[/url], there's a component "Modules - sqlite3" you can file against.

Cheers,
Sean