Spiderly Backend CRUD Hooks FAQs

Question 1

How do I override a hook in Spiderly?

Accepted Answer

Create an {Entity}Service class that inherits from the auto-generated {Entity}ServiceGenerated class and override the desired virtual method. The source generator automatically detects and registers your override.

Question 2

What is the PostgreSQL MARS pitfall mentioned?

Accepted Answer

PostgreSQL doesn't support Multiple Active Result Sets; the skill provides guidance on materializing queries with .Select() or using .Include() to avoid connection busy errors.

Question 3

Are hook executions transactional?

Accepted Answer

Yes, all generated methods wrap logic in a transaction via _context.WithTransactionAsync, ensuring atomicity for database operations and tracked writes within any OnBefore hook.

Question 4

Can I perform validation inside these hooks?

Accepted Answer

Yes, use the BusinessException(message) for UI-facing validation errors and SecurityViolationException() for unauthorized access attempts or data tampering.

Question 5

How does this skill handle file uploads?

Accepted Answer

It provides specific hooks for blob authorization and byte transformation or optimization (like image resizing) before the file is sent to storage.

Spiderly Backend CRUD Hooks

Key Features

Use Cases

REST API Design Patterns

Qa Javascript Typescript

Bun Runtime Optimizer