v3.5.1

Changelog

• 🚀 Added exact date type check for more reliable date detection
• 🐛 Fixed issue with the project access not changing in the team management page
• 🛂 Fixed permission issue where a team admin could remove the owner

v3.5.0

Changelog

✨ New features

• Added Variables support for Chart filters
• Added Variables support for dashboard filters
• Added filters directly on the Chart widget

🚸 UI/UX changes

• Added filter settings shortcut from the Chart editor
• Improved the UI of the Chart filters
• Added new Date pickers for the dashboard and chart filters
• Changed the filter icons to be the same across the app
• Improved the Firestore builder collection selection

🐛 Bug fixes

• Fixed connection forms when editing the connections
• Redux fixes for the team members selectors
• Fixed crash on the dataset page when hard refresh

Misc

• Minor dependencies bump for both client and server
• Added a new docker-compose example (#225)

New Contributors

• @RappyTV made their first contribution in #225

v3.4.0

Warning

This release fixes an important issue in 3.3.0 and this affects only the ones that are updating from 3.3.0 to 3.4.0. Feel free to ignore this warning if you are updating from a previous version. Read below on how to migrate:

Migrating from 3.3.0 to 3.4.0

• Replace the value in CB_ENCRYPTION_KEY with the one in CB_ENCRYPTION_KEY_DEV
• Any API keys created while using 3.3.0 will not work anymore and have to be replaced with new ones

Changelog

🐛 Bug fixes

• Fixed db migration failed problem on windows. by @victor21813 in #213
• Fixed infinite page reload when accepting a team invite while already logged in
• Fixed issue with the DEV encryption key being used in Production (issue introduced in v3.3.0)

Other

• Made sure that a Team Owner and Team Admin cannot be demoted in their team if they access a team invite link

New Contributors

• @victor21813 made their first contribution in #213

v3.3.0

Changelog

🔥 Potential breaking change

• CB_ENCRYPTION_KEY is now the main field used to encrypt data. The previous field CB_SECRET has been discontinued. There is a script that auto-generates the encryption key if not found in the .env file. Everything should still work out of the box without any changes, but if you're not relying on the .env file to populate your variables, you might want to generate this key yourself. (e.g. if you're using a custom docker compose file)

✨ New features

• Added theme support for embedded charts
• Added theme support for embedded reports

🔒 Security updates

• Updated the encryption tool and using more secure encryption keys across the board

🐛 Bug fixes

• Fixed customer.io queries
• Fixed decryption errors

💄 UI/UX changes

• Improved the design of the customer.io query builder
• Improved the user experience when creating an empty chart by showing a focused dataset selector
• Added the option to create datasets directly from the chart editor
• Creating or updating a dataset from the chart editor will redirect to the chart upon completion

Misc

• 🚀 Added a CSS selector (.header) for the report header
• 📝 Updated docs with the new CB_ENCRYPTION_KEY variable
• 🗃️ Changed database schema to allow longer values for the Connection table fields
• 🔧 Added new environment variables to allow using SSL certificates with the database:

CB_DB_SSL=
CB_DB_SSL_KEY=
CB_DB_SSL_CERT=

v3.2.1

Changelog

🐛 Bug fixes

• Fixed metrics and dimensions autocompletions in the GA4 builder
• Fixed filters in the Embedded charts
• Fixed request issues in the Firestore builder
• Fixed text editor theme issues in the Firestore and RealtimeDB connection form
• Make sure all nulls are filtered out when processing data for timeseries charts

💄🚸 UI/UX Changes

• Removed the Chartbrew branding from single embedded charts
• The login page re-routes to the homepage if the user is already logged in
• Changed UI of the Login page
• Changed the UI of the Signup page
• Added information about what data source the datasets are using in the chart editor
• Added the ability to create datasets directly from the chart editor + automatic routing back to the chart when done
• When editing a dataset from the chart editor, re-route automatically to the chart when done
• Added error handling and display of error in all the query builders

Misc

• ⬆️ Updated chart.js to v4

v3.2.0

Changelog

🔥 Breaking changes

• Previously Chartbrew could run on NodeJS v14 and v16 even though v20 was recommended. This is not possible anymore, v20+ required

