A bit OT: handling multiple users in DB

Klaus Major klaus at major-k.de
Tue Sep 23 10:25:39 EDT 2008


Hi Rob,

> Hi Klaus,
>
> FWIW,  here is the information SDB maintains internally to handle  
> multiuser access:
>
> A list of DBs currently open by the user or client:
> local clientDbList -- array by clientId:dbId1, dbId2, etc
>
> A list of the current record position and access privileges for each  
> user/client currently accessing any open DBs
> local dbClientList -- array by dbId:client  
> id,writeAccessType,current position
>
> The main indexes of every DB that has been opened since the user or  
> the server app started
> local indexList -- array by dbId:cardIndex
>
> A list of locked records by DB
> local lockedRecordList -- array by dbId: record id, client id
>
> Path and generic locking options to each open DB
> local sdbDbPathList -- array by dbId: db stack path, autoLockOn,  
> readLocksEnforced
>
> Information to support record translation if client and server are  
> running on different platforms
> local sdbTranslationList -- array by clientId: 1=ASCII>ANSI, 0=None,  
> or -1=ANSI>ASCII + tab & ipcProtocol [tp,ae,pc,dc,sf]

Thanks, but unfortunately our users demand a SQL database.

> Rob Cozens
>
> "I must be the change I want to see in the world."
>
> -- Gandhi 

Best

Klaus Major
klaus at major-k.de
http://www.major-k.de





More information about the use-livecode mailing list