Add SQLite package

[hishamco]

Problem

Lack to support SQLite database OOB

Solution

Introducing Testcontainers.Sqlite package

Benefit

Allow devs to use SQLite

Alternatives

Nothing

Would you like to help contributing this enhancement?

Yes

[0xced]

Could you please elaborate on what are the advantages of using a Docker container over directly using one of the many available SQLite libraries such as Microsoft.Data.Sqlite, SQLite-net or System.Data.SQLite?

[hishamco]

I working on an OSS project I just find myself need a docker image for integration testing. I know I can manage it myself by creating a .db but I need to cleanup everything after the testing

[HofmeisterAn]

Couldn't you use the generic container builder? We could add a section to our documentation covering common builder patterns, similar to an article or how-to guide. I am uncertain whether we require modules for all kinds of "simple" configurations.

Is there even a container image available? How would you access the database from remote? Looking forward to discussing this topic and hear your thoughts (since I would simply store the database in-memory and might miss something).

[hishamco]

Is there even a container image available?

https://hub.docker.com/r/keinos/sqlite3#!

(since I would simply store the database in-memory and might miss something).

This sometimes problematic especially in testing

[HofmeisterAn]

https://hub.docker.com/r/keinos/sqlite3#!

As I commented here, I do not think it hosts a database accessible remotely. According to the Docker Hub docs, they also mount the database file from the host. I am not sure how you are planning to implement a module, but I am curious to see the proof of concept.