User Neil McGuigan

43 votes

Accepted

What are Measures and Dimensions in Cubes

answered Jul 3, 2013 at 17:17

36 votes

Accepted

Ready-to-Use Database models example

answered Sep 6, 2012 at 16:56

20 votes

Function Performance

answered Dec 19, 2013 at 18:44

19 votes

Is there a name for this database schema of key values?

answered Jul 12, 2012 at 2:54

18 votes

Accepted

Feasible to have thousands of users in Postgres?

answered Jan 14, 2015 at 19:34

17 votes

Is there any difference at all between NUMERIC and DECIMAL?

answered Aug 29, 2014 at 18:29

17 votes

Accepted

Efficiently storing irregular/repeating intervals (think calendar/events)

answered Mar 30, 2014 at 17:47

16 votes

Accepted

Can a PostgreSQL Trigger be used to ignore an insert?

answered Sep 11, 2014 at 18:34

15 votes

Accepted

PostgreSQL equivalent of MySQL query variables?

answered Aug 27, 2014 at 20:40

14 votes

Plural vs Singular Table Name

answered Jul 17, 2015 at 21:29

10 votes

How to set a search_path default on a psql cmd execution?

answered Apr 24, 2017 at 19:16

9 votes

Accepted

Does PostgreSQL allow multiple grantees in GRANT commands?

answered Aug 9, 2014 at 19:07

9 votes

Accepted

How to create a Postgres trigger to ensure field is non-updateable

answered Aug 21, 2014 at 17:18

9 votes

How to implement business logic permissions in PostgreSQL (or SQL in general)?

answered Apr 7, 2014 at 5:45

9 votes

Accepted

postgresql bigserial or sequence using jpa

answered Apr 10, 2014 at 19:13

9 votes

Best practices on common person fields (Name, email, address, gender etc...)

answered Jun 13, 2012 at 21:01

8 votes

Is polling the only way for updating app's data from a database?

answered Jan 22, 2013 at 19:07

8 votes

PostgreSQL, what is the hostname address of my default database?

answered Mar 31, 2017 at 18:10

8 votes

How to make middle and suffix matching using full text search?

answered Oct 23, 2017 at 19:17

8 votes

Two names for a column

answered Apr 15, 2016 at 0:38

7 votes

Accepted

Is there a term for a table that has an "effective date" column?

answered Feb 28, 2013 at 2:20

7 votes

How do I use an Ispell dictionary with Postgres text search?

answered Jan 19, 2014 at 3:02

7 votes

Multiple instances of same foreign key in a single table

answered Feb 3, 2015 at 22:47

6 votes

Why do large images stored in database hurt performance

answered Nov 4, 2015 at 19:41

6 votes

PostgreSQL: schema diff/patch tool

answered Aug 13, 2014 at 17:44

6 votes

Postgres full text search with multiple columns, why concat in index and not at runtime?

answered Jul 29, 2014 at 18:51

6 votes

Postgres DDL and DML best practices and coding standards

answered Oct 28, 2013 at 17:54

6 votes

Database design - People and Organisations

answered May 2, 2013 at 17:25

6 votes

how to enable temporal database capability in mysql.?

answered Apr 25, 2012 at 17:12

6 votes

How to store and query products the price of which depends on a complex set of conditions?

answered Apr 16, 2012 at 22:51

Stack Exchange Network

192 Answers

What are Measures and Dimensions in Cubes

Ready-to-Use Database models example

Function Performance

Is there a name for this database schema of key values?

Feasible to have thousands of users in Postgres?

Is there any difference at all between NUMERIC and DECIMAL?

Efficiently storing irregular/repeating intervals (think calendar/events)

Can a PostgreSQL Trigger be used to ignore an insert?

PostgreSQL equivalent of MySQL query variables?

Plural vs Singular Table Name

How to set a search_path default on a psql cmd execution?

Does PostgreSQL allow multiple grantees in GRANT commands?

How to create a Postgres trigger to ensure field is non-updateable

How to implement business logic permissions in PostgreSQL (or SQL in general)?

postgresql bigserial or sequence using jpa

Best practices on common person fields (Name, email, address, gender etc...)

Is polling the only way for updating app's data from a database?

PostgreSQL, what is the hostname address of my default database?

How to make middle and suffix matching using full text search?

Two names for a column

Is there a term for a table that has an "effective date" column?

How do I use an Ispell dictionary with Postgres text search?

Multiple instances of same foreign key in a single table

Why do large images stored in database hurt performance

PostgreSQL: schema diff/patch tool

Postgres full text search with multiple columns, why concat in index and not at runtime?

Postgres DDL and DML best practices and coding standards

Database design - People and Organisations

how to enable temporal database capability in mysql.?

How to store and query products the price of which depends on a complex set of conditions?