sosedoff
Add a disk-backed custom query log
Storing SQL query log (user-generated) into a file would be a good solution for history persistence. Something like $HOME/.pgweb/history.json is fine, although will probably break when running multiple instances of pgweb on the same machine.
Are you thinking of persisting every single query in this log? or would there be a custom "store query" option?
Another question - how would we uniquely identify clients? Say one client saves the query, quits and comes back up. How would we identify that the new client is the same one that stored the query?
I think we should store every single query and NOT separate queries by clients. This means that two concurrent clients may get each other's queries in their history. I think this is fine since this is how a lot of terminal emulator's history works as well (think iterm, mac's terminal etc).
