The sponsored spot is appalling, I reported something that looked dodgy which appeared above the UK gov identity verification for passports and such app. When people search for a specific app, putting something else in front only makes me think you are untrustworthy scum, so my trust in the play store is fundamentally broken. There's a fundamental incompatibility between giving the right result for what was searched for and pushing promoted irrelevant results.
The good answers tend to use links as well, which won't capture well. In many political and local subreddits there's a huge amount of Russian and far right sock puppet activity. Good luck training an AI to understand political opinions or what people in an area are like when most of the longer comments are pre written copy pasted talking points from astro turf groups and bad actors.
Many of us who were writing all the decent comments there left after they made clear they want it to be another bland nothing of a website during the blackouts. A hundred dull image macros a day aren't worth wading through for the few nuggets of decent content, so loads more left or majorly cut back. Some communities such as javascript are now dead.
Phillips master ultra efficient, similar to their Dubai lamp, may be what you need. Running much less power per led is more efficient, so there's less heat and the lifetime is massively increased. Big Clive put a good video out about Dubai lamps a few years back.
Of the tens of thousands of queries I've written I've needed right join the exactly once. It's a feature which is neat in that it exists, but the prevalence in teaching materials is entirely unjustified. Cross joins are massively more practical and enable some efficient transformations, but are usually taught only as all to all without a clear position on why they are useful.
> , but the prevalence in teaching materials is entirely unjustified.
I agree that it is seldom good query-writing practice, but I think it makes sense in education because it rounds out the join variations to name them symmetrical, and thus easier to remember.
> Utilized Low Code Tools at Client’s Request for the Web Front End Work
Oof!
Nice to find someone else who recognises explicitly that management is in no way a natural career progression path, it may have been decades ago, but in the current market we often see seniority / value confused with team management when the two need have little relation.
LLMs today are great for certain use cases, which is amazing when it suits your needs. Need to extract a hotel name, city, address and confirmation number from emails and return it as JSON? Not a problem. Need it to validate postal codes in Canada? It's the wrong tool.
You get a lot more views for a video on how to index a column in MySQL than for how to approach evaluating your needs and choose a suitable database. The latter would be outdated in a few years as new technologies emerge, while the former can be padded with enough fluff to show two adverts. So we end up with the content you know today, rather than what you'd really like to see. It's good to remember this and interact with those who do publish the latter content, plus it makes the algorithm feed you more content that's worth your time.
That is the sort of thing I'd think LLMs (with suitable training data, that's not overrun with promotional material) would be good at. I've had ChatGPT recommend technologies to me before that I hadn't thought of or didn't know (much) about.
