0

Archetypes has a sqlstorage attribute when design the schema,how about the Dexterity?

user1459985
  • 23
  • 4

1 Answers1

2

SQLStorage is deprecated and never really worked in the first place. There is no equivalent for Dexterity, and there will not be. If you need to deploy Plone with a SQL backend, you should use RelStorage, it is modern and battle-tested. http://pypi.python.org/pypi/RelStorage

Jon Stahl
  • 2,090
  • 10
  • 10
  • 1
    I wouldn't say "there will not be." Presumably a class could be created which was both an sqlalchemy ORM-mapped class and a Dexterity content class. But it would take quite some familiarity with multiple frameworks to make it work. – David Glick Nov 21 '12 at 04:56
  • 2
    Well, fair enough. The fact that Shane Hathaway declared this to be "too complicated to be worth pursuing" after several attempts seems like fairly strong, but admittedly not definitive, evidence to me. ;-) – Jon Stahl Nov 21 '12 at 05:51
  • David,do you have any sample about class herient from dexterity and sqlalchemy orm-class. The RelStorage is Last changed at 2011-11-12,does it alive? – user1459985 Nov 21 '12 at 14:01
  • 1
    RelStorage is in active use. Ask for existing users on the user list and you should be able to get practical feedback. – SteveM Nov 21 '12 at 17:20
  • 4
    Be advised that RelStorage is not the same as or in any way equivalent to storing field values in an SQL table. RelStorage simply stores the ZODB in a relational database rather than in a flat file. It is still the ZODB underneath. This is useful for replication and such, but does not mean that the data is in any way 'relational'. – cewing Nov 22 '12 at 05:27