Google App Engine HRD query without ancestor

Question

I have a GAE project written in Java and I have some thoughts about the HRD and a problem that I'm not sure how to solve.

Basically I have users in my system. A user consists of a userid, a username, an email and a password. Each time I create a new user, I want to check that there isn't already a user with the same userid (should never happen), username or email.

The userid is the key, so I think that doing a get with this will be consistent. However, when I do a query (and use a filter) to find possible users with the same username or email, I can't be sure that the results are consistent. So if someone has created a user with the same username or email a couple of seconds ago, I might not find it with my query. I understand that ancestors are used to work around this problem, but what if I don't have an ancestor to use for the query? The user does not have a parent.

I'd be happy to hear your thoughts on this, and what is considered to be best practice in situations like these. I'm using Objectify for GAE if that changes anything.

I asked a question that you may find very useful. (stackoverflow.com/questions/6584435/…) I, too, needed to store unique information for my users. In my case, I needed to store both a unique email and unique User ID per user. This is a bit difficult with the HRD, but I did come to a reliable solution. ...cont... — RLH
The only issue with my situation is that my account creation implementation (see my answer) will not scale well. That was OK in my circumstance because my GAE app is very small and has a slow trickle of new users (1 or 2 a month.) Also, this information is in Python, but the code is simple-- you should be able to re-translate it to Java with relative easy. — RLH
@RLH Thank you for your input, always interesting to see different solutions, but I do not think your solution would work well in my case. — Joel

stickfigure stickfigure · Accepted Answer · 2012-04-05T16:37:44

I wouldn't recommend using email or any other natural key for your User entity. Users change their email addresses and you don't want to end up rewriting all the foreign key references in your database whenever someone changes their email.

Here's a short blurb on how I solve this issue:

https://groups.google.com/d/msg/google-appengine/NdUAY0crVjg/3fJX3Gn3cOYJ

Create a separate EmailLookup entity whose @Id is the normalized form of an email address (I just lowercase everything - technically incorrect but saves a lot of pain when users accidentally capitalize [email protected]). My EmailLookup looks like this:

@Entity(name="Email")
public class EmailLookup {
    /** Use this method to normalize email addresses for lookup */
    public static String normalize(String email) {
        return email.toLowerCase();
    }

    @Id String email;
    @Index long personId;

    public EmailLookup(String email, long personId) {
        this.email = normalize(email);
        this.personId = personId;
    }
}

There is also a (not-normalized) email field in my User entity, which I use when sending outbound emails (preserve case just in case it matters for someone). When someone creates an account with a particular email, I load/create the EmailLookup and the User entities by key in a XG transaction. This guarantees that any individual email address will be unique.

The same strategy applies for any other kind of unique value; facebook id, username, etc.

Google App Engine HRD query without ancestor

4 Answers