Kevin Leung

Generated(computed) Columns

5

MySQL/Postgres: (Postgres does not support VIRTUAL) ```sql column_name data_type [GENERATED ALWAYS] AS (expression) [VIRTUAL | STORED] [UNIQUE [KEY]] ``` SQL server: ```sql column_name AS expression [PERSISTED] ``` Proposed Haxe syntax:...

I am writing some log-to-db snippets and I want the interface to accept a driver, db name, table name (or pre/suffix). I could hand-write the stuff done by DatabaseBuilder/TableBuilder to...

https://github.com/haxetink/tink_sql/blob/da7d66facc7f6a9094dbd4585bcda909a8ba732c/src/tink/sql/format/SqlFormatter.hx#L86 This 65535 is the max row size including overhead. For example the practical max row size of VARBINARY is about 63900 bytes (not very sure what exactly contributes to...

Custom Queries

6

What is the plan for arbitrary queries?

.where(table.field == null) translated to "WHERE false"

5

Looks like compiler is doing the job. Because the expr was already `EConst(false)` when it reaches the formatter

To be investigated, because I have totally no idea on this. I only know that it is not well handled now. Mostly because all those SQL implementations (e.g. mysql /...

Specifying length for integer is basically useless

3

I just realized it: https://stackoverflow.com/questions/5634104/what-is-the-size-of-column-of-int11-in-mysql-in-bytes/27519793#27519793 Maybe we should consider removing the type parameter, and use Haxe's `Int` type instead. (But could add `TinyInt`, etc)

Support foreign keys in create table query

2

Proposed syntax: ```haxe @:foreign(User, id) var userId:Id; ```

Support the CASE expression

1

https://dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html#operator_case

Comparison is not restricted to Float

1

SQL also supports comparing date & string. We should consider relaxing the constraint somehow. But that also involve generalizing the `ValueType`, not sure how to do that properly.