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.

Anomaly detection on SQL data warehouses and databases

With CueObserve, you can run anomaly detection on data in your SQL data warehouses and databases. Getting Started Install via Docker docker run -p 300

Cuebook 171 Dec 18, 2022
A SQL linter and auto-formatter for Humans

The SQL Linter for Humans SQLFluff is a dialect-flexible and configurable SQL linter. Designed with ELT applications in mind, SQLFluff also works with

SQLFluff 5.5k Jan 08, 2023
A pandas-like deferred expression system, with first-class SQL support

Ibis: Python data analysis framework for Hadoop and SQL engines Service Status Documentation Conda packages PyPI Azure Coverage Ibis is a toolbox to b

Ibis Project 2.3k Jan 06, 2023
Redis client for Python asyncio (PEP 3156)

Redis client for Python asyncio. Redis client for the PEP 3156 Python event loop. This Redis library is a completely asynchronous, non-blocking client

Jonathan Slenders 554 Dec 04, 2022
An extension package of 🤗 Datasets that provides support for executing arbitrary SQL queries on HF datasets

datasets_sql A 🤗 Datasets extension package that provides support for executing arbitrary SQL queries on HF datasets. It uses DuckDB as a SQL engine

Mario Šaško 19 Dec 15, 2022
Python DBAPI simplified

Facata A Python library that provides a simplified alternative to DBAPI 2. It provides a facade in front of DBAPI 2 drivers. Table of Contents Install

Tony Locke 44 Nov 17, 2021
Use SQL query in a jupyter notebook!

SQL-query Use SQL query in a jupyter notebook! The table I used can be found on UN Data. Or you can just click the link and download the file undata_s

Chuqin 2 Oct 05, 2022
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.

dbd: database prototyping tool dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL d

Zdenek Svoboda 47 Dec 07, 2022
Implementing basic MongoDB CRUD (Create, Read, Update, Delete) queries, using Python.

MongoDB with Python Implementing basic MongoDB CRUD (Create, Read, Update, Delete) queries, using Python. We can connect to a MongoDB database hosted

MousamSingh 4 Dec 01, 2021
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
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
Create a database, insert data and easily select it with Sqlite

sqliteBasics create a database, insert data and easily select it with Sqlite Watch on YouTube a step by step tutorial explaining this code: https://yo

Mariya 27 Dec 27, 2022
Records is a very simple, but powerful, library for making raw SQL queries to most relational databases.

Records: SQL for Humansâ„¢ Records is a very simple, but powerful, library for making raw SQL queries to most relational databases. Just write SQL. No b

Kenneth Reitz 6.9k Jan 03, 2023
Simplest SQL mapper in Python, probably

SQL MAPPER Basically what it does is: it executes some SQL thru a database connector you fed it, maps it to some model and gives to u. Also it can cre

2 Nov 07, 2022
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

Redash is designed to enable anyone, regardless of the level of technical sophistication, to harness the power of data big and small. SQL users levera

Redash 22.4k Dec 30, 2022
A simple Python tool to transfer data from MySQL to SQLite 3.

MySQL to SQLite3 A simple Python tool to transfer data from MySQL to SQLite 3. This is the long overdue complimentary tool to my SQLite3 to MySQL. It

Klemen Tusar 126 Jan 03, 2023
Logica is a logic programming language that compiles to StandardSQL and runs on Google BigQuery.

Logica: language of Big Data Logica is an open source declarative logic programming language for data manipulation. Logica is a successor to Yedalog,

Evgeny Skvortsov 1.5k Dec 30, 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
Google Cloud Client Library for Python

Google Cloud Python Client Python idiomatic clients for Google Cloud Platform services. Stability levels The development status classifier on PyPI ind

Google APIs 4.1k Jan 01, 2023
Asynchronous, fast, pythonic DynamoDB Client

AsyncIO DynamoDB Asynchronous pythonic DynamoDB client; 2x faster than aiobotocore/boto3/botocore. Quick start With httpx Install this library pip ins

HENNGE 48 Dec 18, 2022