want to quickly check the permissions on your #postgreql DB? simply run these 5 easy to remember commands:
\du
\l+ (db name)
\dn+
\dp
\ddp
(and then cross reference the list of 9 characters next to each username against the manual)
(about sums up my confusion this evening)
Levei um tempão para tentar otimizar a performance do portal, e era só criar um índice duplo para atender o ORDER BY
O resultado da busca caiu de 1500 milissegundo para 5 milissegundos 🙏
#postgreql
PostgreSQL in #WASM allows you to run a #PostgreQL instance in the browser, Node.js, or Bun. Finally a proper, dependency-less database server for your browser :) #linktuesday