Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In a LiteFarm deployment, the database runs as litefarm-db, a Docker container built from the official Postgres image.

Auto-Increment ID Conventions as of August 2024

In our migration strategy:

  • Manually Set IDs: Used for the permissions table to ensure consistent IDs across different environments (local, beta, production).

    • Previously, hard-coding IDs led to "UniqueViolationError" issues when inserting new rows.

      • #2857 (comment)

      • Jira Legacy
        serverSystem Jira
        serverId815f41e5-e5fb-3402-8587-82eccc3ffab0
        keyLF-3651

  • Auto-Increment IDs: Applied by default unless there's a specific reason to manually set IDs. This helps avoid conflicts and simplifies record management.

The API code

An Application Programming Interface (API) is an interface that a software product provides for use by other software, rather than by human users.

...