#Postgresql supports doing `WHERE IN` queries with a single type-safe placeholder rather than making you manually list out separate placeholders for each item.
This is probably the Postgres feature I want in other OSS DBs more than anything else. And it's not even close.
The amount of hassle it would save me on this project (SQLite-based) is mind-boggling.
#Programming #SQL
Larry Garfield /
npub1aq…j28fe
2025-01-12 06:35:07
Author Public Key
npub1aqsp4hwy8hfzvre05whanzj9dz7naae9dach8a75gnm8wq6q6f4qdj28fePublished at
2025-01-12 06:35:07Event JSON
{
"id": "1db12dea43949960d9867dc99afbe5654126f8d331c204fa298c6feca424dfcf",
"pubkey": "e8201addc43dd2260f2fa3afd98a4568bd3ef7256f7173f7d444f6770340d26a",
"created_at": 1736663707,
"kind": 1,
"tags": [
[
"t",
"postgresql"
],
[
"t",
"programming"
],
[
"t",
"sql"
],
[
"proxy",
"https://phpc.social/users/Crell/statuses/113813992744514816",
"activitypub"
]
],
"content": "#Postgresql supports doing `WHERE IN` queries with a single type-safe placeholder rather than making you manually list out separate placeholders for each item.\n\nThis is probably the Postgres feature I want in other OSS DBs more than anything else. And it's not even close.\n\nThe amount of hassle it would save me on this project (SQLite-based) is mind-boggling.\n\n#Programming #SQL",
"sig": "564c1fa6999f51c0e7423039f6bdb6bafd4b6d1eb5d6a2af8e38b3910d52312bbb0e0c9f0fbf2573b8dbbcda65440dfbaf05d61618416ce21a788856981c6ba2"
}