On 10/19/10 1:22 PM, Brion Vibber wrote:
On 10/11/10 11:05 AM, Brion Vibber wrote:
I'd love for folks working with PostgreSQL (or with other experimental
backends) to poke around at my 'schema-x' work branch and send feedback
or fixes. Thoughts and ideas about slightly-funky stuff like binary
blobs, enums, and db-specific fulltext indexing are especially
welcome. :)
A little update on how it's going, with some samples:
http://leuksman.com/log/2010/10/19/statusnet-schema-x-branch-in-progress/
I got the installation working and confirmed that the basic OStatus
send/receive tests pass when running under a fresh 1.0.x install with
the schema-x stuff merged in... which makes me happy. :)
I've gone ahead now and merged schema-x into the mainline 1.0.x. It'll
need some more fixes to support setting up the fulltext indexes for
PostgreSQL, but otherwise seems to now be working reasonably well.
As a compromise I've gone ahead and continued using a 'timestamp' type
separate from 'datetime' for the 'modified' columns -- however not
filling that column ourselves and letting the DB do it has a number of
known problems with caching, so we might want to think about just making
them regular old datetimes as well.
The old .sql files are still there, and some plugins might have some
issues with auto conversion of the old schema format, so keep an eye
out. There's gonna be more cleanup needed as we tidy up 1.0.x branch
towards the end of the year!
-- brion
_______________________________________________
StatusNet-dev mailing list
StatusNet-dev@lists.status.net
http://lists.status.net/mailman/listinfo/statusnet-dev