Baserow 1.29: data sync integrations, AI field upgrades, workspace export/import, and more

In this release, we’re excited to introduce a range of new features and improvements that enhance Baserow’s functionality and user experience. Let’s dive into the key updates:

New data sync integrations

screenshot data sync integrations

We’ve introduced new data sync integrations to keep your information current across multiple platforms. New integrations allow automatic updates between Baserow and Jira, GitLab, GitHub, and PostgreSQL, eliminating the need for manual updates in multiple places. This ensures all collaborators have access to the latest information, keeping workflows in sync. Additionally, you can now track the progress of your data synchronization with a visual progress bar.

  • Jira, GitLab and GitHub issue integration: Seamlessly sync your Jira, GitLab and GitHub issues with Baserow, maintaining a single source of truth across different teams. This integration saves time so you don’t need to switch between tools or manually update information.
  • PostgreSQL table sync: We’ve developed direct synchronization with PostgreSQL tables. You can now input server hostname, username, table name, and other details to view and manipulate table data directly in Baserow.

To create a data sync:

  1. In your database sidebar, click ‘+ Create table’.
  2. Select Data Source from the options.
  3. Name your table and enter the necessary details for synchronization.
  4. Click ‘Next’.
  5. Choose the fields you want to sync.
  6. Click ‘Create and sync table’.

Coming soon: configure existing data sync, and Zendesk, Salesforce customers, Hubspot customers, GitHub pull requests, and GitLab merge request data sync.

AI field improvements

screenshot AI field improvements

We’ve made significant enhancements to our AI field functionality, providing you with more powerful and flexible AI-driven features.

  • Choices output type for classification: We’ve added a new AI output type designed specifically for classification tasks—choice options. You can, for example, use this to classify whether a review positive, neutral, or negative, or classify issue types based on their descriptions.
  • Anthropic and Mistral integrations: Leverage Anthropic’s and Mistral’s advanced AI models directly within Baserow for more sophisticated AI-powered operations.
  • Temperature setting option: Fine-tune the creativity of AI-generated content with the new temperature setting.

Coming soon: ability to generate all values in view, and Azure OpenAI, AWS Bedrock, and Google Gemini integrations.

Export and import of workspaces

screenshot export import workspaces

It’s now possible to export and import entire workspaces, making it easier to transfer your data between different Baserow instances, copying data between workspaces, or make an offline backup that you store outside of the Baserow instance.

To export a workspace, click the ‘Home’ tab, then click the arrow icon next to the workspace name. In the dropdown menu, select the option ‘Export data’.

Shared data sources

screenshot shared data sources

Shared data sources in Baserow’s Application Builder allow you to add a data source that’s usable across multiple pages within your application. This feature boosts efficiency and saves time so you don’t need to add the same data source on multiple pages.

To create a shared data source, go to the ‘Data Sources’ tab. There, you can set up ‘Share between pages’ for a new data source or an existing one, marking it as available throughout different pages.

Filter, sort and search for published applications

screenshot filter sort search for end users in application builder

We’ve added a new feature for Baserow’s Application Builder, giving your end-users more control. They can now filter, order, and search table elements within the published applications, creating a more interactive and user-friendly experience.

For each table element, you can specify which fields to make filterable, sortable, and searchable for your external users.

To add filtering, ordering, and searching capabilities, click on the table element and navigate to the right sidebar. There, you’ll see checkboxes to enable Filter, Order, and Search for specific fields.

Additional filters

screenshot additional filters

We’re expanding our filters to provide you with more control over your data. You can now apply filters on the following field types:

  • Single select field formulas and lookups
  • URL field formulas

To add custom filters to a view, you can show rows that apply to your conditions by clicking on the ’Filter’ tab at the top right of your table.

Company news

Webinar: Build your own governance, risk, and compliance (GRC) solution without coding

edg webinar
!

Learn how to create a tailored Risk and Compliance management solution that meets your specific needs—without custom development or costly software. Join us online on December 10th at 4:00 PM (CET) to discover how.

Reserve your spot now!

Join as a Baserow Ambassador

Are you a Baserow power user? We want YOU for our ambassador program! Here’s what you can expect:

  • A special space to interact with the Baserow team and fellow ambassadors
  • Free Baserow Advanced plan
  • Early previews of product updates
  • Exclusive merch
  • Financial support for organizing offline events

Want to know more? Details here.

How to effectively work with large amount of data in Baserow

Baserow is designed to handle high volumes of data and can scale as your data needs grow. However, it’s important to optimize your data for efficient performance. Here are some tips from our founder and CEO, Bram Wiepjes, on how to effectively manage large amounts of data in Baserow.

Watch now!

What’s next

The next big features on the roadmap include an analytics dashboard, more AI features, multi-page container, menu element, SSO for Application Builder and other features suggested by the community.

If you have any questions about the new updates, please leave them in our official community forum. We’re happy to answer them!