Game Development Community

Ids

by Ted Lilljegren · in Technical Issues · 07/22/2007 (2:40 pm) · 1 replies

Very brief question: is identfication of users and items in DBS using strings entirly out of the question? Do i have to use Integers? I remember from web programing that it was often beter to use an integer to identify an user. If so, how do i set a column in sqLite to auto increment and primary key?

Thanks for your time

#1
07/22/2007 (3:52 pm)
It's not out of the question to use strings, after all it's your application so use what ever you feel best - integer are usually the best policy because they are more efficient as indexes and require less space than characters but it's totally up to you.

Can't help with the sqllite bit though as I've never used it before.