I'm unable to make out the reason for people using diesel when it's synchronous. E.g. if my actix-web server has 4 threads running in runtime, diesel can block all of them for just 4 simultaneous requests. Or there is some other magic going on that I haven't yet understood.

First of all, Diesel far pre-dates the existence of async in Rust. Second, I sense a default (and wrong) assumption that async is somehow unconditionally "superior" or "faster". This isn't the case. You can perfectly well write high-performing applications in synchronous code. As a trivial solution…

I completely know and understand the fact that async has its own tradeoffs in performance, but what I'm particularly looking at are backend web applications that need to interact with database over network. And network request-response (in this case with database) inherently adds latency, other than…

[image] p_s_rathore: I don't see any way to implement this other than pushing queries to queue and poping in another, say query processing, thread. And this particular implementation would make query executions even more synchronous I don't understand what you mean by this. The point is exact…

You can use diesel-async for async queries in diesel.

Thanks, though I know about existence of async ORMs and libraries. What I'm trying to do, is understand why synchronous database interaction ORMs like diesel exist and widely used as well in BE applications, other than for the quoted point. [image] H2CO3: First of all, Diesel far pre-dates the …

It also helps to recognize that not everything needs to be async. Which was also hinted at by the post you quoted. For instance, maybe you are writing a simple CLI tool that just needs to interact with a remote database for one-off admin purposes. There is little incentive to using a complex multi-…

The most important question to ask here is: Why do you believe async database connections are that important for your application design. Do you feel that this could be a performance problem? If that's the case do you have performed benchmarks or at least looked for benchmarks that support that hypo…

Why use diesel when it's not async?

help

quinedot March 1, 2023, 7:31pm 7

Here's a prior topic on the issue.

4 Likes

Topic		Replies	Views
Best ways to interface with databases for Rust web backend (actix)?	15	4648	January 9, 2021
Use of async - where to draw the line help	10	1269	February 15, 2022
Diesel-Async 0.5 announcements	1	215	October 17, 2024
Examples of high performance Rust multi-thread network app w/o async?	14	5813	March 15, 2022
Why benchmark only diesel vs another framework it faster, but use with Actix it slower? help	3	1946	June 28, 2022

Why use diesel when it's not async?

Related topics