Reputation
6,130
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
11 30
Newest
 Enlightened
Impact
~423k people reached

Jul
22
answered Constraint on Composite Type
Jul
21
revised How do I know what indexes to create for a table
added 91 characters in body
Jul
14
answered optimizing MySQL for traffic analytics system
Jul
12
comment Dump PostgreSQL without DROP DATABASE
I think DROP DATABASE is included only when you use both -c and -C options on pg_restore. As far as I can tell, pg_dump never includes DROP DATABASE.
Jul
11
comment Is it possible to keep track of changes to tables structure?
In a disciplined development environment, you'd use your version control system--subversion, mercurial, git, even RCS in a pinch.
Jul
10
answered How to estimate/predict data size and index size of a table in MySQL
Jul
9
comment Indexes and Optimizations for Logging System
@ypercube: Right, corrected my answer. Thanks.
Jul
9
revised Indexes and Optimizations for Logging System
MySQL writes to the sort buffer.
Jul
9
comment Storing complex userdata
A to-do application doesn't require a user-defined database. It just requires user-supplied data.
Jul
9
answered Indexes and Optimizations for Logging System
Jul
8
comment Indexes and Optimizations for Logging System
Will you need to sort?
Jul
8
comment Storing complex userdata
I won't speak for other professional developers, but I try to avoid that kind of use case. Letting end users essentially design their own databases has always caused immense pain and suffering.
Jul
8
awarded  postgresql
Jul
2
comment what is the best practice when making changes to the the application and database?
@user24250: Updated answer.
Jul
2
revised what is the best practice when making changes to the the application and database?
TSQL is software development.
Jun
29
answered what is the best practice when making changes to the the application and database?
Jun
27
revised MySQL system date change impact
Link to docs
Jun
27
answered MySQL system date change impact
Jun
27
comment How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
@user2100659: Updated answer.
Jun
27
revised How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Sum minutes to calc elapsed hours.