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

Question

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?

You might also want to have a look at the Berkeley DB implementation of sqlite. I use it cross-platform (Ubuntu/Windows) and in some cases it might also be faster. — fnokke
– fnokke, Commented Apr 13, 2011 at 11:41

still_learning · Accepted Answer · 2011-04-15 07:24:58Z

1

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.

answered Apr 15, 2011 at 7:24

still_learning

463 bronze badges

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

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related