Creating and managing databases is a critical part for any business or any development process. It also requires fair knowledge of installing, configuring and managing database engines and the managing software.
While there are some cool management tools like PhpMyAdmin (Adminer) and pgAdmn for PostgreSQL, they also require technical skills to install, run and manage. Furthermore, they are not easy to use by normal users.
That's not the case of Baserow, so in this article we will demonstrate why Baserow is different.
What is Baserow?
Baserow is free open-source web-based database creation and management tools that requires no prior coding skills or advanced technical skills like other tools.
Some may consider it a low-code or even no-code platform, however, it also aimed to be a functional tool to build apps on it.
Why should you consider using or trying out Baserow?
- Open-source Self-hosted System;
It is a Libre open-source solution as you can install and self-host it on your own server. It also means you will own your data without feat of vendor lock-in.
- Works with PostgreSQL;
PostgreSQL is a strong open-source database engine aimed for enterprise, commercial or even individual use.
- Create multiple databases on-fly;
Baserow supports creating many groups, database on-fly. Databases are organized in a simple easy-to-use functional view (tables). It supports search (Full-text search), sorting or dering and more.
- Templates ready;
Templates in Baserow are a creative functional method to create purpose-specific databases for accounting, patient-records, customer support and more.
With one-click, you can create a project tracking database, personal to-do list, applicant tracker or personal budget manager. With still yet more templates to come, we are expecting the community to supply it with dozens of useful templates for all types of users.
- Headless system to build external apps;
A REST-API (Headless system) is built-in useful feature in Baserow that helps developer to create external mobile, desktop and web apps to feed the database.
- Developer-friendly with plugin-build system.
Baserow is intended for:
- Companies or individuals who want to create databases on-fly
- Web Developers
- App developers
Baserow's Skeletons and Muscles
Baserow is built on top of Django long-standing functional and powerful Python web framework and Nuxt.js a Vue.
- User-friendly interface
- Multiple-database support
- Multiple user and user groups support
- Search and filtering
- Interactive tables
- File upload support
- Image file upload support
- Unlimited rows
- Lighting Fast
- Headless with a friendly REST-API support
- Supports custom and third-party plugins and extensions
- Docker installation support
- Supports up to 100,000+ rows view per table
- Custom database templates
- WebSocket API support
- Database plugin API for developers
- Customizable style with a rich style guide
- Rich user- and developer-friendly documentation
- Supports Ubuntu, Fedora, Debian
- Supports Cloudron
Install Baserow with Docker:
Docker installation is pretty easy as it takes only one command to get everything up and running.
First you need to download Baserow locally, make sure you have Docker installed (and docker-compose) then run this command:
docker-compose -f docker-compose.yml -f docker-compose.dev.yml up
Features that we expect in the future!
Baserow is still in active development, so expecting more features and improvements to come is fair, however, as a developer, i would like to see more features to build solid apps, customizable view extensions and GraphQL support.
- Multiple-user permission and group support
- One click-install on servers like DigitalOcean and Linode servers.
- Import and export in multiple format.
- Multimedia file uploads like videos, audio and more.
- Document file uploads
- A Snap package for Linux (Ubuntu) servers
- Accounting features that resemble spreadsheet functions
- Custom fields
- GraphQL support
We have been testing and playing with Baserow locally, it is proven to be reliable to build quick apps using it is seamless REST-API. Templates also came in handy as well as plugin development.
We recommend Baserow for developers, normal users who require to create their own database and collections without dealing with so much code.
As we stated, Baserow is still in active development and more features to come on its active roadmap, so stay tuned.