I'm creating an application in C#
that must have a database. At first I'm thinking of using SQlite for simplicity. But for each data inserted in my bank must have:
- Identifier (
int
,char
,bool
) ... - Vector (which can be as large as 2,10000)
The problem is how to store this vector, and SQLite does not accept vectors.
I have researched some solutions, but I have doubts about these options and their problems.
1 - Store as a string:
Is there any problem storing very large strings? Anyway my values are float
or double
, and converting to string
, I'll easily be losing information, so I do not know if this is a good solution.
2 - Create new tables for each new entry:
So I would have a main table and for each new input I would need to create a new table. The solution might be interesting, but could a database with many tables (10000 tables) be slow?
I would like one of these two options above if any of them might work fine, or else I would suggest another alternative to a database so I can put vectors as table elements.