You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: WIKI/ESOTERIC-CHATSCRIPT/ChatScript-Database_Access.md
+9-9Lines changed: 9 additions & 9 deletions
Original file line number
Diff line number
Diff line change
@@ -11,7 +11,7 @@
8000
server as a hot backup and transfer users to it while redeploying the primary se
11
11
The solution to this (and the ability to scale CS with an arbitrary number of servers) is to have some kind of networked file server.
12
12
13
13
CS directly supports use of Mongo, Postgres, MySQL,and MsSQL databases as file servers.
14
-
Instead of writing the users’s state record to the local file system,
14
+
Instead of writing the users's state record to the local file system,
15
15
it writes it as a record in the database.
16
16
That record will be overwritten each volley with the changed state.
17
17
There is no accumulation of prior state data. Nor are user logs ever written there.
@@ -37,10 +37,10 @@ use chatscript;
37
37
CREATE TABLE userfiles (userid varchar(100) PRIMARY KEY, file MEDIUMBLOB, when DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
38
38
```
39
39
40
-
The table name “userfiles” and the field names are fixed. ChatScript assumes them.
41
-
userid - a limit of 64 is more than enough
42
-
file: – in our world we are going to have less than 500K bytes of data
43
-
when – CS never sends or uses this value. It is there to allow an external program to query the database and delete old records since our users do not continue forever with Pearl.
40
+
The table name "userfiles" and the field names are fixed. ChatScript assumes them.
41
+
userid: a limit of 64 is more than enough
42
+
file: in our world we are going to have less than 500K bytes of data
43
+
when: CS never sends or uses this value. It is there to allow an external program to query the database and delete old records since our users do not continue forever with Pearl.
44
44
45
45
An optional key is `appendport` which takes no value. It means to add the current CS port as a
The table name “userfiles” and the field names are fixed. ChatScript assumes them.
113
-
userid - a limit of 64 is more than enough
114
-
file: – in our world we are going to have less than 500K bytes of data
115
-
stored – CS never sends or uses this value. It is there to allow an external program to query the database and delete old records since our users do not continue forever with Pearl.
112
+
The table name "userfiles" and the field names are fixed. ChatScript assumes them.
113
+
userid: a limit of 64 is more than enough
114
+
file: in our world we are going to have less than 500K bytes of data
115
+
stored: CS never sends or uses this value. It is there to allow an external program to query the database and delete old records since our users do not continue forever with Pearl.
116
116
117
117
### MsSQL Termination:
118
118
If at any time a call to utilize MsSQL fails, the CS server will abort itself. If you have an
0 commit comments