Add sample for SQLite event store web api

[oskardudycz]

We have samples for PostgreSQL, MongoDB and EventStoreDB, but not yet for SQLite. It'd be great to add them.

See the existing samples: https://github.com/event-driven-io/emmett/tree/main/samples/webApi.

The thing that'll be missing in the first version are Pongo projections for read model, as I'm working on adding SQLite support to Pongo, but the rest should be fine.

I suggest using a regular SQLite file-based eventstore instead of the in-memory version.

[pawel-twardziak]

@oskardudycz hi :)
Any deadline you want it to be done by? 😺

[oskardudycz]

@pawel-twardziak For yesterday! 😅

Jokes aside, my suggestion would be to send smaller Pull Requests one by one, e.g. first one with the project structure, the next one with domain code, then API and tests.

If you do it, even if you'll get some other priorities at some point, then someone else could take it from there. 🙂

Plus it's more motivating to deliver something faster, and it gives me the chance to help you or comment.

[pawel-twardziak]

@oskardudycz ok, then I will do that for yesterday! Hopefully yesterday is gonna come again! 😆

Yep! I am with you 100% on that approach - step by step stone by stone - as Whitney Houston sang 🎵

Expect initial draft commit this weekend 🚀 (now I will be held accountable for it 😃)

[oskardudycz]

I mean, I’m not lying about bringing applications back to the future! 🚀😅

Jokes aside, no pressure and thanks in advance!

[pawel-twardziak]

@oskardudycz First delay recorded! sorry! Apparently, my weekend was chill to me 🧒 I had to rest. I'll take up the topic this weekend.

[oskardudycz]

@pawel-twardziak no worries, weekend should be for resting 🙂 Thanks for following up.

[pawel-twardziak]

@oskardudycz thanks for understanding 👍I usually work on side OSS projects on weekends because of my regular job 9-17 😆 in the evenings, I need to take a break from my computer as much as I can.

[pawel-twardziak]

@oskardudycz finally! I can kick it off today 🚀 Sorry for the delay. My habd are always dirty with somethig and time is limited :(

[oskardudycz]

@pawel-twardziak no need to be sorry; you're doing that in your spare time, so there's no rush. Don't put too much pressure on yourself. I'll appreciate it when it's ready 🙂

[pawel-twardziak]

@oskardudycz thanks for kind words 😸 As for me, it is not about pressure, it is about remembering that I've committed myself to something and continuously waiting for the moment to do that 😆

[pawel-twardziak]

Either way, I stared yesterday, that's good news 👍