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

Reply via email to