Database & ORM

Register DatabaseServiceProvider and configure config/database.ts:

export default {
  default: 'sqlite',
  connections: {
    sqlite: { driver: 'sqlite', database: 'database/database.sqlite' },
    postgres: {
      driver: 'postgres',
      host: '127.0.0.1',
      database: 'pondoknusa',
      username: 'postgres',
      password: '',
    },
  },
} as const;

Optional drivers (register the matching service provider before DatabaseServiceProvider). Install the driver and @pondoknusa/database — drivers declare the ORM as a peer so DatabaseManager.extend() shares one registry with core:

Driver	Package	Install
postgres	@pondoknusa/database-pg	npm install @pondoknusa/database-pg @pondoknusa/database
mysql	@pondoknusa/database-mysql	npm install @pondoknusa/database-mysql @pondoknusa/database
oracle	@pondoknusa/database-oracle	npm install @pondoknusa/database-oracle @pondoknusa/database
mssql	@pondoknusa/database-mssql	npm install @pondoknusa/database-mssql @pondoknusa/database
d1	@pondoknusa/database-d1	npm install @pondoknusa/database-d1 @pondoknusa/database

Oracle uses thin mode by default (no Instant Client required for typical setups). DB_DATABASE is the Oracle service name. SQL Server accepts optional encrypt / trustServerCertificate (env: DB_ENCRYPT, DB_TRUST_SERVER_CERTIFICATE).

Models

export class User extends Model<UserAttributes> {
  static override table = 'users';

  static scopeActive(builder: ModelQueryBuilder) {
    return builder.where('active', 1);
  }
}

const users = await User.all();
const active = await User.scope('active').getModels();
const user = await User.find(1);

Relationships

const posts = await user.hasMany(Post).get();
const author = await post.belongsTo(User).get();
const roles = await user.belongsToMany(Role).get();

Eager-load to avoid N+1 queries:

const users = await User.query().with('posts').getModels();

Migrations

pondoknusa make:migration create_posts_table
pondoknusa migrate

await schema.create('posts', (table) => {
  table.id();
  table.string('title');
  table.timestamps();
});

Factories & seeders

pondoknusa make:factory Post
pondoknusa make:seeder DatabaseSeeder
pondoknusa db:seed

Computed attributes

Whitelist accessors in JSON output:

export class Post extends Model<PostAttributes> {
  static override appends = ['rendered_body'];

  get rendered_body(): string {
    return markdownToHtml(this.getAttribute('body') ?? '');
  }
}