user avatar
user avatar
user avatar
paul23
  • Member for 3 years, 4 months
  • Last seen more than a month ago
  • N.A.
  • Netherlands
16 votes
3 answers
3k views

What is the reason to "normalize your databases"?

6 votes
2 answers
1k views

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

2 votes
1 answer
151 views

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

1 vote
4 answers
750 views

Get results from "combined, either inner join"

1 vote
1 answer
277 views

Select with fallback and default?

0 votes
1 answer
106 views

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

0 votes
1 answer
434 views

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

0 votes
1 answer
100 views

pg_dump -> import traject using "upsert" paradigm?

0 votes
1 answer
80 views

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

0 votes
2 answers
673 views

Select/print data from subquery

0 votes
1 answer
5k views

GROUP BY after ORDER BY/LIMIT/OFFSEt?

0 votes
3 answers
60 views

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