If you already have a non-trivial set of tables in your database, consider using the data schema generation because it can save time.įor our API, we select the line_items, orders, products, and users tables and click “Generate Schema.” As the result, we'll have 4 generated files in the schema folder-one schema file per table. Please make sure you have PostgreSQL installed.Ĭube can generate a simple data schema based on the database’s tables. So, in order to display that data on a dashboard, we're going to create an analytical API.įor that, we'll use the Cube command-line utility (CLI).Ĭube supports all popular databases, and the API will be pre-configured to work with a particular database type. Let's assume that the company keeps its data in an SQL database. We're going to build the dashboard for an e-commerce company that wants to track its overall performance and orders' statuses. Also, check out the live demo and the full source code available on GitHub. It also provides many production-grade features like multi-level caching for optimal performance, multi-tenancy, security, and more.īelow you can see an animated image of the application we're going to build. It removes all the hustle of building the API layer, generating SQL, and querying the database. We're going to use Cube for our analytics API. We'll go from data in the database to the interactive, filterable, and searchable dashboard. In this guide, we'll learn how to build a full-stack dashboard with KPIs, charts, and a data table. It provides a lot of ready-to-use components to build web applications, including dashboards, fast and easy. Material is the reference implementation of Material Design components for Angular. According to Stack Overflow Developer Survey 2020, only just about ~10 % of developers prefer React to Angular. Angular □️ is the web framework of choice for many professional developers.
0 Comments
Leave a Reply. |