🚀 Highlights

Share the form view

• [bug] Detail view: monaco editor is missing #617
• [closed] New tables created in public schema (Postgres) #615
• [closed] Question. Can I see id(primary key) in the view? #609
• [Feature] [Feature request] Form view - shared view, move to an URL, email #608
• [bug][community][hacktoberfest] Using NODE_ENV variable leads to issues #588
• [enhancement] Improvement: Word wrap for comments in data dialog #581
• [enhancement][community] change order of attachments? #383
• [Feature] Feature : Spreadsheet : Support Form View #142

Highlights

• Form view

  

• Language translations in 12+ languages!

  

• Locked view for grid

  

• [bug] CORS in heroku #579
• [closed] Feature: Host files by putting in folder like docs, libraries etc #578
• [closed] removed #571
• [enhancement] Feature request: Json editor in fullscreen #570
• [enhancement] Fetch nested tables info #568
• [closed] invalid database parameters #563
• [bug] Bug: Editor role is not able to add/delete rows(GUI) #532
• [needs more info] Update SQL Error for DateTime Field #502

• [bug] Unable to pick May 31 2021 in date picker #542

• [bug] Multiple update API calls happen for checkbox #551
• [bug] Delete swagger documentation for deleted table #543

• [Feature] Add litestream support to sync ncdb sqlite meta database #540
• [bug] REST API Bulk delete results in removal of all rows of table #509
• [bug] Bug: Mysql meta migration fails #447
• [enhancement] Show the signed-in user in the account-circle menu #169

• [bug] "Editor" role not allowed to upload files #536
• [bug] Deleted table still visible in navigation pane #535
• [bug] No Decimal Place on Some Formula Outputs where Needed #530
• [bug] Too many fields for a table #519

• [bug] Bug: Editor role is not able to add/delete rows(GUI) #532
• [bug] Bug: BelongsTo cell value is empty in GUI for Commenter/Viewer #531
• [closed] forgot my password,how i find it? #527
• [closed] How to calculate the sum of column A grouped by column B by calling APIs? #526
• [closed] Foreign Key does not display in primary table when reference column is changed #525
• [Feature] SMTP authentication is mandatory #520
• [Feature] [Feature] JSON helper for Handlebars #516
• [bug] Find/Get By Id does not return the Rollup result #515

• [enhancement] Quick next & previous record in the form view #501
• [closed] postgres - Connection terminated unexpectedly #453
• [enhancement] Feature: edit external database connection details #439
• [closed] Handling SingleSelect: set to null value, easier adding of new values #261
• [Feature] Feature request: i18n support #236
• [needs more info] Bug: Cannot read property 'cn' of undefined #178
• [needs more info] Bug: ID column is unknown #177
• [needs more info] Bug: A column has been specified more than once #174
• [closed] Commenter / Viewer see controls they cannot use #168

• [Feature] Feature : Rollup #504
• [closed] Tables not loading on different roles #503

• [bug] m2m column delete fails #496

• [bug] date shows in grid is different from value in database. #483
• [closed] Failed to insert a Many to Many relation column with "linked to other records #478
• [closed] Facing issue while using Monaco editor present in Nocodb #331
• [bug] Table UI disappears after Page Refresh #281
• [closed] Bug: Issues Connecting to MSSQL Server #268
• [bug] Creating columns then renaming or arranging causes SQLITE_ERROR: no such column #252
• [bug] docker 0.9.16 - postgres 11 - foreign-key fields must display the name (title) and not the ID #202
• [bug] docker 0.9.16 - postgres 11 - after "delete field" the view is not accessible any more #201
• [closed] "Save" needs to be way more visible #167
• [closed] Bug: A user without internet access faces missing fonts and stylesheets #162
• [closed] Bug: Password policy is incompatible with Firefox password generator #161
• [needs more info] Issue with default column names #157
• [needs more info] Issue: Error when editing by clicking edit button on column header #486

• Feature : SQL : Migrations from one env to another #146
  • Works for external DB project
  • For master database project (to be done)

