Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall'
  • Member for 13 years, 3 months
  • Last seen this week
  • United States
7 votes
Accepted

Optimised Schema for City-to-City Distance Table

6 votes

What alternatives exist when a table requires too many foreign keys?

6 votes
Accepted

Defining constraints in `CREATE TABLE` statements

6 votes

Two-sided UNIQUE INDEX for two columns

6 votes
Accepted

How to make it impossible for a postgres user to delete databases?

6 votes

Should I split a single table with an AUTO_INCREMENT PRIMARY KEY into two tables that can be joined on that PRIMARY KEY?

6 votes
Accepted

What is the purpose of the keyword "ID" in PostgreSQL?

6 votes

Is there a tool to check if my database is normalized to the third normal form?

6 votes

Single data type for imprecise date values, as allowed by ISO 8601

6 votes
Accepted

Data validity and accuracy according to database integrity

5 votes

Postgres Server access restricted to only one database from list of databases

5 votes

Which areas of a DBA's knowledge should a developer delve into?

5 votes

Estimate average and median efficiently in Postgres?

5 votes

How to connect to remote PostgreSQL server

5 votes
Accepted

How to tell if database tuning is fruitful (PostgreSQL)

5 votes

History table design for supertype/subtype

5 votes

Is there any rule of thumb to optimize sql queries like this

4 votes

Simple table normalisation

4 votes

BCNF when no keys are available

4 votes

Postgres: Use result of group by as column names

4 votes
Accepted

Limiting number of results in a Partition using OVER(PARTITION BY)

4 votes

Is there a way to avoid duplicating the definition of a foreign key?

4 votes

PostgreSQL 9.1 - Asynchroneous commits performance boost

4 votes

Speeding Up Querying Views

4 votes

What is best practice to organize / normalize database tables?

4 votes
Accepted

Add Check Constraint On Varchar Column to enforce no duplicates

4 votes

Need to Check if a Table Exists Before Deleting a Record

4 votes

Does an Oracle nvarchar2 take twice as much space as varchar2?

4 votes
Accepted

Postgres planer JOIN removal

4 votes

What are the performance considerations between using a broad PK vs a separate synthetic key and UQ?