### Project
```sql=
CREATE TABLE users (
id INTEGER PRIMARY KEY,
email TEXT NOT NULL UNIQUE,
name TEXT NOT NULL,
avatar BLOB <--- change to BYTEA in pqsl
-- in PostgreSQL you'd have to use `BYTEA` here; `BLOB` is specific to SQLite
```
---
```
// note <form> uses enctype="multipart/form-data"
// this is required for file uploads
```
```htmlembedded=
<form enctype="multipart/form-data" method="post">
```
---
### setting format and size
``` javascript
const MAX_SIZE = 1000 * 1000 * 5; // 5 megabytes
const ALLOWED_TYPES = ["image/jpeg", "image/png"];
```
{"metaMigratedAt":"2023-06-16T12:42:44.820Z","metaMigratedFrom":"YAML","title":"project Danilo, Alax and Mohamed","breaks":true,"contributors":"[{\"id\":\"0a3ab15b-3310-4524-96d0-8240b9d0005e\",\"add\":680,\"del\":27}]"}