Reputation
5,741
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
10 27
Newest
 Custodian
Impact
~294k people reached

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.
Jun
27
revised How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Added output.
Jun
27
answered How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Jun
20
revised Good explanation of cascade (ON DELETE/UPDATE) behavior
Added interpretation.
Jun
20
answered Good explanation of cascade (ON DELETE/UPDATE) behavior
Jun
19
comment Is it ok to let users add new columns and tables to your database?
Yes, but it would need more than one table. The OP seems to be saying that the database his code creates is a single table. (But I might have misunderstood him.)
Jun
19
comment Is it ok to let users add new columns and tables to your database?
The OP said, "An administrative User can go in and hit 'Create Database' (which is basically a table)..." I meant that they're probably better off with a database that's actually a database than with a database that's really just a table.
Jun
19
answered Is it ok to let users add new columns and tables to your database?
Jun
19
comment Deploying database changes in high availability environment
@Chris: When you want to rename a column, you don't rename a column. Column names are part of your public API. Instead, you 1) add a new column with the right name, 2) update it with the right values, 3) add either a trigger that keeps the two columns identical or you add a check constraint that guarantees both columns have the same values. Then 4) change all the applications to use the new column. Finally, 5) drop the old column. You can also use views to provide some logical data independence, depending on what kinds of changes you need to make.