Show HN: Prisma Python – A fully typed ORM for Python

Post by BerislavLopac » Mon, Feb 21, 2022, 8:42 PM UTC

samwillis wrote: post #26

dragonwriter wrote: post #21

Earlier quoted context omitted.

You can create Python types at runtime, and Python’s runtime type checking features predate it's static analyzers. Unfortunately, the additional kinds of objects used for typechecking in the static analyzers (beyond those which are also runtime types) don’t work with runtime type checking, nor do static type declarations (even using types that are also runtime types.) (And, obviously, AOT static analyzers can’t make…

Exactly, it’a brilliant that they designed a system where the annotations themselves can be dynamic and read at runtime, it has so much potential for interesting things. But MyPy completely hobbles it by preventing all the dynamic potential, even if MyPy had an escape hatch to say ignore anything derived from this type as it’s not possible to describe statically that would be better than nothing. It unfortunately lea…

Post by inshadows » Mon, Feb 21, 2022, 9:28 PM UTC

    posts = await client.post.find_many(
        where={
            'OR': [
                {'title': {'contains': 'prisma'}},
                {'content': {'contains': 'prisma'}},
            ]
        }
    )

    ... where title like '%prisma%' or content like '%prisma%'

Post by probablyrobert » Mon, Feb 21, 2022, 10:03 PM UTC

inshadows wrote: post #63

How is this DSL acceptable? posts = await client.post.find_many( where={ 'OR': [ {'title': {'contains': 'prisma'}}, {'content': {'contains': 'prisma'}}, ] } ) SQL for comparison: ... where title like '%prisma%' or content like '%prisma%'

Post by jjice » Mon, Feb 21, 2022, 10:06 PM UTC

probablyrobert wrote: post #65

inshadows wrote: post #63

How is this DSL acceptable? posts = await client.post.find_many( where={ 'OR': [ {'title': {'contains': 'prisma'}}, {'content': {'contains': 'prisma'}}, ] } ) SQL for comparison: ... where title like '%prisma%' or content like '%prisma%'

How do you suggest to improve it?

Post by probablyrobert » Mon, Feb 21, 2022, 10:13 PM UTC

lucas_codes wrote: post #68

probablyrobert wrote: post #66

Earlier quoted context omitted.

I find the relational API very easy and intuitive to work with. What do you not like about it?

So do I - the parent is choosing to compare the most basic example which didn't show the benefits of using an orm over raw sql