v0.16.0-RC3

Bugfixing

• Solved a problem parsing USING in CREATE INDEX

v0.16.0-RC2

New Features

• internal/rule,gitbase: use refs indexes in squash tables
• internal/rule: display indexed tables in squash
• gitbase: do not warn on not found HEAD
• Now, DESCRIBE statement return used indexed ids on queries

Performance improvements

• Update to new go-git version (~ 40%-60% speed performance, 60% less memory)
• sql/plan: more efficient implementation of GroupBy

Bugfixing

• Add regression queries

v0.16.0-RC1

New Features

• Pilosa index driver as library (pilosalib)
• sql: add support for show indexes
• vendor: upgrade bblfsh client-go
• Dockerfile: update to use --directories flag
• cmd/gitbase: load siva files and git indistinctly
• *: rename ref_commits index to history_index
• gitbase: add a more descriptive error connecting to bblfsh

Performance improvements

• Do not register pilosa driver if no connection.
• *: add siva files to the repository pool with an ID

Bugfixing

• gitbase: do not skip repo when it has no head in squash
• internal/function: recover from panics in uast functions
• Fix "NOT expressions with non existing value"
• fix panic when bmp is nil
• Fix merging indexes when row is nil.

Documentation

• docs: update references to go-mysql-server

v0.15.0

New Features

• sql/index/pilosa: implement negation indexes
• sql/analyzer: use indexes with 'NOT IN' expressions
• sql/plan: disallow indexes on blob and json columns
• add version() udf
• sql/expression/function/aggregation: allow conversion in AVG
• sql/analyzer: resolve ascend and descend indexes
• sqle: log query in debug

Performance improvements

• gitbase: compress keys using zlib
• sql/analyzer: add a rule to evaluate filters ahead of time

Bugfixing

• internal/rule: fix projections when squash joins
• cmd/gitbase: fix version and build info
• cmd/gitbase: remove -h flag as shortcut for --host
• gitbase: make squash iterators cancellable
• gitbase: fix bugs handling git errors
• sql/analyzer: remove unnecessary qualification of star
• sql/analyzer: fix resolveNaturalJoins rule to work properly with table aliases
• sql/analyzer: add a rule to reorder aggregations inside projections
• sql/parse: fix parsing when there are preceding spaces

Documentation

• docs: Add troubleshooting info about connecting with MySQL client 8.x
• docs: Add indexes section into the summary

v0.14.0

New Features

• sql/driver/pilosa: implement AscendIndex and DescendIndex
• plan/index: Add tracing to index creation
• sql/(index,plan): add logs for index creation
• sql/function/aggregation: add SUM aggregation function
• internal/rule: make SquashedTable tree more explanatory
• vendor: upgrade bblfsh client-go
• cmd/gitbase/command: make pilosa endpoint and index directory configurable through env vars
• *: implement commit_files table
• Documentation: https://docs.sourced.tech/gitbase/
• cmd/gitbase: add readonly flag
• cmd/server: add trace parameters to enable jaeger tracing
• sql/index: improved index tracing
• functions: Add CONCAT(...) function.
• sql/index: improved index tracing
• sql/plan: allow synchronous index creations

Performance improvements

• index/pilosa: batch boltdb and pilosa writes
• sql/analyzer: rule to move join conditions to filters
• Do not use full path in plain repository IDs
• internal/function: do not make requests to bblfsh for unsupported languages
• *: use indexes in the topmost squashed table
• cmd/gitbase: make squash rule active by default
• gitbase: custom encode and decode of index keys to save space
• index/pilosa: speedup index iterator

Bugfixing

• sql/analyzer: rule to resolve sort based on dependencies
• sql/parse: fix order by with group by
• sql/analyzer: improve error message when an alias is defined and used in the same projection
• sql/analyzer: fix star resolution when there are natural joins involved
• sql/(plan,index): force index deletion on save failure
• travis: build and upload macOS releases
• internal/rule: fix squashjoins rule to squash projections properly too
• gitbase: ignore .DS_Store files in darwin
• internal/rule: fix indexes of filters in squash
• gitbase: fix tree entry index iteration when object is unpacked
• Fix drop index panic
• sql/function: make time functions not return errors on conversion
• index/pilosa: do not error when key is not found
• sql/analyzer: fix columns in the resolveNaturalJoins rule when a Natural Join is transformed
• internal/function: don't fail if the uast function can't parse a blob

