Batches are a way to group together queries and we will support various types of batch

for task like this: <div class="highlight highlight-source-sql notranslate positio

Batch implementations about skytable HOT 1 OPEN

ohsayan commented on June 14, 2024

Batch implementations

from skytable.

Comments (1)

calvin2021y commented on June 14, 2024

for task like this:

CREATE MODEL myspace.user_model(user_id: int, groups: list { type: int })
CREATE MODEL myspace.group_model(group_id: int, password: string, users: list { type: int })

add user into group will require transaction,

UPDATE user_model SET groups += "group_id" WHERE user_id = '1'
UPDATE group_model SET users += "user_id" WHERE group_id = '1'

You want avoid the case first is done but the other failed. this need to be run in batch and atomic.

And some case like this:

if count( user_model.groups ) < 10 and user_model.status == good and  count( group_model.users ) < 10  and group_model.status == good   {
 UPDATE user_model SET groups += "group_id" WHERE user_id = '1'
 UPDATE group_model SET users += "user_id" WHERE group_id = '1'
}

Some solution like redis lua script.

update 2 entities at once will be good enough.

from skytable.

Batch implementations about skytable HOT 1 OPEN

Comments (1)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent