Top Tweets for #PostgreSQL
Learning PostgreSQL and looking for the best resources to level up! 🐘
What are your go-to tutorials, courses, or docs for mastering queries, indexing, and optimisation?
#PostgreSQL #BuildingInPublic
pgvector gives Postgres 6 distance operators:
<-> L2 (Euclidean)
<#> negative inner product
<=> cosine
<+> L1 (Manhattan)
<~> Hamming (bit vectors)
<%> Jaccard (bit vectors)
ORDER BY embedding <=> $1 LIMIT 5 and you've got semantic search
#PostgreSQL
#pgvector
Postgres has a search engine built in.
to_tsvector('english', 'The cats were running and the cat ran fast')
→ 'cat':2,7 'fast':9 'ran':8 'run':4
Stopwords gone, words stemmed, positions kept. Add a GIN index and you get fast keyword search.
#PostgreSQL
#pgvector
Day 3 at #PGConfEU, and there's still plenty happening in Valencia! 🐘
Kyle Flanagan takes us around the Percona booth in today's video. Kai Wagner and Zsolt Parragi are also speaking today.
Come say hello!
#PostgreSQL #OpenSource
Supabase stops auto-granting Data API access to new tables on October 30. If you hit error 42501 after that, don't fix it by granting everything back.
Grant per table and per role, turn on RLS and add a policy in the same migration.
#Supabase #PostgreSQL
Combining Listmonk with Docker Mailserver (DMS) delivers an enterprise-grade, self-hosted email marketing and transactional SMTP pipeline on DigitalOcean.
https://t.co/3eq5iE65DR
#Listmonk #DockerMailserver #EmailMarketing #DigitalOcean #SelfHost #PostgreSQL #SMTP #oDeskTeam
PostgreSQL is open source, but free does not mean secure by default.
Running default configurations without regular updates leaves systems open to attacks. Security must be an ongoing process.
#PostgreSQL #DataSecurity #TechOps
Stop relying on WHERE filters to keep your multi-tenant data safe. If a dev misses one, you have a leak. Use PostgreSQL Row Level Security (RLS) to enforce data boundaries at the DB layer. It is the ultimate safety net for SaaS. #PostgreSQL #SaaS #Backend https://t.co/whTTEN241R
Hybrid search in Postgres takes ~10 lines:
- pgvector for semantic matches
- tsvector + GIN index for keyword matches
- RRF to merge: score = Σ 1/(60 + rank)
No Elasticsearch needed. Your SKUs, error codes and acronyms will get found.
#PostgreSQL
#pgvector
#SemanticSearch
Mulai amankan fondasi basis data enterprise Anda bersama Equnix.
#Equnix #OpenSource #PostgreSQL #Database #2FAConnectionString
5/ UNION stacks the results of two SELECTs:
UNION removes duplicates
UNION ALL keeps them
Both need the same number of columns, with matching data types.
Day 8 done. 92 to go.
Notes and code: https://t.co/dqCXW3KaFk
#SQL #PostgreSQL #LearningInPublic
DATABASE PERFORMANCE
Your application might have a great UI, clean code, and powerful features—but if database queries are slow, the entire user experience can suffer.
My approach:
#DatabasePerformance #DatabaseOptimization #FullStackDeveloper #SoftwareEngineering #PostgreSQL
Day 154: 5 tests passed. Zero proof the pipeline worked.
My M-Pesa Financial Intelligence Platform reported:
5 tests passed ✅
But the tests weren't even calling the Analytics Service.
#BuildInPublic #Python #FastAPI #Microservices #PostgreSQL #SoftwareTesting #FinTech
Day 8.
Backend stack locked in.
#Supabase for Auth + #PostgreSQL + most of the backend.
Already building. 🚀
Before I open the MVP, what are the 3 backend must-haves you’d never skip?
Drop them below 👇
Planning to modernize #OracleDatabases? Start by uncovering what’s inside them.
#CloudAtlas® Oracle Workbench helps your team turn that complexity into a clear #modernization plan.
https://t.co/3m0KNVnHeH
@UnifyCloudLLC #OracleModernization #OracleForms #PostgreSQL #Application
Your app's DB user probably has DROP rights it never needs. That's how one bad connection string wipes a table. https://t.co/kf3aP6MhWO
#postgresql #mysql #leastprivilege #python #devops #infra #redis #sharding #ValtersIT #snippet #infosec #SysAdmin #cybersecurity #Linux #devsecops #developer #100daysofcode #git #github #gitlab #redteam #blueteam #ethicalhacker #cybersecurityawareness #cybersecuritynews #cybersecuritytips #hacker #kali #ubuntu #debian #docker
The vision is Nexus. The mission is to build it right, one feature at a time. 🚀
#Nexus #BackendDevelopment #NodeJS #TypeScript #ExpressJS #PostgreSQL #SoftwareEngineering #BuildInPublic #FullStackDevelopment
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
241.5M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.5M followers
Kim Kardashian
@kimkardashian
70.9M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.5M followers
Bill Gates
@billgates
65.3M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.7M followers