Drivers page to connect via wss: socket

gionatamettifogo · gionatamettifogo · commit 7cc3e2a63b84 · 2024-02-15T09:36:37.000+01:00
diff --git a/public/drivers.html b/public/drivers.html
@@ -8,14 +8,14 @@
   </head>
 
   <body class="p-4">
-    <h1>SQLite Cloud Driver</h1>
-    <div class="pb-6">
-      <a href="https://www.npmjs.com/package/sqlitecloud">npm sqlitecloud</a>
+    <h1>SQLite Cloud Drivers</h1>
+    <div class="pb-6 text-sm">
+      <a href="https://www.npmjs.com/package/@sqlitecloud/drivers">npm add @sqlitecloud/drivers</a>
     </div>
 
     <!-- Add the text field and button here -->
     <div class="pb-2">
-      <div class="text-sm w-12">connectionString:</div>
+      <div class="text-xs w-12">databaseUrl</div>
       <input
         type="text"
         id="connectionStringInput"
@@ -65,7 +65,13 @@ <h2 class="pb-4">Results:</h2>
 
       sendButton.addEventListener('click', () => {
         if (!database) {
-          database = new window.sqlitecloud.Database(connectionString, error => {
+          // connect via websocket to the gateway on the same server
+          const connectionConfig = {
+            gatewayUrl: `${window.location.protocol === 'https:' ? 'wss' : 'ws'}://${window.location.hostname}:4000`,
+            connectionString
+          }
+
+          database = new window.sqlitecloud.Database(connectionConfig, error => {
             if (error) {
               database = null
               appendMessage(`connection error:  ${error}`)
diff --git a/public/index.html b/public/index.html
@@ -111,7 +111,7 @@ <h2>Messages:</h2>
           socket = setupSocket()
         }
         socket.emit('v1/info', {}, response => {
-          appendMessage(`info | rss: ${(response.data.rss / 1024 / 1024).toFixed(2)}mb, ${JSON.stringify(response)}`)
+          appendMessage(`info | heapSize: ${(response.data.memory.heapSize / 1024 / 1024).toFixed(2)}mb, ${JSON.stringify(response)}`)
         })
       })
     </script>

Original file line number	Diff line number	Diff line change
`@@ -111,7 +111,7 @@ <h2>Messages:</h2>`
`111`	`111`	`socket = setupSocket()`
`112`	`112`	`}`
`113`	`113`	`socket.emit('v1/info', {}, response => {`
`114`		- appendMessage(`info \| rss: ${(response.data.rss / 1024 / 1024).toFixed(2)}mb, ${JSON.stringify(response)}`)
	`114`	+ appendMessage(`info \| heapSize: ${(response.data.memory.heapSize / 1024 / 1024).toFixed(2)}mb, ${JSON.stringify(response)}`)
`115`	`115`	`})`
`116`	`116`	`})`
`117`	`117`	`</script>`