Skip to content

Document PostgreSQL requirement for full test suite when using SQLite local setup #2229

@Sanjay-VK07

Description

@Sanjay-VK07

Hi,

I set up VulnerableCode locally in GitHub Codespaces using the documented Makefile flow.

What worked:

  • make dev
  • make envfile
  • make sqlite
  • make run

The application started successfully with SQLite for local development.

What I observed:

  • make test fails under SQLite because some tests rely on PostgreSQL-specific database features, including DISTINCT ON queries and JSON containment lookups.

The installation docs already mention SQLite caveats, but it would help contributors if the docs clearly stated that:

  • SQLite is fine for quick local development and running the dev server
  • PostgreSQL should be used for running the complete test suite

I’ve prepared a small docs clarification for this.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions