Skip to content

Drizzle: 50-line program against real MySQL via @perry/mysql (followup to #488) #489

@proggeramlug

Description

@proggeramlug

Scope

Followup to #488 (drizzle + Postgres). Same end-to-end demo, MySQL flavor:

One of: pg, mysql2, sqlite drivers verified end-to-end. Others as follow-up.

Driver choice: @perry/mysql (pure-TS)

Use `@perry/mysql` (pure-TS MySQL/MariaDB wire-protocol driver, lives at `PerryTS/mysql`) — same reasoning as #488: pure-TS dep tree exercises perry's full compile-packages path.

What's left

  1. Wire `@perry/mysql` as drizzle's mysql driver.
  2. 50-line program: schema + insert/select/update/delete + relation join via `leftJoin`.
  3. Run against a real MySQL on `127.0.0.1:3306` (docker / mysqld).
  4. Diff binary output against `node --experimental-strip-types`.

Blocked on

#488 lands first. Once Postgres path works end-to-end, MySQL is a smaller delta — same drizzle surface, different driver.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions