Transac sql
SB is not a transactionnal database, but there is small transactionnal mode in SB
This mode can be used to store users, messages
The goal is to avoid having another database for that
Corruption is possible in bi mode, but it is not possible in transac mode
Update with sql in possible in transac mode but not in bi mode
Parameters TCP_PORT_TRANSAC and TRANSAC_FILES_DIR must be set in stormbase.conf
create
create table table_name(col1 text, col2 text, ...)insert
insert into table_name('txt1', 'txt2', ...)insert
select <*|col1, col2, ...> from table_name <|where col1='txt1' and col2='txt2' ...>update
update table_name set col1='txt1', col2='txt2' <|where col1='txt1' and col2='txt2' ...>delete
delete table_name <|where col1='txt1' and col2='txt2' ...>