Baserow is an open source no-code database tool and Airtable alternative

Overview

Baserow

Open source no-code database tool and Airtable alternative. Join our forum on https://community.baserow.io/ or on Gitter via https://gitter.im/bramw-baserow/community.

Warning: From version 0.8.0 to 1.4.1 of Baserow the docker-compose.yml included in the root of this repository has exposed an unsecured redis instance by default on the ip:port 0.0.0.0:6379. If you have been running a server which is accessible via the internet using this docker-compose.yml then it is possible this redis server has been exposed to the internet depending on your operating system, networking setup and firewall settings. Please update to the latest version of Baserow, 1.4.2 which no longer exposes the redis, db and mjml containers. Additionally, 1.4.2 only exposes the backend, web-frontend and media containers on localhost and not on 0.0.0.0. If you were previously relying on docker-compose.yml publicly exposing Baserow then please follow the Make Baserow publicly accessible section in the docker how to guide.

Deploy to Heroku Beta

We're hiring remote developers! More information at https://baserow.io/jobs/experienced-full-stack-developer.

Baserow screenshot

Introduction

Create own database without technical experience. Our user friendly no-code tool gives you the powers of a developer without leaving your browser.

  • Uses popular frameworks like Django and Nuxt.js.
  • Uses PostgreSQL.
  • Open source.
  • MIT license.
  • Self hosted.
  • Headless and API first.
  • Modular architecture.
  • Supports plugins.
  • Includes a plugin boilerplate.
  • Unlimited rows.
  • Runs in your browser.
  • Alternative to Airtable.

Self host

Try out Baserow on your machine

If you just want to try out Baserow, you can create an account on the SaaS version at https://baserow.io. Just click on the create account or register button at the homepage.

If you want to try out Baserow on your own computer, you can easily start a local environment via docker-compose. Just clone the repository, run the following commands and visit http://localhost:3000 in your browser.

$ git clone --branch master https://gitlab.com/bramw/baserow.git
$ cd baserow
$ docker-compose up 

More detailed instructions and more information about running baserow locally check here or at https://baserow.io/docs/guides/running-baserow-locally.

Development environment

If you want to contribute to Baserow you need to setup the development environment. Execute the following commands to start a development version of the baserow environment which has debug and hot re-loading features enabled.

$ git clone --branch master https://gitlab.com/bramw/baserow.git
$ cd baserow
$ docker-compose -f docker-compose.yml -f docker-compose.dev.yml up
$ # OR use our ./dev.sh script which also ensures your dev containers run as your user
$ ./dev.sh --build

The Baserow development environment is now running. Visit http://localhost:3000 in your browser and you should see a working version in development mode.

More detailed instructions and more information about the development environment can be found here or at https://baserow.io/docs/development/development-environment.

Plugin development

Because of the modular architecture of Baserow it is possible to create plugins. Make your own fields, views, applications, pages or endpoints. We also have a plugin boilerplate to get you started right away. More information can be found in the plugin introduction and in the plugin boilerplate docs.

Official documentation

The official documentation can be found on the website at https://baserow.io/docs/index or here inside the repository. The API docs can be found here at https://api.baserow.io/api/redoc/ or if you are looking for the OpenAPI schema here https://api.baserow.io/api/schema.json.

Become a sponsor

If you would like to get new features faster, then you might want to consider becoming a sponsor. By becoming a sponsor we can spend more time on Baserow which means faster development.

Become a GitHub Sponsor

Meta

Created by Baserow B.V. - [email protected].

Distributes under the MIT license. See LICENSE for more information.

Version: 1.7.1

The official repository can be found at https://gitlab.com/bramw/baserow.

The changelog can be found here.

Become a GitHub Sponsor here.

Community chat via https://gitter.im/bramw-baserow/community.

A selection of SQLite3 databases to practice querying from.

Dummy SQL Databases This is a collection of dummy SQLite3 databases, for learning and practicing SQL querying, generated with the VS Code extension Ge

1 Feb 26, 2022
Py2neo is a comprehensive toolkit for working with Neo4j from within Python applications or from the command line.

Py2neo v3 Py2neo is a client library and toolkit for working with Neo4j from within Python applications and from the command line. The core library ha

64 Oct 14, 2022
Python PostgreSQL adapter to stream results of multi-statement queries without a server-side cursor

streampq Stream results of multi-statement PostgreSQL queries from Python without server-side cursors. Has benefits over some other Python PostgreSQL

