Database views

Has anybody used database views with Glorp ?

I can confirm they work, but as Joachim says, read only. So any
attempt to modify the data there will cause an error when attempting
to commit.

I used that in the past to aggregate data on the database side (which
was 100x faster and lightweight) than doing it in the smalltalk side,
but I wanted to have an object on the Smalltalk side that I was able
to interact with.

Regards,

Esteban A. Maringolo

On Thu, May 14, 2020 at 2:28 PM jtuchel <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="11Sa8vLpCgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">jtu...@...> wrote:

>
> No I haven't, but I'D expect them to work like tables. You can probably try to use read-only mappings, depending on your database, because some cannot write to views,
>
> Since the SQL used to query a view does not differ from a select from a table, I don't see any reason for Glorp to encounter any problems. Apart from teh writing, of course.
>
> Why not just do a CREATE VIEW and implement a class mapping just as you'd do for a table?
>
>
> Joachim
>
>
> Am Donnerstag, 14. Mai 2020 18:17:21 UTC+2 schrieb Annick:
>>
>> Has anybody used database views with Glorp ?
>>
> --
> You received this message because you are subscribed to the Google Groups "glorp-group" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="11Sa8vLpCgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">glorp...@googlegroups.com.
> To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/glorp-group/7e31d596-ee44-4ab6-8d05-8755f760b29e%40googlegroups.com" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/msgid/glorp-group/7e31d596-ee44-4ab6-8d05-8755f760b29e%40googlegroups.com&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/msgid/glorp-group/7e31d596-ee44-4ab6-8d05-8755f760b29e%40googlegroups.com&#39;;return true;">https://groups.google.com/d/msgid/glorp-group/7e31d596-ee44-4ab6-8d05-8755f760b29e%40googlegroups.com.