NocoDB
No-code platform that creates and manages databases with spreadsheet UI.
Alternative to: Airtable, Google Sheets, Microsoft Lists, Coda, Smartsheet, Microsoft PowerApps, Monday.com
v0.257.0
2024-10-09π NocoDB : Feature Release
π₯ π₯ π₯ π₯
Weβre excited to announce several powerful new features in this release, designed to enhance your data management experience with NocoDB!
π Demo Video : https://youtu.be/QbYnyITi1hE
ποΈπ True Data Reflection π
A Revolutionary No-Code Data Architecture
True Data Reflection introduces a breakthrough in no-code data management, enhancing your enterpriseβs data agility. With this feature, what you see in NocoDBβs UI is exactly whatβs stored in your Postgres databaseβno middle layers, no discrepancies. Every NocoDB base now directly translates into a Postgres schema, keeping tables and columns perfectly aligned.
Why True Data Reflection?
In earlier versions, all bases in self-hosted NocoDB lived within the βpublicβ schema, which wasnβt ideal for seamless integration with BI tools or internal systems. This new feature fixes that by giving each base its own dedicated schema in PostgreSQL, simplifying system architecture and enabling transparent SQL access.
Key Benefits:
- π Unified Connectivity: Connect directly with tools like Metabase, Tableau, Retool, and more.
- β© Instant Data Replication: Sync data effortlessly across systems and scale efficiently using PostgreSQL.
- ποΈ Full Transparency: View and manage your data in real time, right from your database.
πβοΈ Conditional Fields in Form View π
Create dynamic forms with ease using the new Conditional Fields feature! Now, you can display or hide form fields based on user inputs, creating a more personalized and efficient data entry experience.
π° π’ Product Feed π
Stay up-to-date with all things NocoDB! The new Whatβs New button on the dashboard gives you easy access to:
- :octocat: The latest GitHub releases
- :arrow_forward: YouTube tutorials
- π¦ Recent updates on Twitter
Now, you can keep track of all new developments in one place!
We hope these updates make a big impact on your workflow. Try them out, and let us know how theyβre helping you in the comments. Happy building with NocoDB!
Team NocoDB
π Closed Issues
- [π Type: Bug] π Bug: Updating a record with slash (/) in the primary key throws βCannot PATCHβ error #9615
- [π Type: Bug] π Bug: Field βShow On Conditionsβ missing #9602
- [π Type: Bug] π Bug: skip confirmation modal for duplicate view #9576
- [π¦ Type: Feature][π For : Community or Good First Issue][π For : Hacktoberfest] π¦ Feature: column filter I18n #9574
- [π Type: Bug][π For : Community or Good First Issue][π For : Hacktoberfest] π Bug: βRedirect to URLβ setting does not work in a Form View #9571
- [π Type: Bug] π Bug: Fields when added from multi field editor on grid are also added to form #9559
- [π Type: Bug] π Bug: noco.sh generates invalid docker-compose.yml file #9533
- [π Type: Bug] π Bug: Field in Table disappeared #9524
- [π Type: Bug] π Bug: Audit log not visible for MySQL connection #9521
- [π Type: Bug] π Bug: Prevent keyboard shortcuts if user is in cell edit mode (keyboard shortcut collision with special characters). #9512
- [π Type: Bug] π Bug: nocodb form browser tabs redirect after opening nocodb in a second tab #9501
- [π Type: Bug][Status: Reproducible] π Bug: Decimal column type does not respect βpreciscionβ setting from GUI #9461
- [π Type: Bug] π Bug: REST APIs display pageSize: 10 if limit<10 #9451
- [π Type: Bug] π Bug: migration that generates thumbnails fails with external storage providers #9450
- [π Type: Bug] π Bug: Unable to resolve pg container name in coolify #9449
- [π Type: Bug] π Bug: external mysql database the sum withing grouping stops being counted #9446
- [π Type: Bug] π Bug: API does not adhere to βlimitβ parameter if βlimitβ of results per page is less than 10. #9445
- [π Type: Bug] π Bug: Missing default value for βsumβ rollup #9437
- [π Type: Bug] π Bug: Empty required field in forms #9429
- [π Type: Bug] π Bug: In GUI Number Numeric column shows up with the wrong type indicator icon #9423
- [closed] β #9410
- [π Type: Bug] π Bug: Invalid date on postgresql DB βdateβ field #9409
- [π¦ Type: Feature] π¦ Feature: Create records in bulk #9407
- [π Type: Bug] π Bug: Webhook on condition for user field with operator βContains all ofβ has an issue #9398
- [π Type: Bug] Build Commands: Potential Issue with Script Execution #9394
- [π Type: Bug] π Bug: docker compose version deprecated in github and docs examples #9392
- [π Type: Bug] canβt reset password #9389
- [π Type: Bug] π Bug: No Super-Admin available #9386
- [π¦ Type: Feature] π¦ Feature: (airtable feature) keyboard shortcut for todayβs date #9372
- [closed] how to query pg with sslmode=require #9371
- [π¦ Type: Feature] π¦ Feature: Support For Other DBMSs #9344
- [π Type: Bug] π Bug: Postgres test connection succeed even though no database exist #9257
- [π Type: Bug] π Bug: Unable to add TLS-encrypted external data source (PostgreSQL) in NocoDB v0.251.3+ #9098
- [π¦ Type: Feature] π¦ Feature: when creating views, having the hability to always see column headers when scrolling vertically #9018
- [closed] π Bug: Docker-Upgrade to 0.251.1 causes trouble again #8922
- [π For : Community or Good First Issue] π Bug: Installation using windows executable and postgres-db does not work #8350
- [closed] π¦ Feature: Improve object storage provider configuration #7903
- [closed] π Bug: Some of Auth APIs missing in v2 documentation #7730
- [π¦ Type: Feature] π¦ Feature: Form View fields based on conditional logic #4404
Whatβs Changed
- Release 0.255.2 by @github-actions in https://github.com/nocodb/nocodb/pull/9382
- chore: post-release sync by @github-actions in https://github.com/nocodb/nocodb/pull/9383
- fix: password encoding by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9380
- Nc fix(nc-gui): rename light theme colors shortcuts by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9377
- docs: improve french doc by @omahs in https://github.com/nocodb/nocodb/pull/9390
- chore: update KnexClient.ts by @eltociear in https://github.com/nocodb/nocodb/pull/9388
- fix: add some docs to calendar code by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9395
- Docs/fixes portuguese typos by @GabrielModog in https://github.com/nocodb/nocodb/pull/9370
- fix: add additional docs to calendar code by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9396
- Add one click deploy on sealos by @fanux in https://github.com/nocodb/nocodb/pull/7925
- Full install by @starbirdtech383 in https://github.com/nocodb/nocodb/pull/7587
- Update 030.rollup.md by @hasanradi93 in https://github.com/nocodb/nocodb/pull/9359
- fix: Refactor error handling within password reset by @o1lab in https://github.com/nocodb/nocodb/pull/9397
- chore(deps-dev): bump webpack from 5.76.0 to 5.94.0 by @dependabot in https://github.com/nocodb/nocodb/pull/9384
- chore(deps): bump webpack from 5.90.3 to 5.94.0 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/9399
- New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/9366
- Nc chore/docs link corrections by @dstala in https://github.com/nocodb/nocodb/pull/9411
- chore: Missing dependency in GUI by @pranavxc in https://github.com/nocodb/nocodb/pull/9413
- Nc revamp/csv import extension by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9351
- Nc fix: showing wrong date joined time from now in project members tab & for editor and below role it showing current date as date joined by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9419
- fix: form submission email attachments by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9421
- New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/9420
- fix: Clear store values only after redirecting to SignIn page by @pranavxc in https://github.com/nocodb/nocodb/pull/9412
- fix: user fields filters not working in webhook by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9422
- chore: updated installation docs by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9424
- fix: Refresh-token based token generation issues by @pranavxc in https://github.com/nocodb/nocodb/pull/9415
- fix: Missing id param in i18n language file by @pranavxc in https://github.com/nocodb/nocodb/pull/9428
- fix: update auto-upstall url by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9430
- update : refactor auto-upstall and installation methods by @o1lab in https://github.com/nocodb/nocodb/pull/9432
- feat: add today shortcut for Date related fields by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9425
- New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/9426
- fix: default options overriding ssl config by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9435
- fix: Handle date object as value and avoid treating it as nested condition by @pranavxc in https://github.com/nocodb/nocodb/pull/9441
- Auto upstall docs by @o1lab in https://github.com/nocodb/nocodb/pull/9448
- Nc fix/miscellaneous by @pranavxc in https://github.com/nocodb/nocodb/pull/9447
- New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/9443
- issue#9417 fix text to numerical type conversion ignores negatives by @sioutisc in https://github.com/nocodb/nocodb/pull/9418
- refactor: nocoExecute by @pranavxc in https://github.com/nocodb/nocodb/pull/9456
- feat: integrations follow-up migration by @mertmit in https://github.com/nocodb/nocodb/pull/9455
- refactor: Event related modules by @pranavxc in https://github.com/nocodb/nocodb/pull/9459
- fix: aggregation queries by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9457
- fix: Proper column meta null value handling by @pranavxc in https://github.com/nocodb/nocodb/pull/9452
- refactor: Pagination limit min value restriction by @pranavxc in https://github.com/nocodb/nocodb/pull/9458
- fix(nc-gui): show decimal cell value with trailing zeros by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9464
- fix: aggregation not working in mariadb by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9462
- Nc docs/v2 meta api reorg by @dstala in https://github.com/nocodb/nocodb/pull/9468
- New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/9466
- fix: handle missing col options for button by @mertmit in https://github.com/nocodb/nocodb/pull/9469
- fix: Post update extract new id since composite key can be changed in update by @pranavxc in https://github.com/nocodb/nocodb/pull/9453
- fix: add default value for rollup by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9467
- fix: swagger UI blank page by @mertmit in https://github.com/nocodb/nocodb/pull/9475
- Nc feat/missing api v2 by @pranavxc in https://github.com/nocodb/nocodb/pull/9454
- Nc fix/email template by @dstala in https://github.com/nocodb/nocodb/pull/9477
- docs: meta api v2 label and order by @dstala in https://github.com/nocodb/nocodb/pull/9476
- refactor: Sanitise method by @pranavxc in https://github.com/nocodb/nocodb/pull/9486
- docs: meta apis for base by @dstala in https://github.com/nocodb/nocodb/pull/9485
- fix: Disable form view creation only for data readonly source by @pranavxc in https://github.com/nocodb/nocodb/pull/9487
- feat: Implement scanFiles for gcs and Minio by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9463
- docs: embed Tutorial Videos in documentation by @LisaVCherian in https://github.com/nocodb/nocodb/pull/9460
- fix: Apply view based filter if linkColumnId present in list api by @pranavxc in https://github.com/nocodb/nocodb/pull/9500
- Nc feat: form view conditional fields by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9433
- docs: meta v2 fields description by @dstala in https://github.com/nocodb/nocodb/pull/9502
- fix: barcode on formula by @mertmit in https://github.com/nocodb/nocodb/pull/9493
- fix: Query cache on source update by @mertmit in https://github.com/nocodb/nocodb/pull/9506
- fix: handle type diff while comparing pks by @mertmit in https://github.com/nocodb/nocodb/pull/9494
- docs: view & webhook APIs by @dstala in https://github.com/nocodb/nocodb/pull/9508
- feat: restrict concurrent operations by @mertmit in https://github.com/nocodb/nocodb/pull/9509
- feat: single query command palette & dedicated cache by @mertmit in https://github.com/nocodb/nocodb/pull/9522
- Fix $(pwd) invocation in readme example by @NickCrews in https://github.com/nocodb/nocodb/pull/9519
- fix: at import stall issue by @mertmit in https://github.com/nocodb/nocodb/pull/9517
- fix: cmdk issue by @mertmit in https://github.com/nocodb/nocodb/pull/9529
- fix(nc-gui): show mfe save changes field error by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9535
- fix: skip trimming options while applying filter by @pranavxc in https://github.com/nocodb/nocodb/pull/9542
- Nc fix/9501 redirection issue by @pranavxc in https://github.com/nocodb/nocodb/pull/9540
- Nc fix/dev warnings by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9541
- Nc docs/meta apis cleanup 2 by @pranavxc in https://github.com/nocodb/nocodb/pull/9544
- Nc refactor/api token by @dstala in https://github.com/nocodb/nocodb/pull/9526
- fix: compose configuration generation by @sinanmohd in https://github.com/nocodb/nocodb/pull/9536
- feat: Decide base creation behaviour on app load based on permission by @pranavxc in https://github.com/nocodb/nocodb/pull/9530
- Nc fix/swagger base pw by @dstala in https://github.com/nocodb/nocodb/pull/9543
- chore[charts/nocodb/values.yaml]: Typo
https:/->https://. by @VergeDX in https://github.com/nocodb/nocodb/pull/9534 - Nc fix(nc-gui): grid column resize error by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9557
- Nc fix(nc-gui): MFE show newly added column in same view and hide it in other views by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9561
- [docs] Fix docker compose setup path by @nathanbegbie in https://github.com/nocodb/nocodb/pull/9566
- fix: optimizations to potential blockers by @mertmit in https://github.com/nocodb/nocodb/pull/9555
- feat: add sqlite support in the upstall script by @sinanmohd in https://github.com/nocodb/nocodb/pull/9537
- fix: cmdk improvements by @mertmit in https://github.com/nocodb/nocodb/pull/9575
- Nc fix/duplicate name update by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9573
- Nc product feed by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9323
- Adjusted path for 2_pg folder in 030.docker-compose.md by @ymilhahn in https://github.com/nocodb/nocodb/pull/9465
- fix: product feed fixes by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9579
- Nc fix font weight safari by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9584
- Nc fix: add tab key to query params by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9585
- chore: Skip type checking of declaration files of dependencies by @pranavxc in https://github.com/nocodb/nocodb/pull/9516
- ColumnFilter ToolBar Correctly Show I18n string and LanguageAlias for zh_Hans by @armgong in https://github.com/nocodb/nocodb/pull/9580
- fix: events by @DarkPhoenix2704 in https://github.com/nocodb/nocodb/pull/9588
- feat: Postgres base as schema by @pranavxc in https://github.com/nocodb/nocodb/pull/9591
- Nc fix: skip confirmation modal for duplicate view by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9586
- Nc refactor/remove default datasource config encryption by @pranavxc in https://github.com/nocodb/nocodb/pull/9499
- Nc fix/add to fav bug by @pranavxc in https://github.com/nocodb/nocodb/pull/9592
- Nc fix/add to fav bug followup by @pranavxc in https://github.com/nocodb/nocodb/pull/9599
- refactor: nc-secret-mgr cli followup by @pranavxc in https://github.com/nocodb/nocodb/pull/9594
- fix(nc-gui): Prevent keyboard shortcuts if user is in cell edit mode or any other active input element by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9600
- refactor: GUI error handling by @pranavxc in https://github.com/nocodb/nocodb/pull/9528
- refactor: Change Postgres as schema environment key by @pranavxc in https://github.com/nocodb/nocodb/pull/9601
- fix: Integration encryption bug by @pranavxc in https://github.com/nocodb/nocodb/pull/9607
- refactor: Add logs for encryption - upgrader and init logic by @pranavxc in https://github.com/nocodb/nocodb/pull/9608
- fix: Integration encryption - handle stringified config value by @pranavxc in https://github.com/nocodb/nocodb/pull/9610
- fix(docs): broken fenced code blocks and indentation by @wingkwong in https://github.com/nocodb/nocodb/pull/9604
- Nc feat/enable conditional field in oss by @dstala in https://github.com/nocodb/nocodb/pull/9609
- Nc fix(nc-gui): form redirect url issue by @rameshmane7218 in https://github.com/nocodb/nocodb/pull/9612
- chore: add AI mention to translations by @mertmit in https://github.com/nocodb/nocodb/pull/9614
- New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/9480
- fix: encode primary key before sending PATCH request by @nakul251197 in https://github.com/nocodb/nocodb/pull/9616
- fix: Encode id to handle special chars by @pranavxc in https://github.com/nocodb/nocodb/pull/9618
- 0.256.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/9619
- Release 0.256.0 by @github-actions in https://github.com/nocodb/nocodb/pull/9620
- fix: avoid treating feed as shared view by @mertmit in https://github.com/nocodb/nocodb/pull/9622
- chore: post-release sync by @github-actions in https://github.com/nocodb/nocodb/pull/9621
- 0.257.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/9624
New Contributors
- @omahs made their first contribution in https://github.com/nocodb/nocodb/pull/9390
- @GabrielModog made their first contribution in https://github.com/nocodb/nocodb/pull/9370
- @fanux made their first contribution in https://github.com/nocodb/nocodb/pull/7925
- @hasanradi93 made their first contribution in https://github.com/nocodb/nocodb/pull/9359
- @sioutisc made their first contribution in https://github.com/nocodb/nocodb/pull/9418
- @NickCrews made their first contribution in https://github.com/nocodb/nocodb/pull/9519
- @sinanmohd made their first contribution in https://github.com/nocodb/nocodb/pull/9536
- @nathanbegbie made their first contribution in https://github.com/nocodb/nocodb/pull/9566
- @ymilhahn made their first contribution in https://github.com/nocodb/nocodb/pull/9465
- @armgong made their first contribution in https://github.com/nocodb/nocodb/pull/9580
- @nakul251197 made their first contribution in https://github.com/nocodb/nocodb/pull/9616
Full Changelog: https://github.com/nocodb/nocodb/compare/0.255.2β¦0.257.0