Retrieve SQL data from server with LiveCode and websocketd.
For security reason, most of the database servers does not allow remote connection and to be able to access a non exposed database servers I have to install LiveCode Server edition as a CGI processor or use a "middleware" code like PHP or Python. With websocketd, I can run my executable livecode desktop application on the server without the hassle of server installation, and I like to keep my project as simple as possible without too many programming language. For simplicity I use SQLite database for this example project.
-
Create a new stack on LiveCode IDE and paste the code from sqldata.livecode to the stack script
-
Save as standalone application
-
Navigate to the stand alone application folder and Create or download sqldata.html
-
Download the sample database sqldata.db
OR
- Download and install websocketd
- Open command prompt and go to application folder created with LiveCode or ./sqldata folder if download from prebuild binaries
- If you are using linux, make sure file sqldata have execute permission
- $ websocketd --port=8080 --staticdir=. ./sqldata -ui
- Open https://localhost:8080/sqldata.html with your browser