✨ New features

• Two-factor authentication with authenticator apps now available
• Added Amazon RDS connectors (for Postgres and MySQL data sources only)

🐛 Bug fixes

• Fixed crash with the new NoticeBoard component in the user dashboard
• Fixed invite tokens in the Login screen
• Multiple fixes in the Firestore builder, including the sub-collection UI not appearing or state updating accordingly when using sub-collections

🚸 💄 UI/UX changes

• Changed the user profile dropdown to show "Team Settings" instead of "Account settings" for more clarity
• Hide the list of members for client accounts
• Added autocomplete functionality for Dashboard timezones to find the right one easier

⬆️ Major dependencies updates

Updated most of the dependencies on both server and client including major bumps. If you notice something breaking with this new version, please open a new issue about it.

Misc

• Added a cron job to delete old temporary charts (only from the ghost project)
• Updated the circleCI script to build the right version of the docs

v3.1.1

Changelog

✨ New features

• Added Supabase DB as a connection option: See tutorial
• Users can now replace connections when creating a new dashboard from a template
• Users can indicate if the template should create new datasets when the dashboard is created

💄 🚸 UI/UX changes

• Fixed custom template cards to have the same height
• Order templates by creation time
• Added the option to peak at the tokens in the API creation form
• Moved the KPI growth tooltip at the bottom so it doesn't hide the metric value

🐛 Bug fixes

• Fixed the Saved queries and migrated them to the new RTK syntax
• Fixed Dataset migration script that was causing new setups to break during DB migration
• Exposed date filters are not overwritten by the internal chart date filters anymore
• Fixed occasional UI crash when Datasets had a malformed conditions field
• Fixed occasional UI crash when changing the values of the date variables in the API builder
• Fixed the negative color for KPI growth labels
• Fixed leap year time series charts

MISC

• 🚀 Added accumulation support for string type on the X Axis
• ⬆️ Upgraded date libraries versions in the backend
• ♻️ Migrated templates to RTK
• 🔧 Added stale GH action to close old issues and PRs
• 🗃️ The server is now waiting for migrations to complete before it starts
• 🔧 Chartbrew's version is now exposed through the Vite config file instead of relying on 3rd party dependencies

v3.1.0

Changelog

✨ New features

• Full SSL support for Postgres and MySQL connections. This means you can select different SSL modes and upload certificates on the platform
• You can now configure the start_date and end_date variables when making an API request for a dataset

💄 Design changes

• Improved the design of the Forgot Password page
• Improved the design of the KPI charts
• Added a loading indicator for the dataset fields when processing a larger data set

🐛 Bug fixes

• fixed warning of teamId missing for the API keys page
• fixed the change password call from the forgot password page
• fixed issue with API builders with no route crashing
• fixed dataset joins not populating the right responses
• fixes to the Firestore builder with pulling collections and populating the response
• fixed MongoDB builder query
• fixed the Customer.io builder
• fixed the Realtime DB builder

♻️ Refactoring

• changed the postgres connection form component to support other providers to reduce complexity when adding other integrations

🔧 Config changes

• using vite.config.js to populate the app version rather than relying on other dependencies like cross-env

📝 Documentation

• Added new MySQL tutorial: https://chartbrew.com/blog/visualize-mysql-data-with-chartbrew/
• Added new Postgres tutorial: https://chartbrew.com/blog/how-to-visualize-postgresql-data-with-chartbrew/

v3.0.0 - Major release

v3 has arrived 🚀

📺 Watch a preview of v3 on YouTube

v3.0.0 Changelog

Lots have changed, so this changelog will be kept brief with the notable changes only.

🔥 Breaking changes

• REACT_APP_API_HOST is now VITE_APP_API_HOST
• REACT_APP_CLIENT_HOST is now VITE_APP_CLIENT_HOST
• New variable VITE_APP_CLIENT_PORT to specify where the app runs or is served. The default value is 4018, but you will have to change this if you run the app on a different port.
• NodeJS v20 is required as a minimum version
• Team roles have changed. The previous admin and editor roles are now set as projectAdmin. This will not allow them to create connections and datasets, so you might have to reassign the roles for your team members in the UI.