• [closed] bug: Missing less than operator in formula #471
• Type conversion of number value in NC_DB url

• [enhancement] Feature: filter and sort using formula column #466
• [closed] Formula CONCAT() #465
• [closed] Heroku deployed standard setup - can't delete tables, relation fields failing #329

Supported Formula Functions

• AVG
• ADD
• CONCAT
• TRIM
• UPPER
• LOWER
• LEN
• MIN
• MAX
• CEILING
• FLOOR
• ROUND
• MOD
• REPEAT
• LOG
• EXP
• POWER
• SQRT
• ABS
• NOW
• REPLACE
• SEARCH
• INT
• RIGHT
• LEFT
• SUBSTR
• MID
• IF
• SWITCH

---

• [closed] Bug : Linked records are editable by non-creator roles #462
• [bug] New Project button #409
• [closed] Feature : Spreadsheet : Formula Column #138

• [bug] Bug: Mysql meta migration fails #447
• [enhancement] Feature: Download button for view media/images #440
• [bug] No data in my tables from a schema #438
• [closed] Bug: Mssql has missing data for non dbo schema #437
• [bug] Bug: fields param in API not functioning #436
• [bug] Project Metadata Sync messes up the schema #434
• [enhancement] enhancement: inconsistent views with Long Text columns with line break #430
• [bug] Bug in 'reverse-proxy with sub-path' configuration #428
• [enhancement] Enhancement : Image taxonomy on upload #426
• [enhancement] Connect to MySQL with require_secure_transport = ON #425
• [enhancement] Enhancement: missing cursor when editing for Editors #423
• [bug] Unexpected behavior when adding roles for users not added to projects #420
• [enhancement] Lookup column has a different display format than origin #416
• [bug] error when saving a row #412
• [bug] Unable to update/delete/select records for composite primary keys from swagger #410
• [enhancement] Feature: Display comment only #404
• [bug] Bug: Import not working #400
• [closed] Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call #390
• [closed] Error when clearing date from date field. #389
• [closed] M2M lenked subtable column adding #388
• [bug] Bug: failed to import meta data #343
• [enhancement] Feature: Add MailerSend to the app store #334
• [enhancement] json type column #312

• [enhancement] Feature : Lookup fields #356
• [closed] Underscore does not count as a special character in super admin password #386
• [closed] How can I create clickable URL column cell? #382
• [bug] NC_PUBLIC_URL not honored in invite email #370
• [closed] Date field includes time when choosing "date" type. #358
• [closed] Docker Volume for App #351

• [bug] Bug: Unexpected character "}" in M2M relation #349
• [closed] Bug: APIs related to M2M columns become undefined in Swagger #348
• [closed] Bug: Missing M2M column result in Swagger API Docs #347
• [bug] Bug: failed to execute the auto-generated function after setting the column as PK #346
• [closed] Bug: Can not synchronize the table list #342
• [enhancement] Feature : Bulk add users. #300
• [closed] could nocodb consider use dual licence? #243
• [closed] Error: Cannot find module 'jsonfile' #212
• [closed] Docker Volume for App #351

• [bug] Bug: Unexpected M2M columns being created #338
• [bug] Missing filtering logic in M2M #337
• [bug] Bug: Failed to select UUID with SpecificDBType #332
• [closed] Feature Request: Use Postgres JSON type to store attachements #193

Features :rocket::rocket::rocket::rocket:

Many to many relations :fire:

	MySQL	MSSQL	PostgreSQL	SQLite	MariaDB
REST	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:
GraphQL	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:

Has many relations :fire:

	MySQL	MSSQL	PostgreSQL	SQLite	MariaDB
REST	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:
GraphQL	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:

Spreadsheet :fire::fire:

	Schema				DATA					NESTED DATA FORM
	Create	Read	Update	Delete	List	Create	Update	Delete	Unlink	Create	Update	Delete	Unlink
HasMany	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:
BelongsTo	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:
ManyToMany	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:	:white_check_mark:	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:	:white_check_mark:	:white_check_mark:	NA	:white_check_mark:

