[HN Gopher] A Principled Approach to Querying Data - A Type-Safe...
       ___________________________________________________________________
        
       A Principled Approach to Querying Data - A Type-Safe Search DSL
        
       Author : kioku
       Score  : 58 points
       Date   : 2025-04-24 15:53 UTC (7 hours ago)
        
 (HTM) web link (www.claudiu-ivan.com)
 (TXT) w3m dump (www.claudiu-ivan.com)
        
       | hu3 wrote:
       | Looks good.
       | 
       | For a more database specific, type-safe, data querying solution,
       | I like to use https://kysely.dev
        
         | damidekronik wrote:
         | I am using both prisma and kysely in the same codebase with a
         | great success. The db schema is driven by SQL, not prisma. It
         | is then introspected by both kysely and prisma, prisma is used
         | in 95% of the places while kysely is used whenever performance
         | is critical or when prisma doesn't support the SQL features we
         | need.
        
           | tough wrote:
           | any underlying negative consequences on letting prisma schema
           | handle the underlynig model/migrations
           | 
           | I found out about stackzen yesterday, really like the
           | RBAC/ABAC backed up into the models/codegen stuff, been
           | thinking about just using that for our custom logic and maybe
           | add RLS pg a la supabase but also codegen from the same
           | .zmodel from zenstack model that generates prisma
           | models/migrations have it generate RLS sql migrations code
           | 
           | thoughts??
           | 
           | also maybe postgres views to handle field/attribute level
           | security since rows is mostly about whole columns
           | 
           | main goal is to secure the data at all the levels of the
           | stack from db to api to app so there's no footguns in the
           | future where someone with a pg user or modifying our clients
           | can see data they shouldn't etc
        
       | FrustratedMonky wrote:
       | Seems a lot like FSharp Type Providers? Is that a good analogy?
        
       | mifydev wrote:
       | The same should apply to configuration, we have prisma for sql,
       | we should have something like this for JSONs, like
       | https://typeconf.dev (I'm one of the founders)
        
       | fire_lake wrote:
       | > Users expect near-native responsiveness, even when offline
       | 
       | Do they? I think users are amazed if _anything_ works without
       | internet with modern applications.
        
       | tehlike wrote:
       | LINQ or PRQL.
        
       ___________________________________________________________________
       (page generated 2025-04-24 23:00 UTC)