Reputation
1,571
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 8
Newest
 Enlightened
Impact
~142k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Dec
15
awarded  Enlightened
Dec
15
awarded  Nice Answer
Feb
27
awarded  Yearling
Jun
16
answered Review database schema / thought process
Jun
14
comment Review database schema / thought process
1. Are nodes shared across graphs or does each graph have its own nodes? 2. Are there any patters for users or groups gaining access to graphs, or it totally random?
Apr
4
comment Foreign key with multiple table options
You can try to use triggers which can lead to a host of problems, however I would recommend putting that kind of logic into the application code or middle layer since its not native database functionality
Feb
27
awarded  Yearling
Aug
25
answered Managing constants changes to database
Aug
25
answered Restrict access to rows by usename
Aug
22
awarded  Revival
Mar
26
comment InnoDB best index practises
You also want to create indexes on columns with similar data which can be grouped together to make the indexes more efficient
Mar
25
revised Rent weekly cost database design
updated to accomodate new rules for using coefficients based on the building in which the room is located
Mar
25
comment How to write this self join based on three columns
Are there any instances in which an id can have a different parent for each language, say id 5 has parent with id 1 for language 1 and parent with id 4 for language 2?
Mar
15
answered Rent weekly cost database design
Feb
27
awarded  Yearling
Feb
19
answered An admin (GUI or shell tool) for managing all kinds of databases
Jan
29
comment Is it OK to keep a value which updates in a table?
Chris and @JNK very well put, explained it a lot better than I did
Jan
29
answered Is it OK to keep a value which updates in a table?
Jan
29
comment Coding an accounting database from scratch?
To add onto what @Catcall is saying, pick an off the shelf accounting software specifically for the type of practice you are running, down to having it hosted online so that all you pay is a monthly/annual subscription fee and spend your time healing people and growing your practice
Jan
25
comment What MySQL storage engine should I choose?
@brabertaser1992 I am not sure whether the InnoDB cache is persisted after a server restart, however this may help for the latest 5.6 version of MySQL which is going GA in a few weeks dev.mysql.com/doc/refman/5.6/en/innodb-performance.html and dev.mysql.com/doc/refman/5.5/en/innodb-performance.html for 5.5