Git Product home page Git Product logo

Comments (7)

dankochetov avatar dankochetov commented on August 16, 2024 2

We have it on our roadmap, can't provide an ETA yet, though. Stay tuned 🙂

In the meantime, you can just use raw SQL to work with them, like this:

db.run(sql`call proc_name()`);
const rows = db.all<{ col1: string; col2: number; }>(sql`select func_name()`);

To create procedures/functions in migrations, you can just manually add them to one of the migration files. We're working to support first-class custom migrations as well.

from drizzle-orm.

AndriiSherman avatar AndriiSherman commented on August 16, 2024 1

@shah thanks!
view support is currently next big thing to be released, so we are currently working on it

Regarding your contribution - we are open to any suggestions. I guess best way would be to join our Discord channel and send us your suggestions on how you see PG stored procedures / function in drizzle. We can continue our discussion with you from there

from drizzle-orm.

shah avatar shah commented on August 16, 2024

Excellent idea, will use raw SQL for now.

Having first-class support for procs/functions/domains (especially with auto-generated migrations like for tables) would be fantastic.

I have implemented some of these Typescript template literal procedure/func/domain generators in my own library and would love to discuss how I can contribute that work to integrate into Drizzle. It would be easier to discuss on a video call so if there's a chance to speak to one or more of the core team members about that I would appreciate the opportunity (at your convenience).

Thanks!

from drizzle-orm.

shah avatar shah commented on August 16, 2024

I saw v0.20.1 drop today, great job with the with addition! I was curious if you had any updates for when the view or when type-safe PG stored procedures / function calls might land. :-)

from drizzle-orm.

questloggg avatar questloggg commented on August 16, 2024

Hello! Since quite some time has passed I figured I'd ask whether there is a rough ETA for RPC's/functions or whether it's still unknown. We rely quite a lot on the reusability and performance of RPCs so would love to see first class support. Thanks and keep up the great work!

from drizzle-orm.

benhassineb avatar benhassineb commented on August 16, 2024

Excellent idea, will use raw SQL for now.

Having first-class support for procs/functions/domains (especially with auto-generated migrations like for tables) would be fantastic.

I have implemented some of these Typescript template literal procedure/func/domain generators in my own library and would love to discuss how I can contribute that work to integrate into Drizzle. It would be easier to discuss on a video call so if there's a chance to speak to one or more of the core team members about that I would appreciate the opportunity (at your convenience).

Thanks!

@shah
I've been working on similar Typescript template literal generators.
Could you please share the code with me? I'm interested in exploring it further. Thank you!

from drizzle-orm.

shah avatar shah commented on August 16, 2024

Sure, @benhassineb my code is available at https://www.github.com/netspective-labs/sql-aide.

from drizzle-orm.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.