Model PostgreSQL entities and build fluent queries in TypeScript with BigAl.
npx skills add https://github.com/bigalorm/bigal --skill using-bigal
Please help me install this Agent Skill. Skill: using-bigal Source: https://github.com/bigalorm/bigal/tree/main/skills/using-bigal Command: npx skills add https://github.com/bigalorm/bigal --skill using-bigal
Type-safe PostgreSQL data access in TypeScript is error-prone when using raw SQL or weakly typed mappers. This Skill provides structured guidance to model entities with decorators, craft fluent queries, and leverage the repository pattern for CRUD and complex queries.
Install BigAl, define an Entity using decorators, initialize the repository, and execute a simple find query.
High-intent search queries and answers about installing and using this skill.
Type-safe PostgreSQL data access in TypeScript is achieved by defining entities with decorators, using a fluent query builder, and applying the repository pattern for structured CRUD operations and complex queries.
Querying JSONB columns and applying pagination are handled through the fluent query builder, which provides specific methods for JSONB querying, pagination, and DISTINCT ON support to manage complex data retrieval.
A TypeScript ORM is best for structured CRUD and type-safe modeling, while raw SQL is preferred for complex queries. Guidance on choosing between them is based on specific application scenarios and performance needs.
Entity models are defined using decorator-based annotations to control schema, enabling type-safe mapping. You initialize the repository and execute find queries to interact with PostgreSQL.
Yes, the fluent query builder supports joins and subqueries, allowing you to craft complex find and count operations while maintaining type safety across your PostgreSQL data layer.
FindMalekConfigure Prisma for multiple database providers and set up the client.
bughqConstruct type-safe SQL queries with a fluent API for Stacks applications.
autorundevAutomate database migrations for Python applications using Alembic and raw SQL.
nhattran998Build type-safe SQL queries in TypeScript with compile-time validation.
