HackerTrans
TopNewTrendsCommentsPastAskShowJobs

_laiq

no profile record

comments

_laiq
·3 jaar geleden·discuss
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...
_laiq
·4 jaar geleden·discuss
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.
_laiq
·5 jaar geleden·discuss
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.
_laiq
·5 jaar geleden·discuss
Modern lifestyle advice dictates people to eat more, to move less, to be alone and sleep less ?
_laiq
·6 jaar geleden·discuss
I would like to know more about the subject. Is there any way I can contact you ?
_laiq
·6 jaar geleden·discuss
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.
_laiq
·6 jaar geleden·discuss
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.