There is no mention of SQL views at http://www.yesodweb.com/book/persistent .
I (even in imperative languages) was very keen on the constant design of the database schema. that is, only INSERT and SELECTs - UPDATE and DELETE are not used.
This has the advantage of preserving the entire history due to the fact that the current “state” is a relatively expensive pure history function in the database.
eg. there is no user table, only the tables "user_created", "user_password_updated" and "user_deleted", which are combined in the "user" SQL VIEW, showing the current status of users.
How do I work with VIEW in Persistent? Should I use Persistent at all - is it (ironically for Haskell) too focused on the volatile DB for my use?
source share