Skip to content

Mathesar 0.1.3 (alpha release)

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

  • Add superuser creation page (#3088)
  • Create superuser page’s stylings (#3131)
  • Remove the documented steps for creating a superuser from the command line (#3134)

Sharing tables and explorations

  • Shareable links backend - Models, APIs, bypass auth for table requests (#3092)
  • Shareable links frontend - shared table consumer view (#3093)
  • Shared queries - Auth handling for query requests, frontend consumer view, API tests (#3113)
  • UI for creating & managing shares for tables and explorations (#3127)
  • Shares - regenerate link, general fixes (#3133)

Internationalization

  • Install typesafe-i18n & translates one component (#3099)
  • RichText component (#3100)
  • Django templates translatable (#3101)

RSQLA1: Move DDL Operations to SQL functions

  • Sql test setup (#2903)
  • Add SQL for column adding (#2923)
  • Move constraint creation to SQL (#2952)
  • Cleaner consolidated logic for adding constraints (#2976)
  • Column creation and duplication DDL 2 (#2978)
  • SQL for links creation (#2986)
  • Table create ddl (#3016)
  • Add DDL functions for altering columns (#3097)
  • SQL tests for schema ddl (#3098)
  • Remove pglast, use SQL function instead (#3107)
  • Move table splitting logic to SQL (#3119)
  • Tests for links & constraints ddl (#3120)
  • Properly detect identity columns (#3125)
  • Wiring sql functions for links and tables (#3130)
  • Tests for alter table (#3139)
  • Add constraint copying to column extraction logic (#3168)

Summarization improvements

  • Fix SQL Syntax error while summarizing Money, URI, Email column (#2911)
  • Add Sum aggregation function (#2893)
  • Add max aggregation function (#2912)
  • Add min aggregation function (#2914)
  • Add mean aggregation function (#2916)
  • Add median aggregation function (#2932)
  • Add Mode aggregation function (#2940)
  • Add Percentage True aggregation function (#2945)
  • Add Peak Time aggregation function. (#2981)
  • Add Peak Day of Week aggregation function. (#3004)
  • Add Peak Month aggregation function. (#3006)
  • Fix NaN:NaN error while aggregating duration column (#3136)

JSON and Excel file improvements

  • Updated datafile model to store file type (#2890)
  • Added methods to import a perfect JSON (#2906)
  • Removed code duplication while importing datafiles (#2926)
  • Added tests to check importing json feature (#2933)
  • Added pandas and JSON normalization code (#2968)
  • Added api tests for importing JSON feature (#2977)
  • Added documentation for importing data into tables (#2992)
  • Extended import via copy-paste for JSON and updated UI (#3008)
  • Updated documentation navigation to show importing data doc (#3023)
  • Added max_level param for JSON import feature in the backend (#3039)
  • Added functionality to import perfect Excel (#3059)

Fixes for user-reported issues

  • Help text: “its linked tables” (possessive adjective) (#3086)

DX improvements

  • Remove .env from developer guide. (#2925)
  • Add SQL files to the pytest workflow (#3082)
  • New linting rule (#3116)
  • Repeat failed tests (#3118)
  • Add pldebugger to dev db (#3126)

Backend fixes and improvements

  • Fix migrations (#2899)
  • Remove lazydict dependency (#2993)
  • Add API tests for multi-column primary key constraints (#3025)
  • Support unknown types (backend) (#3040)
  • Allow usage of local.py for untracked settings (#3064)
  • Fix the error when list aggregation on mathesar custom array (#3106)
  • Merge db list demo mode commits into release 0.1.3 (#3171)

Frontend fixes and improvements

  • Schema updates in database page without reloading. Fixes #2736 (#2745)
  • Make columns re-orderable (#2831)
  • Fix caret out of view when using Input on Chrome (#2836)
  • Improve TSV serialization when copying cells (#2867)
  • Add max_split=1 to retrieve the column name (#2956)
  • Fix default value input stealing focus (#2957)
  • Auto-focus input when editing number/money cells (#2975)
  • Updated frontend to send a single bulk delete request instead of one request for each record (#2985)
  • Added margin between breadcrumb selector and bottom of the veiwport (#3014)
  • Date Input closes now on tab (#3038)
  • Scroll sheet all the way down when clicking the New Record button (#3045)
  • Use Truncate component in Record Selector table cells (#3077)
  • Copy formatted cell values to clipboard instead of raw values (#3094)
  • Fix regression: Move UserProfile to the App level context from Route level context (#3175)

Documentation

  • Update README.md with troubleshooting instructions (#2751)
  • Update documentation styles for active and hover (#2937)
  • Added the command that generates the API documentation schema file to… (#2970)
  • Added the command to copy the .env file, to the DEVELOPER GUIDE (#2972)
  • Update demo’s documentation (#2996)
  • Fix typo error in DEVELOPER_GUIDE.md (#2999)
  • Update build from source documentation (#3029)
  • Clean up import docs (#3042)

API documentation

  • Integrated drf-spectacular library (#2939)
  • Improved the operationIds by implementing a post hook function (#3021)
  • Added OpenAPI spec for datafiles endpoint (#3044)
  • Added OpenAPI specification for databases endpoint (#3047)
  • Added OpenAPI specification for /schemas/ endpoint (#3074)

Full Changelog