FeatureBase v3.30.0
About
This is FeatureBase v3.30.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/
Examples: https://github.com/FeatureBaseDB/featurebase-examples
Would you rather use Docker?
Video
This release marks the first and ongoing bi-weekly sprint reviews we'll be publishing to YouTube.
Release
This release contains AMD and ARM FeatureBase binaries for macOS (darwin) and Linux.
The tarball for each architecture includes the consumers for CSV, Github, Kafka and SQL.
Notes are provided for guidance but are not yet inclusive of all features, fixes, issues and bugs. We're working on rectifying this.
Features
- Implements REPLICATE() for SQL
- String value support for Arrow (dataframes)
- Implements string method CHARINDEX() for SQL
Fixes
- SQL MIN() and MAX() don't work for timestamps*
- < and > operators don't work for timestamps*
- memory issues on bulk insert*
- ! → Bit-wise NOT operator doesn't work as expected*
- Large INT type data inserted with incorrect values*
- Restore uses an obnoxious amount of memory*
*previously not reported as a bugs, but they are fixed so there's that. 🪂
Issues
- Pending SQL GA, requires using flags to enable new SQL support (--sql.endpoint-enabled)
- Dashboard UI still isn't showing metrics on imports (previously a bug, but we're kicking around getting rid of the current dashboard, so standby)
- 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)
Bugs
- SQL AVG() Returns Incorrect Results (for fields of type ID)
- Bug in backup and backup_tar field key translation (cluster mode ONLY)
- --offset-mode flag doesn't change behavior
Comments
Moving forward, all work to FeatureBase will occur on this repository. 🚀
To run the server with the new SQL preview support, please use the following command (the docker builds in featurebase-examples do this for you):
./featurebase server --sql.endpoint-enabled
Keep in mind we don't support all SQL statements, yet.