Create conversation app with sqlite, best practice

I know there are a lot of question about chatapp But none of them satisfied me or helped me. So I decide to create a new one.
I want to create a clientside chat with sqlite. It should be like this:
But this is written in ionic v1. Is there an example like that with ionic v3?