Hello! I think your structure is not good enough. You may use cookie-based database selection instead and doesn't store user information into your "Master DB".
The algorithm is like to: Username -> user_id -> check password by user_id database As example: User enter USERNAME and PASSWORD and we check PASSWORD in database file md5(USERNAME).db You may block brutforces in your application. For valid users performance is usually fine by this schema. P.S. For javascript auto-complete of user names is possible to build list of usernames periodically. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
