paul23's user avatar
paul23's user avatar
paul23's user avatar
paul23
  • Member for 5 years, 2 months
  • Last seen this week
  • N.A.
  • Netherlands
16 votes
3 answers
4k 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
342 views

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

2 votes
1 answer
2k views

Select with fallback and default?

2 votes
1 answer
95 views

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

1 vote
1 answer
14k views

GROUP BY after ORDER BY/LIMIT/OFFSEt?

1 vote
3 answers
726 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
155 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
316 views

pg_dump -> import traject using "upsert" paradigm?

0 votes
2 answers
1k views

Select/print data from subquery

0 votes
1 answer
55 views

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

-1 votes
1 answer
378 views

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