Database

The Fuel indexer uses Postgres as the primary database.

Note: Indexing also supports SQLite. However, we recommend Postgres usage for any type of production service.

• Types
  • How to use different data types from your Sway contract, all the way to your Postgres table
• Foreign Keys
  • How foreign keys are handled in GraphQL schema, Postgres, and SQLite
• Directives
  • How GraphQL schema directives are translated into data-layer constraints
• ⚠️ IDs
  • Explains some conventions surrounding the usage of ID types