HackerTrans
TopNewTrendsCommentsPastAskShowJobs

_laiq

no profile record

comments

_laiq
·3 tahun yang lalu·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 tahun yang lalu·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 tahun yang lalu·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.