Reputation
3,020
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
8 25
Newest
 Nice Answer
Impact
~93k people reached

8h
answered Performing search on a column by query
9h
comment Performing search on a column by query
Why ta = Entertainment? I would not want or expect that as a search result. Which is why no one else does that. I'm willing to help you if you drop this particular requirement
1d
comment Why is vertical scaling expensive?
Why is a Dodge Viper more expensive than two Kias?
May
5
comment Create a grouping based on chains of pairs
Sounds like time for our friend Recursive CTE
May
1
comment How to edit `postgresql.conf` with pgAdmin?
holy crap. i've been using pgAdmin for 2 years and never knew that. thanks!
Apr
28
answered Database design: Is there a much better way on this current relationships?
Apr
24
comment Users' physical characteristics - design
Ah, the daily EAV question
Apr
23
comment MySQL Brute Force Defense
You could try monitoring mysql log with fail2ban brain.demonpenguin.co.uk/2014/05/01/fail2ban-monitoring-mysql
Apr
23
comment MySQL Brute Force Defense
do they authenticate directly w the db, or with your web server?
Apr
22
comment PostgreSQL security threats in external modules or PL languages
Of course it's a threat. You're installing executable code on your server from another party. If you don't trust the source, pay a security expert to evaluate the code and then compile it yourself.
Apr
18
revised What are Measures and Dimensions in Cubes
edited body
Apr
16
comment Uber-wide tables: Time to switch to Mongo?
There are 5000 possible answers per questionnaire? I'm guessing some are free-form text responses, yes?
Apr
14
comment How to remove duplicates and keep the one with the most additional information
blog.databasepatterns.com/2014/12/… . Instead of two separate tables, join to self
Apr
8
comment Big lists in a relational DB
How's about you do it the standard way, test its performance, then tweak if necessary?
Apr
8
comment Database design import massive csv files is there a more efficient way?
by staging table i mean a short-lived table that you create, mimicking your real table. What do you mean "I can't check the user input"?
Apr
8
comment Database design import massive csv files is there a more efficient way?
Why don't you import it into a staging table (no trigger), then validate it, then move it to the real table?
Apr
7
revised Scalable Relational Database Design
deleted 107 characters in body
Apr
7
revised Scalable Relational Database Design
added 106 characters in body
Apr
7
answered Scalable Relational Database Design
Apr
7
revised Replace SQL Server with another DBMS
deleted 5 characters in body