_laiq

Incredible how people are underestimating ChatGPT or overestimating open-source models.

A basic question: How can i join with SQL a column to a string separated with comma

GPT-4: PostgreSQL: SELECT STRING_AGG(columnName, ', ') FROM tableName;

Guanaco: Here is an example of how you could use the CONCAT function in MySQL to concatenate a string to a column value in a single-line query: SELECT CONCAT('The total price for ', product_name, ’ is ', SUM(price)) AS total FROM products; This will result in output like “The total price for Chocolate Bar is 10” or similar depending on your data.

Yeah, no...

Issues with scaling typically occur when confronted with unbounded traffic issues.

BeReal has a known traffic cap, say, 3 or 4 billions peak connections at the same time.

This cap has already been solved by other tech companies if i’m not mistaken.

I find this really hard to believe.

Say, you manage to recruit the top-30 engineers who know all the in-and-outs of the google search engine. Add to that, their recent replacement of trad AI methods with full NN I believe, and I can't realistically believe it's not more than a 1B problem.

One of the reasons Google is going horizontal because their search engine can't be "magical" forever, this applies to their ad platform too.

Modern lifestyle advice dictates people to eat more, to move less, to be alone and sleep less ?

I would like to know more about the subject. Is there any way I can contact you ?

I feel your example is a good portrayal of a life pretty much well-lived: you made money doing something you enjoy, met tons of people and fed your curiosity.

But according to this essay, you followed a BAD path not innovative enough, and the hidden reason why it's bad is because it will never generate any sort of profit for YC.

Now if you had tried 3 or 4 startups in that same timespan, burned through all your life savings, did not make several millions in the process, and failed all you endeavours, you will be applauded by YC.

Why ? because the more people exist like you, the better it is for them.

The way I see it is, say, you own a house. And you're having someone telling you that it is not properly secured.

If I come up to you, the owner, and kindly warn you that your doors can easily be unlocked, your reaction would probably be a big thank you. But, I also understand that you are free to answer me to get the hell out of your lawn, because it's none of my business.

Sure I am doing it for your safety, for the safety of your kids, your wifes, and your valuables. I have no ulterior motives.

But, you have the right to not want to listen to all the ways an intruder can come to your house and steal all your stuff. You should have the right to find that information useless, and I don't have any say in that.

Now, warning all the town that your house is not secure enough to try to provoke an answer from you ? What do you think about that ? Really curious.

I don't know. I think what we all do, we know how to do it without a computer. Computer just automate stuff for us. It's a very practical saying because it forces you to ask the right question about the problem you're trying to solve. (We all know how to do AirBNB by hand, or Uber by hand, but the mobile app is hyper efficient w/ GPS & 4G, that's all).

I went through their recruitment process last fall for a summer internship, and I can confirm: Their developer-focused approach is definitely what make them stand out.

There is a reason Stripe succeeded where many (many) other payment companies tried and failed.

Combining great UI/UX and a developer-centric experience can go a long way into ensuring your business is future-proof, especially when your core service is an API :).