Just found out you can hash passwords in Postgres using the pgcrypto extension. I can't really see a reason why you'd want to hash passwords manually instead of just using that. At least in the context of a normal web app.
March 13, 2025 at 3:38 PM
Just found out you can hash passwords in Postgres using the pgcrypto extension. I can't really see a reason why you'd want to hash passwords manually instead of just using that. At least in the context of a normal web app.
Руководство по pgcrypto — шифрование внутри PostgreSQL. Часть 2 https:// habr.com/ru/companies/selectel /articles/925948/?utm_source=habrahabr&utm_medium=rss&utm_campaign=925948
Interest | Match | Feed
Interest | Match | Feed
Origin
pravda.me
July 11, 2025 at 1:00 PM
Identificador Único Universal (UUID): o que a pgcrypto e a sua mãe têm em comum... Sim eu sei, a comparação entre a sua mãe e uma extensão do PostgreSQL pode soar um tanto quanto estranha e ...
#uuid #rails #humor #postgres
Origin | Interest | Match
#uuid #rails #humor #postgres
Origin | Interest | Match
Identificador Único Universal (UUID): o que a pgcrypto e a sua mãe têm em comum...
Sim eu sei, a comparação entre a sua mãe e uma extensão do PostgreSQL pode soar um tanto quanto...
dev.to
July 26, 2025 at 3:47 AM
"A few secure, random bytes without `pgcrypto`" 🔮
Generating a ULID using a roundabout way to avoid a dependency on the pgcrypto extension used just to get `gen_random_bytes()`
https://brandur.org/fragments/secure-bytes-without-pgcrypto
By @brandur
#postgresql #postgres #pgcrypto #uuid […]
Generating a ULID using a roundabout way to avoid a dependency on the pgcrypto extension used just to get `gen_random_bytes()`
https://brandur.org/fragments/secure-bytes-without-pgcrypto
By @brandur
#postgresql #postgres #pgcrypto #uuid […]
Original post on fosstodon.org
fosstodon.org
October 1, 2024 at 12:28 AM
"A few secure, random bytes without `pgcrypto`" 🔮
Generating a ULID using a roundabout way to avoid a dependency on the pgcrypto extension used just to get `gen_random_bytes()`
https://brandur.org/fragments/secure-bytes-without-pgcrypto
By @brandur
#postgresql #postgres #pgcrypto #uuid […]
Generating a ULID using a roundabout way to avoid a dependency on the pgcrypto extension used just to get `gen_random_bytes()`
https://brandur.org/fragments/secure-bytes-without-pgcrypto
By @brandur
#postgresql #postgres #pgcrypto #uuid […]
PostgreSQL 18 is gearing up to add SHA-2 based password hashes to pgcrypto. Finally, a password security update that doesn't feel like a medieval torture device. Kudos to Álvaro Herrera and the team for keeping it modern.
https://postgr.es/p/760
https://postgr.es/p/760
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.
https://postgr.es/p/760
postgr.es
April 17, 2025 at 1:08 PM
PostgreSQL 18 is gearing up to add SHA-2 based password hashes to pgcrypto. Finally, a password security update that doesn't feel like a medieval torture device. Kudos to Álvaro Herrera and the team for keeping it modern.
https://postgr.es/p/760
https://postgr.es/p/760
To my #postgresql tweeps: what are the extensions that you build/enable by default on your production databases? Anything outside `contrib`? I would assume pgaudit, pgcrypto and pg_stat_statements. What else?
November 10, 2024 at 2:28 AM
To my #postgresql tweeps: what are the extensions that you build/enable by default on your production databases? Anything outside `contrib`? I would assume pgaudit, pgcrypto and pg_stat_statements. What else?
Waiting for # PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto. – select * from depesz; https://www. depesz.com/2025/04/17/waiting- for-postgresql-18-add-modern-sha-2-based-password-hashes-to-pgcrypto/
Interest | Match | Feed
Interest | Match | Feed
Origin
fosstodon.org
August 7, 2025 at 4:03 PM
pgcrypto + pgjwt for authentication combined with psql policies for row level access security www.postgresql.org/docs/current... github.com/michelp/pgjwt
March 6, 2025 at 8:31 AM
pgcrypto + pgjwt for authentication combined with psql policies for row level access security www.postgresql.org/docs/current... github.com/michelp/pgjwt
Ok, Gemini, Claude, Deepseek. They all fully haluzinate when it comes to decrypt a symmetric pgp content from pgcrypto. They lie that GnuPG from PHP can do it, when it absolutely cannot. they also use old or wrong openpgp-php implementations. What a fuck shit is this
April 8, 2025 at 6:15 AM
Ok, Gemini, Claude, Deepseek. They all fully haluzinate when it comes to decrypt a symmetric pgp content from pgcrypto. They lie that GnuPG from PHP can do it, when it absolutely cannot. they also use old or wrong openpgp-php implementations. What a fuck shit is this
One Simple pgcrypto Tweak That Saves Millions #1 This article is based on my experience with usin...
https://levelup.gitconnected.com/one-simple-pgcrypto-tweak-that-saves-millions-1-b6293746d95c?source=rss------technology-5
#encryption #technology #backend #postgresql #database
Event Attributes
https://levelup.gitconnected.com/one-simple-pgcrypto-tweak-that-saves-millions-1-b6293746d95c?source=rss------technology-5
#encryption #technology #backend #postgresql #database
Event Attributes
One Simple pgcrypto Tweak That Saves Millions #1
This article is based on my experience with using a random secret key in pgcrypto. Initially, everything seemed fine with only 1.000 users…
levelup.gitconnected.com
January 10, 2025 at 3:05 AM
One Simple pgcrypto Tweak That Saves Millions #1 This article is based on my experience with usin...
https://levelup.gitconnected.com/one-simple-pgcrypto-tweak-that-saves-millions-1-b6293746d95c?source=rss------technology-5
#encryption #technology #backend #postgresql #database
Event Attributes
https://levelup.gitconnected.com/one-simple-pgcrypto-tweak-that-saves-millions-1-b6293746d95c?source=rss------technology-5
#encryption #technology #backend #postgresql #database
Event Attributes
PostgreSQL 18 is already in testing mode. We’ve wrapped up CommitFests, and no new features are joining the party. Just a few performance tweaks and a modern password hash for pgcrypto. Welcome to the future, folks. Thanks, Hubert and Jim.
https://postgr.es/p/768
https://postgr.es/p/768
Ian Barwick: PgPedia Week, 2025-04-20
https://postgr.es/p/768
postgr.es
April 22, 2025 at 1:03 PM
PostgreSQL 18 is already in testing mode. We’ve wrapped up CommitFests, and no new features are joining the party. Just a few performance tweaks and a modern password hash for pgcrypto. Welcome to the future, folks. Thanks, Hubert and Jim.
https://postgr.es/p/768
https://postgr.es/p/768
hex = encrypted.unpack1("H*")
sql = "SELECT pgp_sym_decrypt(decode('#{hex}', 'hex'), #{ActiveRecord::Base.connection.quote(secret)})"
Anyone else run into this? How’d you solve it?
#PostgreSQL #RubyOnRails #pgcrypto #encryption #security #bughunt
sql = "SELECT pgp_sym_decrypt(decode('#{hex}', 'hex'), #{ActiveRecord::Base.connection.quote(secret)})"
Anyone else run into this? How’d you solve it?
#PostgreSQL #RubyOnRails #pgcrypto #encryption #security #bughunt
May 2, 2025 at 4:03 PM
hex = encrypted.unpack1("H*")
sql = "SELECT pgp_sym_decrypt(decode('#{hex}', 'hex'), #{ActiveRecord::Base.connection.quote(secret)})"
Anyone else run into this? How’d you solve it?
#PostgreSQL #RubyOnRails #pgcrypto #encryption #security #bughunt
sql = "SELECT pgp_sym_decrypt(decode('#{hex}', 'hex'), #{ActiveRecord::Base.connection.quote(secret)})"
Anyone else run into this? How’d you solve it?
#PostgreSQL #RubyOnRails #pgcrypto #encryption #security #bughunt
Did you know that you can encrypt data directly in #SQL via PostgreSQL?
#PostgreSQL's pgcrypto module provides powerful cryptographic functions for encrypting, decrypting, and hashing data. It's perfect for securely handling sensitive information in your database. 🔐
#PostgreSQL's pgcrypto module provides powerful cryptographic functions for encrypting, decrypting, and hashing data. It's perfect for securely handling sensitive information in your database. 🔐
November 24, 2024 at 4:55 PM
Did you know that you can encrypt data directly in #SQL via PostgreSQL?
#PostgreSQL's pgcrypto module provides powerful cryptographic functions for encrypting, decrypting, and hashing data. It's perfect for securely handling sensitive information in your database. 🔐
#PostgreSQL's pgcrypto module provides powerful cryptographic functions for encrypting, decrypting, and hashing data. It's perfect for securely handling sensitive information in your database. 🔐
Fortifying # PostgreSQL : Advanced Security Strategies! Learn how to protect databases with authentication, encryption, auditing, pgcrypto, TDE & more by Kothari Nishchay Click here: https:// youtu.be/eULP2L7ogNQ
Interest | Match | Feed
Interest | Match | Feed
Origin
floss.social
September 24, 2025 at 2:56 PM
Doing some LLM testing by asking various coding questions.
Ask "differeng pgcrypto digest and hmac" and for the hmac example it stored the key inside the table ... when pressed its like "oh yeah that ain't good brah"
So ...
if anyone vibe codes
without having ANY fucking coding experience […]
Ask "differeng pgcrypto digest and hmac" and for the hmac example it stored the key inside the table ... when pressed its like "oh yeah that ain't good brah"
So ...
if anyone vibe codes
without having ANY fucking coding experience […]
Original post on famichiki.jp
famichiki.jp
April 4, 2025 at 2:41 AM
Doing some LLM testing by asking various coding questions.
Ask "differeng pgcrypto digest and hmac" and for the hmac example it stored the key inside the table ... when pressed its like "oh yeah that ain't good brah"
So ...
if anyone vibe codes
without having ANY fucking coding experience […]
Ask "differeng pgcrypto digest and hmac" and for the hmac example it stored the key inside the table ... when pressed its like "oh yeah that ain't good brah"
So ...
if anyone vibe codes
without having ANY fucking coding experience […]
Руководство по pgcrypto — шифрование внутри PostgreSQL. Часть 2 Привет, Хабр! На связи снова Антон Дятлов, инженер по ...
#selectel #базы #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
#selectel #базы #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
July 11, 2025 at 1:24 PM
Руководство по pgcrypto — шифрование внутри PostgreSQL. Часть 2 Привет, Хабр! На связи снова Антон Дятлов, инженер по ...
#selectel #базы #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
#selectel #базы #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
Before using pgcrypto, you need to install the extension:
CREATE EXTENSION IF NOT EXISTS pgcrypto;
This gives you access to encryption and hashing functions.
CREATE EXTENSION IF NOT EXISTS pgcrypto;
This gives you access to encryption and hashing functions.
November 24, 2024 at 4:55 PM
Before using pgcrypto, you need to install the extension:
CREATE EXTENSION IF NOT EXISTS pgcrypto;
This gives you access to encryption and hashing functions.
CREATE EXTENSION IF NOT EXISTS pgcrypto;
This gives you access to encryption and hashing functions.
Руководство по pgcrypto — шифрование внутри PostgreSQL. Часть 1 Привет, Хабр! На связи Антон Дятлов, инженер по защите...
#selectel #базы #данных #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
#selectel #базы #данных #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
July 8, 2025 at 1:14 PM
Руководство по pgcrypto — шифрование внутри PostgreSQL. Часть 1 Привет, Хабр! На связи Антон Дятлов, инженер по защите...
#selectel #базы #данных #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match
#selectel #базы #данных #postgresql #pgcrypto #шифрование #чувствительные #данные #разработка
Origin | Interest | Match