jeudi 21 janvier 2016

Best way to represent 3 dimensional data in sqlite table?

I was wondering if there is a nice way to represent a three dimensional table in sqlite. i.e. how to create a table in sqlite with a 3rd dimension: e.g.: col, row, and height?

In my case, number of columns would be fixed, but rows and height will grow on demand by inserting.

If possible, how does one SELECT a specific height on a specific row?

Aucun commentaire:

Enregistrer un commentaire