SmartBase: A Free Low-code Platform for AIoT

Posted November 23, 2022 by joinbase0 ‐ 5 min read

We are proud to announce to the world that, SmartBase, a free modern AIoT low-code platform, is available for free requesting of everyone.

Why Yet Another IoT Dashboard


Where the dashboard will take us?

Because we want IoT users to have more and better choices.

Currently there are existed IoT dashboards, like ThingsBoard and Datacake. Different products are developed by different people with different goals in their minds. Some are open source, but they may be started from the feature oriented engineering and lack enough performance for the real world. Others are source closed, you can pay for the service but there is a cost burden for small business units, and you can not do customization.

ThingsBoard is the builtin but pluggable frontend of JoinBase, which is a free all-in-one data stack built around our unique and innovative database technologies. We are committed to simplifying the IoT data pipeline while delivering the highest production efficiency. By lowering the consumption threshold of IoT data, we believe that JoinBase can benefit every organization and individual in this era.


ItemSmartBase w/ JoinBaseThingsBoardDatacake
Private deployment
Cloud servicecoming soonhaveonly cloud
Easy to use38 seconds to
setup the JoinBase
and 2 minutes to
create an interactive
dashboard in SmartBase as below
(try it yourself)
Free to usefree 2 devices
Source available for customization
Numbers of connected devicesunlimited (hardware limited)?2 devices for free
Builtin free MQTT broker for large-scale production
Builtin free database with full bigdata analysis
Mixed SQL + MQTT style interactive dashboard

Comparison between SmartBase w/ JoinBase and some other IoT dashboards

Let's just highlight unique points of SmartBase:

  1. Not limited to connect the JoinBase, SmartBase is open to connect to other data sources, like PostgreSQL (and all its wired), MySQL (and all its wired), MQTT endpoints and more.

Of course, the support to JoinBase with PostgreSQL and MQTT technologies is best and guaranteed.

  1. SmartBase is source available under the USAL(User Source Available License).

Become our users and request the sources for your business customization freely!

Show Case

To demonstrate the great power of the SmartBase, just see a simple show case for SmartBase.

The data model can be simply described as the following SQL:

create table myhouse.mysensors
    hour UInt8,
    temp1 Float32,
    temp2 Float32

here, hour stands for the hour part of current sensor sampling, temp1 for room #1 's temperature, temp2 for room #1 's temperature. This may be naive, but it is simple enough. Just request free SmartBase for all tries.

Then inject some random sensor data as like:

insert into mysensors values (0,21.3,22.2);
insert into mysensors values (1,21.1,22.1);
insert into mysensors values (2,20.9,22.1);
insert into mysensors values (3,21.0,22.2);
insert into mysensors values (4,21.2,22.2);
insert into mysensors values (5,21.3,22.3);
insert into mysensors values (6,21.6,22.2);
insert into mysensors values (7,21.9,22.2);
insert into mysensors values (8,22.5,22.3);
insert into mysensors values (9,22.9,22.2);
insert into mysensors values (10,23.2,22.2);
insert into mysensors values (11,23.6,22.3);

Let's just start to create an interactive dashboard for my smart house!

create a dashboard by SmartBase

Create an interactive dashboard in two minutes

A fully detailed record video is put on here.

Recap for the show case:

  1. General build blocks or widgets for common AIoT are available.
  2. Overlaying to any image with any widget is easy.
  3. Any SQL query on arbitrary history is easy with JoinBase, which is not available to a common MQTT dashboard.
  4. After-query data processing logic is easy.
  5. After-query widget presentation hooking is easy.
  6. Interaction is easy by the event handling of widgets.

In a word, the common AIoT interactive dashboarding has been well supported by the first SmartBase release. We are honored if you would like to give us more suggestions.

More Links

Get your AIoT one step ahead with free SmartBase and JoinBase by request here.

Talk with SmartBase and JoinBase developers in the Discord server.

Watch or submit your ideas in the community.