Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
med-mastodon.com is one of the many independent Mastodon servers you can use to participate in the fediverse.
Medical community on Mastodon

Administered by:

Server stats:

419
active users

med-mastodon.com: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#performance

17 posts15 participants3 posts today
Public
Doug Ortiz

Did you know PostgreSQL has its own built-in full-text search engine? 🔎📝

-- Create a tsvector column with GIN index
ALTER TABLE articles ADD COLUMN search_vector tsvector;
CREATE INDEX articles_search_idx ON articles USING GIN (search_vector);

UPDATE articles SET search_vector =
to_tsvector('english', title || ' ' || content);

-- Search
SELECT title FROM articles
WHERE search_vector @@ to_tsquery('english', 'postgresql & search');

#PostgreSQL#FullTextSearch#DatabaseTips
Public
junwin

A group of Zulu performers at a safari park near Durban share a vibrant and expressive dance, inspired by ceremonies that may be seen at Zulu weddings. While the performance is tailored for visitors, it offers a glimpse into the rhythm, energy, and storytelling that are integral to Zulu cultural celebrations.

#performance #joy #zuludance #durban #traditional #phezulu #south africa #photo #sony #photography #southafrica #activity #dance #zulu #a6400 #scenic #culture #warm #africa

Several dancers perform outdoors, dressed in colorful traditional Zulu attire. The dancers wear beaded skirts and feathered accessories, moving energetically in a circle. The background displays a vast open landscape under a cloudy sky.
ExploreLive feeds
About