Here is the final article of SQLite series.
I don’t expect you to read entirely but at least take a look at these notes It is important to know limitations of the tool you are using. This may also affect your choice regarding the tool you’ll use in your project.
Making SQLite calls async
There is a GitHub repo which’ll let you to do async data access. It is -for the moment- the best one I found.
What if I want to use it on mobile apps?
This fellow created a series of two articles which explain very clearly how to use SQLite on universal applications. Also, this article -despite the fact that it is a bit old- gives good idea of where to start.
What if I want to parse an existing CSV to fill my database?
That happened to me when I was working on a project that employs SQL Server :). What I did was to create a data importer class using a library called fast member The basic idea is:
- parse the CSV
- transform lines into objects
- gather these objects using a list
- bulk insert them into the database (fast-member takes a list and creates a reader that you can
use in in
WriteToServermethod. Here is a code snippet:
Are there any other tools that can facilitate my life?
Along with fast-member, there are 2 libraries that I use frequently :