release
Back to overview

October release of Baserow

Blog placeholder image

When we launched the first version in April this year, we have received a lot of feature requests. Importing existing data and exposing data publicly via a REST API endpoint were very popular. We are pleased to announce that both these features are included in the 0.5.0 release! Baserow has also gained contributions from the community. We now have a step by step guide on how to install Baserow on a Ubuntu server, an email field, delete confirmations a many more additions.

Importing existing data

It's of course tedious to manually type over your existing data in Baserow. We understand that completely and we have set the first steps by implementing a CSV and tabular paste importer. When creating a new table you now have the option to use an importer. In case you choose the CSV importer you can upload a file, choose a column separator an see a really cool preview of your data. This way you can make sure that the file that you have uploaded contains the correct data in and is in the right format. It's also possible to copy data from a spreadsheet and paste that into into the tabular paste importer.

The CSV and tabular paste importer are only the beginning. We have plans to create a Microsoft Excel, Apple Numbers, Google Sheets, XML, JSON and many other importers. Of course it's also possible to create your own importer by developing a plugin.

Screenshot importing CSV file in Baserow

Publicly exposing data via a REST API endpoint

It was one of the first feature requests that we have received. Easily exposing your data via a public REST API. This makes it possible to integrate Baserow with your existing application or website. You can for example create a table with projects that you have worked on in Baserow, and add a page to your portfolio website that fetches and lists those projects. This way you don't have to setup a backend or CMS by yourself. Your site can even be a fully static. It's possible to perform create, read, update and delete operations on the table.

Creating a token

In order to expose your data publicly you need to generate an authentication token. This token must be provided upon each request to the endpoint. You generate the token via your account settings, which can be accessed by clicking on the account button in the bottom left corner. Next use the sidebar of the settings modal to navigate to the API tokens section. Here you can use the button to create a new token for a specific group. After that you can select permissions for each CRUD operation on group, database and table level.

Screenshot listing API tokens in Baserow

Using the API documentation

Now that you have created your table and your API token, you can use the API documentation that is generated for your table. Here you will find instructions for your needs. We have also included example requests in cURL, HTTP, Axios (JavaScript) and Requests (Python).

View your API documentation here

Screenshot API docs in Baserow

All changes

All the changes of Baserow version 0.5.0 listed.

  • Importing existing data.
  • Publicly exposing data via a REST API endpoint.
  • A row is now highlighted when you select a cell (by Keith).
  • Fixed small validation bug when changing the link row table.
  • Fixed small error when there is no view.
  • Added a step by step Ubuntu installation guide (by Timo).
  • Added an email field (by Keith).
  • Added the ability to navigate a dropdown with the arrow keys (by Keith).
  • Added delete confirmation modals (by Hoang).
  • Fixed a bug in the web frontend URL validation (by Hoang).
release
November 2, 2020 by Bram Wiepjes
October release of Baserow

This month's update includes, along with some great contributions from the community, the much requested importing and exposing data publicly via a REST API features.

release
September 14, 2020 by Bram Wiepjes
Building your own database
info
May 22, 2020 by Bram Wiepjes
Best Airtable alternatives