drizzle-team / drizzle-team/drizzle-orm

[BUG]: studio is very slow when having data in PostgreSQL bytea columns

Open
#6,213 1 comment 0 reactions 1 assignee Claimed by @RomanNabukhotnyi View on GitHub
bug drizzle/studio
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

1.0.0-rc.4

### What version of `drizzle-kit` are you using?

1.0.0-rc.4

### Other packages

_No response_

### Describe the Bug

I have this table in my schema:
```ts
export const files = pgTable("files", {
id: uuid().primaryKey(),
name: varchar().notNull(),
content: bytea(),
});
```
When I load some files into it, viewing the table in my local drizzle studio becomes really slow, e.g. for a few files with a total of 50MB it takes 8s to load the table.

I guess the solution would be to ignore the data in the bytea column when viewing the table. E.g. pgAdmin does this. It just says "[binary data]" for each row and doesn't show the actual content.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.