How to retrieve data from a SQLite db in Angular?

Question

I'm new to front-end/back-end communication and I was hoping for some guidance on the basic steps to retrieve data from a SQLite db file so that I can populate a page in my angular project. If you know of any resources I could read that would be of use, that would be great, but my knowledge on where/how to get started is zilch.

If I have a SQLite db file, is it best to convert it to json first and then retrieve that file from Angular?
Can I work directly with the SQLite db file in Angular and make use of the data that way?

TL;DR - Need to access data in a SQLite db file and display that in my Angular application, but I'm unsure of where to start/what the best practices would be to accomplish this task.

This should be a good starting point, sqlitetutorial.net/sqlite-nodejs — JDunken
– JDunken, Commented Mar 6, 2020 at 18:44

Bhavik · Accepted Answer · 2020-03-06 20:12:36Z

2

If you are planning to use database in browser directly using Angular, I think you need to relay on Browser support for that. I doubt if it allows you to use SQLLite on client side. [You can use SQLLite for sure in backend NodeJs app]

That being said, you can use indexedDB specific APIs. If you want to easily integrate it with your angular app, I would suggest you to refer dexie

Hope this helps!

edited Mar 6, 2020 at 20:12

answered Mar 6, 2020 at 19:27

Bhavik

1243 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to retrieve data from a SQLite db in Angular?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related