I've spent some time attempting to create a JPA implementation for SimpleDB to see if it could be done (1) and because I couldn't imagine working without my object relational mapping framework (2). ;)
And indeed, after some serious hack sessions, I've got what appears to be a solid working version, albeit it is a subset of the full JPA spec due to the nature of SDB vs RDBMS.
Currently supports:
# @ManyToOne - object references.
# @OneToMany - collections.
# @MappedSuperClass? - Useful for a common ID and timestamping class.
# @Inheritance
# @Lob - stores lobs in S3 so make it as big as you want (up to 5GB).
# @Id - Assigns UUID automatically
# Lazy loading on ManyToOne, Lobs, and OneToMany so only hits SDB on an as needed basis.
# rudimentary caching to reduce hits on SDB
# JPA Queries - see: http://code.google.com/p/simplejpa/wiki/JPAQuery
The jar along with documentation is available here:
http://code.google.com/p/simplejpa/
I would love any feedback and if anyone is interesting in helping out with the project, let me know.
And indeed, after some serious hack sessions, I've got what appears to be a solid working version, albeit it is a subset of the full JPA spec due to the nature of SDB vs RDBMS.
Currently supports:
# @ManyToOne - object references.
# @OneToMany - collections.
# @MappedSuperClass? - Useful for a common ID and timestamping class.
# @Inheritance
# @Lob - stores lobs in S3 so make it as big as you want (up to 5GB).
# @Id - Assigns UUID automatically
# Lazy loading on ManyToOne, Lobs, and OneToMany so only hits SDB on an as needed basis.
# rudimentary caching to reduce hits on SDB
# JPA Queries - see: http://code.google.com/p/simplejpa/wiki/JPAQuery
The jar along with documentation is available here:
http://code.google.com/p/simplejpa/
I would love any feedback and if anyone is interesting in helping out with the project, let me know.