sqlx

sqlx copied to clipboard

Support rotating passwords

6

I suspect this is not a common use case. But I was looking at using https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/UsingWithRDS.IAMDBAuth.html To authentic to an AWS Aurora Postgres server, instead of playing hide the keys...

Cocalus

[question] Convert errors to user friendly errors

4

Is there a best practice method of converting a `sqlx::Error::Database` to a user friendly message. For example, when writing HTTP API, I have a create user route. When there's already...

itmecho

Support for INSERTing multiple records?

40

How do you do the equivalent of ``` INSERT INTO my_table (my_num, my_str) VALUES ($1,$2) ,($3, $4) ,($5,$6) ... etc. depending on how many records you pass in ``` By...

greglearns

[MySQL] Can't get by column name when calling stored procedure

1

Hi When calling a stored procedure, i can't retrieve column by name : ``` sqlx::query("call fetch()").map(|row: MySqlRow| { row.get("id") }).fetch_all(&pool) ``` is not working, and with debugger i can see...

mickaelmagniez

[mssql] feature request: support for connection encryption

4

I'm really happy to see that you are working on mssql support for sqlx. I really would like to use sqlx with an azure managed mssql database, which requires connection...

njust

UNION not supported?

3

Hi, not sure if this a bug or expected behaviour or just me misunderstanding how to use UNION, but it would be great if this would work: This code compiles...

felixwatts

Wrong type when UNION

6

If we create two tables like this: ```sql CREATE TABLE table_1(id INTEGER PRIMARY KEY); CREATE TABLE table_2(id INTEGER PRIMARY KEY); ``` And query separately: ```sql SELECT id FROM table_1; ```...

duongdominhchau

sqlx_cli can not read database_url from .env in win10

4

why? and when you migrate with error,you have to fix _sqlx_migrations mannuly.this is boring.

oralpast

[SQLite] Support linking against a system SQLite library

15

* Is this a cargo feature flag? How does it work? Perhaps have `sqlite` (bundled) and `sqlite_sys` (unbundled) ? * What is the default inclusion strategy? My preference leans heavily...

mehcode

[query macros] faulty null inference involving left joins in Postgres

9

https://discordapp.com/channels/665528275556106240/694697474689859614/717103397848875049 ```sql CREATE TABLE IF NOT EXISTS colors ( color_uuid UUID NOT NULL DEFAULT uuid_generate_v4(), color TEXT ); insert into colors (color_uuid, color) values ('5ab49fea-1b9e-4ae1-ad7d-9fd9e0f48852','Red'); insert into colors (color_uuid, color)...

abonander