[Lazarus] data matrix with thousands of columns

[Andrea Mauri]

one more thing. my data is more similar to a huge spreadsheet than a 
relational DB, anyway I am looking for the best option already available 
in lazarus/fpc to store and query the dataset

Il 26/03/2013 15:38, Andrea Mauri ha scritto:
> Dear all,
> I am looking for the best option in order to store big datasets with
> thousands of columns.
> The dataset can contains from tens to hundred thousands lines and
> thousand of columns (some columns are string some numbers).
> Which is the best option to store and retrieve information from a
> dataset like this?
> Actually I am using sqlite, tens of tables including maximum 200
> columns. But I am not sure this is the best option.
> Within my application I have to query this dataset:
> - retrieve a particular line (all or some columns);
> - retrieve a particular column (all or some lines);
> - order the dataset with respect to a particular column;
> - delete/add line(s);
> - delete/add column(s);
> ...
>
> SQLIte is easy to use when I need to query the dataset but I am not sure
> that is the most suitable.
>
> Any hint?
> Andrea Mauri