Populate a list with data from SQlite?

Hello guys,

How can I populate an *ngFor list with all data from SQlite?
For example, let’s say I have several data objects stored with different keys inside SQlite.
and I want to call all of them up on an html list like this:

<div *ngFor="let item of items">
   <h1>{{ item.name }}</h1>
<p> {{ item.about }} </p>

and here’s my ts file for that:

  ionViewDidLoad() {


This ts code will not work… I don’t know how to get all items in sqlite at a time.

Please help.