✨ New changes

• Connections and Datasets can now be re-used on team-level and can access them from any dashboard.
• Introduced tags for Connections and Datasets to allow complex access across dashboards
• Satisfying new grid layout design for dashboards with variable height and drag-and-drop capabilities
• Brand new UI design, colors, and improved UX across the board
• New Connection creation wizard UI to help you get started much quicker
• New Dataset builder with Chart preview and editor built-in
• New dashboards can be created directly from community templates
• Newly designed user dashboard with team focus
• New roles separated by team and dashboard levels. Your team can have the teamOwner and teamAdmin roles, and your clients can have specific access to dashboards with their own projectAdmin and projectViewer roles.
• New public dashboard design (themes coming soon!)
• New Strapi plugin updates to work with v3, new dashboard layout, and team-switch function

v3.0.0-beta.3

v3 has arrived 🚀

⚠️ Important info

🚧 This is work in progress, and a major release. Please read the migration guide carefully before using this in production

📺 Watch a preview of v3 on YouTube

🐳 v3 is available on Docker at razvanilin/chartbrew:v3. Read the guide here on how to get and run the image

The managed app at chartbrew.com will still run on v2 until full release - currently planned for mid-Jan 2014

Changelog v3.0.0-beta.2 -> v3.0.0-beta.3

• ✨ Introduced Tags for Connections and Datasets for more control over who has access to what
• 💄 Added a Grid view option for the dashboards table
• 💄 Updated empty states for the dashboard list and for dashboards with no charts
• 💄 Improved the UI for the Navbar breadcrumbs
• 💄 UI tweaks for the chart resizer
• 💄 Fixed the UI for the show/hide drafts
• 🚸 The current selected team is now remembered across the app so users don't switch manually
• 🐛 Fixed issue with layout changes not saving all the time
• 🐛 Fixed custom template cards overlapping each other
• 🐛 Fixed issue with Connections and Datasets local state mixing between teams
• 🐛 Fixed issue with client accounts not being able to access their dashboards
• 🐛 Fixed issue with malformed layouts being sent to the server and breaking the dashboard layout
• 🐛 Fixed issue with the chart not being rendered automatically when creating a new Dataset
• 🛂 Updated permissions for projectAdmin to reflect the new tags update
• 🚀 Updated the caching in the ChartPreview component to use local state for status

✔️ Outstanding items

• Add filter options in the Chart editor
• Redesign the filter on the charts with the new layout
• Make embedding work with the new design
• Add the option to edit tags for Connections and Datasets
• Add new guides and tutorials across the UI
• Add grid view for dashboards in the User Dashboard
• Fully update the Docs site
• Migrate Strapi plugin to work with v3

v3.0.0 Changelog

Lots have changed, so this changelog will be kept brief with the notable changes only.

🔥 Breaking changes

• REACT_APP_API_HOST is now VITE_APP_API_HOST
• REACT_APP_CLIENT_HOST is now VITE_APP_CLIENT_HOST
• New variable VITE_APP_CLIENT_PORT to specify where the app runs or is served. The default value is 4018, but you will have to change this if you run the app on a different port.
• NodeJS v20 is required as a minimum version
• Team roles have changed. The previous admin and editor roles are now set as projectAdmin. This will not allow them to create connections and datasets, so you might have to reassign the roles for your team members in the UI.

✨ New changes

• Connections and Datasets can now be re-used on team-level and can access them from any dashboard.
• Introduced tags for Connections and Datasets to allow complex access across dashboards
• Satisfying new grid layout design for dashboards with variable height and drag-and-drop capabilities
• Brand new UI design, colors, and improved UX across the board
• New Connection creation wizard UI to help you get started much quicker
• New Dataset builder with Chart preview and editor built-in
• New dashboards can be created directly from community templates
• Newly designed user dashboard with team focus
• New roles separated by team and dashboard levels. Your team can have the teamOwner and teamAdmin roles, and your clients can have specific access to dashboards with their own projectAdmin and projectViewer roles.
• New public dashboard design (themes coming soon!)