skytable / skytable

Skytable is a modern scalable NoSQL database with BlueQL, designed for performance, scalability and flexibility. Skytable gives you spaces, models, data types, complex collections and more to build powerful experiences
https://skytable.io
GNU Affero General Public License v3.0
2.38k stars 85 forks source link

Demo Logic on skytable.io website needs updating? #361

Open KayCynk opened 1 month ago

KayCynk commented 1 month ago

Hello, First thank you @ohsayan for starting this project. I'm new to Github and programming with nosql. I'm experimenting with Skytable, but going through a slight learning curve. I noticed the code on the front page of: https://skytable.io/ had a couple of errors and I modified the code below to fix the issue:

CREATE SPACE IF NOT EXISTS myspace
CREATE MODEL IF NOT EXISTS myspace.mymodel(    username: string,    password: string,    notes: list { type: string },    null profile_pic: binary)
USE myspace
INSERT INTO myspace.mymodel {    username: "sayan",    password: "pass123",    notes: ["this is my first note"],    profile_pic: null}

SELECT ALL * FROM myspace.mymodel LIMIT 100

UPDATE myspace.mymodel SET notes += "my new note" WHERE username = 'sayan'
ALTER MODEL myspace.mymodel ADD phone_number {    nullable: true,    type: uint8}
INSERT INTO myspace.mymodel {    username: "sayanNew",    password: "pass123New",    notes: ["NEW this is my first note"],    profile_pic: null,    phone_number:1234567}

The problem i'm experiencing is that when i try to run this code '*SELECT ALL FROM myspace.mymodel LIMIT 100' the client aborts with the following error code: **cli error: client error. protocol error: invalid data received from server**

I started over by deleting the old model 'myspace.mymodel' and created a new 'myspace.mymodel' and removed the field 'notes: list { type: string },' CREATE MODEL IF NOT EXISTS myspace.mymodel( username: string, password: string, null profile_pic: binary) now this statement works: *'SELECT ALL FROM myspace.mymodel LIMIT 100'**

I believe the 'notes: list { type: string }' is not working with the client? Or does that require additional logic to retrieve the records? +++++++++++++++++++++++++++

Operating systems: Windows Server 2022 and Centos9 Stream Version Skytable: 0.8.3

Steps to reproduce the behavior: visit https://skytable.io/ use code under "BlueQL in action Beta"

Thanks in advance for any help? Best KC.

ohsayan commented 3 weeks ago

Can you try it now (v0.8.4)? There was a bug in skysh that prevented SELECT ALL from working correctly