398 reputation
318
bio website
location London, United Kingdom
age
visits member for 1 year, 4 months
seen 5 hours ago

Mar
28
awarded  Popular Question
Mar
6
awarded  Popular Question
Feb
5
comment Tracking correct order details in commerce database when modifying 'products'
at no point have you mentioned anything about 'Tracking correct order details in commerce database when modifying 'products''. All you've said is 'create a product hierarchy' not very helpful really
Feb
4
comment Tracking correct order details in commerce database when modifying 'products'
-1 no even close to attempting to answer the question
Feb
4
awarded  Benefactor
Feb
4
accepted Tracking correct order details in commerce database when modifying 'products'
Feb
3
comment Tracking correct order details in commerce database when modifying 'products'
ok, makes sense. Can you expand on you answer a little then? Need a few more details to satisfy a 'conical answer' for the bounty
Feb
3
comment Tracking correct order details in commerce database when modifying 'products'
ok, but say i have a product, its price is changed one a year, but it has 50 orders at one price and 50 orders at the other. If we freeze the details in the order, we are saving the same information 50 times, but if we save the changes we only save twice. Thats why i can't understand why the order takes a snap shot. It just seems wasteful as you store the same information over and over again when you could just reference to it?
Feb
3
comment Tracking correct order details in commerce database when modifying 'products'
but if you are going to store the information of a service in EVERY order, is it not better to maintain a history of the changes, and then allow the orders to reference to them? The assumption is that you have more orders than you have price changes so you would store less information if a change table is created?
Feb
3
accepted When should a database table use timestamps?
Feb
3
awarded  Promoter
Jan
30
comment Tracking correct order details in commerce database when modifying 'products'
hmm im not a fan of composite keys. I could have a services table, and a service_descriptions table. The latter has FK to the former?
Jan
30
revised Tracking correct order details in commerce database when modifying 'products'
added 259 characters in body
Jan
30
revised Tracking correct order details in commerce database when modifying 'products'
deleted 874 characters in body
Jan
30
asked Tracking correct order details in commerce database when modifying 'products'
Jan
29
comment When should a database table use timestamps?
would a simple solution be to save any query that updates and table to a log?
Jan
29
revised When should a database table use timestamps?
added 1 characters in body
Jan
29
revised When should a database table use timestamps?
edited tags
Jan
29
asked When should a database table use timestamps?
Jan
8
comment Payment Gateways and RESTful API
cool - i think that solution sounds like the best. I don't have huge traffic, but separation will be easy to do and helps if I need to scale. Thanks