📊 Views encapsulate complex SELECT statements with joins & calculations, appearing as regular tables to #Laravel applications
🚀 Real performance gains: Moving profit margin calculation from accessor to stored generated column achieved 80% speed improvement (350ms to 70ms)
💡 Best for: frequently queried computed values, complex reporting queries, and scenarios where database-level operations are needed
michabbb
npub1z2…84yd9
2025-07-29 15:19:02 UTC
in reply to nevent1q…rmqz
Author Public Key
npub1z20c8zvvwqydxdthrlngrm8e08nhv7ketrz49lu9m6tzhghhwklql84yd9Seen on
wss://relay.mostr.pubPublished at
2025-07-29 15:19:02 UTCEvent JSON
{
"id": "f2dff3c9c7f1ce2b9681cbefb6dd739b64f90e18fdf7e707fed9b003c2365ef6",
"pubkey": "129f83898c7008d335771fe681ecf979e7767ad958c552ff85de962ba2f775be",
"created_at": 1753802342,
"kind": 1,
"tags": [
[
"e",
"e911315996701cb38e0294ea89a9d7e081c514d39cf9e1cf450133a315480c56",
"wss://relay.mostr.pub",
"reply"
],
[
"t",
"laravel"
],
[
"proxy",
"https://social.vivaldi.net/users/michabbb/statuses/114937190287342100",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.mostr.pub"
]
],
"content": "📊 Views encapsulate complex SELECT statements with joins \u0026 calculations, appearing as regular tables to #Laravel applications\n🚀 Real performance gains: Moving profit margin calculation from accessor to stored generated column achieved 80% speed improvement (350ms to 70ms)\n💡 Best for: frequently queried computed values, complex reporting queries, and scenarios where database-level operations are needed",
"sig": "8f488b54745de2c479ec249a5dc29d6de44b540b946780dccfdd4526b8f4b756723c9a9da79ac842b859ed43766f6e4b57f1188102c47c4232e022df5f8b4cf4"
}