[Typo3-typo3org] Hosting the TYPO3 sites

[Karsten Dambekalns]

Hi Sven.

Sven Wilhelm wrote:
> no not yet. Thats the next part. I've started to migrate the schema to
> Postgres,

I can send you the schema for PostgreSQL, empty as well as with "static"
data.

>> Well, optimizing the schema makes sense for MySQL, too. One *can* have
>> referential integrity enforced with MySQL, too. Would you mind sharing
>> with me what you did so far?
> Sure. I appended a first part of the handmigrated part. With this
> reviewed part most of the other schema parts could be migrated by a sed

Hm. This is the same database schema, just for PostgreSQL. I can create that
by setting up everything with DBAL - and then use manual work rather to add
foreign key constraints, etc. Or am I off track here?

> * Think about benefits such as object-relational stuff (be_***, fe_***)
>   (Important, that could break a migration mysql <-> postgres)

Heh. Object-relational stuff *is* cool, but the we'd probably have to switch
to PostgreSQL in a way like we now depend on MySQL - bye-bye abstraction.

> * Real dependencies inside the database (that breaks typo3 totally :)

What do you mean with "real dependencies"?

Karsten
PS: I'll give you a call next week...
-- 
Karsten Dambekalns
TYPO3 Association - Active Member
http://association.typo3.org/