Jump to content
vanderbreye

possible: file based instead of sql-database?

Recommended Posts

is it somehow possible to get PW running without SQL - maybe as a file based CMS, saving everything in a single(?) xml or multiple txt files?
i know, there are a lot of downsides using files, but for some small projects it would be a great alternative!

Share this post


Link to post
Share on other sites

There where already requests to support sqlite as second database option, but even this never really found consideration. Also I don't think files would be in any way as performant as a real database, especially if you're talking about a single file. ProcessWire can manage 100.000s of pages. I don't want to imagine a single file with all those information in it. 

Share this post


Link to post
Share on other sites

There was a few topics about this kind of options. Not sure there ever was a conversation about flat files, but this is one about SQLite:

https://processwire.com/talk/topic/858-sqlite-has-ftt-could-it-be-a-viable-alternative-database-backend-for-pw/

The answer to your question is no, it is not possible now (at least as I know it).

Share this post


Link to post
Share on other sites

If this is a requirement for you, give http://getkirby.com/ a try. It's file based, has custom fields and it's API has some things in common with PW.

  • Like 2

Share this post


Link to post
Share on other sites

If this is a requirement for you, give http://getkirby.com/ a try. It's file based, has custom fields and it's API has some things in common with PW.

thanks!

but actually, i try to find an alternative for kirby - which fits for very small projects - but i would love to replace it with PW...

Share this post


Link to post
Share on other sites

thanks!

but actually, i try to find an alternative for kirby - which fits for very small projects - but i would love to replace it with PW...

You found he best alternative to kirby for larger projects (actually, also for smaller projects), you'll just have to live with the database ;)

  • Like 2

Share this post


Link to post
Share on other sites

Databases are cute, cuddly and don't stay out late at night getting into trouble.

Embrace the PW database and give it a nice home!

  • Like 4

Share this post


Link to post
Share on other sites

Yes this question has been answered in the forum already a couple of times.

If you really need a good file based (xml) cms try this one:

http://get-simple.info/

I used it in the past and had good experience with it.

Share this post


Link to post
Share on other sites

Why would small projects need an alternative to ProcessWire and it's requirement for a database? Is there anything specific about the environment you're using (or propose to use) where a database would be an issue?

ProcessWire works as great for small projects as it does for larger ones :)

  • Like 1

Share this post


Link to post
Share on other sites

Interestingly I was thinking about this the other day. A friend has his business page as part of his ISP subscription. He is given very basic tools including being able to point a domain at it, but it has no database.

Mind you, I am not sure it has php either!

I have just done him a sweet little static html page.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By JeevanisM
      Hello All,
      Recently I have read a series of articles about some new terms like Headless CMS, Hybrid CMS and Digital Experience Platforms ( DXP). I cannot get a clear picture of these but I could understand that these are different from the traditional CMS as we use now, at least in theoretical level. Does any one here have any better understanding on these topics ? may be what / how we can apply these on the processwire CMS ?
       
      just for the talk
       
    • By modifiedcontent
      I had upgraded my Apache configuration to include PHP7.2 and PHP7.3 for a Laravel-based script on the same server. Somehow it/I messed up a previously fine Processwire site, in a very confusing way.
      The site still looks fine, but editing template files has no effect whatsoever. It is stuck on some kind of cached version. I have already disabled PHP7's OPcache, cleared browser caches, etc, with no effect.
      The pages now apparently come from PW's assets/cache/FileCompiler folder, even though I never enabled template caching for this site.
      I have tried adding "namespace ProcessWire;" to the top of the homepage template file, but then I get this fatal error:
      My functions.php file pulls data in from another Processwire installation on the same VPS with the following line:
      $othersitedata = new ProcessWire('/home/myaccount/public_html/myothersite/site/', 'https://myothersite.com/'); That apparently still works fine; the site still displays data from the other installation, but via the "cached" template that I am now unable to change.
       
      I don't know where to start with this mess. Does any of this sound familiar to anyone? Any pointers in the right direction would be much appreciated. 
       
      Edit:
      Adding "$config->templateCompile = false;" to config.php results in the same fatal error as above. 
    • By MacLeod
      [GERMAN]
      Hallo Community,
      ich hoffe Ihr könnte mir weiter helfen?
      Ich habe Processwire bei meinen Webhosting Anbieter installiert ohne Probleme.
      Nun wollte ich es bei meinen Local webserver (MAMP 4.1) installieren...
      Leider zeigt er mir einen Datenbank fehler, dass er bestimmte Tabelle nicht finden kann!!!
      (Siehe Bild)
      Kann mir einer sagen, wodurch der Fehler verursacht wirt?
      Habe es auch schon bei einen Kumpel und eine anderen Local Webserver Umgebung Installiert. Immer der Selbe Fehler.
      Gruß
      MacLeod
       
      [ENGLISH]
      Hello Community,
      I hope you could help me further?
      I have Processwire installed at my webhosting provider without any problems.
      Now I wanted to install it on my local webserver (MAMP 4.1) ...
      Unfortunately he shows me a database error that he can not find certain table !!!
      (See image)
      Can someone tell me what causes the error?
      Have it already installed with a buddy and another Local Web server environment. Always the same mistake.
      greeting
      MacLeod
       

    • By Mats
      Hi!
      On a clients multilanguage site, upgrading to latest PW version, started to generate the following exceptions:
      SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pages.has_parent' in 'where clause' (in /wire/core/WireDatabasePDO.php line 480) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pages.has_parent' in 'where clause' (in /wire/core/WireDatabasePDO.php line 480) And this message by the newly created page:
      Name already in use! A sibling page (id=15877) is already using name "my-page-name" for language: English
      Searching the forums the only thing i've found seems related to multi language: 
       
       
×
×
  • Create New...