All Projects β†’ chartbrew β†’ Chartbrew

chartbrew / Chartbrew

Licence: mit
Open-source web platform for creating charts out of different data sources (databases and APIs) πŸ“ˆπŸ“Š

Programming Languages

javascript
184084 projects - #8 most used programming language

Projects that are alternatives of or similar to Chartbrew

Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Stars: ✭ 20,147 (+10024.12%)
Mutual labels:  hacktoberfest, analytics, mysql, postgresql, dashboard
Grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Stars: ✭ 45,930 (+22980.4%)
Mutual labels:  hacktoberfest, analytics, mysql, data-visualization, dashboard
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company πŸ˜‹
Stars: ✭ 26,803 (+13368.84%)
Mutual labels:  analytics, mysql, postgresql, data-visualization, dashboard
Helicalinsight
Helical Insight software is world’s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions.
Stars: ✭ 214 (+7.54%)
Mutual labels:  mysql, mongodb, postgresql, data-visualization, dashboard
Koolreport
This is an Open Source PHP Reporting Framework which you can use to write perfect data reports or to construct awesome dashboards using PHP
Stars: ✭ 204 (+2.51%)
Mutual labels:  mysql, mongodb, postgresql, data-visualization
Databazel
The analytical and reporting solution for MongoDB
Stars: ✭ 118 (-40.7%)
Mutual labels:  analytics, mongodb, data-visualization, dashboard
Next
Directus is a real-time API and App dashboard for managing SQL database content. 🐰
Stars: ✭ 111 (-44.22%)
Mutual labels:  api, mysql, postgresql, dashboard
Directus
Open-Source Data Platform 🐰 β€” Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Stars: ✭ 13,190 (+6528.14%)
Mutual labels:  api, mysql, postgresql, dashboard
Denodb
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Stars: ✭ 498 (+150.25%)
Mutual labels:  mongo, mysql, mongodb, postgresql
Abixen Platform
Abixen Platform
Stars: ✭ 530 (+166.33%)
Mutual labels:  analytics, data-visualization, charts, dashboard
Django Dbbackup
Management commands to help backup and restore your project database and media files
Stars: ✭ 471 (+136.68%)
Mutual labels:  hacktoberfest, mysql, mongodb, postgresql
Dashblocks
Enable Analytics in your Apps
Stars: ✭ 48 (-75.88%)
Mutual labels:  analytics, charts, chartjs, dashboard
Aclify
πŸ”’ Node Access Control Lists (ACL).
Stars: ✭ 49 (-75.38%)
Mutual labels:  api, mysql, mongodb, postgresql
Cube.js
πŸ“Š Cube β€” Open-Source Analytics API for Building Data Apps
Stars: ✭ 11,983 (+5921.61%)
Mutual labels:  analytics, mysql, postgresql
Dashboards
Responsive dashboard templates πŸ“Šβœ¨
Stars: ✭ 10,914 (+5384.42%)
Mutual labels:  analytics, charts, dashboard
Lapidus
Stream your PostgreSQL, MySQL or MongoDB databases anywhere, fast.
Stars: ✭ 145 (-27.14%)
Mutual labels:  mysql, mongodb, postgresql
Nodebb
Node.js based forum software built for the modern web
Stars: ✭ 12,303 (+6082.41%)
Mutual labels:  hacktoberfest, mongodb, postgresql
Dolibarr
Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). It is open source software (written in PHP) and designed for small and medium businesses, foundations and freelancers. You can freely install, use and distribute it as a standalon…
Stars: ✭ 2,877 (+1345.73%)
Mutual labels:  hacktoberfest, mysql, postgresql
Appkernel
API development made easy: a smart Python 3 API framework
Stars: ✭ 152 (-23.62%)
Mutual labels:  api, mongo, mongodb
Endb
Key-value storage for multiple databases. Supports MongoDB, MySQL, Postgres, Redis, and SQLite.
Stars: ✭ 208 (+4.52%)
Mutual labels:  mysql, mongodb, postgresql

ChartBrew logo

ChartBrew build

Chartbrew is an open-source web application that can connect directly to databases and APIs and use the data to create beautiful charts. It features a chart builder, editable dashboards, embedable charts, query & requests editor, and team capabilities.

ChartBrew dashboard


πŸ“š Read the full docs here

πŸ”§ Development roadmap - start here if you want to contribute

πŸš™ Public feature roadmap over here

πŸ’¬ Join our Discord

Data sources

Currently, ChartBrew supports connections to these data sources.

  • MySQL
  • PostgreSQL
  • MongoDB
  • APIs that support JSON data

Prerequisites

  • NodeJS v12 (should also work with v10)
    • For M1 Macs you might need the latest v14 or v15
  • NPM
  • MySQL (5+) or PostgreSQL (12.5+)

Start

It is recommended you head over to the more detailed documentation to find out how to set up Chartbrew

πŸ“š You can find it here

Quickstart

If you already have a MySQL or PostgreSQL server running, create a database called chartbrew and follow the prompts of the create-chartbrew-app command below.

Important Windows command line is not supported at the moment. Use something like Cygwin on Windows.

npx create-chartbrew-app chartbrew

The CLI tool creates a chartbrew/.env file which you can configure at any time if you want to change the database, API & client host, etc. The file contains comments explaining what each environmental variable is for. Check out which need to be set here.

Run the database migrations

If the database parameters are correct, the migrations should run automatically. If the new database wasn't populated with tables, ensure all the environmental variables are set, then run the following command in the server folder:

cd server
npm run db:migrate

Run the project in Development

Open two terminals, one for front-end and the other for back-end.

# frontend
cd client/
npm run start

# backend
cd server/
npm run start-dev

Run with Docker

Check the full guide in the docs.

Quickstart

Run the following commands and configure the variables:

docker pull razvanilin/chartbrew
docker run -p 3210:3210 -p 3000:3000 \
  -e CB_SECRET=<enter_a_secure_string> \
  -e CB_API_HOST=0.0.0.0 \
  -e CB_DB_HOST=host.docker.internal \
  -e CB_DB_NAME=chartbrew \
  -e CB_DB_USERNAME=root \
  -e CB_DB_PASSWORD=password \
  -e REACT_APP_CLIENT_HOST=http://localhost:3000 \
  -e REACT_APP_API_HOST=http://localhost:3210 \
  razvanilin/chartbrew

Acknowledgements

Many thanks to everybody that contributed to this open-source project πŸ™

Start here if you want to become a contributor

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].