If you have enough connections to get you through your first 6 months or so then you can make the jump. Often when consulting your rate is double your normal take home so it balances out the period of searching for more work. But you highlighted the key anxiety in going freelance: you will always have to be selling your services. Its just like any startup except you are the product. Having to get new gigs will always be part of the job whether its now, 6 months from now, or 3 years from now
I've used Snowflake a fair amount. It's a decent product, probably on par with Redshift / BigQuery. Obviously theres a lot of hype and free money floating around but my take on why they are popular is that they are basically a replacement for large Hadoop installations that have become untenable to manage over the past decade. If a company is already using Redshift or BigQuery I'm not sure why they would switch.
I would be apprehensive in investing in Snowflake long term purely because their product is highly susceptible to being obsoleted in the next 5-10 years.
I’ve lived in SF for 10 years and my family of 4 is finally moving out. Part of it is economic as we can’t really afford to raise kids here. Part of it is rapid deterioration of public spaces. The breaking point was someone blocking my apartment door by shooting up heroin when I brought my newborn son home from the hospital.
It’s not bad everywhere. The Marina, Noe, Pac Heights, Cole Valley, Outer Sunset, and parts of Richmond districts all manage to keep their neighborhoods clean. The mission feels like a 3rd world country.
I’m democrat but I would most certainly vote in a hard line republican DA to take a stand. I’m done having my car broken into and literally shat on. I’m tired of seeing piles and piles of trash like we’re living in some kind of garbage mound. People just don’t care.
It wasn’t this bad even 3 years ago, but it’s certainly taken a turn for the worse. It’s untenable.
What I’ve heard from my therapist is that anxiety is often a cloud that covers the real emotion underneath. I experience anxiety when I’m really upset because I don’t know how to express anger. But sometimes it is sadness or fear. Anxiety is basically an evolutionary adaptation — we no longer are being hunted or having to hunt for survival, but our minds still think danger is present.
In an expensive city like SF, its not small. It's a 1 bedroom. Most single people live in a 1bd or studio apt. But to raise a family with multiple kids, it feels tight. My wife and I live in the living room off the kitchen and our kids will take the bedroom. For the same (market) price of our unit, you can get 10x more space in the "country", but then finding work and interacting with friends will be harder. Lots of trade-offs
I used to be an analyst, and used to make atleast double that. But to earn that kind of salary you often sacrifice work life balance and experience all consuming stress. I decided being poor was more healthy and quit.
Story of my life. I’ve lived in SF for almost 9 years, my wife for 15 years, and we have a toddler, 90 lb dog, and a baby on the way, making it work in 650sf apt on combined $120k. I’m immensely grateful that the only reason we have savings at all is because my wife bought a below market rate condo with the city when she was single making $40k a year.
It feels weird to make this much but feel so poor. That any hiccup in life could make you miss bills. It’s been fine so far but as our family grows there will be no choice but to leave. Childcare is just too expensive.
I love this city, but over time I’ve felt I’ve gotten less out of it in exchange for more.
With new programmers, you can't have the expectation that you're going to get a response or be upvoted. You help them precisely because you like helping, not that you expect anything in return.
Its the long term goodwill that eventually brings new programmers into the field, because programming is hard! Newbies need to know its ok to take risks and there will be a safety net.
There are probably multiple ways to reverse proxy, it’s just that CF workers are versatile to handle many use cases. You don’t have to lose the caching benefits. You can still pull your assets through Cloudflare CDN since workers operate at the request level (afaik).
In fact it can be even more performant. You can use Workers KV to cache as well. So a request comes in, check KV store, return if found. If not, pull from asset CDN.
If you have a blog running at blog.mycompany.com, that is not going to be as effective for SEO as if the blog were at mycompany.com/blog. You want your primary domain getting the credit. But it’s also not ideal to have a separate subfolder if you have two different services (blog and main product).
So the best solution is to reverse proxy so that internet traffic hits /blog, but the worker is actually forwarding the traffic to your internal service.
Important to note that workers have a 15s timeout, so this is really only good for routing. You probably don’t want this to manage tasks that could potentially take longer.
I tend to think of these services as fulfilling different use cases.
For Fargate, the ideal scenario in my workloads is async background processing. Add tasks to SQS, Fargate pulls tasks off and does the job. Elastically scales up or down and lots of flexibility on machine specs. Ok with some failure rate.
For AWS Lambda, recently I like the combo of adding a Cloudflare worker in front and using it as an API gateway. More flexibility on routing, faster performance, and reverse proxy for free which can be good for SEO. And you get all the goodies of Cloudflare like DDOS protection and CDN.
Yes non technical people can’t write complex sql, but they can self service basic questions easier than learning Python or R for example.
And it’s difficult to code review SQL because complex business logic means complex data manipulations and those are hard to visualize and comprehend. You don’t have to think in a 3D space so much when you write python.