there actually are limits, though? and some operations will take much longer if you have an insane number of tables
MySQL:
> InnoDB permits up to 4 billion tables. (edit: unless your filesystem poops out first)
Postgres:
https://www.postgresql.org/docs/current/limits.html
#pedantic
feld /
npub1gp…2qcha
2024-05-15 14:22:48
in reply to nevent1q…qlc3
Author Public Key
npub1gps7g5m48t4cn2h34fh5a6pu9g3gz7943gl4rdj4fykpmd9r436s32qchaPublished at
2024-05-15 14:22:48Event JSON
{
"id": "5c1dcdf5bc588a285b80f4de79a9d57d72068c65f10f3d25ecd94600ba6714ff",
"pubkey": "4061e453753aeb89aaf1aa6f4ee83c2a228178b58a3f51b655492c1db4a3ac75",
"created_at": 1715782968,
"kind": 1,
"tags": [
[
"p",
"6adf0c2f565ae9fdf64310bdc6d5efee934c5b1faca9a82512b62230077b896c"
],
[
"e",
"2286ee14080aee69049f9ecec67b1e783294c84f02281b5622c6a23432604bae",
"",
"root"
],
[
"t",
"pedantic"
],
[
"e",
"2e82cba7c049257fc75279e42f449dd69959b0efdcf47dce66ea673a7fc2b025",
"",
"reply"
],
[
"proxy",
"https://bikeshed.party/objects/ab2ea5a7-d82d-43f5-a14e-d6d58d8763a9",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://bikeshed.party/objects/ab2ea5a7-d82d-43f5-a14e-d6d58d8763a9",
"pink.momostr"
]
],
"content": "there actually are limits, though? and some operations will take much longer if you have an insane number of tables\n\nMySQL:\n\n\u003e InnoDB permits up to 4 billion tables. (edit: unless your filesystem poops out first)\n\nPostgres:\n\nhttps://www.postgresql.org/docs/current/limits.html\n\n\n#pedantic",
"sig": "5b904827c5d9c9983269c154f4f7a0e2eb5649c30c2d3f53f78293ff4c1b86566b32d4305762d2c7d1f34d6090ddba9eb358c56f80fa767bbe8c9ed929d3a298"
}