4 Commits

Author SHA1 Message Date
Ophir LOJKINE 563bc87959 delegate statement preparation to sqlx (#135)
* delegate statement preparation to sqlx

The logic of preparing statements and caching them for later reuse is now entirely delegated to the sql driver library (sqlx).
This simplifies the code and logic inside sqlpage itself.

 More importantly, statements are now prepared in a streaming fashion when a file is first loaded, instead of all at once, which allows referencing a temporary table created at the start of a file in a later statement in the same file.

 fixes #100

* remove temporary table usage

mssql does not have "create temp table"

* mssql permissions fix
2023-11-19 01:32:04 +01:00
lovasoa 699fe95c17 fix docker compose for mssql 2023-07-30 12:42:04 +02:00
lovasoa 9cea3703e8 fix mssql setup 2023-07-30 12:00:04 +02:00
lovasoa e01bfa066d Add support for ms sql server in docker-compose 2023-07-30 11:49:41 +02:00