Skip to main content
Database Administrators
paul23's user avatar
paul23's user avatar
paul23's user avatar
paul23
  • Member for 5 years, 6 months
  • Last seen more than a week ago
  • N.A.
  • Netherlands
Profile Activity

14 Questions

Score Activity Newest Views
16 votes
3 answers
5k views

What is the reason to "normalize your databases"?

6 votes
2 answers
3k views

In postgres is there any real drawback on using a json field over multiple tables and one to many relationships?

3 votes
1 answer
355 views

Make a DBMS-enforced multi-column "UNIQUE" constraint, with a "match all" wildcard

3 votes
1 answer
2k views

Select with fallback and default?

2 votes
1 answer
97 views

Can this subquery be optimized by a join? - Even without foreignkeys?

1 vote
1 answer
15k views

GROUP BY after ORDER BY/LIMIT/OFFSEt?

1 vote
3 answers
910 views

update one column based on query containing another (joined) table

1 vote
4 answers
2k views

Get results from "combined, either inner join"

1 vote
1 answer
166 views

Improving database design, is this a valid case for entity attribute values?

1 vote
1 answer
1k views

"merge" two tables -from different databases- together?

0 votes
1 answer
342 views

pg_dump -> import traject using "upsert" paradigm?

0 votes
2 answers
1k views

Select/print data from subquery

0 votes
1 answer
76 views

Should you be liberal with create index and add to many "identifier" columns?

-1 votes
1 answer
393 views

In postgres, is using a lock better than transaction when reading data?