Jump to:

558 Posts in 3569 Topics by 244 members

Hosting Requirements

SilverStripe Forums » Hosting Requirements » Europe: needs for SQLite support for try&buy installations

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

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

Page: 1
Go to End
Author Topic: 1906 Views
  • robocap
    Avatar
    Community Member
    1 Post

    Europe: needs for SQLite support for try&buy installations Link to this 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

  • Mo
    Avatar
    Community Member
    508 Posts

    Re: Europe: needs for SQLite support for try&buy installations Link to this post

    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

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Europe: needs for SQLite support for try&buy installations Link to this post

    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

    1906 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.