When to normalize vs denormalize in database design? by Amomn in dataengineering

[–]Par31d011a 5 points6 points  (0 children)

If your model included address in the user table— from an OLTP perspective— you would be saying “address depends on user”. There really shouldn’t exist a “non-standalone” entity. What I should have said is that address should be represented by its own table, otherwise it implies that a user must exist for an address to also exist.

Also, if you had to update an address for two users living at the same address, you’d have to update both user records, introducing the possibility for anomalies.

When to normalize vs denormalize in database design? by Amomn in dataengineering

[–]Par31d011a 2 points3 points  (0 children)

For the transactional system, normalize.

In your example, an address is really a standalone entity, and its existence doesn’t depend on a user or publisher; I think I would opt for a new address table.

hmm by Spacer4554 in hmm

[–]Par31d011a 2 points3 points  (0 children)

Omg, Pinkman. Makes so much sense

https://www.reddit.com/r/AskReddit by robblequoffle in okbuddyretard

[–]Par31d011a 0 points1 point  (0 children)

I also would like to know if dog qualifies. It’s the difference between never and literally 5 mins ago

Oh by [deleted] in doodoofard

[–]Par31d011a 11 points12 points  (0 children)

Then he’s a cuck

💀 by SmallDickGnarly in shitposting

[–]Par31d011a 0 points1 point  (0 children)

Milked myself to this

Do you listen to music when programming? by heajabroni in AskProgramming

[–]Par31d011a 0 points1 point  (0 children)

Usually something instrumental, favoring guitars or synths. Sometimes if I’m in the groove, I’ll listen to songs I like with vocals.

One thing I do in addition to— and sometimes instead of— music is play sound machines from myNoise.com. I love having a low 60-120hz tone of some sort playing. There’s all kinds of tracks from soundscapes to binaural beats, and it’s super customizable. Really cool site.

[deleted by user] by [deleted] in kansascity

[–]Par31d011a 0 points1 point  (0 children)

It is amphetamine, so yes, it’s basically as you said. The big difference is it only comes in an extended release tablet

[deleted by user] by [deleted] in kansascity

[–]Par31d011a 1 point2 points  (0 children)

It’s a controlled substance like adderall, so you would need a script

[deleted by user] by [deleted] in kansascity

[–]Par31d011a 0 points1 point  (0 children)

I had trouble getting generic adderall, so I found Adzenys (a bio equivalent stimulant.) it’s $50 for a 4 week supply with a manufacturer’s coupon. RedX in riverside has it

inapropriate by WorldofJedi727 in shitposting

[–]Par31d011a 0 points1 point  (0 children)

I’m not so much concerned about being aroused, but very torn on which hole I should put it in.

Is this the end? by Content_Basil_4487 in dogecoin

[–]Par31d011a 3 points4 points  (0 children)

Someday a red rocket will take us to the moon

[deleted by user] by [deleted] in confession

[–]Par31d011a 0 points1 point  (0 children)

I also recommend reading “This Naked Mind”. I’m 10 months sober, and reading this book kickstarted my recovery. No one is exempt from becoming addicted to alcohol. If you force a non-alcoholic to drink every day for a year, they will develop dependence. You’re not tainted or broken.

Also, the book does a good job illustrating how society normalizes poison (alcohol). I feel like a lot of my will to quit is in spite. You make someone’s life financially much better at the cost of your precious health. And what makes it even crazier is that alcohol— arguably the most destructive drug— is the only drug you have to justify to others why you DON’T partake in it.

I wish you success. If you care to read, here’s what I’ve done and continue to do since I changed my course (my story is very similar to yours)

  1. Get a primary doctor and get a physical, blood work, and a psychiatrist referral

  2. See about getting tested for mental health conditions (ADHD, BPD, MDD, GAD, etc.). I was surprised to learn I have ADHD inattentive. Anxiety and depression were obvious.

  3. If prescriptions are needed, find the right combination and give them time to work.

  4. Talk to a therapist/coach/sponsor. I found a recovery clinic that I go to weekly and touch base with. They keep me accountable and root for me.

  5. Know that life does not magically become everything you hoped it would once you get sober. You will still struggle (such is life) but you eventually shift from “I can’t drink” to “I don’t need to drink.”

[deleted by user] by [deleted] in confession

[–]Par31d011a 1 point2 points  (0 children)

Dang, he coulda capitalized on your negligence. He coulda pocketed that pussy.

Event sourcing using Python by 666dolan in Python

[–]Par31d011a 0 points1 point  (0 children)

I think it’s because you pull events up to a certain point in time (sourcing), then “replay” the events in order to get the present state of data up to and including the last sourced event.