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.
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.
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.
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.
All the changes of Baserow version 0.5.0 listed.
Because we had less time available in this month we have focussed on lots of smaller issues. Among them are the single select field and inserting rows above and below a row.