Documentation

• docs: add commit_files table to the schema documentation
• docs: add create index examples
• docs: new examples
• Add GITBASE_READONLY to docs
• docs: add indexes section

v0.14.0-rc2

New Features

• cmd/gitbase: add readonly flag
• cmd/server: add trace parameters to enable jaeger tracing
• sql/index: improved index tracing
• functions: Add CONCAT(...) function.

Performance improvements

• gitbase: custom encode and decode of index keys to save space
• index/pilosa: speedup index iterator

Bugfixing

• gitbase: ignore .DS_Store files in darwin
• internal/rule: fix indexes of filters in squash
• gitbase: fix tree entry index iteration when object is unpacked
• Fix drop index panic
• sql/function: make time functions not return errors on conversion

Documentation

• docs: add commit_files table to the schema documentation
• docs: add create index examples

v0.14.0-rc1

New Features

• sql/driver/pilosa: implement AscendIndex and DescendIndex
• plan/index: Add tracing to index creation
• sql/(index,plan): add logs for index creation
• sql/function/aggregation: add SUM aggregation function
• internal/rule: make SquashedTable tree more explanatory
• vendor: upgrade bblfsh client-go
• cmd/gitbase/command: make pilosa endpoint and index directory configurable through env vars
• *: implement commit_files table
• Documentation: https://docs.sourced.tech/gitbase/

Performance improvements

• index/pilosa: batch boltdb and pilosa writes
• sql/analyzer: rule to move join conditions to filters
• Do not use full path in plain repository IDs
• internal/function: do not make requests to bblfsh for unsupported languages
• *: use indexes in the topmost squashed table
• cmd/gitbase: make squash rule active by default

Bugfixing

• sql/analyzer: rule to resolve sort based on dependencies
• sql/parse: fix order by with group by
• sql/analyzer: improve error message when an alias is defined and used in the same projection
• sql/analyzer: fix star resolution when there are natural joins involved
• sql/(plan,index): force index deletion on save failure
• travis: build and upload macOS releases
• internal/rule: fix squashjoins rule to squash projections properly too

v0.13.0

New Features

• gitbase: implement sql.Indexable on all tables
• *: implement indexable interfaces on basic and relation tables
• cmd/gitbase: register pilosa index on server startup
• Make repo dir configurable in Dockerfile
• *: remove commit_has_blob, squash rule for commit_blobs
• *: remove commit_has_tree, add squashes for commit_trees
• *: remove history_idx, squash rules for ref_commits
• *: add squashes for joining repos with commits, entries and blobs
• gitbase: implement commit_blobs table
• Add commit_trees table
• gitbase: implement ref_commits table
• cmd/gitbase: glob support for adding repositories
• *: rename columns for easier natural joins, add repository_id

Bugfixing

• make it clear that the server is now running
• gitbase: implement files table with pushdown
• internal/function: language should return nil for unknown languages

v0.12.1-rc1

Merge pull request #299 from jfontan/configurable-repos-in-dockerfile

Make repo dir configurable in Dockerfile

v0.11.0

Bugfixing

• Fix incorrect error handling in commitsIter.New
• Ignore missing HEAD references

New Features

• Update enry dependency to v1.6.4
• Add bblfsh integration
• Relicense to Apache 2.0
• Skip git errors in iterators if GITBASE_SKIP_GIT_ERRORS is set
• Add commit parents to commits table
• Add support for siva files
• Support multiple siva and git folders
• Add Dockerfile

Performance improvements

• Don`t read blob content if it's not in the projection
• Skip hash references that do not point to commits
• Improve history_idx and commit_has_tree performance with an LRU cache