perseus VS sqlx

The best part is that it doesn’t use a virtual DOM for its reactivity, which can lead to a significant increase in performance.  Perseus not only inherits some of the best aspects of existing web frameworks but also strives to surpass them. Perseus went stable on April 9, 2023 after one year of beta development -- this is just the beginning!

I actually made a small sample project some weeks ago using Axum + Perseus + Sycamore. The purpose was to show, that also unocss was possible instead of tailwindcss. But I recommend tailwindcss for now, because there is an easy to use Perseus Plugin for it. https://gitlab.com/kibsi-perseus-examples/perseus-sycamore-rest-example-unocss But it could maybe be of interest to you. There are also the official Perseus examples: https://github.com/framesurge/perseus/tree/main/examples/core

Perseus is a web development framework for the Rust programming language. https://framesurge.sh/perseus/en-US/

Perseus is a pure Rust web development framework with support for static site generation, server-side rendering, client-side rendering, reactive state, internationalization, capsules (sometimes called an 'islands architecture'), seamless deployment, custom API routes, and so much more! And, after a year of beta versions, v0.4.0 of it just went stable!

Personally, I would go for Perseus. https://framesurge.sh/perseus/en-US

For PostgreSQL, the most relevent part of the code is here. With this in mind I changed some things around to rely on schemas instead of databases and even simplified some parts of the implementation as this was always meant to be for internal use only..

What exactly are you missing? I haven't really written "boring corporate backend stuff" in a few years but something like sqlx provides everything I've ever needed there.

Badges are the little rectangles you typically see at the top of a crate's README: https://github.com/launchbadge/sqlx/blob/main/README.md

SQLX has entered the chat [1].

[1] https://github.com/launchbadge/sqlx

Database : SqLite (using sqlx).

The current (well, removed) MSSQL sqlx driver also doesn't support encrypted connections (https://github.com/launchbadge/sqlx/issues/1552), so it might work locally on an unnamed instance but not over the network until they add in the newer driver (which will be closed source but for an OSS project you should be able to request a free license I think)

I'm considering making my own wrapper over lower-level database drivers. There are a lot of features in sqlx that I don't need, and the latest version seems to have removed useful data structures that SQLPage is using. It also removed support for SQL Server.

add Ed25519 to AuthPlugin enum on https://github.com/launchbadge/sqlx/blob/061fdcabd72896d9bc3abb4ea4af6712a04bc0a8/sqlx-core/src/mysql/connection/auth.rs and implement them using these crates: