11,334 reputation
11845
bio website
location Munich
age
visits member for 3 years, 3 months
seen 27 mins ago

1d
comment How do I prove that the act of removing foreign keys doesn't corrupt existing data?
I totally agree. Even if you could get RI right in your application, in my experience any database that contains valuable information will be used by more than just one application.
1d
comment How do I prove that the act of removing foreign keys doesn't corrupt existing data?
Interesting enough I never see this discussion when people are using Postgres, Oracle, DB2 or SQL Server. It's alyways MySQL where this discussion comes up.
1d
comment How do I prove that the act of removing foreign keys doesn't corrupt existing data?
"He's removed them from existing tables to change things and it's caused data corruption [...] so he'd rather not use them." - I don't get it. The FKs were removed, the inevitable data corruption showed up and that's why he doesn't want to use them?
1d
revised Are there any tools to go from ERD to DB design and vice versa?
added 40 characters in body
1d
accepted Why is there a collation conflict between system views
1d
comment Why is there a collation conflict between system views
Ah! Obvious once you know it :) Which also answers my second question: using the database collation for the the result from the "server view" should be safe, right?
1d
asked Why is there a collation conflict between system views
2d
reviewed Looks OK What are valid usage scenarios for HEAP tables?
2d
reviewed No Action Needed Specifying Oracle Service Name in UNIX Profile
2d
comment How do I fix and prevent corrupted MySQL tables?
A first step is probably getting rid of the dreaded MyISAM engine and convert your tables to InnoDB.
2d
reviewed Approve suggested edit on Multiple Queries with overlapping results and column level permissions
Aug
18
revised Passing arguments to psql
edited tags
Aug
18
comment How do I ORDER BY typical software release versions like X.Y.Z?
@JNK: that is what the v[1]::int is about. It casts the string to an integer.
Aug
18
revised How do I ORDER BY typical software release versions like X.Y.Z?
added 77 characters in body
Aug
18
revised Database design Problem for the web-app
edited tags
Aug
18
answered How do I ORDER BY typical software release versions like X.Y.Z?
Aug
18
revised Adding Partitions to an Existing Filegroup
edited tags
Aug
18
answered PostgreSQL SQL syntax - JOIN and substrings
Aug
18
comment PostgreSQL SQL syntax - JOIN and substrings
How do you know that host2 is the destination host for host1? I don't see how you can make that connection.
Aug
18
comment Combine two mySQL sum queries into one which use different where clauses
Please format you queries.