FeatureBase v3.33.0
About
This is FeatureBase v3.33.0, a crazy fast database/analytics engine based on Roaring Bitmaps.
FeatureBase is written in Go and supports SQL.
License
FeatureBase is released under the Apache 2.0 Open Source license.
Support
Join the Discord community: https://discord.com/invite/featurefirstai
Documentation: https://docs.featurebase.com/
Cookbooks (including SQL bulk inserts): https://github.com/FeatureBaseDB/featurebase-examples
Would you rather use Docker?
Video
Video is forthcoming.
Release
This release contains AMD and ARM FeatureBase binaries for macOS (darwin) and Linux.
The tarball for each architecture includes a directory for FeatureBase and an IDK directory for consumers for CSV, Github, Kafka and SQL.
Highlights
The SQL3 feature flag has been removed, and the SQL3 is now the default. We've added new functions such as time quantum and aggregate functions.
NOTE: We use "SQL3" to refer to the new SQL support for FeatureBase. "SQL3" does not refer to a particular flavor of SQL.
Resolved Bugs
- FB-1887 fb_exec_requests query group by not working
- FB-1909 Bug in backup and backup_tar field key translation
- FB-1912 Restore uses an obnoxious amount of memory
- FB-1954 Weird capitalization column misrepresentation bug (Nope, not capitalization)
- FB-1963 Featurebase server error printed despite successful query
- FB-1968 Timestamp in bulk import not handling seconds properly
- FB-1974 SQL3: Select count fails when run against table with no _id
- FB-1980 Test timeout observed in CI
- FB-1997 HAVING producing incorrect results for some queries
- FB-2002 HAVING sum(decimal) gets type coercion error, possibly sum(decimal) is coming back as int64
- FB-1790 Resolved a Protobuf Error which prevented connecting Grafana to FeatureBase
NOTE: The tickets/labels above and below are for our reference to Jira issues and do not correspond to issues on Github.
Task
- FB-1558 Implement semantics to support inserts into time quantum fields
- FB-1654 Implement select on a timequantum nested table
- FB-1658 Factor out AggregateFunctionType
- FB-1852 SQL3 w/ Grafana Plugin
- FB-1955 Support aggregates on top of results/expression of other functions (i.e. AVG(len(col)))
- FB-1975 Clean up version check code. Add options for where to store the UUID and where to check for version.
- FB-1996 Limit memory allowed while creating backup
- FB-2013 Remove SQL3 feature flag
Active Bugs
None
Issues
- Dashboard UI still isn't showing metrics on imports (previously a bug, but we're kicking around getting rid of the current dashboard, so we moved it here)
- Delete can delete records it probably shouldn't (this is limited to pending inserts and is a hard problem with filtering we're advertising here while we investigate)
Comments
The previously required flag for enabling full SQL support is no longer required and this message will be removed on the next release.
Keep in mind we don't support all SQL statements, yet.