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'
...>