Page head image

One reason why I moved away from OX5

(3 comments)

I don't understand much about SQL, but even I know it's not supposed to be done like this...

CREATE TABLE prg_knowledge (
creating_date timestamp with time zone,
created_from text,
changing_date timestamp with time zone,
changed_from text,
user_right text,
group_right text,
sid text,
tid text,
order_crit text,
timestampfield01 timestamp with time zone,
timestampfield02 timestamp with time zone,
intfield01 integer,
intfield02 integer,
intfield03 integer,
intfield04 integer,
intfield05 integer,
intfield06 integer,
field01 text,
field02 text,
field03 text,
field04 text,
field05 text,
field06 text,
field07 text,
field08 text,
field09 text,
field10 text
);

And that's just one of numerous tables where all of the relevant information (including the relations to other tables) is stored in intfield* and field*. Granted, OX6 has fewer tables like this. But it doesn't work for me. And there is no migration tool from the old open-xchange version to OX6, thus I would have had to do what I had done today anyway: getting data from the old database and convert it to something that can be imported by the new system. At least the data base schema of Horde is much better than the OX one.

Oh, and I picked up a new DSL modem from my provider this morning. M-Net probably is a bit more expensive than their competitors, but their service is outstanding.

Comments

footpad.livejournal.com 11 years, 9 months ago

*convulsive twitch*

Link | Reply

lynard-.livejournal.com 11 years, 9 months ago

ouchouchouch.... that looks nearly like our plm system - i guess someone who sees databases as a simple storage and who has no knowledge about how to normalize data has created this, hmm?

Link | Reply

woelfisch.livejournal.com 11 years, 9 months ago


Dies ist psql 8.3.1, das interaktive PostgreSQL-Terminal.

Geben Sie ein: \copyright für Urheberrechtsinformationen
\h für Hilfe über SQL-Anweisungen
\? für Hilfe über interne Anweisungen
\g oder Semikolon, um eine Anfrage auszuführen
\q um zu beenden
postgres=# DROP DATABASE openexchange;
DROP DATABASE
postgres=#

Link | Reply

New Comment

required

required (not published)

optional