nocodb

> I wish there were simple-as-Excel frontends for databases

This is exactly what we are attempting to solve at nocodb : https://github.com/nocodb/nocodb

Which is, nocodb gives you a google-drive like collaborative spreadsheets on your existing databases (MySQL, Postgres etc)

And the original problem in article could be countered with nocodb as we keep audit of all changes done to the database.

Thank you for the answer

Thanks a tonne, fixed it.

We're using developer certificate of origin. Used by nextcloud and likes.

This is a demo to create and consume API token. https://youtu.be/AvdEAiKnpg8

I believe integration with n8n is possible as we do expose APIs.

In our 2nd iteration this was a desktop app that could connect to database, create-edit schema and generate code and was without spreadsheet.

Thank you

Hotjar allows us to ask questionnaire about product. And the idea was to give it and google analytics as plugins so you as a customer can key in your own analytics. Happy to remove it and somebody had raised an issue of jsdeliver related to fonts.

Thanks for your report.

With regards to Swagger thing, we allow to create multiple projects within same schema too! And this happens in NC_DB only - I imagine we 've an issue with Swagger related model creation. This should be straight forward.

At row edit part - we will work on your feedback.

Ah, I never imagined those logs are not public! We just moved from travis to actions. This is new to us.

Below is the command to run the test for REST APIs

https://github.com/nocodb/nocodb/blob/master/.github/workflo...

git clone https://github.com/nocodb/nocodb

and you can run the same command.

Yes it does which is what it makes it interesting.

This is our 1-Click/1-Command shell script on fresh ubuntu machine.

But we havent tested it recently. It installs docker, mysql, letsencrypt etc and help you set. You can try it.

After 'Cypress' run there is 'Docker' run.

And our tests are dockerised so that it could be run locally with minimal setup and on CI too.

Please click on 'Docker' then 'Test MySQL REST APIs' & 'Test GraphQL APIs'.

Fair enough, having it as open source and work with existing databases opens up entirely new usecase & opportunities.

Thank you for mentioning, what is the safari version ? looks good at 11.1.2

Tests are here : https://github.com/nocodb/nocodb/blob/master/.github/workflo...

https://github.com/nocodb/nocodb/runs/2687614633?check_suite...

>> home assistant out of interest? Sqllite of influxdb ?

Sorry could you help elaborate on this.

You want to access home assistant data which is in sqlite or something.

Adding SSO/SAML would be in our enterprise edition. There isn't a plugin for it the current product for it :)

Most of spreadsheet part is self explaining : here are all our demos https://nocodb.com/demos

S3 and Google Auth for newbies can be found here : https://github.com/nocodb/nocodb/tree/master/markdown/plugin...

Having said that, we will be working on the documentation series in coming week.

There is no limit on upperbound - spreadsheet fetches data from your table in database.

Thank you for the kind feedback.

>> Is there any chance to build in SQL commands.

We've full fledged SQL Editor support in the product. Also support for SQL views, procedures etc. It is not shown in UI as there is lot to take in. So it will be in shortly :)

NocoDB can be run as a single node.js file which has just SIX lines of code in it.

So entire NocoDB stack can be run a repl.it / glitch too! :) - This makes it insanely powerful & ubiquitous.

https://github.com/nocodb/nocodb-seed/blob/main/index.js

:)

Although there is similarity, we are radically different.

We transform any existing databases MySQL, Postgres, SQL Server & SQLite databases into a spreadsheet. This is a _massive_ difference to begin with. And the ability to invite team to collaborate and build business workflow automations with Slack, Twilio is available for everybody. Since the launch today, I have already have close to 25+ plugin requests which sounds reasonable for NocoDB to have! We believe for a horizontal product like NocoDB - developing every app, connector and plugins is just beyond the ability of single team in open source. It is community driven approach that eases this possibility.

What tools have your tried with redshift ? which has helped.

Does a spreadsheet like thing help for columnar database ? Please let us know usecases.

ah ok.

Was this on windows ? You might have to start command prompt with administrator privileges. Some of our users ran into these.

SSO / SAML will be be in enterprise versions.

>> Tried it and it's so beautiful!

Thank you it means so much.

Yes, in our earlier version we could connect to Planetscale and create tables (this was at inception stage). With recent Planetscale release DDL are no longer supported and branching is the way. We would love to support if anything changes.

Yes, its just like your google spreadsheets. You can insert/edit/delete. And share views with and without password.

>> Was just trying to find a way to offer access to a DB for a non-technical person

Yes, you can say we are advanced version of MS Access for all databases that can talk to even 3rd party apps.

Yes, Xmysql was a hobby project originally submitted on HN. Below is the gist of it.

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 recombine the power of our 2 API products then transform them into something better.