Is there any way to reach the Window: localStorage property? #4583

kxkv · 2025-12-29T11:27:54Z

kxkv
Dec 29, 2025

Is there any way to access the HTML Web Storage API from PostgREST?

Something like this (pseudo code):
v_local_storage_msg := htmlWebStorageApi.localStorage.getItem('msg');

Dec 29, 2025

Not sure if I understood your question, but PostGREST works server side and does not access anything from the web page. You'd need to send it in a request for PostgREST to be aware of it, e.g. in a header (and access it with settings) or as parameters in functions.

Or are you using PostgREST to return JS code from a table or function? If so then yes, it should be able to do that (just be sure to sanitize the way that code is added to the database if required).

View full answer

laurenceisla · 2025-12-29T16:05:20Z

laurenceisla
Dec 29, 2025
Collaborator

Not sure if I understood your question, but PostGREST works server side and does not access anything from the web page. You'd need to send it in a request for PostgREST to be aware of it, e.g. in a header (and access it with settings) or as parameters in functions.

Or are you using PostgREST to return JS code from a table or function? If so then yes, it should be able to do that (just be sure to sanitize the way that code is added to the database if required).

2 replies

laurenceisla Dec 29, 2025
Collaborator

e.g. in a header (and access it with settings) or as parameters in functions.

To be more precise in these examples, how are you planning to use the data from localStorage?

kxkv Dec 29, 2025
Author

Thanks for getting back to me!

What I wanted to achieve, was something like this:

create or replace function api.index(p_msg text) returns "text/html" as $$
  select $html$
    <!DOCTYPE html>
    <html>
    <head>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <title>PostgREST</title>
    </head>
    <body>
      <main class="container"
            style="max-width: 600px">
            <!--  
              PSEUDO CODE:
              if p_msg is not null then
                localStorage.setItem('msg', p_msg);
              elseif p_msg is null then
                -- use value from local storage, if found:
                p_msg := localStorage.getItem('msg');
              end if;
            -->
      </main>
    </body>
    </html>
  $html$;
$$ language sql;

But, I my thinking was way off here! As you stated, the server code can not reach into the client's web storage, before generating / returning the result. The solution might be using parameters instead.

Navigation Menu

Repository navigation

Is there any way to reach the Window: localStorage property? #4583

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 1 comment 2 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Is there any way to reach the Window: localStorage property? #4583

Uh oh!

Uh oh!

kxkv Dec 29, 2025

Replies: 1 comment · 2 replies

Uh oh!

laurenceisla Dec 29, 2025 Collaborator

Uh oh!

Uh oh!

laurenceisla Dec 29, 2025 Collaborator

Uh oh!

kxkv Dec 29, 2025 Author

kxkv
Dec 29, 2025

Replies: 1 comment 2 replies

laurenceisla
Dec 29, 2025
Collaborator

laurenceisla Dec 29, 2025
Collaborator

kxkv Dec 29, 2025
Author