Hi Julian, Let TsFile supporting SQL is attractive.
However, as it may have some limitations, e.g., a tsfile does not support out-of-order data integration for a given time series. It will limit the usage scenarios: if a embedded machine can run TsFile with Java, why not run IoTDB .... The above question may have two reasons: - computation resource limitation, but I think if the workload is not heavy, IoTDB will also spend few. - The OS/application does not allow running a long-term process, i.e., an embedded database is needed, and that is what SQLLite suitable for. For reason one, I think TsFile (C) is the final solution. For reason two, I think TsFile (Java) + SQL layer is very suitable. For example, considering it runs on an Android OS based machine. Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Julian Feinauer <j.feina...@pragmaticminds.de> 于2021年9月28日周二 下午6:33写道: > > Hi folks, > > I just came up with a little idea to improve the usage of TSFiles at the > „edge“. What if we create an access layer (besides the Readers /Writers) to > access the TSFiles with SQL as if they were in the server. > Thats basically the same that sqlite does with extreme success > (https://sqlite.org/index.html). > > For Java I created a very minimal sketch based on Apache Calcite (so with a > different SQL Dialect than the server but this could be adapted), here: > https://github.com/JulianFeinauer/incubator-iotdb/tree/feature/iotdb-lite/iotdb-lite > > What do you think about that? > > Happy to hear many ideas and feedback : ) > > Julian