🚀 NocoDB Feature Pre-Release : Snowflake Support, BarCode Column & Emojis 🚀

🥬 What's new .. What's fresh ?

Snowflake Database support (Enterprise Feature - Early Preview)

This is an enterprise-only feature available for preview freely. You can add a nocodb enterprise key in the UI to get started (any value at the moment will do). And you should be able to unlock all the productivity features of a nocodb spreadsheet on your own Snowflake database.

Barcode Column

A barcode column type is out! This new feature allows users to quickly scan and input barcode information in various supported formats including CODE128, EAN, EAN-13, EAN-8, EAN-5, EAN-2, UPC (A), CODE39, ITF-14, MSI, Pharmacode, Codabar. This new column type is compatible with the following valid column types, namely Number, SingleLineText, LongText, PhoneNumber, URL, Email, and Decimal.

We are thrilled to enable our customers with this new feature, which will help simplify the process of capturing, validating, and saving barcode information. With this innovative new feature, users can save time and reduce errors when entering barcode data.

We hope our customers enjoy the new barcode column type, and we look forward to continuing to bring our customers the latest innovations.

Reconfigurable table & view icons

Move over boring standalone static icons for tables & views. Add more colours, differentiate visually by opting out for separate icon for each table/view

Add Data Source from within the project

We have now moved the option to add an existing database from within the project. No longer you have to do it from while creating the project. This change allows us to add multi data sources in the future (its available behind an easter egg at the moment ;)

🕐 Now, its demo time

Snowflake

https://user-images.githubusercontent.com/5435402/209937139-d00c6ff4-7061-43f2-936e-e5092c9f8f8d.mov

Barcode Column

https://user-images.githubusercontent.com/35857179/209751834-3e8eddfa-083d-448f-9a16-fcb74727cd3e.mp4

Multidata source

https://user-images.githubusercontent.com/5435402/209937133-3c1421de-33ff-4b5a-a832-1d75ef25cc5c.mov

🐛 Closed Issues

• [🟠 Priority: High] 🐛 Bug: NC_INVITE_ONLY_SIGNUP env is not working with 0.100.2 #4708
• [closed] 🐛 Bug: nocodb\packages\nocodb\node_modules\sqlite3\lib\binding\napi-v6-win32-unknown-x64\node_sqlite3.node is not a valid Win32 application #4695
• [🔦 Type: Feature] 🔦 Feature: sql query and sql import #4689
• [🔦 Type: Feature] 🔦 Feature: More information on LinkToAnotherRecord Hover #4677
• [closed] Suggestion: Add bounties? #4652
• [closed] Enhancement: Retain search items on tab switch #4636
• [closed] 🐛 Bug: Error comes whenever monaco editor is opened #4619
• [closed] 🐛 Bug: Setting primary value removes existing relations #4606
• [🐛 Type: Bug][🎰 Scope : Hosting] 🐛 Bug: 1-click deploy to heroku is broken #4602
• [closed] Upload csv for existing data not working, #4600
• [🐛 Type: Bug][🚀 Status: Ready for Next Release][🟠 Priority: High] 🐛 Bug: Not able to type in expanded form if trying to add record from LTAR list #4575
• [🚀 Status: Ready for Next Release] 🔦 Feature: change the error prompt for forgot password #4570
• [closed] 🐛 Bug: On going issues in develop ( >0.99.2 ) #4529
• [closed] Feature : Column options #4523
• [🐛 Type: Bug][🚀 Status: Ready for Next Release] 🐛 Bug: Feeding any character when date cell in-focus, clears cell contents #4493
• [🟠 Priority: High][🏗️ Type: In Development] 🐛 Bug: Tab switch in a certain usecases is leading to block of UI #4402
• [closed] 🐛 Bug: Windows Binary #4394
• [🏗️ Type: In Development] [feat/multiple-source] Failed to open project #4355
• [closed] 🐛 Bug: cell data disappears after page refresh #4329
• [closed] 🐛 Bug: Socket hang up when importing from Airtable #4326
• [🐛 Type: Bug] 🐛 Bug: AT import fails if other tables present in project #4230
• [🐛 Type: Bug] 🐛 Bug: TOKEN API can be use in all Project #4163
• [🐛 Type: Bug][🔎 Status: More Info Needed] Import currency field #3788
• [🔦 Type: Feature] Column type : QR Code #3581
• [🔎 Status: More Info Needed] npm start on dashboard showing 404 Not Found #3047
• [🔦 Type: Feature][🔭 Scope : Project] Pressing the "here"-button in the "For production please see here." message does nothing #2823
• [🏗️ Type: In Development] Select v2: error on reconfiguring dbType to varchar #2765
• [🔎 Status: More Info Needed] PostgreSQL specific type "inet" looks as empty string on NocoDB #2556
• [🔎 Status: More Info Needed] Suspected Memory Leak #2510
• [🔎 Status: More Info Needed] "The "config.option.port" property must be of type number" and other issues #2305
• [✨ Type: Enhancement][🔦 Type: Feature][🔭 Scope : Project] New user pain points related to SQLite and improper error messages #749

What's Changed

