Jack Douglas

Maidenhead, United Kingdom

http://maidenhead.heartchurch.org.uk

I'm pastor of Heart Church, Maidenhead, England, which is committed to declaring the whole counsel of God.

I will be blogging regularly through the planting process on the church website.

top accounts reputation activity bookmarks subscriptions

Should binary files be stored in the database?

database-design blob asked Apr 29 '11 at 12:02

dba.stackexchange.com

136 votes

Can we add 'asked', 'answered', 'edited' text to each question featured on the front page?

feature-request status-completed user-interface bump active asked Aug 27 '12 at 11:11

meta.stackexchange.com

104 votes

Can we exempt downvoted accepted answers from getting the top spot?

feature-request status-declined down-votes accepted-answer asked Apr 30 '13 at 7:37

meta.stackexchange.com

84 votes

Time to fork Markdown?

feature-request markdown asked Apr 19 '14 at 14:16

meta.stackexchange.com

46 votes

How could DBAs be more 'programmer friendly'?

database-design best-practices database-administration asked May 2 '11 at 11:05

dba.stackexchange.com

37 votes

What were the historical reasons why the Book of Enoch was excluded from most Christian canons?

canonicity pseudepigrapha 1-enoch asked Apr 15 '14 at 13:47

hermeneutics.stackexchange.com

36 votes

Should every table have a single-field surrogate/artificial primary key?

database-design primary-key surrogate-key asked Sep 23 '11 at 21:25

dba.stackexchange.com

31 votes

How to implement a 'default' flag that can only be set on a single row

constraint database-agnostic referential-integrity asked Aug 19 '11 at 12:41

dba.stackexchange.com

23 votes

Does Gen 1:1 refer to day 1 or the entire 6 days of creation?

genesis hebrew creation asked Feb 16 '12 at 18:19

hermeneutics.stackexchange.com

21 votes

Automatic system-generated bounties on old, highly-upvoted, unanswered questions in small sites

feature-request bounty unanswered-questions asked Aug 13 '14 at 9:00

meta.stackexchange.com

Top Answers

397

How to insert values into a table from a select query in PostgreSQL?

dba.stackexchange.com

150

List the database privileges using psql

dba.stackexchange.com

105

How do I get the current unix timestamp from PostgreSQL?

dba.stackexchange.com

How can I time SQL-queries using psql?

dba.stackexchange.com

Is there Markdown to create tables?

meta.stackexchange.com

What was Jesus referring to by “the eye of the needle”?

hermeneutics.stackexchange.com

How can I use a default value in a Select query in PostgreSQL?

dba.stackexchange.com

How can I convert a string to a double precision in PostgreSQL?

dba.stackexchange.com

How should I best name my timestamp fields?

dba.stackexchange.com

Eliminate duplicates in ListAgg (Oracle)

dba.stackexchange.com

Can spatial index help a “range - order by - limit” query

dba.stackexchange.com

Remove all migration targets except Meta Stack Overflow

meta.stackexchange.com

How to insert (file) data into a PostgreSQL bytea column?

dba.stackexchange.com

Why is Database Administration so hard?

dba.stackexchange.com

What are the arguments against or for putting application logic in the database layer?

dba.stackexchange.com

What is the Biblical basis for the doctrine of the Trinity?

christianity.stackexchange.com

Did Adam and Eve not have sex in the Garden of Eden?

hermeneutics.stackexchange.com

Why has traffic on my site spiked suddenly?

meta.stackexchange.com

Pass an array or record to a function in PostgreSQL?

dba.stackexchange.com

Avoiding multiple `or` expressions

dba.stackexchange.com

What is the 'cock's crow'?

hermeneutics.stackexchange.com

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

dba.stackexchange.com

What does Jesus mean by “generation” when talking about the destruction of the temple and the end of the age?

hermeneutics.stackexchange.com

What risks are there if we enable read committed snapshot in sql-server?

dba.stackexchange.com

Distinguish close votes by reason

meta.stackexchange.com

Error Code 1117 Too many columns; MySQL column-limit on table

dba.stackexchange.com

Is there a reason to use extremely abbreviated table names?

dba.stackexchange.com

Redesigned community bulletin

meta.stackexchange.com

What storage engines work with Oracle?

dba.stackexchange.com

Why does TSQL return the wrong value for POWER(2.,64.)?

dba.stackexchange.com

current community

your communities

more stack exchange communities

Stack Exchange

Jack Douglas

Should binary files be stored in the database?

Can we add 'asked', 'answered', 'edited' text to each question featured on the front page?

Can we exempt downvoted accepted answers from getting the top spot?

Time to fork Markdown?

How could DBAs be more 'programmer friendly'?

What were the historical reasons why the Book of Enoch was excluded from most Christian canons?

Should every table have a single-field surrogate/artificial primary key?

How to implement a 'default' flag that can only be set on a single row

Does Gen 1:1 refer to day 1 or the entire 6 days of creation?

Automatic system-generated bounties on old, highly-upvoted, unanswered questions in small sites