needed more basic and advacned features

[salva-imm]

1. VARCHAR/CHAR with length support
2. exist
3. count
4. maybe some db specific features?(like HStore/JsonField for postgres)
5. filitering for numeric types (greater/smaller equals)
6. some basic aggregations/annotations

[moigagoo]

@salva-imm

 VARCHAR/CHAR with length support

I'm doing this right now in a separate branch. The way I see it, there will be types StringOfCap[n] and PaddedStringOfCap[n] that will correspond to VARCHAR and CHAR in Postgres and TEXT in SQLite.

How do you find this solution?

 filitering for numeric types (greater/smaller equals)

You can do that with db.select(objs, "field > $1", value).

some basic aggregations/annotations

What do you mean by that?

[moigagoo]

VARCHAR/CHAR with length support

Should be addressed in #101

[moigagoo]

maybe some db specific features?(like HStore/JsonField for postgres)

Duplicates #24

[salva-imm]

What do you mean by that?

@moigagoo
please take a look at this https://swcarpentry.github.io/sql-novice-survey/06-agg/index.html
somethings like calling min / max / avg in database layer

[moigagoo]

Count added in 2.3.0.