chai
chai copied to clipboard
chaisql
Modern embedded SQL database
Multi-table `SELECT` is query like ```SQL SELECT * FROM foo, bar; ``` ### Example If `foo` table is: | a | b | |---|---| | 1 | 2 | |...
### Proposal Add bleve support ( https://github.com/blevesearch ) ### Motivation Provides FTS like sqllite has and other DB's, to allow searching over documents. https://sqlite.org/fts3.html Provides facet based data analysis. A...
We should do something about integer overflows for values retuned by engine `NextSequence` method. E.g. SQLite claims to randomly choose available sequence number on overflow (I’d prefer deterministic solution, although...
Whenever we release a new version of the CLI, we should automatically compile the binary for Linux, macos and windows, 32 and 64 bits and upload them to the Github...
I wonder if its possible to use existing SQL DB tools with genji ? https://github.com/kyleconroy/sqlc - Just takes SQL and generates the golang code. So not dependent on anything else....
I can reproduce mattn/go-sqlite3#204 with [minimal changes](https://gist.github.com/tie/88322c6f880f8515b3b5ac64b2124ba4/revisions#diff-53618cae32e23ae47e1c35f10da92654). main1.go ``` // https://github.com/mattn/go-sqlite3/issues/705 package main import ( "database/sql" _ "github.com/genjidb/genji/sql/driver" ) func main() { db, err := sql.Open("genji", ":memory:") if err !=...
Are nested subqueries like the following allowed? ``` SELECT customerName FROM customers WHERE customerNumber NOT IN (SELECT DISTINCT customerNumber FROM orders); ``` This is not mentioned in the doc. Also,...
