Skip to content

Releases: elliotchance/vsql

v0.6.2

31 Jul 14:29
ab53338
Compare
Choose a tag to compare
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

31 Jul 06:43
0d9081b
Compare
Choose a tag to compare
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

30 Jul 23:44
82971d3
Compare
Choose a tag to compare
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

29 Jul 15:40
5c9002c
Compare
Choose a tag to compare
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

29 Jul 15:17
898951f
Compare
Choose a tag to compare
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

29 Jul 14:01
baa523a
Compare
Choose a tag to compare
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

28 Jul 00:19
837d5b9
Compare
Choose a tag to compare
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

27 Jul 00:22
a649dd4
Compare
Choose a tag to compare
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

27 Jul 00:17
3f61c59
Compare
Choose a tag to compare
Cleanup storage.v (#8)

Now that V supports seek/tell we no longer have to track the positions
manually.

v0.3.2

26 Jul 22:10
b1121f5
Compare
Choose a tag to compare
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.