Department for International Trade 6 Oct 31, 2022
SQL queries to collections

SQC SQL Queries to Collections Examples from sqc import sqc data = [ {"a": 1, "b": 1}, {"a": 2, "b": 1}, {"a": 3, "b": 2}, ] Simple filte

Alexander Volkovsky 0 Jul 06, 2022
Query multiple mongoDB database collections easily

leakscoop Perform queries across multiple MongoDB databases and collections, where the field names and the field content structure in each database ma

bagel 5 Jun 24, 2021
Apache Libcloud is a Python library which hides differences between different cloud provider APIs and allows you to manage different cloud resources through a unified and easy to use API

Apache Libcloud - a unified interface for the cloud Apache Libcloud is a Python library which hides differences between different cloud provider APIs

The Apache Software Foundation 1.9k Dec 25, 2022
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

PyPika - Python Query Builder Abstract What is PyPika? PyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a s

KAYAK 1.9k Jan 04, 2023
Asynchronous Python client for InfluxDB

aioinflux Asynchronous Python client for InfluxDB. Built on top of aiohttp and asyncio. Aioinflux is an alternative to the official InfluxDB Python cl

Gustavo Bezerra 159 Dec 27, 2022
A HugSQL-inspired database library for Python

PugSQL PugSQL is a simple Python interface for using parameterized SQL, in files. See pugsql.org for the documentation. To install: pip install pugsql

Dan McKinley 558 Dec 24, 2022
Find graph motifs using intuitive notation

d o t m o t i f Find graph motifs using intuitive notation DotMotif is a library that identifies subgraphs or motifs in a large graph. It looks like t

APL BRAIN 45 Jan 02, 2023
MySQL database connector for Python (with Python 3 support)

mysqlclient This project is a fork of MySQLdb1. This project adds Python 3 support and fixed many bugs. PyPI: https://pypi.org/project/mysqlclient/ Gi

PyMySQL 2.2k Dec 25, 2022
MongoX is an async python ODM for MongoDB which is built on top Motor and Pydantic.

MongoX MongoX is an async python ODM (Object Document Mapper) for MongoDB which is built on top Motor and Pydantic. The main features include: Fully t

Amin Alaee 112 Dec 04, 2022
pandas-gbq is a package providing an interface to the Google BigQuery API from pandas

pandas-gbq pandas-gbq is a package providing an interface to the Google BigQuery API from pandas Installation Install latest release version via conda

Google APIs 348 Jan 03, 2023
aiomysql is a library for accessing a MySQL database from the asyncio

aiomysql aiomysql is a "driver" for accessing a MySQL database from the asyncio (PEP-3156/tulip) framework. It depends on and reuses most parts of PyM

aio-libs 1.5k Jan 03, 2023
Import entity definition document into SQLie3. Manage the entity. Also, create a "Create Table SQL file".

EntityDocumentMaker Version 1.00 After importing the entity definition (Excel file), store the data in sqlite3. エンティティ定義(Excelファイル)をインポートした後、データをsqlit

G-jon FujiYama 1 Jan 09, 2022
A simple python package that perform SQL Server Source Control and Auto Deployment.

deploydb Deploy your database objects automatically when the git branch is updated. Production-ready! ⚙️ Easy-to-use 🔨 Customizable 🔧 Installation I

Mert Güvençli 10 Dec 07, 2022
Script em python para carregar os arquivos de cnpj dos dados públicos da Receita Federal em MYSQL.

cnpj-mysql Script em python para carregar os arquivos de cnpj dos dados públicos da Receita Federal em MYSQL. Dados públicos de cnpj no site da Receit

17 Dec 25, 2022
aiosql - Simple SQL in Python

aiosql - Simple SQL in Python SQL is code. Write it, version control it, comment it, and run it using files. Writing your SQL code in Python programs

Will Vaughn 1.1k Jan 08, 2023
Pure-python PostgreSQL driver

pg-purepy pg-purepy is a pure-Python PostgreSQL wrapper based on the anyio library. A lot of this library was inspired by the pg8000 library. Credits

Lura Skye 11 May 23, 2022
MongoDB data stream pipeline tools by YouGov (adopted from MongoDB)

mongo-connector The mongo-connector project originated as a MongoDB mongo-labs project and is now community-maintained under the custody of YouGov, Pl

YouGov 1.9k Jan 04, 2023