2535 Commits

Author SHA1 Message Date
lovasoa c788655804 Improve login component documentation and usability
Add complete example with database schema, credential processing, and page protection. Update authentication migration to reference new login component. Enhance login template with default icons and autocomplete attributes. Make validate parameter optional with sensible default.
2025-10-27 18:13:52 +01:00
Olivier Auverlot ce4ffd3394 Documentation improved 2025-10-24 08:45:57 +02:00
Olivier Auverlot 2570bda545 Documentation improved 2025-10-24 08:29:35 +02:00
Olivier Auverlot cb8fa2dc16 Fixing a regression with the class attribute. 2025-10-24 08:09:32 +02:00
Olivier Auverlot b356cc8904 username_icon and password_icon attributes 2025-10-24 08:04:39 +02:00
Olivier Auverlot 5d5d1f94d7 The login component is an authentication form for users of an application. 2025-10-18 12:19:15 +02:00
lovasoa b577695eee Enhance llms.txt.sql to include detailed parameter documentation
- Updated the SQL file to improve the output format for components, adding sections for top-level and row-level parameters.
- Each parameter now includes its type, requirement status, and description for better clarity in the generated documentation.
2025-10-17 23:51:28 +02:00
lovasoa c5c4a4fcd5 add llms.txt
closes https://github.com/sqlpage/SQLPage/issues/980
2025-10-17 23:43:20 +02:00
lovasoa 0184bb9b9a Enhance routing to support SQL execution for non-SQL file extensions
- Updated routing logic to execute SQL files when a request is made for paths with extensions other than .sql.
- Added tests to verify that SQL files are executed correctly for paths with non-SQL extensions.
- Updated CHANGELOG to reflect this new feature in version 0.38.1.
2025-10-17 23:42:33 +02:00
lovasoa cc3faba20f fix https://github.com/sqlpage/SQLPage/issues/1055 2025-10-17 21:45:05 +02:00
lovasoa 81d2dd43e3 update deps 2025-10-16 10:18:17 +02:00
lovasoa 9a383c9cd5 Update README.md to clarify ODBC support and driver linking details
- Added information about SQLPage's support for ODBC connections.
- Clarified that Linux and MacOS binaries include a built-in statically linked ODBC driver manager (unixODBC).
- Removed redundant text regarding ODBC support for specific databases.
2025-10-14 23:35:13 +02:00
lovasoa 9a8bb78f5c v0.38.0
CI / compile_and_lint (push) Has been cancelled
CI / test (mssql, mssql, mssql://root:Password123!@127.0.0.1/sqlpage) (push) Has been cancelled
CI / test (mysql, mysql, mysql://root:Password123!@127.0.0.1/sqlpage) (push) Has been cancelled
CI / test (postgres, odbc, Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so;Server=127.0.0.1;Port=5432;Database=sqlpage;UID=root;PWD=Password123!, true) (push) Has been cancelled
CI / test (postgres, postgres, postgres://root:Password123!@127.0.0.1/sqlpage) (push) Has been cancelled
CI / windows_test (push) Has been cancelled
CI / docker_build (linux/amd64) (push) Has been cancelled
CI / docker_build (linux/arm/v7) (push) Has been cancelled
CI / docker_build (linux/arm64) (push) Has been cancelled
CI / docker_push (push) Has been cancelled
Create Release / Build sqlpage binaries (macOS & Windows) (.exe, , windows-latest, x86_64-pc-windows-msvc) (push) Has been cancelled
Create Release / Build sqlpage binaries (macOS & Windows) (odbc-static, macos-latest, x86_64-apple-darwin) (push) Has been cancelled
Create Release / Build sqlpage binaries (Linux) (push) Has been cancelled
Create Release / Build AWS Lambda Serverless zip image (push) Has been cancelled
Create Release / Create Github Release (push) Has been cancelled
Create Release / Publish to crates.io (push) Has been cancelled
v0.38.0
2025-10-14 22:35:23 +02:00
lovasoa e9831ab5f3 fix clippy warning 2025-10-14 16:39:03 +02:00
lovasoa 93ca430e14 add a test for simple static set that sets a variable to the value of another variable 2025-10-14 16:37:23 +02:00
lovasoa 9dfbf42f56 enable arbitrary precision in the internal representation of values
- Enabled arbitrary precision for `serde_json` to handle large numbers without rounding.
- Refactored decimal handling in `sql_to_json.rs` to utilize a new function for converting decimals to JSON format.

Fixes https://github.com/sqlpage/SQLPage/issues/1052
2025-10-14 16:33:10 +02:00
lovasoa 534fa422fa Local execution of simple static SET commands
`SET x = 'hello'` is now executed locally by SQLPage and does not send anything to the database. This completely removes the cost of extracting static values into variables for cleaner SQL files.
2025-10-14 12:14:11 +02:00
lovasoa 5881ed7f18 update dependencies 2025-10-14 10:57:32 +02:00
lovasoa 68a20ebee2 remove dependency to autotools
https://github.com/pacman82/odbc-sys/pull/76
2025-10-13 10:43:25 +02:00
lovasoa 0757ecc946 update odbc sys 2025-10-12 14:53:27 +02:00
lovasoa a8792a4e89 dependency to libclang-dev on armv7 2025-10-09 18:26:38 +02:00
lovasoa f71c7ac864 add missing arm64 dep 2025-10-09 17:54:22 +02:00
lovasoa 2dc131ba08 remove unused dependencies in dockerfile 2025-10-09 17:24:30 +02:00
lovasoa 6019ab3d4e update odbc-sys 2025-10-09 16:30:26 +02:00
lovasoa 189ac240d1 fix slight spacing issue in list's empty value 2025-10-08 15:38:17 +02:00
lovasoa 86f2722bdf fix https://github.com/sqlpage/SQLPage/issues/1048 2025-10-08 15:26:04 +02:00
lovasoa dfeba164b5 update odbc sys 2025-10-07 14:35:41 +02:00
lovasoa c8b38980e2 pin odbc-sys 2025-10-07 09:58:42 +02:00
lovasoa e263788ef3 rename deploy job 2025-10-05 12:01:12 +02:00
lovasoa 0bd5a06a20 scripts: enhance cross-compilation setup by adding apt-get update and removing redundant installations 2025-10-05 10:45:31 +02:00
lovasoa b278764b18 Dockerfile: extract scripts to separate files 2025-10-05 10:41:13 +02:00
lovasoa 656c73f86d Dockerfile: update library paths for aarch64 and arm architectures 2025-10-05 10:22:37 +02:00
lovasoa 05b7a55f48 Dockerfile: statically link odbc 2025-10-05 09:45:54 +02:00
lovasoa bac0ffc14e fromascasing 2025-10-05 09:40:47 +02:00
lovasoa cf1e585340 update feature and compatibility sections in homepage template with IDs for improved accessibility 2025-10-05 09:26:05 +02:00
lovasoa 2f37d2ddd1 add lambda-web feature and update CI to test with odbc-static
CI / compile_and_lint (push) Has been cancelled
CI / test (mssql, mssql, mssql://root:Password123!@127.0.0.1/sqlpage) (push) Has been cancelled
CI / test (mysql, mysql, mysql://root:Password123!@127.0.0.1/sqlpage) (push) Has been cancelled
CI / test (postgres, odbc, Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so;Server=127.0.0.1;Port=5432;Database=sqlpage;UID=root;PWD=Password123!, true) (push) Has been cancelled
CI / test (postgres, postgres, postgres://root:Password123!@127.0.0.1/sqlpage) (push) Has been cancelled
CI / windows_test (push) Has been cancelled
CI / docker_build (linux/amd64) (push) Has been cancelled
CI / docker_build (linux/arm/v7) (push) Has been cancelled
CI / docker_build (linux/arm64) (push) Has been cancelled
CI / docker_push (push) Has been cancelled
Create Release / Build sqlpage binaries (macOS & Windows) (.exe, , windows-latest, x86_64-pc-windows-msvc) (push) Has been cancelled
Create Release / Build sqlpage binaries (macOS & Windows) (odbc-static, macos-latest, x86_64-apple-darwin) (push) Has been cancelled
Create Release / Build sqlpage binaries (Linux) (push) Has been cancelled
Create Release / Build AWS Lambda Serverless zip image (push) Has been cancelled
Create Release / Create Github Release (push) Has been cancelled
Create Release / Publish to crates.io (push) Has been cancelled
v0.38.0-beta.1
2025-10-04 23:18:35 +02:00
lovasoa a472c1c51f install unixodbc before cargo publish 2025-10-04 22:57:07 +02:00
lovasoa a73a765014 Merge remote-tracking branch 'refs/remotes/origin/main' 2025-10-04 22:51:47 +02:00
lovasoa a95376bfa2 switch back to stable sqlx-oldapi 2025-10-04 22:45:05 +02:00
lovasoa 80ef8262e8 update dependencies 2025-10-04 22:37:08 +02:00
lovasoa 2472d827a6 ODBC 2025-10-04 22:36:37 +02:00
Ophir LOJKINE 8a7910fcd2 Merge pull request #1029 from sqlpage/cursor/statically-link-unixodbc-and-update-configurations-df86
Statically link unixodbc and update configurations
2025-10-04 22:33:40 +02:00
lovasoa 2c7cb90729 add compatibility section to homepage 2025-10-04 22:31:12 +02:00
lovasoa e186f13d0d instructions 2025-10-04 21:22:12 +02:00
lovasoa 3cad946738 documentation 2025-10-04 21:11:16 +02:00
lovasoa 6ceeb81ccb test with static odbc 2025-10-04 20:36:09 +02:00
lovasoa c5c03346ff contributing 2025-10-04 20:34:38 +02:00
lovasoa 719937beb1 remove rpath 2025-10-04 20:34:07 +02:00
lovasoa a7ff6d6c12 Update ODBC dependency configuration and CI workflow to use all features 2025-10-04 20:23:42 +02:00
lovasoa 5fb17c65d0 update driver path 2025-10-04 00:25:52 +02:00