suggestion: add support for django

[yashasolutions]

First of all, thank you for this excellent project! py-pglite looks like a brilliant tool for ultra-fast test environments, and the in-memory PostgreSQL approach is a game-changer for many use cases.

Currently, py-pglite offers native support for SQLAlchemy and SQLModel, which is great. However, I’d like to propose adding native support for Django ORM models as well. Django has a large and active user base, and in-memory test databases are highly valuable for running fast unit and integration tests during development and CI.

Django’s default test setup involves spinning up and tearing down actual PostgreSQL instances, which can be slow - so the in memory approach sounds attractive.

I don't know how much work it would be, but in case it is not too much work it feels it would be valuable for a large audience.

[wey-gu]

Dear @yashasolutions
Thank you for your kind words and thoughtful feature request! so excited to hear that py-pglite has been helpful for your testing needs.

You've made an excellent point about Django's large user base and the value of in-memory test databases for Django developers. I completely agree that adding native Django ORM support would be a valuable addition to py-pglite.

Will be working on it!
BR//wey

[93578237]

Also is it possible to make sqlalchemy optional? For Django codebase this is an unnecessary dependency.

[93578237]

It would be great to support pytest-django as well.

[wey-gu]

Also is it possible to make sqlalchemy optional? For Django codebase this is an unnecessary dependency.

wow, got it! will do

It would be great to support pytest-django as well.

Sure!

[93578237]

I tried to use with django (pytest-django) with psycopg(3) backend and it fails in django with NotSupportedError('PostgreSQL 13 or later is required (found 0.0).')

connection: psycopg.Connection
connection.info.server_version is 0

you can mock it and return 13+ but then it fails Fatal Python error: Segmentation fault

[wey-gu]

@q0w it's already done via #10 !

[93578237]

@wey-gu tests are skipped because of

🚫 SQLAlchemy not available. Install with: pip install 'py-pglite[sqlalchemy]'

in

@pytest.mark.pglite_django
def test_create_user(transactional_db) -> None:
       pass

it happens because of

py-pglite/py_pglite/pytest_plugin.py

Line 195 in 87e648d

if fixture_names & sqlalchemy_fixtures:

- pglite_manager