ProductPromotion
Logo

Open.Source

made by https://0x3d.site

GitHub - mathesar-foundation/mathesar: Web application providing an intuitive user experience to databases.
Web application providing an intuitive user experience to databases. - mathesar-foundation/mathesar
Visit Site

GitHub - mathesar-foundation/mathesar: Web application providing an intuitive user experience to databases.

GitHub - mathesar-foundation/mathesar: Web application providing an intuitive user experience to databases.

Mathesar

Mathesar is a straightforward open source tool that provides a spreadsheet-like interface to a PostgreSQL database. Our web-based interface helps you and your collaborators work with data more independently and comfortably – no technical skills needed.

You can use Mathesar to build data models, enter data, and even build reports. You host your own Mathesar installation, which gives you ownership, privacy, and control of your data.

Table of Contents

Sponsors

Our top sponsors! Become a sponsor on GitHub or Open Collective.

Status

  • Public Alpha: You can install and deploy Mathesar on your server. Go easy on us!
  • Public Beta: Stable and feature-rich enough to implement in production
  • Public: Production-ready

We are currently in the public alpha stage.

Join our community!

The Mathesar team is on Matrix (chat service). We also have mailing lists and the core team discusses day-to-day work on our developer mailing list.

Screenshots

crm-table

authors-filter

talks-with-topics

author-record

arxiv-schema

db-page

Live Demo

Check out a live demo of Mathesar here!

Features

  • Built on Postgres: Connect to an existing Postgres database or set one up from scratch.
  • Set up your data models: Easily create and update Postgres schemas and tables.
  • Data entry: Use our spreadsheet-like interface to view, create, update, and delete table records.
  • Filter, sort, and group: Quickly slice your data in different ways.
  • Query builder: Use our Data Explorer to build queries without knowing anything about SQL or joins.
  • Schema migrations: Transfer columns between tables in two clicks.
  • Uses Postgres features: Mathesar uses and manipulates Postgres schemas, primary keys, foreign keys, constraints and data types. e.g. "Links" in the UI are foreign keys in the database.
  • Custom data types: Custom data types for emails and URLs (more coming soon), validated at the database level.
  • Basic access control: Users can have Viewer (read-only), Editor (can only edit data, but not data structure), or Manager (can edit both data and its structure) roles.

Self-hosting

Please see our documentation for instructions on installing Mathesar on your own server.

Our motivation

Mathesar is a non-profit project. Our goal is to make understanding and working with data easy for everyone.

Databases have been around for a long time and solve common data problems really well. But working with databases often requires custom software. Or complex tooling that people struggle to get their heads around.

We want to make existing database functionality more accessible, for users of all technical skill levels.

Contributing

We actively encourage contribution! Get started by reading our Contributor Guide.

Bugs and troubleshooting

If you run into problems, refer to our troubleshooting guide.

License

Mathesar is open source under the GPLv3 license - see LICENSE. It also contains derivatives of third-party open source modules licensed under the MIT license. See the list and respective licenses in THIRDPARTY.

Articles
to learn more about the open-source concepts.

Resources
which are currently available to browse on.

mail [email protected] to add your project or resources here 🔥.

FAQ's
to know more about the topic.

mail [email protected] to add your project or resources here 🔥.

Queries
or most google FAQ's about Open-Source.

mail [email protected] to add more queries here 🔍.

More Sites
to check out once you're finished browsing here.

0x3d
https://www.0x3d.site/
0x3d is designed for aggregating information.
NodeJS
https://nodejs.0x3d.site/
NodeJS Online Directory
Cross Platform
https://cross-platform.0x3d.site/
Cross Platform Online Directory
Open Source
https://open-source.0x3d.site/
Open Source Online Directory
Analytics
https://analytics.0x3d.site/
Analytics Online Directory
JavaScript
https://javascript.0x3d.site/
JavaScript Online Directory
GoLang
https://golang.0x3d.site/
GoLang Online Directory
Python
https://python.0x3d.site/
Python Online Directory
Swift
https://swift.0x3d.site/
Swift Online Directory
Rust
https://rust.0x3d.site/
Rust Online Directory
Scala
https://scala.0x3d.site/
Scala Online Directory
Ruby
https://ruby.0x3d.site/
Ruby Online Directory
Clojure
https://clojure.0x3d.site/
Clojure Online Directory
Elixir
https://elixir.0x3d.site/
Elixir Online Directory
Elm
https://elm.0x3d.site/
Elm Online Directory
Lua
https://lua.0x3d.site/
Lua Online Directory
C Programming
https://c-programming.0x3d.site/
C Programming Online Directory
C++ Programming
https://cpp-programming.0x3d.site/
C++ Programming Online Directory
R Programming
https://r-programming.0x3d.site/
R Programming Online Directory
Perl
https://perl.0x3d.site/
Perl Online Directory
Java
https://java.0x3d.site/
Java Online Directory
Kotlin
https://kotlin.0x3d.site/
Kotlin Online Directory
PHP
https://php.0x3d.site/
PHP Online Directory
React JS
https://react.0x3d.site/
React JS Online Directory
Angular
https://angular.0x3d.site/
Angular JS Online Directory