Sqlite support?

[bdovaz]

I'm surprised it doesn't have support:

https://github.com/thepirat000/Audit.NET/tree/master?tab=readme-ov-file#data-providers-included

Among other things, it would be useful to be able to iterate quickly in the IDE without relying on an external service such as a Docker container with the database, etc.

Are there plans to add it? If not, what is the recommendation for rapid iteration without external services?

Thank you.

[thepirat000]

You can store audit events using SqlLite, but only via Entity Framework (using the DbContextDataProvider)

Here is the description the readme: https://github.com/thepirat000/Audit.NET/tree/master/src/Audit.EntityFramework#generic-dbcontext-data-provider

Currently there is no dataprovider that uses ADO.NET provider for SqlLite directly .

There isn't a plan to remove the external dependencies from the integration tests. Some of the services don't have in-memory equivalents, so real instances are needed to verify behavior. That's why there is a test category "Integration" for those tests.

For fast iteration when developing locally, focus on the unit tests that don’t need external services (TestCategory!=Integration). Keep the Docker-based integration tests for CI or when you need to verify actual service behavior.

If you have any suggestions on improving this or ideas for faster local iteration, I’m more than open to hearing them.