Haha, nope. The links points to a table of contents after which you are on your own. The right link should point to a specific page instead, but the problem here is that postres docs are poorly optimized for search engines. If you click on the top link from google, you would see there's a notice that the page is outdated, with a link to a current version, but said
link is dead. It's not an issue I've ever experienced with mysql docs for example.
And yes, w3schools, despite how terrible it is, is still above the official docs because it is more popular with newbies. I remember a time when I just started, I preferred sites like it, because they were simple and on point, rather than technically correct and comprehensive like the official docs are. If you forgot the feeling, try learning math on wikipedia (assuming you don't have a math degree).
For the rest I cannot argue. Generated/AI shit is indeed ruining the internet and search engines giving up and joining them isn't helpful either.
After which ctrl+f " in" takes you to the correct chapters. I do agree that a direct link would be more helpful.
And for learning postgresql I agree it isn't very helpful - using their tutorial links, w3schools or something like udemy if you prefer video format is the way to go in that use case.
I remember back when you were told to learn to work with the documentation, not memorize it, because you will always have access to it as a reference. Maybe bookmarking reference books/documentation will make a come back as the search engines degrade.
There has been something similar for years: a page that basically says "Yeah, nah, we don't have any information for that, but you might be interested in a totally irrelevant something else", but phrased in a way that gets it high in the results. What's astonishing is that Google doesn't punish those pages.
I was looking up some tips for Baldurs Gate missions and these fking AI generated pieces of shit with hallucinated fake playthroughs ruined the whole experience.
Oh, that stuff happens all the time. The one that really pissed me off was Microsoft 404-ing basically their entire KB system.
That thing was standing for so long you could still find Windows 9x stuff on it, and it was glorious.
Around the time they stopped supporting windows 7, they bricked the entire thing up and started a new system. Overnight, all the Microsoft help article links went dead. Find a good forum post about an issue that you're having and someone replied with a link to the MS KB saying little more than "this should work" followed by a sea of commenters saying thanks, that worked, but when you follow the link, it goes nowhere.
And right before they did that, they started removing footnotes from KB articles that only dealt with older OSes, so if you ever needed to go back and find something, it just wasn't there anymore. For example certain RGB packing formats were only supported on newer OSes and the footnote used to tell you that, but then it disappeared. I have been directly affected by that multiple times.
Been there. Done that. FML on searching for programming help some days. Versioning is a nightmare as the way you "used" to do things is no longer relevant and the rest of the results are some asshole saying it is a duplicate question that was answered 10 years ago...that is no longer fucking relevant!
Sorry. Yesterday sucked. I hope today is less frustration and more things working like they are supposed to.
As someone who is trying to teach themselves a few new things this year by diving to projects using them... I seriously, seriously feel you. It honestly makes me question whether I should just abandon each project I start, both professional and personal.
All the relevant hits are from years and/or 2+ versions of whatever ago or forum posts with dead links to an alleged solution.
I feel like in the past I could just dive into something and search my way through it. Now I feel like that era is over and I question whether it's me, my niche project idea, the disappearing community, or just the search engines.
It makes me sad because Google used to be great. The main feature that made Google great was the click rejection. Basically the search would know when you clicked on a link and didn't come back to the search results. This action would add weight to that result as "this probably has the information that was being searched for" so it would be nearer to the top later when others made similar queries.
This was their killer feature, it basically crowd sourced the correct information. After a small amount of time, the correct results would kind of float to the top so subsequent searches would put those results near the top to help satisfy queries faster.
Now? They seem to want to give you results that satisfy their partners, and keep you tied to the results page as long as possible. The focus seems to have shifted from being a good search engine with accurate results, to a meme of how to make money.
Never before has this shift been more clear to me than right now, directly in the wake of I/O 2024; an event my friends have taken to calling AI/O. Pretty much every single presentation was about Gemini and AI generated garbage, but this isn't what made Google's new direction clear to me. In the last 20-30 minutes of the event it was made perfectly clear what they were doing with I/O. And to drive the point home, every I/O has showcased stuff you can't use yet, stuff they're working on, and other cool shit. Some of it cost money, but there was usually some stuff that was just done because it could be done and it would be made available at some point, a nontrivial amount of it was free. At AI/O, the entire focus was on AI, with little to no non-AI stuff in there, at all, then at the end, they kicked everyone in the shorts. Here's our prices to access this shit. Buy it. As far as I'm concerned AI/O was a gigantic marketing circle jerk to sell their AI.
It seems that Google has entered the final phases of enshittification.
Saw an article that said that some execs demanded for search to have better user retention. I.e make the user search multiple times to find what they're looking for, so they can be shown more ads.
I remember how people used to joke about the second page of Google results being a desolate wasteland where no one ever looks, now I just instinctively scroll down a bit because I know the first page of results is going to be trash.
This is possibly something you could implement in a meta search engine like SearXNG, though there are some privacy concerns.
Maybe it could locally store which domains you personally tend to click (and stay) on. Then automatically raise those domains when it sees them somewhere in the output of the underlying engines. This isn't perfect because you wouldn't get data from other users. But I think it could do a lot to improve search results.
I might actually clone the repo and see if I can get somewhere soon
The thing with Google was that the data about click through vs click back was supposed to be anonymised. Whether it was or not, inside of the black box that is Google's algorithm, who knows?
Either way, I'd be interested if you get any progress here. I've never tried to self host a search engine, but I might consider it.
DuckDuckGo is also being poisoned by SEO unfortunately. Some group of people managed to crack its algorithm, and as Google is slowly but fading relevancy, DuckDuckGo is now also has the same issues.
We currently have a student for training and had her learn Rust. After two weeks or so, she told me that she had a really hard time finding anything about Rust, and it became clear that she was really confused and thought Rust was some fringe technology that no one uses.
And yeah, no, search engines just got obliterated by LLM spam since the last time she had to learn a new technology. Seriously, I remember getting better results about Rust back in 2018, when it was really still relatively fringe...
One search that was memorable to me was looking for dimensional information on a T-slot. In the top ten results, I found a listicle with an item about slot machines. LLM spam and Google's relentless bullshit have poisoned the internet.
I've been into computers for over 20 years and I couldn't tell you what uses rust. I am aware of it, but I am completely unaware of how narrow or broadly it is used. I keep forgetting people aren't talking about the game.
I mean, to name a few projects off the top of my head:
Firefox
Android is migrating some of their internals.
The Linux kernel, Google Chrome, Thunderbird are preparing to use Rust.
Many Python programs now have Rust in there, because of the PyCrypto library.
Fish shell is in the middle of a RiiR.
I don't feel like there's a ton of big, mature projects yet, because of how relatively young Rust still is, but performance-critical or embedded software will be strongly considering Rust in the future.
And like C, Rust can be used to create libraries which can be called from practically any other programming language. I expect that to give it significant growth in the future.
Frankly, I do most of my searching these days directly on https://std.rs and https://docs.rs . But yeah, those are usually better as a reference than for learning.
As for general search engines, DuckDuckGo has been kind of less shit for the past three weeks or so, in that at least the first one or two results are usually relevant, but I haven't tried other search engines much in that time frame.
Another tip is to make use Clippy. Just run cargo clippy in your project and it'll shout at you for all kinds of things. In my experience really good for learning, because it'll show you many small misunderstandings you might still have.
The section "other people also search for" is complete garbage.
I was searching for a used car part in my native language and Google mistook it for a name.
No, Google, other people do not search for "car part net worth and marital status ". Why are you showing me this crap?
The English word 'speaker' has multiple meanings. In Hungarian, there is a different word for a speaker device that casts sound (hangszóró, "sound caster") and Speaker of the House of Parliament (házelnök, "president of the house").
Still, when googling one, you may get results for the other. 🤷
if Kagi were open source sure, but it's $10 a month and the CEO is kind of an asshole. And a generative-AI-bro (please don't make me call them GAI-bros)
Get with the times. When Google isn't a useful tool anymore, use a different one.
Curate and maintain your own list of links to official documentation.
I think we're almost at a point where having a library of books next to your workstation would be beneficial again.
I also learned C on the Amiga. I loved SAS C. I also came across C++ first on the Amiga when it was just a pre processor for C.
I really loved that machine but it was the community that was special
Search results: "Here's how you setup Rawinput in this competitive FPS, and look how it reduces input latency by a single milisecond! After 2-3 pages of AI generated SEO garbage full of misinformation, you might find something else besides of the official MS docs."
Me: "Okay, this is not working, maybe I should look for some another preexisting SDL alternative, maybe at least one of them isn't an even bigger dumpster fire than SDL itself."
Search results: "Duuuude, have you heard of this game making tool, called Gamemaker? It doesn't need coding, and it's totally the same thing, because some people mistakingly called SDL a game engine, and now my AI hallucinates it as such. If you're up to a bigger challenge, then there's always Godot, or DirectX, which my AI also hallucinates being a game engine!"
SDL, on the other hand, is not, and instead is a multimedia layer (middleware) often used for game development.
One could argue that game engines constitute as middleware, but in reality, most modern game engines are way more than that, and instead often rely on other middleware nowadays (e.g. OpenGL, or even SDL for some). This, alongside with people mistakingly calling SDL a game engine, leads to stuff like this.
Interestingly, bing of all things turns up better results than Google with the same search terms, first 3 blocks are "popular results", first is tutorial sites, second is w3 schools and third takes you to the current docs for functions and operators.
If you ignore those, the fourth result takes you to the current docs for comparison functions and operators. I'd prefer it taking you right to the official docs on the first result, but comparatively acceptable. It was memed to death but I've seriously found it more useful than Google these days, comparable to ddg's results.
If you're going through that route, SearX beats everything and it's not even close. It's self hosted and takes search results from any engine you check in a config, different config for search categories, ... Rn I'm mostly getting results from brave, qwant, and duckduck.
Gotta acknowledge the bing copilot tho, it's pretty decent, but requires to use edge or bing app in android, so i only use it when I'm lazy or I'm searching for something too obscure for searx.
I've used Bing for a few years for the free rewards points and purchase rebates, and it has worked very well for me when it comes to normal searches including searches for software development. I very rarely have to turn to Google when trying to look something up, and as you mentioned, sometimes Google honestly gives me worse results. I will say however that I have found the image and video search on Bing to be significantly worse than Google's (which I already have some issues with). Not sure about the other search types like shopping or news since I never use them.
I have a half thought that maybe bing works well for technical searches because it's the default search engine for edge and depending on the company, you may or may not be able to use a different browser and I'll be real, I tend to leave my work laptop setting as default as possible unless particularly awful.
I feel like I've been going crazy, web searching as a developer has become a daily nightmare and all the devs I ask are like "yeah, maybe it's gotten a bit worse? Haven't really noticed"
I get quite a bit of flak from my colleagues for paying for search, but I kid you not, I don't regret splurging on a Kagi subscription at all. It's personally less stressful for me, having to wade through less cruft, and I think I even work significantly faster because of how I use it.
It's sad when you think about it. Search was such a good experience in the past.
I also pay for Kagi and I'm super happy with that decision. I do wish they'd stop putting so much AI cruft into their search engine, but at least I can disable it.
Mistakes were made. It happens, OK? I'm quite certain Bing won't let THAT happen again......../////
For my, VERY limited needs for the tiny bit I have dabbled in programing or even just help with some Linux issues, I've been using Phind. It seems to work a whole lot better than any of the other search engines. But my needs can't really twist the tail like real programmers.
This is why I jumped ship to DuckDuckGo like 4-5 years ago already, never looked back
Coincidentally, yesterday I was quickly setting up a new computer for some testing whilst talking to somebody about another so I was half distracted. I did a search for some package to install and got absolute unusable crap. I didn't understand, tried again, tried different search parameters and it just got worse, and then I noticed that, since this was a new computer, the browser was using google.
I switched to DDG, and first page first hit was what I needed.
DDG also has been in a steady decline and apparently has been using Bing as it's back-end now. I'd love to use a self hosted open source browser, or of not that, an open source federated search engine, akin to Lemmy, but I don't see either coming into existence anytime soon.
bing itself is unusable tho. I get a full page of "sponsored links" before any tentatively relevant search result pop up. DDG at least removes the sponsored bullshit.
For what it's worth, DDG isn't perfect either. There are plenty of times I have to use Google instead. I don't keep track of how often it anything but it's definitely not perfect.
apparently has been using Bing as it's back-end now.
A lot of stuff uses Bing to search, as it's the largest search engine with an official public API that any developer can just sign up and use. Voice assistants like Alexa use Bing too.
Had to test with Kagi also, leads with official documentation, after that tutorials and unofficial things. Nothing obviously irrelevant. The only thing with the Kagi results, was that there were a few very simmilar official documentation links (for different postgresql versions) at top. But, still good search results. Not sure why anyone is still using google, when there are quite a few better alternatives availale
Though if I would use postgresql documentation very often I could just use the Kagi feature that rewrites URLs with a regex, so I can replace it always with the latest version.
Interesting, my Kagi results gave W3Schools, geeks for geeks, and postgresqltutorial.com before the official docs, but hey still way better than OP's results!
Kagi has search personalization where you can lower/raise/pin specific domains (one of kagis main selling points) and I blocked geeks for geeks and w3schools, as these are irrelevant for me and I don't want them in my results
yeah not ideal, but if the actual functionality of that operator hasn't changed then I wouldn't expect the version to matter. Same with searching most ruby stuff and getting old results. it hasn't changed in decades, it ain't changing now. But I did scroll down and literally every result was from the postgres docs so that's a marked improvement from the google results.
I forgot how this worked until I discovered NeoCities.
I suddenly remenbered when so many personal websites would have some page that's like "links" or "sites I love" or "other cool people", etc. And it was just a curated list of sites the author thought were neat.
And your bookmark function was actually really helpful, because "web surfing" was literally jumping from link to link to link, following rabbitholes and breadcrumb trails across the web.
Nowadays, I bookmark things but I never go back through them. I know Firefox sometimes automatically helps you remember stuff in your bookmarks though.
But there was a time when it felt like finding some niche site was a sort of secret club or cool treasure, and you had to make sure you could find your way back. :)
I searched for Magic The Gathering cards earlier on my phone (FireFox mobile), and got YouTube shorts in the results. This was in addition to a large amount of useless info panels and junk in the search results. I just wanted the official links or even an Amazon URL to the upcoming precons, not slowly regurgitated info!
Must be an old screenshot because there's now half a page of Gemini AI garbage at the very top now.
Highly recommend using the uBlacklist extensions to filter out the garbage, spam, copycat, useless sites that somehow seem to always beat out legitimate sources in SEO.
Some of the ads are charged by CPM (cost per 1000 impressions), meaning Google get paid just because people see the ads. That's similar to how ads in traditional media are billed - TV, billboards, newspapers, etc.
Not all ads use CPM though. Some use CPC (cost per click) and some use CPA (cost per action).
Doesn't matter, billions of other people do, and they prioritize ads, and results with AdSense on the pages above relevancy. They'll even show you shit results to keep you searching longer, which allows them to show you more ads.
It would be funny, if it weren’t painfully true. DuckDuckGo sucks just as bad as Google. I hear there is a good search engine, but it costs money to use. Shocking. Maybe they are all the same company, making shitty free services to try to steer you to paying for better services.
Not the one you replied to but they're probably talking about Kagi. I crunched the numbers a while back and the higher tiers were kind of hard to make worthwhile, however iirc they simplified the pricing slightly since then.
Funny, we all used to avoid W3Schools because it was a heavily SEO’d ad farm, but nowadays it’s actually a Web 2.0 oasis in a hellscape of infinite scrolling AI bullshit. I’ve found myself using it over SO since their surrender to OpenAI.
While I don't miss checking the index of my wall of Microsoft books (the light gray binders with the squishy plastic). At least those were (mostly1) correct and ad free.
Then the future began and you got MSDN subscription on CD with sample code. Woohoo.
they included a somewhat 20 pages of erratas that you sooner or later managed to memorize or punch and put in the correct place.
This is why I've really grown attached to Kagi (paid search engine).
It's made the internet usable again.
I'm honestly surprised how much of difference there is.
I'd really recommend people give it a shot. (there's a free trial for it)
For now, ignore my recommendation, as I don't yet fully know my stance on this, with the information provided.
However, I can say that I've been super happy with the search results.
I don't use their email service.
Just the search and the access to all of the LLMs that are out there.
I don't know what shady shit you're referring to. They do AI, but I don't use any of that. IMO their core strength is the search engine and how it works for you rather than against.
Asked it for the official documentation, got a link to the /current/ documentation's chapter on operators. Then asked for the heading about the IN operator and it gave me all four of the numbers. No need to wade through outdated or irrelevant results.
I just go the official docs even if their old and then switch to the latest version once I'm on the website. Most of the software I use has easy index to switch between versions.
Some of this is just because some of these frameworks and technologies have been around for a while and they iterate frequently. I see a ton of Azure content that is obsolete after only a few years.
read the official docs, and don't use google anymore, seriously, any technical question duckduckgo/ecosia can answer better because they use bing search engine
It doesn't matter. List all the crap you want, but show me the most up to date official documentation for the postgres "IN" operator in the very first result! It can't be that hard.
So many SEO trick to put yourselves into top google search for traffic.
I have google for bug and stuff, and most common bug can be found on shitty content Java tip page with broken format, lot of ads, and sometime untrue/outdate information.
You didn't include a version in your query. You also could try using quotes, though this specific entry may not be helped by it (e.g. "in operator"). For most things, you can click a link with the older version and somewhere there is typically a dropdown or something to change the version and, if not, you'll at least know which section/etc. it is in in the new documentation.
If you don't include a version, it's probably going to pull up questions/answers that it finds most match in general and maybe people just aren't asking that question for your version.
I think there's a lot to hate about modern search results, but I also think there's some opportunity to search better. I do miss the days when AND, OR, and NOT operators actually worked all the time and as expected.
I've started relying more on AI-powered tools like Perplexity for many of my search use-cases for this very fact - all results basically warrant a pre-filtering to be useful.
Unfortunately the spam arms race has destroyed any chance of search going back to the good ole days. SEO and AI content farms means we'll need a whole new system to categorize webpages, as well as filter out human sounding but low effort spam.
Point being, it's no longer enough to find a page that's relevant to the topic, it has to be relevant and actually deliver information, which currently the only feasible tech that can differentiate those is LLMs.
This is one solution to the issue, and it seems silly you are being downvoted for it.
Google became what it became, and years of seo optimisation cat & mouse play has reached new heights. Those obviously target Google instead of their competitors for now.
Would that we could have perfect search results, it would be beneficial to google as well.
Skill issue. Old version docs tend to offer you a redirect to more recent docs, and even then something sintactic like an "IN" operator is unlikely to change in form or structure between versions of a database engine.
Old version docs tend to offer you a redirect to more recent docs
Sadly, the docs, I've worked with (openstack and ansible) frequently, don't do this. They have a button to go to the latest version of the docs, but not to the equivalent page on the latest version. This means I have to find the equivalent page again, from the integrated search usually.
And yes, a lot can change between versions. New features can get added that solve your problems or older stuff can get removed.