Fixes

• [closed] i18n translation question #328
• [closed] Calendar/Kanban/Gantt views? #327
• [bug][graphql] Unable to create new colums in graphql project #322
• [closed] [question] How do you create Charts from NocoBb data ? #316
• [bug] graphql: Can't reload view data #315
• [bug] No Headers/Auth section #314
• [bug] Bug : Https scheme missing in swagger #311
• [bug] Condition based automation doesn't work #309
• [bug] Editor group can't attach files while creating a new row #308
• [bug] Bug: fail to test & upload attachment to S3 #307
• [bug] Error when adding columns of certain types (MySQL) #302
• [closed] feature: add params in Automations referencing cell values #296
• [closed] Filter feature issue #295
• [needs more info] Deleting of table gives error. #294
• [closed] xc-token - After deleting the token from backend admin, it's still working with the deleted token (it has to be invalid) #291
• [bug] Audit Log - DELETE is not right now recording... #290
• [bug] Swagger UI doesn't use NC_PUBLIC_URL #288
• [bug] User invite email issues #287
• [closed] Large tables fail to load #283
• [closed] Why is initEmail commented out? #278
• [closed] Table List is not refreshing and removing deleted table list when table is deleted #276
• [closed] "Email must be valid" error for valid email with a four-character top-level domain #267
• [closed] how to use token for graphql? #266
• [closed] Docker-compose script fails to launch #265
• [closed] Failed to connect backend if hosting frontend and backend separately #264
• [bug] 'This spreadsheet is connected to an SQLite DB' alarm while using mysql #263
• [closed] Not able to build through npm install #259
• [closed] could not run nocodb from latest (0.9.25) docker #258
• [enhancement] Add confirm dialog for project delete #255
• [enhancement] Docker failing on Apple with M1 chip #249
• [closed] css: in the graphql client tab the resource bar is cropped #246
• [enhancement] Confusing "Sign up" button loading state #241
• [bug] Server doesn't restart if incorrect endpoint is entered in the minio settings. #238
• [enhancement] Feature : Make row data available in API Webhook #237
• [enhancement] Issue: "expensive" filter on the front end #229
• [closed] Bug : Postgres : UUID field with gen_random_uuid() is failing. #227
• [closed] Postgres: can only access public schema #226
• [closed] README.md uses an image link with an absolute path #225
• [closed] Bug: Renaming a ForeignField causes not showing the table #224
• [closed] 'nodemon' is not recognized as an internal or external command, operable program or batch file. #222
• [closed] DockerFile ENV admin_user #221
• [closed] Building on Windows 0.9.19 #220
• [closed] Not all type of attachments will open #219
• [closed] Bug/Feature Request #218
• [closed] host networking "shouldn't" work #216
• [closed] Bug: Navbar button focus #211
• [closed] Bug: when searching a query, can't access property "dt", col is undefined. Even though the field is selected correctly #210
• [closed] docker 0.9.16 - postgres 11 - create project upper lower case issue #203
• [closed] App store configure plugins - Saving without required fields #199
• [closed] Bug: SingleSelect does not render dropdown #198
• [closed] Configuring Heroku 1-click install, improve documentation "Cannot GET /" error #197
• [closed] Ports and reverse proxy #191
• [closed] Support multiple Postgres schemas #187
• [closed] Bug: Plus Email Address Not Accepted #185
• [enhancement] Build Docker image for ARM, ARM64 (M1) #183
• [closed] Feature request : add support for JDBC #180
• [closed] Main project site wobble #176
• [closed] Feature request: Make hotjar tracking Optin #175
• [closed] Email validation for superadmin signup is too restrictive #173
• [closed] Feature: Disable the screensaver #171
• [closed] Hide "Preview as" to low-privilege users #170
• [closed] Question: How to view API endpoints? #166
• [closed] Bug: Type set does not exist #165
• [closed] Server does not start, error installing mysql #164
• [closed] Redshift Support #163
• [closed] Unable to run nocodb with postgres RDS #156

Hey Everybody, Hey Everybody 👋 👋

