HN user

naudo

6 karma

Long time lurker, short time account holder.

Posts0
Comments9
View on HN
No posts found.

Trial Spark | New York, NY | Remote / Onsite | https://trialspark.com

TrialSpark is a technology enabled pharma company. We’ve built an in-house clinical trial engine that runs drug development and clinical trials significantly faster and more efficiently.

We acquire or license assets and then leverage our tech-driven engine to develop these assets in our high priority therapeutic areas, enabling us to take more shots on goal and drive towards value inflection faster.

Open Roles: I'm specifically the Hiring Manager for a Senior Data Engineer Role https://boards.greenhouse.io/trialspark/jobs/3758289

But we're hiring for several other engineering roles such as SRE, Product Engineer, and Engineering Manager in addition to non-tech roles as well. https://boards.greenhouse.io/trialspark

To apply, either apply to the greenhouse links above or email me questions: nicholas [ at ] trialspark.com.

After doing that on a local db a couple of times, I started just writing the where clause first. Goes like this

WHERE id = 1 ctrl + a DELETE FROM....

Found it's also helpful for writing SELECTS and avoiding the whole "oh crap, now let's load the entire DB" type of moments.