User peterh

32 votes

Accepted

Drop table taking too long

answered Sep 14, 2018 at 6:52

22 votes

Can CURRENT_TIMESTAMP be used as a PRIMARY KEY?

answered Aug 6, 2018 at 0:48

6 votes

How do I find out how far along my PostgreSQL query is?

answered Sep 19, 2018 at 22:47

4 votes

How to update integer primary key adding 1000?

answered Jun 10, 2018 at 16:05

4 votes

Trying to connect a PostgreSQL database to Eclipse

answered Jul 17, 2018 at 16:05

4 votes

Accepted

How to improve the performance of this select query?

answered Apr 8, 2014 at 12:23

3 votes

Accepted

How to make sqlplus prompt longer than 50 chars?

answered May 6, 2014 at 9:57

3 votes

Accepted

How to make a table that could add many same number of different item?

answered Aug 19, 2018 at 8:47

2 votes

Missing mysqld.sock file on linux server

answered Aug 13, 2018 at 2:31

2 votes

Accepted

recover postgresql database after removal with --purge

answered Aug 18, 2018 at 7:28

2 votes

MySQL CPU usage super high since server crashed

answered Aug 26, 2018 at 10:35

2 votes

How to build the database for subdomain multisite?

answered Jun 10, 2018 at 15:47

2 votes

How to filter for consecuting timeline events in pure SQL?

answered Jun 11, 2018 at 18:47

2 votes

If a database only ever has one insert, is it bad to index every possible column combination?

answered Jun 13, 2018 at 17:47

2 votes

Relations between a imeid, sim chip, and account from a cellphone company?

answered Apr 14, 2014 at 15:24

2 votes

Accepted

How does SQL*Plus connect to Oracle without a listener?

answered May 18, 2015 at 15:02

2 votes

Postgresql create database with size & resize?

answered May 6, 2014 at 6:56

1 vote

Docker for Oracle Timestamp out of sync

answered Jun 8, 2018 at 18:16

1 vote

pgAdmin on a fresh OS X Server installation

answered May 28, 2014 at 9:55

1 vote

How to synchronize a Windows database for Linux?

answered May 29, 2018 at 20:49

1 vote

Accepted

How to change the output encoding of Oracle command line tools to UTF8?

answered Mar 31, 2014 at 10:06

1 vote

Creating a database structure for a quiz

answered Jun 10, 2018 at 16:33

0 votes

When trying to connect to an external postgres database using pgAdmin, I get an error

answered Jun 10, 2018 at 19:08

0 votes

How to optimize and find minimum from the two sql query, by writing it as single query?

answered Jun 10, 2018 at 20:48

0 votes

Accepted

Database Design where there's three parent tables and only 1 child table

answered Jun 11, 2018 at 1:13

0 votes

Accepted

How to store array values?

answered Jun 11, 2018 at 2:53

0 votes

Significantly Slower DB Dumps on AWS RDS After Turning on Encryption?

answered Jun 11, 2018 at 17:37

0 votes

Accepted

Mp3 file directly in a Database Without using BLOB

answered Nov 22, 2018 at 11:30

0 votes

Accepted

Migrating PostgreSQL DB from AWS to Alibaba Cloud

answered Aug 17, 2018 at 20:35

0 votes

Mysql not started after some crash

answered Aug 21, 2018 at 12:37

Stack Exchange Network

39 Answers

Drop table taking too long

Can CURRENT_TIMESTAMP be used as a PRIMARY KEY?

How do I find out how far along my PostgreSQL query is?

How to update integer primary key adding 1000?

Trying to connect a PostgreSQL database to Eclipse

How to improve the performance of this select query?

How to make sqlplus prompt longer than 50 chars?

How to make a table that could add many same number of different item?

Missing mysqld.sock file on linux server

recover postgresql database after removal with --purge

MySQL CPU usage super high since server crashed

How to build the database for subdomain multisite?

How to filter for consecuting timeline events in pure SQL?

If a database only ever has one insert, is it bad to index every possible column combination?

Relations between a imeid, sim chip, and account from a cellphone company?

How does SQL*Plus connect to Oracle without a listener?

Postgresql create database with size & resize?

Docker for Oracle Timestamp out of sync

pgAdmin on a fresh OS X Server installation

How to synchronize a Windows database for Linux?

How to change the output encoding of Oracle command line tools to UTF8?

Creating a database structure for a quiz

When trying to connect to an external postgres database using pgAdmin, I get an error

How to optimize and find minimum from the two sql query, by writing it as single query?

Database Design where there's three parent tables and only 1 child table

How to store array values?

Significantly Slower DB Dumps on AWS RDS After Turning on Encryption?

Mp3 file directly in a Database Without using BLOB

Migrating PostgreSQL DB from AWS to Alibaba Cloud

Mysql not started after some crash