Example of connecting to a database

[novnc]

Example of connecting to a database

[kanaka]

@x20mar I won't have time to do this personally, but if somebody wants to code up a simple example then I'm willing to include this as an example in the repo.

[ysangkok]

it's pretty straightforward. for pgsql, launch like this: ~/websockify/websockify.py 5432 -- /usr/lib/postgresql/9.1/bin/postgres -D .

i made a fork of node-postgres here on github to make it work in the browser. there are issues because websockify seems to discard data just before connection close, which makes error messages about wrong login disappear, i'll make an issue for that.

to find out what to send over the websocket, you can use wireshark on a psql session.

i also made a quick modification of wstelnet.html to test out pgsql over websocket, it's here: https://gist.github.com/3779549 instructions:

1. adjust hex data (using data from wireshark, or by looking at it in ascii).
2. open connection to websockified pgsql.
3. click part1 (postgres handshake)
4. click part2 (postgres login)
5. click part3 (postgres query)
6. click part4 (postgres logout)

here's a screenshot: http://i.imgur.com/EipJ9.png