introduce indices for accessing indices
make sure indices method is available
consistent name
simpler code
sqlite doesn't treat primary key an unique index :(
mysql works now
fix test for sqlite, i am too tired to make sqlite report primary key