xenoterracide

Member for 12 years, 2 months
Last seen more than a month ago

Twitter
GitHub
xenoterracide.com
Indianapolis, IN

Summary

Reputation

2,821

2.8k
2.6k
2.4k

2020
2021
2022
2023

Top tag

postgresql

Next privilege

3,000 Rep.

Cast close & reopen votes

Badges

5

29

32

Newest

Yearling

Next badge

0/1

Excavator

Questions

View all 17 questions

Score Activity Newest Views

60

Is it possible to have passwords configured per database or per host in .my.cnf

Jul 15, 2011

33

How do you test for race conditions in a database?

Jan 4, 2011

32

Source several files at once with psql

Jun 15, 2011

20

How do I find out if a procedure or function exists in a mysql database?

Jan 12, 2011

8

How do I search to see if a MySQL user exists on the system?

Jan 18, 2011

Answers

View all 10 answers

Score Activity Newest

35

Is it a good idea/approach to index a VARCHAR column?

Jan 22, 2011

9

How to version control PostgreSQL schema with comments?

Feb 27, 2011

9

How do I search to see if a MySQL user exists on the system?

Jan 18, 2011

4

A way to reference the ID in a multi insert transaction? (postgres)

Oct 26, 2013

3

Transferring concepts - users/groups/permissions of db objects from mysql to postgresql

Jan 12, 2011

Tags

View all 28 tags

postgresql

55

Score

11

posts

index

35

Score

1

post

query

35

Score

1

post

performance

35

Score

1

post

mysql

12

Score

9

posts

Reputation

+30

Source several files at once with psql

+30

Is it a good idea/approach to index a VARCHAR column?

+10

Is it possible to have passwords configured per database or per host in .my.cnf

+10

ts_rank massively slows my query, how can I improve performance?

Badges

View all badges

5

gold badges

Famous Question

× 5

Apr 4, 2022

29

silver badges

Taxonomist

Jan 30, 2018
Good Question

× 3

May 8, 2019
Good Answer

Jan 13, 2019

32

bronze badges

Precognitive

Jan 4, 2011
Quorum

Jan 21, 2011
Self-Learner

Jan 19, 2011

Accounts

View all 31 accounts

56.9k
72
182
249

15.9k
22
116
235

Role-playing Games

6,351
24
49

Database Administrators

2,821
5
29
32

1,486
2
12
26

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

30

upvotes

8

downvotes

14

question votes

24

answer votes