mathesar

Web application providing an intuitive user experience to databases.

GPL-3.0 License

Stars
2.2K
Committers
113
View Code on GitHub Visit Website View on X
Ecosystems: JavaScript, Python, Svelte, PostgreSQL, TypeScript, Django

Bot releases are hidden (Show)

mathesar - Version 0.1.5 (alpha release)

Published by seancolsen 8 months ago

Release notes

mathesar - Version 0.1.4 (alpha release)

Published by seancolsen 9 months ago

Release notes

mathesar - Version 0.1.3 (alpha release)

Published by mathemancer about 1 year ago

This release:

  • makes improvements to the installation process,
  • adds support for sharing tables and explorations publicly,
  • begins a framework for internationalization and translation of UI elements,
  • moves DDL (SQL) logic to DB-layer functions to increase performance and reduce complexity,
  • Improves summarization behavior in the data explorer,
  • Adds support for importing JSON and Excel files,
  • fixes user-reported issues,
  • improves developer experience,
  • fixes numerous small backend issues,
  • fixes numerous small frontend issues,
  • improves the user documentation, and
  • improves the API documentation.

What's Changed

Installation improvements

Sharing tables and explorations

i18n

RSQLA1: Move DDL Operations to SQL functions

Summarization improvements

JSON and Excel file improvements

Fixes for user-reported issues

DX improvements

Backend fixes and improvements

Frontend fixes and improvements

Documentation

API documentation

Other improvements

New Contributors

Full Changelog: https://github.com/centerofci/mathesar/compare/0.1.2...0.1.3

mathesar - Version 0.1.2 (alpha release)

Published by silentninja over 1 year ago

This release focuses on documenting additional options for installing Mathesar, some improvements to the user experience, and some bug fixes. We've also added support for switching between multiple databases in the UI.

Improvements to the UI

  • Mathesar now supports switching between multiple databases using the UI. #2847
  • You can now copy data from the Mathesar UI to paste into other applications. #2773
  • The first non-primary key column is now highlighted when a new record is created. #2515
  • Form inputs are disabled when the form is being submitted. #2762
  • Action pane sidebars are now resizable. #2808
  • Table deletion now requires you to enter the table's name (to prevent accidental deletion). #2858
  • Long table names are now truncated and the full name is shown on hover. #2825
  • We've disabled setting columns to JSON List and Map types using the UI until we have a better editing experience for cells of those types. #2772
  • Filter conditions can now be added and removed via the column header menu #2782
  • Cell level context menus now also show menu items related to the row and column. #2803

Improvements to installation

  • We have documented additional installation options for Mathesar. Visit the Mathesar docs site to explore these options. #2809, #2826, #2824
  • A reference for Mathesar configuration options has been added to our documentation. #2824
  • We have documented connecting to databases running on localhost outside of Docker. #2819
  • The Mathesar Docker image is now standalone and can be started using the docker run command. #2848
  • Superuser and database passwords are now validated when using the guided install script. #2625

Bug fixes

  • Mathesar no longer crashes when importing tables with long column names. #2725
  • Static default values can no longer be assigned to a dynamic default column. #2780
  • Column names no longer overlap when the browser window is resized. #2856
  • Databases removed from the configuration environment file won't show up in the UI anymore. #2891
  • Fixed inconsistencies with the foreign key column icon. #2768

API changes

  • The URL for the database page has been moved from /<db_name>/ to /db/<db_name>/ to avoid conflicts with other Mathesar URLs. #2791

Housekeeping

  • A "sponsors" section has been added to the README. #2710

Recent new contributors

Full Changelog: https://github.com/centerofci/mathesar/compare/0.1.1...0.1.2

mathesar - Version 0.1.1 (alpha release)

Published by pavish over 1 year ago

This is a minor release focused on addressing bugs and improving user experience.

Bug fixes

  • The UI now supports non-ASCII characters in column names and column settings.
  • The record page works when the primary key is not an integer.
  • Mathesar can now support primary keys that are UUIDs.
  • Access level permissions presented on the UI are now consistent with the API access levels.
  • Deleting newly created records immediately no longer results in getting stuck in a loading screen.
  • Empty columns are now inferred as text instead of boolean during import.
  • The UI now displays an appropriate failure message when failing to delete rows.
  • Mathesar no longer crashes when attempting to order rows by non-orderable columns.
  • Row selection gets cleared correctly when a placeholder cell is selected.

Improvements

  • The UI cancels edits when users press the Esc key in table cells.
  • Group headers with record summaries now have links to allow users to navigate to the associated record.
  • Dropdown positioning is improved across the app, so that they do not overflow the browser window.
  • A bunch of smaller visual and UX improvements made by our Google Summer of Code (GSoC) applicants.

Recent new contributors

Full Changelog: https://github.com/centerofci/mathesar/compare/0.1.0...0.1.1

mathesar - Version 0.1.0 (alpha release)

Published by mathemancer over 1 year ago

Mathesar's first alpha release! 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.
  • Basic documentation: Users can install Mathesar using Docker Compose, and tricky product features are documented.

Recent new contributors

Full Changelog: https://github.com/centerofci/mathesar/commits/0.1.0

Related Projects
al-sql

Abstraction_Layer-Sql is a sql abstraction layer that can be used for every sql database to perfo...

03 Dec 2021 36
chartdb

Free and open-source database diagrams editor, visualize and design your DB with a single query.

05 Aug 2024 3,249
querybook

Querybook is a Big Data Querying UI, combining collocated table metadata and a simple notebook in...

05 Mar 2020 1,718
apitable

πŸš€πŸŽ‰πŸ“š APITable, an API-oriented low-code platform for building collaborative apps and better than a...

17 Aug 2022 12,993