4 ms·
Oh I see MySQL added functional indexing in 8.0.13, that’s the main thing I would miss from Postgres. Partial indexes are also nice to have, but I suppose a sop
by basil-rash 3y ago
Oh I see MySQL added functional indexing in 8.0.13, that’s the main thing I would miss from Postgres. Partial indexes are also nice to have, but I suppose a sophisticated enough ORM could map them to functional ones, at least in so far as testing is concerned. The memory use would likely be much higher than a proper partial index.
- thatwasunusual 3y ago> Oh I see MySQL added functional indexing in 8.0.13, [...] We're talking about agonostic ORMs, not specific benefits for each of the databases. I wish there were an SQL standard. But, the best part of standards is that there are so many of them. :(
- basil-rash 3y agoOh I was thinking of ORMs like Prisma, where the single ORM System is responsible for both runtime mapping of objects to relations, and development/deployment time provisioning of schemas, migrations, indexes, etc.