238 reputation
210
bio website
location
age
visits member for 3 years, 6 months
seen Mar 16 at 13:05

Jan
21
answered Is it better to store images in a BLOB or just the URL?
Jan
20
comment How do you document your databases?
@John Saunders: If you google for "Specifying the Example Database Design" (with quotes!), you should get (probably depending on the country you are) quite at the top (here it was 2nd) a link to google books were you can see their recommendation.
Jan
18
comment How do you document your databases?
@TML: How database documentation should look like, you can read in Applied Mathematics for Database Professionals by Lex de Haan and Toon Koppelaars (by the way a very nice book with a misleading title), but I doubt that (m)any people do it this way.
Jan
18
comment Where can I find database tuning exercises for learning?
A nice book to read about SQL performance tuning is The Art of SQL by Stephane Faroult (with Peter Robson). If a database system is mentioned in the book, it's mostly Oracle. This shouldn't be a problem, but unfortunately there are no exercises...
Jan
14
awarded  Scholar
Jan
14
accepted How can I configure PostgreSQL 9.0 to start automatically under Windows XP?
Jan
14
comment How can I configure PostgreSQL 9.0 to start automatically under Windows XP?
The service was already set to start automatically, but there was a problem with the user (postgresql)/the password, which I solved by setting both to the correct values. Thanks again.
Jan
13
comment How can I configure PostgreSQL 9.0 to start automatically under Windows XP?
Thanks for the answer. I'm looking into it now (the problem is my non-English Windows installation).
Jan
13
comment NULL or NOT NULL by default?
+1: Maybe it's not true for all applications, but for what I'm doing getting consistent/correct data is more important than saving some space or losing some speed.
Jan
13
awarded  Supporter
Jan
12
awarded  Student
Jan
12
asked How can I configure PostgreSQL 9.0 to start automatically under Windows XP?