On Jun 3, 2:52 am, Oveek <[email protected]> wrote: > I'm glad you started working on this when you did, because I was > thinking about it as well. To use TiddlyWeb seriously--my intended use > case is as a collaboration tool in a corporate environment--I think a > database backend becomes necessary.
This seems to be the general consensus, although its mostly speculation. There are definitely hotspots in the text store when bags gets especially large or the number of revisions per tiddler gets especially high. I meant to update http://tiddlyweb.peermore.com/ to use the sql store last night, but got distracted writing a thing called multistore which lets you write to or read from multiple stores.[1] > Before I plunge in I just wanted to find out what the situation is > generally? I'd like to try using PostgreSQL instead of MySQL. According to the SQLAlchemy docs, using PostgreSQL should "just work" by changing the db_config part of server_store in tiddlywebconfig.py: 'server_store': ['sql', {'db_config': 'sqlite:///test.db'}], This section of the SQLAlchemy docs has more detail: http://www.sqlalchemy.org/docs/05/dbengine.html#supported-dbapis Please report on how it goes for you. Thanks! [1] http://github.com/tiddlyweb/tiddlyweb-plugins/tree/master/multistore --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TiddlyWikiDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/TiddlyWikiDev?hl=en -~----------~----~----~----~------~----~------~--~---
