DEV Community

loading...
Cover image for Top 3 Low- and No-code Databases for Creative Entrepreneurs

Top 3 Low- and No-code Databases for Creative Entrepreneurs

Fischerbach
Originally published at Medium ・3 min read

Interactive spreadsheets help free up your time

Unless stated otherwise, all pictures in the article are by the author. Brands belong to their respective owners and are used for information purposes.

If you are like me and run your own practice (business, freelancing, publishing, whatever you want to call it), you probably use some form of a spreadsheet. I started managing my finances, client relationships, time, and other things by creating spreadsheets in Google Sheets (and even before that in classic Excel).

The advantage of Google Sheets is undoubtedly their accessibility from any platform equipped with a modern browser. Furthermore, Sheets can be extended using Google Apps Script (the equivalent of Visual Basic from Microsoft Office, I believe).

Why creators need no-code platforms

Google Sheets are great, but the more I’ve used them, I’ve noticed a certain regularity. Every time I set up a new sheet to manage some project, there was a certain group of actions and elements that repeated between different sheets:

  • Date columns for deadlines & marking updates,

  • Columns with dropdown select,

  • True/false columns in form of checkboxes,

  • VLOOKUP and similar search functions,

  • Pivot tables.

Google Sheets, as spreadsheet software, is a general-purpose tool. Therefore, creating even relatively simple interfaces, although easy, was quite labour intensive.

Aesthetic considerations were also behind the search for alternatives. If I spend several hours in a tool, I would prefer it to be visually satisfying.

Smart spreadsheets

The category, to which all software discussed today belongs, does not have an established name. They are often referred to as interactive or smart spreadsheets. They are usually called (even by their creators) as Airtable alternatives 😅

[Airtable](https://airtable.com) — basic view

In other words, tools for creating interactive online databases without technical experience. Interactive sheets provide the sweet spot between flexibility and development speed, by lowering the barriers to database creation. Thanks to that anyone, who know how to work with a spreadsheet, can also work with databases. They allow you to create tables with business data and automatically recalculated fields, just like classic spreadsheets.

[Airtable](https://airtable.com) — example of calendar view

But at the same time, they have a set of functions that go further. For example, if a table contains a date column, you can overlay its content on a calendar view. The key point here is that whenever you use one of the platforms described below, you are using ready-made elements, blocks and functionalities, prepared by their developers.

You drag and drop or attach those elements to your project.

[Seatable](https://seatable.io) statistics dashboard

At the same time, you retain the flexibility of a classic spreadsheet because you have access to APIs and libraries in popular programming languages. You or your software engineer will be able to adapt the tool to a specific business case.

But why self-hosted?

However, before you trash all your existing spreadsheets, there is one more thing to consider. Most of the solutions available on the market are very convenient, contain a certain minimum set of functions and have a low entry barrier. Those causes make the temptation to base your business logic on those tools. But what if a particular service has a failure or even ceases to exist? Your data, your workflows and your automation can disappear irretrievably.

If, on the other hand, ...

Read More:
https://medium.com/swlh/top-3-low-and-no-code-databases-for-creative-entrepreneurs-b10f069c36b3?sk=5eee8274170c4a3d9fe76cc5cf689f3e

Discussion (1)

Collapse
sonu_sharma profile image
sonu sharma

Awesome resource! Have you tried Nodezap it can be used to create Admin Panels. It has variety of charts and widgets to choose from. You can write your own CRUD logic to manipulate data. It will also let you fetch data from the external resources using REST api.