sqlpage.run_sql opens a new database connection instead of reusing the connection over which the current request is being handled

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly

https://sql.ophir.dev

MIT License

882 stars 62 forks source link

sqlpage.run_sql opens a new database connection instead of reusing the connection over which the current request is being handled #338

Closed lovasoa closed 1 month ago

lovasoa commented 1 month ago

sqlpage.run_sql fetches a new database connection from the connection pool instead of reusing the connection over which the current request is being handled

This has implications such as

temporary tables not being accessible
attached databases not being accessible
performance

for details, see : https://github.com/lovasoa/SQLpage/discussions/336

lovasoa commented 3 weeks ago

@guspower @vlasky v0.23 was released with the new single-connection setup for run_sql. Can you test and confirm it works as expected in your applications ?