4 ms·
PG is something of a different beast too. With MySQL the standard mode of operation for most non-basic functionality is to dump the data in another tool. Full
by brightball 9y ago
PG is something of a different beast too. With MySQL the standard mode of operation for most non-basic functionality is to dump the data in another tool.
Full text with Postgres is pretty fantastic and configurable. Not putting the data somewhere else keeps you from having to maintain a second system, keep things in sync, etc.
People jump to putting data in a search tool because it's a search tool waaaaay too quickly IMHO. If the use case justifies it, go for it...but don't add uneccessary complexity unless you have to.
- ris 9y ago> Not putting the data somewhere else keeps you from having to maintain a second system, keep things in sync, etc. To be fair there is some amount of "keeping things in sync" one has to do with postgres, even if it's just setting up the right triggers to update the FTS index on updates.
- brightball 9y agoTrue, but it's transaction safe so should be impossible to get out of sync which is what I was really getting at.