We are thrilled to open source NocoDB today.

NocoDB is an open source Airtable alternative.

Github : https://github.com/nocodb/nocodb

NocoDB works by connecting to any relational database and transforming them into a smart spreadsheet interface! This allows you to build no-code applications collaboratively with teams. NocoDB currently works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases.

Also NocoDB's app store allows you to build business workflows on views with combination of Slack, Microsoft Teams, Discord, Twilio, Whatsapp, Email & any 3rd party APIs too. Plus NocoDB provides programmatic access to APIs so that you can build integrations with Zapier / Integromat and custom applications too.

FEATURES :

Rich Spreadsheet Interface :

⚡ Sort, search, filter, hide columns with ease ⚡ Create Views : Grid, Gallery, Kanban, Gantt, Form ⚡ Share Views : public & password protected ⚡ Personal & locked Views ⚡ Upload images to cells (Works with S3, Minio, GCP, Azure & many more)!! ⚡ Roles : Owner, Creator, Editor, Commenter, Viewer, Commenter, Custom. ⚡ Access Control : Fine-grained access control even to column level. ⚡ API tokens to integrate with Zapier & Integromat.

Automations & App store :

⚡ Chat : Microsoft Teams, Slack, Discord, Mattermost ⚡ Email : SMTP, SES, Mailchimp ⚡ SMS : Twilio ⚡ Whatsapp ⚡ Any 3rd Party APIs

Programmatic API access via :

⚡ REST APIs (Swagger) ⚡ GraphQL APIs. ⚡ Includes JWT Authentication & Social Auth

Coming Soon : Page designer, Mobile Apps, Amazing++ things.

Follow our roadmap on Github : Star us / watch us / fork us

---

🎯 Why we building this ?

Most internet businesses equip themselves with either spreadsheet or a database to solve their business needs. Spreadsheets are used by a Billion+ humans collaboratively every single day. However, we are way off working at similar speeds on databases which are way more powerful tools when it comes to computing. Attempts to solve this with SaaS offerings has meant horrible access controls, vendor lockin, data lockin, abrupt price changes & most importantly a glass ceiling on what's possible in future.

❤️ Our Mission :

Our mission is to provide the most powerful no-code interface for databases which is open source to every single internet business in the world. This would not only democratise access to a powerful computing tool but also bring forth a billion+ people who will have radical tinkering-and-building abilities on internet.

---

🔦 Also how this all began ..

We open sourced two API solutions before NocoDB : ⚡ A no-code REST APIs generator for any MySQL DB. ~200,000 Docker pulls. This was a hobby project & had no GUI. 📈 ⚡ A low-code REST-GraphQL APIs generator for any database with GUI. Used by 100s of companies. Including fortune 500s & publicly trading companies. 📈

The thing that surprised us the most was that even non-developers started using our API products & rooting for us. 🚀 🚀 Whilst everybody loved instant API access to databases, it was slow-and-painful for them to build UI and collaborate with their teams. 💔 💔 ... This made us to radically rethink & combine the power of our 2 API products then transform them into something better.

---

💊 And.. There is.. One last thing.. this makes it insanely good :

NocoDB can be run from a single node.js file with just SIX lines of code in it! This minimalism means NocoDB runs even on the smallest of servers. Not just AWS, DigitalOcean, Heroku but also in A2Hosting & similar.

Hope you loved it. ❤️

---

Also please join our community at :

📣 Github : https://github.com/nocodb/nocodb 📣 Discord : https://discord.gg/5RgZmkW 📣 Twitter : https://twitter.com/nocodb

Would love to hear your usecases & feedbacks. 🙌

Happy Tinkering, Team NocoDB

Fix #33 Pull requests for supporting sql port number Other minor fixes

#24: While joining two tables if some columns have same name then I am not able to select all column names

#20 change container port to 80 and make xmysql response on any request

Fix : Use process.memoryUsage() in /_health.

Issues: #14 : _health and _version apis #17 : Listen to different IP address on host machine

Pull request: To fix handling of _p and _size when _p = 0