timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
416 stars 17 forks source link

Improve DolphinDB compatibility #42

Closed ryanhamilton closed 3 weeks ago

ryanhamilton commented 1 month ago

Few Areas:

ryanhamilton commented 1 month ago

Type handling improved in tables:

image


def f1(a,b) {return a+b;}
f1
<1+2>

(1,2,3)

{a:1,b:2, c:"foo"}

3.1415926$DECIMAL32(3)

NULL

b = true false
c = "f" "g"
price= 49.6 29.46
qty = 2200 1900
date = [2013.06.13, 2013.06.14]
month = 2012.06M 2012.07M
tt = 13:30:10.008 13:30:22.004
m = 13:30m 13:34m
sec = 13:30:10 13:30:22
datetim = 2012.06.13 13:30:10 2012.06.13 13:45:10
ts = 2012.06.13 13:30:10.008 2012.06.13 13:30:10.222
nanot = 13:30:10.008007006 13:30:11.028007006
nts = 2012.06.13 13:30:10.008007006  2012.06.18 13:30:10.008007006 
t = table(date, datetim , month, nts, nanot, tt, m, sec, price, qty, b, c );
t

select nts,price from t
select ts,price from t
select nanot,price from t
select datetim,price from t
select month,price from t
select tt,price from t
select sec,price from t
select m,price from t
ryanhamilton commented 1 month ago

Improved scalar/atom handling:

image

ryanhamilton commented 1 month ago

Chart rendering works for most types:

image

ryanhamilton commented 1 month ago

Improved highlighting of code.

image