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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Hosting Requirements /

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

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

Europe: needs for SQLite support for try&buy installations


Go to End


3 Posts   3279 Views

Avatar
robocap

Community Member, 1 Post

8 September 2009 at 10:06am

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

Community Member, 541 Posts

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.

Cheers,

Mo

Avatar
Sean

Forum Moderator, 922 Posts

12 March 2010 at 12:54am

Edited: 12/03/2010 12:58am

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 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.

Cheers,
Sean