• Release 0.100.2 by @github-actions in https://github.com/nocodb/nocodb/pull/4578
• fix(nc-gui): type issues by @wingkwong in https://github.com/nocodb/nocodb/pull/4574
• feat: allow project to connect to multiple data sources by @mertmit in https://github.com/nocodb/nocodb/pull/3573
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4596
• QrCode: also allow decimals and numbers as referenced values by @spaudanjo in https://github.com/nocodb/nocodb/pull/4585
• fix(nocodb): provide header in XLSX.utils.json_to_sheet by @wingkwong in https://github.com/nocodb/nocodb/pull/4581
• fix(nc-gui): retrieve the correct column name based on the formula by @wingkwong in https://github.com/nocodb/nocodb/pull/4598
• fix(nocodb-sdk): include node.value for literal case by @wingkwong in https://github.com/nocodb/nocodb/pull/4599
• Copy paste cell more tests added by @mustafapc19 in https://github.com/nocodb/nocodb/pull/4552
• chore: previews for every PR release using Uffizzi by @waveywaves in https://github.com/nocodb/nocodb/pull/4460
• fix: add useNullAsDefault flag for sqlite on root level by @mertmit in https://github.com/nocodb/nocodb/pull/4609
• Add other DBs to uffizzi preview by @waveywaves in https://github.com/nocodb/nocodb/pull/4605
• fix(nc-gui): parse string date if date is not null by @wingkwong in https://github.com/nocodb/nocodb/pull/4611
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4608
• revert mssql and mysql in uffizzi previews by @waveywaves in https://github.com/nocodb/nocodb/pull/4614
• chore(deps): bump qs from 6.10.1 to 6.11.0 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/4620
• fix trivial typos in a README by @williamstein in https://github.com/nocodb/nocodb/pull/4623
• docs: remove heroku info by @wingkwong in https://github.com/nocodb/nocodb/pull/4627
• Fix getColVal in parserHelpers.ts -> col index can be 0 -> so check only that its not undefined by @semmjon in https://github.com/nocodb/nocodb/pull/4631
• chore(deps): bump qs and express in /packages/nc-cli by @dependabot in https://github.com/nocodb/nocodb/pull/4622
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4635
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4637
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4640
• fix: can’t find Id by @willnewii in https://github.com/nocodb/nocodb/pull/4632
• feat: pre-release by @wingkwong in https://github.com/nocodb/nocodb/pull/4601
• fix(nocodb): handle comparing a date with empty string in pg by @wingkwong in https://github.com/nocodb/nocodb/pull/4586
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4646
• Possible fix for API requests with wrong baseId ("undefined"). by @semmjon in https://github.com/nocodb/nocodb/pull/4633
• Update uffizzi compose with other dbs by @waveywaves in https://github.com/nocodb/nocodb/pull/4663
• Update --bug-report.yaml by @altosaar in https://github.com/nocodb/nocodb/pull/4536
• Add condition to uffizzi preview to run only on success of previous workflow by @waveywaves in https://github.com/nocodb/nocodb/pull/4676
• fix save search query by @ketewan in https://github.com/nocodb/nocodb/pull/4654
• fix multiselect by @ketewan in https://github.com/nocodb/nocodb/pull/4656
• feat: formula DATETIME_DIFF by @wingkwong in https://github.com/nocodb/nocodb/pull/4629
• feat(nc-gui): datetime options by @wingkwong in https://github.com/nocodb/nocodb/pull/4593
• refactor(nocodb): move convertAttachmentType to extractRawQueryAndExec by @wingkwong in https://github.com/nocodb/nocodb/pull/4612
• Correct parameter in delete token by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/4681
• feat: Snowflake support by @mertmit in https://github.com/nocodb/nocodb/pull/4645
• fix: search result can’t paging by @willnewii in https://github.com/nocodb/nocodb/pull/4692
• Feat: Custom table icon by @pranavxc in https://github.com/nocodb/nocodb/pull/4630
• fix(nocodb): formula returns empty result when identifier is null by @wingkwong in https://github.com/nocodb/nocodb/pull/4644
• refactor(gui): remove dropdown for create project from project list page by @dstala in https://github.com/nocodb/nocodb/pull/4703
• Barcode by @flisowna in https://github.com/nocodb/nocodb/pull/4641
• fix(gui): GUI - allow attachment upload if user have permission by @pranavxc in https://github.com/nocodb/nocodb/pull/4700
• Miscellaneous bug fixes and enhancements by @pranavxc in https://github.com/nocodb/nocodb/pull/4696
• New Crowdin updates by @o1lab in https://github.com/nocodb/nocodb/pull/4707
• fix: proper error if provided url is not shared base by @mertmit in https://github.com/nocodb/nocodb/pull/4705
• fix get filter by id API by @vijayrathore8492 in https://github.com/nocodb/nocodb/pull/4706
• Fix: GUI Treeview - table icon toggling in multi datasource view by @pranavxc in https://github.com/nocodb/nocodb/pull/4714
• Miscellaneous bug fixes by @pranavxc in https://github.com/nocodb/nocodb/pull/4715
• 0.101.0-beta.0 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/4716

New Contributors

• @waveywaves made their first contribution in https://github.com/nocodb/nocodb/pull/4460
• @williamstein made their first contribution in https://github.com/nocodb/nocodb/pull/4623
• @semmjon made their first contribution in https://github.com/nocodb/nocodb/pull/4631
• @altosaar made their first contribution in https://github.com/nocodb/nocodb/pull/4536
• @flisowna made their first contribution in https://github.com/nocodb/nocodb/pull/4641

Full Changelog: https://github.com/nocodb/nocodb/compare/0.100.2...0.101.0-beta.0

Join Our Team

Thank you for your love & support

💜 🚀