# limit order

## Backend

### Common overview

### Worker details

### API details

### Databse
#### Options

| Name | Advantages | Disadvantages | Comments |
| ----------- | ---------------------------- | ----------------------------------------------------------- | -------- |
| PostgresSQL | Fast, stable, structed | Not self hosted | - |
| SQL Lite | Self hosted | Slower than all others SQL, not sync mechanism | - |
| MongoDB | Fast, stable good replicated | Not SQL queries | - |
| Clickhouse | Ultra fast | ?? | - |
| Redis | Ultra fast | no serach for some fields, hard to replicate, hard to scale | - |

## Types

### Order

| Name | Type | Indexed | |
| -------------- | -------------------------------------------------- | ------- | --- |
| id | number or string | | |
| createdAt | time | | |
| deletedAt | time | | |
| updatedAt | time | | |
| orderType | orderType (RFQ | Normal) | |
| orderStatus | orderStatus (Filled, Cacncelled, Active, Outdated) | | |
| salt | uint256 | | |
| makerAsset | Asset or Address | true | |
| takerAsset | Asset or Address | true | |
| makerAssetData | assetData or bytes | | |
| takerAssetData | assetData or bytes | | |
| getMakerAmount | bytes | | |
| getTakerAmount | bytes | | |
| predicate | bytes | | |
| permit | bytes | | |
| interaction | bytes | | |