CODEWITHSUNDEEP
c++sqlcapisqlite
Rella
Rella

Reputation: 66935

Using SQL lite from sources - how to create a DB file and put into it some data?

So we want to use SQL lite directly from source (mainly because we create a crossplatform opensource app and there are no crossplatfrom lib distributions of SQL LITE) So we download sqlite-amalgamation and create a simple static lib from it. We include sqlite3.h and sqlite3ext.h to our project file and than what - how to create a simple DB file and fill any fields in it?

Upvotes: 0

Views: 345

Answers (1)

still_learning
still_learning

Reputation: 46

I found this tutorial as well as this video very helpful to get started. The video should help you set up the project so that you can create and connect to a simple db. The code from the first tutorial is almost identical to the example on the sqlite homepage. Despite lack of in-depth explanation the tutorial was extremely helpful to me since it comes with source code and MSVS projects. You can use those to have a play with. I would also recommend getting the SQLite Administrator tool to have a GUI for your db.

Upvotes: 1

Related Questions