_laiq's comments

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).

Original comment never mentioned that SQL wasn't a baseline for programmers anymore.

What you don't realize about Epitech (and other similar private schools) is that the only value you're getting is paying a bunch of millionaires the right to join a selective program.

I graduated from an enginnering school, and you can absolutely skip all classes if you wanted to. Sure, the teachers don't encourage you to do it, but the freedom is definitely there.

BUT, since there will always be a percentage of students who don't succeed in a "traditional" way, a bunch of rich people will always attempt to lure them into a paid program (which is, I repeat, selective). So they learn quite a bit, and they can become high-earners in the future, since they're all hanging out with technically good people.

Were you an engineering graduate ? Because 30k€ even in Province right now is extremely low (university graduates are starting at 33k€ in Lyon for example, with engineers 33-38k€)...

“Any city gets what it admires, will pay for, and, ultimately, deserves,” the New York Times editorialized in October 1963, as demolition of the old Penn Station began.

I suggest a corollary:

"Any web community gets what it admires (fancy UX and feeds that work like magic), will pay for (=nothing), and, ultimately, deserves."

Spot on. While the idea behind can be interesting, it is implemented by accepting people who have the same "social status" background (same schools, same opinions), but are of different gender/race.

I think that a white factory worker could add way more insight into how other communities views things, than hiring a black/female attorney does...

Having said that, I'm really afraid what the backlash against this type of diversity-thinking will be. The system will surely corrects itself in the future (it's already starting), but I'm not certain going back to another extreme would be very wise...

I don't really understand why you would think that "avoiding change" is an offense to be fired for.

Your opinion seems to lack every bit of possible nuance: say i'm manager A trying to raise awareness about tech B in company. I have every right as employee C to be skeptical because if B is bad and pointless, I'll be punished for following A's decision. Of course A has every right to spread B even if bad, because it will make A seem awesome in the process.

My general point is: resistance to change is a spectrum and is often mixed with office politics and strong opinions on both sides. Trying to blame someone merely for wanting to keep the status quo is absurd.

I have a feeling they've been working on this. Their https support has always been top notch!

Am suddenly interested in building a product that handles your taxes when you give it read access to your Coinbase account.

Yes.

I'd argue that berating economic success as the main metric for measuring a country's success is precisely what is slowly but surely eroding the West's precious institutions.

Since when people just want to live comfortable lives and leave their collective fate to be decided by a minority whose interests do not necessarily align with the people's interests (otherwise, they would just allow fair elections).

Small example: of course, country-wide surveillance à la China would lead to "economic success", do you think it's criticized because it would lead to mass poverty ?

It would lead to a perfectly stable future for the population, with ever improving quality of life and security. The problem, as you may guess, lies elsewhere.

I have to admit I slightly misread the parent comment, but still: as long it's not a democracy, how can you consider that China "can give their people what they want".

The "they" cannot be referring the people of China, or the majority because China is just not a democracy.

This is the main difference between a country which holds free elections every 4 years, and a single-party country.

Following your logic, China is better off because instead of having one party protesting but failing to reject a law promoted by the elections-winning other party, it's just better to have one single party control everything.

Sorry but I find this just mindblowing.