User Neil McGuigan

3 votes

Accepted

Rewrite sqlite trigger to postgresql

answered Jun 14, 2014 at 21:41

3 votes

How can I fake inet_client_addr() for unit tests in PostgreSQL?

answered Jul 8, 2014 at 22:50

3 votes

Parent/Child table design?

answered Jul 28, 2014 at 15:37

2 votes

Accepted

Securing an Internet Database Connection

answered Jul 23, 2014 at 17:51

2 votes

Need some expert eyes to look at my schema

answered Jun 9, 2014 at 18:02

2 votes

How do I add versioning to this CMS I'm designing?

answered Jul 7, 2014 at 18:14

2 votes

Accepted

How dangerous is it to have a user's password in plaintext in a cgi script?

answered Mar 19, 2014 at 18:06

2 votes

Sync postgreSQL with SQL Server database- on data change event

answered May 6, 2014 at 16:43

2 votes

Accepted

Many-to-many relationship with attributes

answered Aug 30, 2014 at 23:09

2 votes

Full Text Search With PostgreSQL

answered Jul 29, 2014 at 18:56

2 votes

Accepted

How would you normalize a database that has multiple products to a single transaction ID?

answered Feb 9, 2016 at 20:37

2 votes

What's the most efficient way to perform a case insensitive search for a word in a text field?

answered Sep 12, 2015 at 17:31

2 votes

Accepted

postGIS schema qualifier - best practice

answered Aug 18, 2015 at 21:20

2 votes

Database with only text fields

answered Oct 20, 2014 at 17:15

2 votes

Accepted

One field with multiple values?

answered Oct 22, 2014 at 19:39

2 votes

How to save an interval of years in postgresql

answered Oct 1, 2014 at 0:32

2 votes

Accepted

Scalable Relational Database Design

answered Apr 7, 2015 at 4:26

2 votes

Pioneers in Database Research

answered Feb 4, 2013 at 19:48

2 votes

Which database type to use

answered Feb 17, 2013 at 20:44

2 votes

Choice- or ids-list- field representation

answered Feb 19, 2013 at 18:57

2 votes

Accepted

Open source tools to manage Data Quality

answered Mar 1, 2013 at 8:05

2 votes

Accepted

Trying to create a Data Model

answered Apr 8, 2013 at 17:08

2 votes

Accepted

How can I improve this design?

answered Jul 1, 2012 at 21:33

2 votes

What is an effective way of labeling columns in a database?

answered Jan 22, 2013 at 19:32

2 votes

Difference between backup methods: Oracle and MySQL

answered Apr 18, 2012 at 3:12

2 votes

Supertype/Subtype deciding between category: complete disjoint or incomplete overlapping

answered Apr 19, 2012 at 17:54

2 votes

MySql Database solution for specific web app problem

answered Apr 19, 2012 at 18:03

2 votes

How to add FK on a column of composite type in PostgreSQL?

answered Oct 29, 2013 at 20:40

2 votes

Accepted

Dimensional model or Relational model for data warehouse?

answered Nov 7, 2013 at 18:11

2 votes

Automatically generate ALTER TABLE to syncronize schema on PostgreSQL

answered Jan 2, 2014 at 18:30

Stack Exchange Network

192 Answers

Rewrite sqlite trigger to postgresql

How can I fake inet_client_addr() for unit tests in PostgreSQL?

Parent/Child table design?

Securing an Internet Database Connection

Need some expert eyes to look at my schema

How do I add versioning to this CMS I'm designing?

How dangerous is it to have a user's password in plaintext in a cgi script?

Sync postgreSQL with SQL Server database- on data change event

Many-to-many relationship with attributes

Full Text Search With PostgreSQL

How would you normalize a database that has multiple products to a single transaction ID?

What's the most efficient way to perform a case insensitive search for a word in a text field?

postGIS schema qualifier - best practice

Database with only text fields

One field with multiple values?

How to save an interval of years in postgresql

Scalable Relational Database Design

Pioneers in Database Research

Which database type to use

Choice- or ids-list- field representation

Open source tools to manage Data Quality

Trying to create a Data Model

How can I improve this design?

What is an effective way of labeling columns in a database?

Difference between backup methods: Oracle and MySQL

Supertype/Subtype deciding between category: complete disjoint or incomplete overlapping

MySql Database solution for specific web app problem

How to add FK on a column of composite type in PostgreSQL?

Dimensional model or Relational model for data warehouse?

Automatically generate ALTER TABLE to syncronize schema on PostgreSQL