I am starting to work with SQLite in Qt Creator. I never worked with SQLite before. How can I create a table to store the following data?
int id;
QString fullName;
int age;
QVector<QString> friendsFirstName;
QVector<QString> friendsSurname;
In fact, my doubt is how to store vectors that must be linked to a single record? SQLite provides some vector type?
Thanks in advance
Best Answer
Only some basic types.
You can however use the BLOB type to save whatever you want.
Are you going to do the vector processing outside to SQLite?
https://www.sqlite.org/datatype3.html
floating point number.