Hacker News new | ask | show | jobs
by ldjkfkdsjnv 1204 days ago
Today at work I hadnt used apache spark in a long time. I needed to do some quick and dirty data analytics on large datasets. Rather than read documentation, I just put the queries i needed in english into chatGPT, and it spit out perfectly working code. The queries werent that complex, but it saved me hours googling a bunch of random spark SQL syntax.

The old school way is google sends you links, and through those code examples, you build up all the edge cases you need for your code to work.

Thats completely obsolete as a way to synthesize information! Google is going down!

Thanks for reading my daily chat gpt anecdote! Sorry if its irrelevant, I just cant believe how much better it made my day.

5 comments

I've had numerous days just like this.

The perfect use case for ChatGPT for my personal workflow has been to give me the 70-percent-of-the-way-there skeleton for a given query, Terraform module, or even just to prevent myself from lookup up the syntax of for loops in <language> for the 30,000th time. I can then take that 70 percent chunk and bolt on my edge cases as I go.

There hasn't really been a time where the answer didn't need some massaging and of course occasionally it's flat out wrong, but that's becoming more and more apparent to me those instances are the result of feeding it sub-optimal prompts. I've found it to be eerily similar to my experience learning to use search engines back before SEO titles were a "thing."

It's frankly incredible how little I find myself using a traditional search engine compared to six months ago, at least in the context of work stuff. I'm less inclined to feed it general knowledge prompts, but it's encouraging to see the remarkable LLM tech leaps from generation to generation, and in such short order.

Slightly tangential. After interviewing a candidate, within 20 minutes they sent me a long thank you note that had several generic things that definitely did not apply to what we discussed. Very obviously ChatGPT-generated. Using ChatGPT in and of itself may not be all that bad, but this shows that the candidate did not even take the time to tailor it to our conversation. During the interview I was on the fence about pursuing the candidate but this justifies a clear reject.
I had it write my green card justification. Awesome corp-speak BS.
I think this is what people are missing when they say AI can’t replace search — research was never the goal, it was/is a necessary evil in one’s way to the goal.

Yes, current AI is not a perfect replacement yet

Well.. if we are doing ChatGPT anecdotes.. today I tried to "launch" the new version of https://aidev.codes. It integrates the ChatGPT API with Stability.ai (stable diffusion) for generating images and well as Eleven Labs text-to-speech and can create and immediately host an interactive web page on a custom subdomain.

I need marketing help. Or I should just stop trying. I don't see how people are able to get posts on the home page.. I could not get any attention or comments at all or any real user engagement today. I know this is a useful system or at least worth of a tiny amount of discussion. After working on it for months there is almost no reaction.

I don't think its the website. I think its just that I probably need to buy upvotes or something. But I don't have money for marketing. I'm very bitter.

What I keep telling myself is that marketing is going to be as hard as the programming. Which I have been doing the programming for months, so I will need to do the marketing for a long time also. But I am out of money.

If this doesn't get any traction (which it seems very close to zero) I will be desperate for any kind of contract within about a week. But I don't want to give up on the idea despite the apparent lack of interest. I think the biggest thing is that I only have 100 followers on Twitter or 600 followers on the other account and those people only care about one specific domain.

I also seem to have not been able to get a single upvote on reddit. And only one very short comment.

So I am suspecting that these sites are rigged. Or I should just give up on life? Not that I would actually consider that but that's the feedback that I seem to be getting repeatedly from the world.. that my efforts aren't even worth a short comment disparaging them.

Creating front ends that integrate different AI APIs is kind of over saturated, that's probably why you're not getting much attention. It's also somewhat hard to understand what's the value proposition of the website, you should focus on putting as much of that kind of information in everyone's face in the landing page, otherwise they'll just bounce. Take everything from your "Learn more" page and put it in your landing page. Simplify, condense and systematize the information in a way that makes it digestible and instantly obvious.

Also, I should note your comment is kind of off-topic, have you thought about creating a Ask HN talking about your issue? It's very possible other HNers could help you get your website and product more interesting. I would also recommend not being bitter about it, Hacker News is all about Silicon Valley and startups, the main rule for these is that 9 times out of 10 you'll fail. It's normal.

At last I should note, if you're doing things as a hobby, do them for yourself, remember to have fun and create NO expectations of what you will or will not be able to do. If you're trying to get a startup or product going, there's a reason why Y Combinator is so popular, if you truly believe in what you're building you should try getting it into an incubator.

Just my two cents.

How do I get it to an incubator? I believe in it, because its 100% useful in incredibly obvious ways.

And you are basically saying that there is no such thing as bootstrapping.

And honestly I feel that this is a failure of HN not of my website.

But you still give good advice to help people by not expecting them to click a single link to get to the FAQ page.

Bootstrapping is cheap and easy, but the chance of failure is much larger, it also comes with the consequence of giving you a lot of unnecessary stress since you're playing with your own assets. Regarding applying to an incubator: https://www.ycombinator.com/apply

All the best.

If you listen to the people who have done this before (e.g. read/listen to indie hackers), Reddit/HN is very hit/miss.

Only thing seems to consistently work is Twitter - and then you should REALLY be building public if you have no audience so that you can build one. Have you tried this? If not, and you've been building in stealth mode, you've missed out on an opportunity but you can still start now.

You are figuring out so much stuff in an area without expert - make a Twitter post every day about what new problem you solved and you will quickly find a following as you establish authority in this new field. So many people are learning from each other about this stuff, it doesn't take much to become an expert.

I've been going through all the Indie Hackers podcasts. Consider listening to Indie hackers #008 or #009, I think they specifically talk about bootstrapping an audience from nothing.

