Skip to content
This repository has been archived by the owner on Feb 21, 2024. It is now read-only.

FeatureBase v3.26.0
Compare
Choose a tag to compare
@kordless kordless released this 13 Dec 14:30
· 277 commits to master since this release
v3.26.0
5c39a49

About

This is FeatureBase v3.26.0, a crazy fast database based on Roaring Bitmaps. It is written in Go.

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.

Support

Join the Discord community: https://discord.com/invite/featurefirstai

Documentation: https://docs.featurebase.com/

Would you rather use Docker?

Features

  • SQL support now in the UI

Fixes

  • help contains two holder command references (this is a new command that starts and exits the server)
  • DDL statements on tables with hyphens on their names fail with a tokenizer error. (do not use '-' in names)
  • Syntax errors may be triggered by running TOP and DISTINCT
  • Top(x) Does Not Work with Additional Expression Clauses (WHERE, GROUP BY, etc.)
  • SQL - Multiple Group By Columns Can Cause DB Health Issues
  • SQL support not in the UI
  • errors with ingesting CSV files with headers
  • Bulk JSON imports
  • Top() filter with AVG() errors
  • Top() filters with count() errors

Issues

  • requires using flags to enable revamped SQL support (--sql.endpoint-enabled)

Bugs

  • UI: select * query erases history
  • "IS" SQL Argument returns incorrect error
  • SQL3 CLI - NDJSON, BULK INSERT parsing errors

Version Comments

Previous community version numbers were unfortunately chosen, including v1.0.0-community, v1.3.0-community, etc. Moving forward, the community release will follow the binary release versions.

It's complicated, but FeatureBase was originally named Pilosa and was very much Open Source. We closed the source for a time to do enterprise releases under the Molecula brand, running through a whole bunch of different versions. After some careful thought, we've opened up the code base again and arrived at using FeatureBase for both the company and the repository.

This should allow the homebrew recipe to be reactivated.

SQL Comments

We previously referred to "SQL3" in the releases here, but that was the internal name of the project to add most of the common SQL commands to the product, not the narrow implementation of SQL we previously supported (which we called SQL1). As of today FeatureBase now supports most SQL commands in both the UI and API calls to the '/sql' endpoint.

Keep in mind we don't quite support all SQL statements, but when asked our VP of Engineering said, "There's not much left to do...but the work remaining includes common table expressions (CTEs), windowing functions, UPDATEs (use INSERT REPLACE instead) and DELETEs, some of which which will be dropping soon."

Assets 6
Loading