480 karma · joined July 25, 2015
The law is broken and needs to change.
Edit: reading in another thread that perhaps this is content ID. Not that, that is any better.
For foreign key constraints you can set the foreign key to null and orphan the records if the relation is deleted. You could also hard delete them in this case. It depend on your use case.
When the data volume grows or the ratio of soft deleted to normal records is high, you should consider another solution. One solution you suggested, moving the record to a deleted table is a fine one.
The other solution that I've used successfully is to journal your deletions in another table or system. For smaller volumes having an audit table Journaling the data and storing the pk, fkeys, and a serialized version of the record, json works great in postgres, works well. For large volumes or frequent deletions something like Kafka or PubSub work better.
You may very well find others interested in consuming your audit journal to track changes. Updates and even inserts fit great in the more general case.
I find understanding people and effectively communicating essential skills in business. Also I think starting a business is different from running a successful established business, which is further different from running a large corporate entity. But in all of them you have to have a vision for where the company should go. Your idea should be something people need/want/don't realize they want. You have to be able to outline what's important and be able to get that out of others. You can't do it all yourself.
Though I don't think I'd call those interpersonal relationship skills "attitude".
taking a job under someone else's identity is illegal in the US and claiming you were deep faked if caught isn't likely to work.
All without a written agreement? I'm surprised you could get people to work with you.
Your offer letter usually functions as an employment contract. The thing that spells out your start on a specific date, and we will pay you some amount in some given manner.
It really depends on your local labor laws, which vay from state to state.
Faking your identity in the US for a job is breaking several laws. Explaining this behavior by saying "I was deep faked" probably won't satisfy law enforcement or the IRS.
Taking multiple jobs under your legal identity isn't in and of itself illegal. But you may be in violation of your employment contract. Meaning it's probably, depends on local laws, not illegal but gives cause to terminate you and possibly be sued.
What about the IRS and employment tax your employer pays going to the wrong tax ID that should be reported to you?
I'm sure in some situations it'd work (1099, physical paycheck, lax process), but it seems like you're just setting yourself up to have to break more laws.
You'd be better off just using your own name and keeping a low profile online.
At least then you'd probably only be in violation of your employment contract.
It's stuff like this that's going to make providing recent bank statements and tax records a more common requirement for hire. :-(
Can you determine I know what I'm talking about and can do the work without doing a 4h unpaid hoop? You should be able to ask probing questions and pretty quickly have a rough idea of if I've worked with this stuff or not.
I talked in an exit interview. I got exactly what I wanted but eventually regretted it.
I was tasked with building a data warehouse to replace our existing reporting process: a multi-day run access database.
I was young, excitable, and very talented. I was a sponge. It was easier to do things by myself than explain how a star schema worked to others, although I tried.
As the project proved successful and the team grew, I desperately wanted more responsibility and leadership. I had built the whole thing from the inception. But my boss and bosses manager, the VP of Engineering, didn't trust me. They lied, constantly moved the goal post, asked for ridiculous hours, expected me to work most weekends, and kept promising you'll be leading this team soon just hang in there.
Things degenerated to the point where the VP of Engineering was actively trying to fire me, but the COO and CEO wouldn't let him. The project was too high value and I built most of it. I know this because he taunted me with it. On two different occasions they tried to hire a replacement. "New guy is your peer. He's not your boss." Later I learned the new guy was told the opposite.
Still throughout the turmoil I had made friends with a many of my coworkers. I became especially close with the IT Director. At one time he out ranked the VP of Engineering and was his mentor. They still talked, but werent close like they used to be. The IT Director also became a kind of mentor to me. He was the first to prod me to leave.
And despite the toxic work environment our data warehouse had become a cornerstone of the companies business. We expanded from fixing a single long running report to being the database of record for all analytics in the company.
Still my title and salary remained the same as when I started the project.
Fed up, I finally got my resume together and found a new job. I had several documented incidents of their misbehavior. Eg anonymously, falsely accusing me of harassment. Or threatening to withhold pay for hours already worked unless some goal was met.
I laid it all out in my exit interview. Especially focusing on the things that could have had legal standing. The VP of HR soaked it all in, nodded and asked probing questions.
A few months went by. I met up with my old coworkers for lunch. They began to tell me how everything changed after I left. The CxOs became hyper focused on the team. HR started sitting in on meetings and executives would randomly show up to stand ups. But most revealing is they shared that the decision had been made by the COO to replace the VP of Engineering. Another VP had been hired and was quietly attending all meetings. The existing VP of Engineering had no idea he was training his replacement.
I was still in touch with the IT Director. I knew he still talked with the VP of Engineering on occasion. I shared with him, "You know that new guy? I have it on good authority that the COO hired him to replace the VP of Engineering." "How do you know" he asked? "I had lunch with most of my old coworkers and they said so."
I was being manipulate and hoping to cause drama. I wanted to cause the VP of Engineering as much grief as possible. No simple "you're fired" for him. This would be messy.
And I got exactly what I wanted. It caused chaos. The COOs plan for a quiet transition had been ruined. Multiple shouting matches ensued. The drama was so bad that the new guy replacement quit.
But what I hadn't considered was the fall out. Multiple of my coworkers really liked the new guy and were hoping he would fix things. After the new guy quit the VP of Engineering decided that switching to PHP from RoR for the front end would fix things. He fired many of my old coworkers.
They were furious with me. They didn't know how but they knew I was to blame. I burned multiple good references, professional acquaintances, and friends.
But most costly was my friendship with the IT Director. It ended our friendship.
I eventually tried to apologize. A few of them accepted my apology but for most the damage had been done.
It REALLY wasn't worth it.
What I really needed was an older more mature adult to guide me. I needed to learn healthy boundaries, how to communicate better, how to LISTEN, and think before I act. These are the skills that I needed and many "engineers" need to improve.
Be secure in yourself. You are enough. You don't need anyone to tell you that.
Communication is more than just talking at people. It's about having healthy boundaries, positive conflict resolution styles, being able to reach a decision quickly and explain it clearly and concisely to others. It'd about anticipating blockers and clearing them, streamlining process to keep things moving, being accountable and presenting security in yourself and your actions even if you might doubt them. But most of all its about listening and letting the team do their jobs.
In my opinion tech debt is the result of a choice. Tech debt is the remainder of a solution modulo good enough. You choose to do something you consider less than perfect with the understanding that you're just delaying some of the work until later. That left over work is Tech debt.
For example, we need to implement auth on our web app, but let's hard code the permissions and do RBAC later. That's hard and not really valuable with such a limited feature set. RBAC in your web app is therefore Tech debt.
Good luck with your rewrite but can we have a return to the simplicity of synergy 1?
My experience has been that once someone is a few years in to the industry, their degree or lack of one is largely unimportant. Schools and especially boot camps simply cannot compare with hard earned experience.
I'm never dishonest about my school experience although I do not mention it unless I'm asked about it or someone assumes I have a degree.
Interviews are largely about connecting with the interviewer and getting them to like you, consider you as someone they would want to work with.
Focus on what you have done, how you solve problems, how you work with others. Are you up front when you don't know something? Can you consider another's viewpoint and even change your mind? What is your reaction to making a mistake? Confidence and security in one's self go a long way here. Let your curiosity be infectious.
Interviews are an inexact science and there are plenty of bad or even abusive companies out there. Take your time and try not to take rejection personally.
Try to keep in eye out for what your next move will be. You'll likely learn more and earn more through some job hopping every 2 to 3 years. That's okay.
Practice, practice, practice! Code in your free time. Work on an open source project. Find an itch, scratch it and share the results.
I can't do many things that most others can. That's just how it is and I have accepted that. I work with what I have, just like we all do.
Calling it something you consider less offensive doesn't obviate you from treating me with respect and decency. If you want to know something about my disability ask. Be polite and respectful, Understand the appropriateness of the situation and don't obsess on my differences.
When we first met I didn't ask, "wow why are you so ugly?" So maybe asking "why do you limp?" Shouldn't be your first question.
Compassion isn't avoiding offending me, or offending your own feelings.
Compassion is about understanding, hey they can't do some things many of us can or need to do them differently. But they're a person and deserve to be treated like one just like anyone else.
This isn't hard.
echo '1 2 3' | jq ....
as creating three separate json documents, each with a single number as their top level "document" , body, or content.
So of course you can't sum them. They are fed as separate documents to the jq pipeline as if you processed three separate jq commands.
Perhaps by stateless you mean no mutuable global state? But it certainly maintains state from the location in the input document to the output of each selector/functor.
IMO it helps if you have a background in some of the concepts of functional programming.
You could always have someone look at their work. Or better yet walk through it with them to try and ascertain their thinking. This is what I do with my team, multiple times week, in my actual job. Seems better than immediately excluding them