Commit Graph

24 Commits

Author SHA1 Message Date
Ophir LOJKINE af0ca82e6d Strengthen user auth Hurl flow 2026-06-02 15:56:27 +02:00
Ophir LOJKINE 2ef1ba0a7e Add user authentication Hurl workflow 2026-06-02 15:56:27 +02:00
Ophir LOJKINE 379eab38ef Add Hurl smoke tests for examples 2026-06-02 15:56:27 +02:00
lovasoa abe136d095 fix labels semantics in login component 2025-10-28 00:06:04 +01:00
lovasoa 5ee781cf40 use the login component in the user auth example 2025-10-27 23:36:29 +01:00
lovasoa 155e820ffc fix docker compose image references 2024-12-25 12:06:46 +01:00
lovasoa 0d51d52393 not on a personal repo anymore 2024-12-06 21:42:55 +01:00
lovasoa b1da4d6aea sql.datapage.app -> sql-page.com 2024-11-26 23:26:09 +01:00
lovasoa 54cb2aab41 move to the datapage.app domain 2024-08-17 20:06:26 +02:00
Guillaume DELVIT 6757addfb6 Remove obsolete comment.
ON CONFLICT (xxx) DO NOTHING is natively supported by sqlite.

https://sqlite.org/lang_upsert.html
2024-05-22 20:38:21 +02:00
lovasoa e010692749 document postgres-specific syntax 2024-01-05 22:18:29 +01:00
Ophir LOJKINE 23f834de71 null variables (#136)
* update dependencies

* Add support for resetting variables to a `NULL` value using `SET`. Previously, storing `NULL` in a variable would store the string `'null'` instead of the `NULL` value.
2023-11-19 20:09:18 +01:00
lovasoa 64a602897a simplify the user authentication example and make it easier to adapt to different databases 2023-11-07 00:01:20 +01:00
lovasoa c5a56937b4 add an explanation about the logged_in_user function
Hopefully it prevents users from introducing security vulnerabilities in their websites
2023-11-06 23:22:33 +01:00
lovasoa a17bf01c04 fix a bug making it impossible to call sqlpage pseudo-functions with url parameters as arguments on some databases 2023-09-19 03:00:54 +02:00
lovasoa ab50e7661f use insecure cookies in the authentication example
closes https://github.com/lovasoa/SQLpage/issues/79
2023-09-01 00:36:58 +02:00
lovasoa 7c5cb1bb08 Improve authentication example
On the main page, display 'logout' only if the user is logged in.
Display 'login' and 'signup' only if they are not.

See https://github.com/lovasoa/SQLpage/discussions/55
2023-08-09 19:36:52 +02:00
lovasoa 85965bc2b4 fix bug in auth example 2023-07-11 08:16:12 +02:00
lovasoa d466981b3c rewrite the user authentication example to use the latest features 2023-07-10 23:24:05 +02:00
lovasoa 8352a913ad new builtin function sqlpage.random_string 2023-07-10 20:45:16 +02:00
lovasoa 75ab995e8f fix typos 2023-07-07 20:15:02 +02:00
lovasoa 8bcc1a421e caveats 2023-07-07 20:10:25 +02:00
lovasoa c9f14280cf Implement the full user authentication flow in the example 2023-07-07 20:07:25 +02:00
lovasoa 7f2e1f8ed4 start work on auth example
see https://github.com/lovasoa/SQLpage/issues/12
2023-07-07 03:54:33 +02:00