By chiggsy on

I might be in an unfortunate database challenged environment... can drupal 4.6 work with sqllite?

⋅ Categories: Drupal 4.6.x

Comments

alexmc’s picture

alexmc commented

Do you *really* want to be running a serious website on a server where you cant even run MySQL? Honestly now?

I have no idea if it works or not but I guess not.

stevenpatz’s picture

stevenpatz
he/him
commented

That Postgres is not a serious contender to mySQL.

sevo’s picture

sevo commented

Nobody claimed that...

However, the OP appearently doesn't even have access to MySQL - chances that there is a available PostgreSQL installation on-site are even slimmer...

Unfortunately, Sqllite is no real alternative where no backend can be installed - its limited locking mechanisms will inevitably cause deadlocks in a concurrent access situation (at the very latest when rude crawlers hit the site), and disabling them will rapidly crash the system with duplicates.

You can make it sort of work on a static site for unauthenticated visitors, by scrapping all database writes caused by them (logging etc.) from the code, but for a full-blown Drupal site, I'd rather go with a distant database via Internet than with Sqlite...

Sevo

varunvnair’s picture

varunvnair commented

Consider using a file-based CMS. You can find lot of CMSes on OpenSourceCMS.com. For e.g. you can use Pebble if all you want is only a simply blog.

My Drupal-powered Blog: ThoughtfulChaos

chiggsy’s picture

chiggsy commented

Thanks a lot for the information, I've checked it out and confirmed that i will have a "modern" unix system to work with, so some database will be available. I was kind of curious about sqllite.. too bad

varunvnair’s picture

varunvnair commented

Glad to hear that. MySQL should be your first choice and if that is not available go for PostgreSQL (just my opinion). Is it a Linux box?

My Drupal-powered Blog: ThoughtfulChaos