Releases: elliotchance/vsql
Releases · elliotchance/vsql
v0.6.2
Allow custom functions with register_function() (#23) Custom functions make vsql a lot more flexible when working with V. Also added an `examples` directory that doubles as a set of integration tests since all examples are tested on CI.
v0.6.1
Adding support for "AS" aliases (#22) The `AS` in `SELECT` statements allow custom column names to be used. Also, fixed a bug with `*` not being handled correctly in SELECT expressions.
v0.6.0
Support functions in expressions (#21) - Expressions now support functions, starting with some common SQL standard functions `ABS`, `SIN`, `COS`, `TAN`, `ACOS`, `ASIN`, `ATAN`, `SINH`, `COSH`, `TANH`, `MOD`, `LOG`, `LOG10`, `LN`, `EXP`, `POWER`, `SQRT`, `FLOOR`, `CEIL` and `CEILING`. - Better documentation around types and their specific limitations. Including replacing cases of `FLOAT` with the more appropriate `DOUBLE PRECISION` (since `FLOAT` is an alias). - Added SQLSTATE 42883: no such function.
v0.5.2
Fix releases (#20) The asset uploader does not play friendly with environment variables so we'll have to use a fixed name for now.
v0.5.1
Produce binaries for releases (#19) A zip file containing the standalone vsql-cli and vsql-server can be downloaded from the Github Releases page to use vsql without needing a V compilication environment. At the moment only macOS and windows binaries are produced because linux cross compilation is not working for me yet: https://github.com/vlang/v/issues/10992 Fixes #17
v0.5.0
Greatly improved expressions (#18) - Expressions can now contain artithmetic for binary operations (+, -, * and /). - Expressions now follow correct operator pecedence. - Added SQLSTATE 22012 "division by zero". - Adding grouping expression (parenthesis). - Added concatenation `||`. - Added logical operators for `AND`, `OR` and `NOT`. - Added unary operators `+` and `-`. - Changes not equal operator `!=` to `<>` to correct follow the SQL standard. - Renamed the lexer tokens to be same as the naming conventions in the SQL standard.
v0.4.1
row: Improve API and implementation (#14) - The `Row` now has new functions for `get_bool`, `get_null` and `get_unknown` for respective value types. - The get methods are sensitive to returning only on the correct types (ie. `get_f64` can only be used on numeric values). - An error is returned from any get method if the column does not exist. - Should a column not exist but there is a column with a different case, a more helpful message is returned like "no such column foo, did you mean FOO?" Fixes #13
v0.4.0
Added vsql-server (#9) `vsql-server` will run vsql in server mode on the default port 3210. You can connect to it with any compatible PostgeSQL client. The PostgreSQL protocol implementation is very basic so it may not handle many edge cases yet.
v0.3.3
Cleanup storage.v (#8) Now that V supports seek/tell we no longer have to track the positions manually.
v0.3.2
Statements optionally terminated by `;` (#12) A statement can optionally be terminated by `;` and any tokens after that is now considered an error. The SQL test suite has been updated so that statements can span multiple lines since all statements must be terminated with `;`. Overall this makes queries and test more compatible and reliable.