| # |
Mar 4th 2018, 17:55 |
 savant |
cant do it if you are serializing that data |
| # |
Mar 4th 2018, 17:55 |
savant |
some months down the line, you want to figure out how many widgets you sold in March |
| # |
Mar 4th 2018, 17:55 |
savant |
thats stored in a serialized column somewhere and thats it |
| # |
Mar 4th 2018, 17:55 |
savant |
and someone buys 10 widgets |
| # |
Mar 4th 2018, 17:55 |
savant |
lets say you have a store and you sell widgets |
| # |
Mar 4th 2018, 17:55 |
savant |
not really, but if you ever find you need to query for something in there, its harder |
| # |
Mar 4th 2018, 17:54 |
makallio85 |
Probably my question is here, is it stupid to store serialized objects to database of metadata? |
| # |
Mar 4th 2018, 17:54 |
savant |
dont allow anyone to change the data in the database once the user is accepted? |
| # |
Mar 4th 2018, 17:53 |
makallio85 |
I think querying metadata is not something I need, probably just regeneration of pdf |
| # |
Mar 4th 2018, 17:52 |
makallio85 |
And if I choose not to store pdf's anywhere but only create "on the fly" based on metadata |
| # |
Mar 4th 2018, 17:52 |
makallio85 |
What about data revisions? I mean that, if user changes some data in database and after that meta data is not same as it was in time when invoice was created. |
| # |
Mar 4th 2018, 17:50 |
savant |
i would store it as you would anything else so that you can easily query it |
| # |
Mar 4th 2018, 17:50 |
savant |
thats the same as any other data? |
| # |
Mar 4th 2018, 17:49 |
makallio85 |
Sorry about lame explanation |
| # |
Mar 4th 2018, 17:49 |
makallio85 |
Yeah, I mean when you have for eg invoice that user has accepted (no changes anymore), and I need to store metadata for pdf version of it |
| # |
Mar 4th 2018, 17:48 |
savant |
final invoice related static data? |
| # |
Mar 4th 2018, 17:48 |
makallio85 |
Not recessarily cake related question but how would you guys store final invoice related static data to database? Separate tables as usual or static data in single column? I see pros and cons for both approaches but i would like to hear about how other people has resolved this issue. |
| # |
Mar 4th 2018, 04:54 |
savant |
night! |
| # |
Mar 4th 2018, 04:54 |
slackebot |
Action: neothermic sleeps |
| # |
Mar 4th 2018, 04:54 |
neothermic |
Tomorrow it is then :slightly_smiling_face: |
| # |
Mar 4th 2018, 04:54 |
savant |
the kitchen is closed |
| # |
Mar 4th 2018, 04:54 |
neothermic |
it's never too late for wings, unless the place is closed :P |
| # |
Mar 4th 2018, 04:54 |
savant |
its too late for wings tonight |
| # |
Mar 4th 2018, 04:54 |
savant |
tomorrow! |
| # |
Mar 4th 2018, 04:53 |
neothermic |
o/ @savant Thank you for the rubber ducking/useful suggestion by proxy :slightly_smiling_face: Hope you get good wings. |
| # |
Mar 4th 2018, 04:07 |
savant |
nice |
| # |
Mar 4th 2018, 04:06 |
neothermic |
my situation has improved, I have chocolate and a drink |
| # |
Mar 4th 2018, 04:01 |
savant |
16km/h |
| # |
Mar 4th 2018, 03:59 |
neothermic |
it's 7c outside for me right now, but also 8m/s winds |
| # |
Mar 4th 2018, 03:58 |
savant |
and im getting wings tomorrow anyhow |
| # |
Mar 4th 2018, 03:58 |
savant |
its very windy |
| # |
Mar 4th 2018, 03:58 |
neothermic |
that's warm |
| # |
Mar 4th 2018, 03:58 |
savant |
its 5 degrees celsius outside |
| # |
Mar 4th 2018, 03:57 |
savant |
ive been telling myself that all night |
| # |
Mar 4th 2018, 03:57 |
neothermic |
... how fast are the winds and how good are the wings? :) |
| # |
Mar 4th 2018, 03:57 |
savant |
yeah there is a _really_ good wings place around the corner |
| # |
Mar 4th 2018, 03:57 |
neothermic |
thought you were implying it was too windy to fly |
| # |
Mar 4th 2018, 03:57 |
neothermic |
oh, food |
| # |
Mar 4th 2018, 03:57 |
neothermic |
get wings? |
| # |
Mar 4th 2018, 03:57 |
savant |
im only here because its too windy to go outside and get wings |
| # |
Mar 4th 2018, 03:56 |
savant |
take care of yourself, working nights is bad :slightly_smiling_face: |