You may even find people are more interested in an educational product from you than your service, and pivot, for instance.

OK thanks for the advice. Yeah I have about 600 followers on my @algonfts.art thing, but they only care about Algorand.

@aidevcodes has around 100 followers. I should post more routinely on there.

It's not helping that you are constantly hijacking threads which are really only tangentially related to promote your app.

As far as the website premise itself, I feel like this might've been useful 20 years ago when it was more popular to write static vanilla HTML with jquery sprinkled in. These days, if a person wants a relatively no code solution they're gonna go for WordPress or square space, otherwise they're probably going to design something using a framework such as react svelt or vue.

I just watched the demo and personally thought it was amazing. Don't give up! Keep going!
Thank you means a lot.
> I just cant believe how much better it made my day.

Wait until how great your day will become when you’re unnecessary ;).

People are always made unnecessary. The smart ones then find other ways in which they are. Not sure how this is any different.
What we are discussing is something that removes the need for problem solving. What will the supposed smart do if there’s a magical machine that can solve all problems that can be represented as text?
That sounds like a problem, so they ask this magical wonder machine to solve it. It will write pro-UBI statements that instantly convince politicians that maybe those who profited the most from magical wonder machine can now afford to pay more than zero taxes.

After that, it's dolce vita and stargazing until they die.

Run cable, I guess.

But yeah, it kinda stinks that we invented artificial creativity before we invented a bot that can fold and put away my laundry.

I don't know about others but I'll be enjoying the beach, partying, watching movies, etc.
With what money?

Will we have UBI before ChatGPT (or whatever comes next) can do all our jobs?

Not necessarily different, but the day software tech people get treated as disposable rather than rare (as they are very much today), it’s gonna be a rather … peculiar cultural shift to experience (for people, the industry, states).
This one is different because it will pass the threshold of "normality".

Just as we woke up with DALL. E 2 one morning in April 2022 and with ChatGPT one morning in November 2022, one day in the future, perhaps in the next 3-5-10 years, we will wake up with some 5, 10, 100 terabytes of neural weights fully able to drive a car from a single camera under any circumstance, millions of times safer than a perfect human driver ever could.

On that day, which in my view definitely looms in the near future, ~200 million jobs will vanish instantly [1] and hundreds of millions of jobs will be gone forever a few months/years after that. For those 0.7-1.5+ billion people there will be no "alternative careers", not because they won't be able to learn or adapt, although most of them are already tired and sick, but because the system will simply no longer need them, they became not even useless, a burden.

Our current system, no matter how you call it, is socio-pathic, literally: the socius, the fellowship [2], is suffering [3]. The phase transition will come; the question is what we, whoever we are, will do: will we still hold dear the protestant work ethic [4] and believe the probably Los Angeled-invented Chinese fortune cookie message "there is no free lunch" [5] [6], or we will adhere to a metaphysics better suited for a galaxy with trillions of trillions of whatever natural resource we might ever need and enough energy even in our local star to build whatever kind of civilization we would ever want.

[1] Answered by ChatGPT: "According to the International Transport Forum (ITF), there were approximately 107 million commercial vehicles in use worldwide in 2015, which includes trucks, buses, and taxis. This suggests that there are likely many millions of people who earn a living as drivers.

Additionally, the World Bank estimates that the transportation sector, which includes driving, employs approximately 10% of the global workforce."

[2] https://en.wiktionary.org/wiki/socius

[3] https://en.wiktionary.org/wiki/pathos

[4] https://en.wikipedia.org/wiki/The_Protestant_Ethic_and_the_S...

[5] https://en.wikipedia.org/wiki/Fortune_cookie

[6] https://en.wikipedia.org/wiki/There_ain%27t_no_such_thing_as...

This is like saying in 1700 that the invention of farming automation will displace 90%+ of farmers, what ever will they do?

Automation is helpful, but it’s also scary. I guarantee that nobody 300 years ago thought that many of the 90%+ of displaced farmers would end up sitting in front of screens, moving data around. And I also guarantee that farmers in the 1700s were just as tired and sick as the driving industry today.

Yeah it’ll suck for the people who don’t/can’t adapt. But the world that is created by removing unnecessary labor ends up being better for everyone eventually. Should we deprive the people of the future from the technology of never needing to drive, just because the transition is scary?

The point is that there will be no more "new jobs": once we have successfully managed to externalize in silico basic human decision-making (accelerate, brake, make a left, make a right in 2/3D space, but also decisions in other spaces: decisions in the space of language, of images, and so forth) it's game over for 99+% of all the jobs across all the industries. All that remains are the entertainers (very few), the brains (even fewer), and the owners (even fewest) †.

The transition will not be scary: it will be criminal. The governments and general policy decisional factors are so out of touch it's laughable, just look at the French government as they try to raise the retirement age to 64 [1].

† Because this is the crux of the matter: are we able to build a civilization where everyone is an owner, or will only the few of the fewest be the owners. And today, for instance, only those with 50 million USD and above are owners [2], because first of all you must own your life, and if you can't afford a lifesaving $3.5 million gene therapy [3] if you need it (not to mention a 100 USD eye surgery), you don't own your life.

[1] https://www.france24.com/en/france/20230309-french-young-peo...

[2] https://en.wikipedia.org/wiki/Ultra_high-net-worth_individua...

[3] https://www.webmd.com/a-to-z-guides/news/20230215/life-savin...

Looking forward to that day.
Really like your idea because sometime I just want a "just work" solution to verify my idea. Then I can optimize it later if I need