<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Yes it is publicly accessible. The wiki is at <a href="http://icare.org/wiki/index.php?n=Main.HomePage">icare.org/wiki</a> and the site is at <a href="http://icare.org/">icare.org</a>. You will will get a better feel for the wiki site if you login with:<div><br></div><div>username: demo</div><div>password: demo</div><div><br></div><div>Then you will be able to see the researchers and the maps will work. This is because they are generated by pagelists which in turn read addresses as page text variables which are only accessible if you have read permissions. </div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>If you were curious, the site is for a cancer organization called icare. I am trying to help them get started with a website and a functional and scalable way of storing their information. They want to set up and manage a network of doctors and researchers around patients with various forms of cancer.</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Sqlite is very efficient in my case. It sped up the rendering of the pagelists and maps tremendously. This is because of what is mentioned earlier about the page text variable searching. It would probably be worth the effort (for me at least) to modify the sqlite recipe to store page text variables in the way it stores page variables. That would speed things up even more for me, but for now, this works fine. </div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>I will also be storing usernames and passwords as page text variables thanks to a new recipe would like to publish within over the next day or two.</div><div><br></div><div>Thanks for all your help,</div><div>Alex<br><div><br></div><div><br><div><div>On Aug 10, 2012, at 4:40 PM, ABClf wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>I'm curious ;)<br>Alex, is your pmwiki install public on internet ; can we see ?<br>Is sqlite efficient in your case ?<br><br>Thank you.<br><br>Gilles.<br><br>2012/8/8 tamouse mailing lists <<a href="mailto:tamouse.lists@gmail.com">tamouse.lists@gmail.com</a>>:<br><blockquote type="cite">Yes, I was wondering about that. Thanks for clarifying.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On Aug 7, 2012 5:30 AM, "Alex Eftimiades" <<a href="mailto:alexeftimiades@gmail.com">alexeftimiades@gmail.com</a>> wrote:<br></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">As I mentioned in previous questions, my wiki does a pagelist (or two)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">every time a page loads. It usually does a search for back links and/or<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">pagetextvariables. My goal was to make the system more scalable at such<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">point that I have several thousand, or even a million pages.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">So in short, I was under the impression that databases are good for<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">searching, and my wiki is structured around a lot of searching.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Alex<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">On Aug 7, 2012, at 8:17 AM, tamouse mailing lists wrote:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I am curious: what advantage were you seeking by using a database store<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">for the pages?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">On Aug 6, 2012 7:12 PM, "Alex Eftimiades" <<a href="mailto:alexeftimiades@gmail.com">alexeftimiades@gmail.com</a>><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">wrote:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"> I just got the sqlite recipe working with all the pages switched<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">over to the database, and after looking at the database structure, I thought<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">it was odd that it did not use separate tables for different groups. I would<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">think this would cut down on the time it takes to access pages, but I could<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">be wrong. I do not know very much about databases in general. I was just<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">wondering whether this was worth working on.<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Thanks,<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Alex<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">pmwiki-users mailing list<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><a href="mailto:pmwiki-users@pmichaud.com">pmwiki-users@pmichaud.com</a><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><a href="http://www.pmichaud.com/mailman/listinfo/pmwiki-users">http://www.pmichaud.com/mailman/listinfo/pmwiki-users</a><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">pmwiki-users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:pmwiki-users@pmichaud.com">pmwiki-users@pmichaud.com</a><br></blockquote><blockquote type="cite"><a href="http://www.pmichaud.com/mailman/listinfo/pmwiki-users">http://www.pmichaud.com/mailman/listinfo/pmwiki-users</a><br></blockquote><blockquote type="cite"><br></blockquote><br><br><br>-- <br><br>---------------------------------------<br>| A | de la langue française<br>| B | <a href="http://www.languefrancaise.net/">http://www.languefrancaise.net/</a><br>| C | <a href="mailto:languefrancaise@gmail.com">languefrancaise@gmail.com</a><br>---------------------------------------<br></div></blockquote></div><br></div></div></body></html>