6 ms·

Hey Everybody, We are really excited to open source NocoDB today. NocoDB is an open source Airtable alternative. Github : https://github.com/nocodb/nocodb ht

by nocodb 5y ago

Hey Everybody, We are really excited to open source NocoDB today. NocoDB is an open source Airtable alternative. Github : https://github.com/nocodb/nocodb https://github.com/nocodb/nocodb NocoDB works by connecting to any relational database and transforming them into a smart spreadsheet interface! NocoDB currently works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases. This allows you to build no-code business solutions collaboratively with teams. Getting started is simple : docker run -p 8080:8080 nocodb/nocodb or npx create-nocodb-app 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. For storage you can connect to S3, Mini, GCS, Azure, DigitalOcean spaces & any S3 compatible API NocoDB gives programmatic access to REST & GraphQL APIs. And with our API tokens it can be easily integrated with Zapier / Integromat. - - - - - - Also please join our community at : - Github : https://github.com/nocodb/nocodb https://github.com/nocodb/nocodb - Discord : https://discord.gg/5RgZmkW https://discord.gg/5RgZmkW - Twitter : https://twitter.com/nocodb https://twitter.com/nocodb Would love to hear usecases & feedback. Thank you, Team NocoDB edit : made the comment short :)

jasonblais 5y ago
This is an exciting release! Look forward to seeing how this project takes off.
- nocodb 5y ago
  Thank you. Getting started is really simple - please check below. docker run -p 8080:8080 nocodb/nocodb or npx create-nocodb-app
yarapavan 5y ago
Congratulations! Exciting to see nocodb adding to the low-code/no-code scene today. Best wishes to you and your team. 1. What is your monetization strategy? 2. Why AGPL? 3. Is there a tutorial or documentation on creating additional integrations?
- nocodb 5y ago
  Thank you so much. Monetization we'll figure it out whilst interacting with our community. AGPL : we don't want to be sorry with likes of AWS etc around :) This wouldn't stop you from using it freely or commercially. We would be rolling out the tutorial for adding integrations.
  - scotu 5y ago
    Happy to see you try AGPL honestly. It might turn out to not be the right choice, but I think as a license it didn't get a fair test because of how businesses avoiding viral licenses made software authors shy away from them. With the AWS situation I really wish to see more use, and if it can be successful.
steveharman 5y ago
Please forgive the total-noob question but once I've hooked up to say a mySQL db - can I write to the db as well as read from it? Thanks
- nocodb 5y ago
  Yes, its just like your google spreadsheets. You can insert/edit/delete. And share views with and without password.
  - steveharman 5y ago
    Fantastic, thanks!
_jal 5y ago
Cool, I will be playing with this tonight. I haven't built a webapp in several years, and was just trying to find a way to offer access to a DB for a non-technical person. After seeing my options for UI were (still!) basically Access and go-build-something, was resigned to losing my weekend to coming back up to speed with Django, but it looks like this should be fine.
- nocodb 5y ago
  >> 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.
- davnicwil 5y ago
  You should check out Stacker [0] and see if it works for your usecase - we let you build apps without code using Airtable or Google Sheets as a backend. Might be what you need if time is of the essence and you don't want to worry about hosting either. I work at Stacker, my email's in my profile if you have any questions. [0] https://stackerhq.com https://stackerhq.com
Artistry121 5y ago
WOW! I am so excited by this. I'm going to build some nice CRMs and project management tools for my clients - small and growing service businesses - and attempt a cool integration with graphing and Matrix. This is so important and the opening up of code / databases to non-technical people will create so much value. Maybe we can work together on it! (I guess, open source means we will be)
de6u99er 5y ago
Looks good in the Github Readme file, but having tested the docker-compose/pg setup via docker-compose I think you still have some work to do. A lot of things result in an error, or are not possible yet. E.g. I tried a simple example with A country table containing an iso-code and a name, and a company table containing a name and a country. Somehow I can not use the iso code in the company table, I am forced to use the auto-incrementing primary key. I am not able to set iso-code column as unique which would solve my issue. --------------------------------- The app also has UI problems. E.g. when adding a new row, one the last field edited seems to be still in editing mode since the value is left-bound and not centered like the other values. Only after entering another field the value seems to be recognized as changed and I can save the data. Clicking on "Swagger apis dock" results in following error message "Cannot GET /nc/testproject_rest_api_HZOx/v1/graphql". --------------------------------- Having added a few images via attachment column, I noticed that I can access those from a incognito window where I am definitely not logged in. Steps to reproduce: 1. connect to database container -> docker-compose exec --user postgres xcdb psql 2. connect to database -> \c xcdb 3. list tables -> \d 4. select data from the table with attachments (in my case the company table) -> select * from xa1__company; 5. copy one of the urls and paste it in an incognito tab --------------------------------- Another issue that I see is that it relies a lot on external libraries, of which this one has been blocked by my ad-blocker --> https://static.hotjar.com/c/hotjar-2297736.js?sv=6 https://static.hotjar.com/c/hotjar-2297736.js?sv=6 Hotjar seems to be a tool tracking the user interactions with the product -> https://www.hotjar.com/ https://www.hotjar.com/ This is where I stopped evaluating your product LOL --------------------------------- Clicking on Calendar, Kanban, and Form results in a "Coming soon" message. Which is curious since, your website demonstrates it already. --------------------------------- Those rules saying delete cascade seem to be nonsense. I was able to delete rows in both tables (country, company) without any cascading happening which would result in an inconsistent state. --> Foreign keys seem only to exist within your applications metamodel and they don't seem to be respected accordingly. --------------------------------- My final verdict: You have a lot of work ahead of you if you want to bring this into a production ready state. Until then I recommend to others not using it with your production databases, and because of coming with the hotjar user action tracking tool not use and privacy related data with it.
- 5y ago
syrusakbary 5y ago
This is awesome!! I'm also super excited about this. You should apply to YCombinator S21 batch! (feel free to use my reference: syrusakbary if you would like!) https://www.ycombinator.com/apply/ https://www.ycombinator.com/apply/
Abishek_Muthian 5y ago
I'm very excited, looking at the GitHub stars in just 24 hours after launch it looks like many others are. This looks like a text book example of successful 'Show HN' launch. So my question is really regarding this launch, rather than NocoDB itself as all pertinent questions regarding it seems to have been asked. I see you have got some feedback on your website regarding NocoDB after production deployment by some companies, How long you folks have been developing NocoDB? Were you using your personal funds for development? All the best, Hope NoCoDB turns out to be another successful dual-licensed startup.
prox 5y ago
Is there any way to turn this into a desktop app?
- nocodb 5y ago
  In our 2nd iteration this was a desktop app that could connect to database, create-edit schema and generate code and was without spreadsheet.
tecleandor 5y ago
Hi! FYI, I think you are using the wrong logo on Vasyl Rakivnenko testimonial. You using the Spanish Servired (a bank network) logo instead of the Polish Servired (Road Transportation). I think this is the correct one: https://www.linkedin.com/company/servired-sp-z-o-o-/ https://www.linkedin.com/company/servired-sp-z-o-o-/
- nocodb 5y ago
  Thanks a tonne, fixed it.
towelpluswater 5y ago
This is neat, nice work. Any plans to add Snowflake as a database?
- seektable 5y ago
  Snowflake is a DW solution - in most cases it is populated from other OLTP DBs and uses as a data source for BI tools. What is the purpose of editing data directly in Snowflake?..
croes 5y ago
Can't seem to get it to run on Windows 10 via npx or git clone. Both ways show error 9009, failed at the sqlite3@5.0.0 install script.

by nocodb 5y ago

jasonblais 5y ago

This is an exciting release! Look forward to seeing how this project takes off.

nocodb 5y ago
Thank you. Getting started is really simple - please check below. docker run -p 8080:8080 nocodb/nocodb or npx create-nocodb-app

yarapavan 5y ago

Congratulations! Exciting to see nocodb adding to the low-code/no-code scene today. Best wishes to you and your team. 1. What is your monetization strategy? 2. Why AGPL? 3. Is there a tutorial or documentation on creating additional integrations?

nocodb 5y ago
Thank you so much. Monetization we'll figure it out whilst interacting with our community. AGPL : we don't want to be sorry with likes of AWS etc around :) This wouldn't stop you from using it freely or commercially. We would be rolling out the tutorial for adding integrations.
- scotu 5y ago
  Happy to see you try AGPL honestly. It might turn out to not be the right choice, but I think as a license it didn't get a fair test because of how businesses avoiding viral licenses made software authors shy away from them. With the AWS situation I really wish to see more use, and if it can be successful.

steveharman 5y ago

Please forgive the total-noob question but once I've hooked up to say a mySQL db - can I write to the db as well as read from it? Thanks

nocodb 5y ago
Yes, its just like your google spreadsheets. You can insert/edit/delete. And share views with and without password.
- steveharman 5y ago
  Fantastic, thanks!

_jal 5y ago

Cool, I will be playing with this tonight. I haven't built a webapp in several years, and was just trying to find a way to offer access to a DB for a non-technical person. After seeing my options for UI were (still!) basically Access and go-build-something, was resigned to losing my weekend to coming back up to speed with Django, but it looks like this should be fine.

nocodb 5y ago
>> 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.
davnicwil 5y ago
You should check out Stacker [0] and see if it works for your usecase - we let you build apps without code using Airtable or Google Sheets as a backend. Might be what you need if time is of the essence and you don't want to worry about hosting either. I work at Stacker, my email's in my profile if you have any questions. [0] https://stackerhq.com https://stackerhq.com

Artistry121 5y ago

WOW! I am so excited by this. I'm going to build some nice CRMs and project management tools for my clients - small and growing service businesses - and attempt a cool integration with graphing and Matrix. This is so important and the opening up of code / databases to non-technical people will create so much value. Maybe we can work together on it! (I guess, open source means we will be)

de6u99er 5y ago

Looks good in the Github Readme file, but having tested the docker-compose/pg setup via docker-compose I think you still have some work to do. A lot of things result in an error, or are not possible yet. E.g. I tried a simple example with A country table containing an iso-code and a name, and a company table containing a name and a country. Somehow I can not use the iso code in the company table, I am forced to use the auto-incrementing primary key. I am not able to set iso-code column as unique which would solve my issue. --------------------------------- The app also has UI problems. E.g. when adding a new row, one the last field edited seems to be still in editing mode since the value is left-bound and not centered like the other values. Only after entering another field the value seems to be recognized as changed and I can save the data. Clicking on "Swagger apis dock" results in following error message "Cannot GET /nc/testproject_rest_api_HZOx/v1/graphql". --------------------------------- Having added a few images via attachment column, I noticed that I can access those from a incognito window where I am definitely not logged in. Steps to reproduce: 1. connect to database container -> docker-compose exec --user postgres xcdb psql 2. connect to database -> \c xcdb 3. list tables -> \d 4. select data from the table with attachments (in my case the company table) -> select * from xa1__company; 5. copy one of the urls and paste it in an incognito tab --------------------------------- Another issue that I see is that it relies a lot on external libraries, of which this one has been blocked by my ad-blocker --> https://static.hotjar.com/c/hotjar-2297736.js?sv=6 https://static.hotjar.com/c/hotjar-2297736.js?sv=6 Hotjar seems to be a tool tracking the user interactions with the product -> https://www.hotjar.com/ https://www.hotjar.com/ This is where I stopped evaluating your product LOL --------------------------------- Clicking on Calendar, Kanban, and Form results in a "Coming soon" message. Which is curious since, your website demonstrates it already. --------------------------------- Those rules saying delete cascade seem to be nonsense. I was able to delete rows in both tables (country, company) without any cascading happening which would result in an inconsistent state. --> Foreign keys seem only to exist within your applications metamodel and they don't seem to be respected accordingly. --------------------------------- My final verdict: You have a lot of work ahead of you if you want to bring this into a production ready state. Until then I recommend to others not using it with your production databases, and because of coming with the hotjar user action tracking tool not use and privacy related data with it.

5y ago

syrusakbary 5y ago

This is awesome!! I'm also super excited about this. You should apply to YCombinator S21 batch! (feel free to use my reference: syrusakbary if you would like!) https://www.ycombinator.com/apply/ https://www.ycombinator.com/apply/

Abishek_Muthian 5y ago

I'm very excited, looking at the GitHub stars in just 24 hours after launch it looks like many others are. This looks like a text book example of successful 'Show HN' launch. So my question is really regarding this launch, rather than NocoDB itself as all pertinent questions regarding it seems to have been asked. I see you have got some feedback on your website regarding NocoDB after production deployment by some companies, How long you folks have been developing NocoDB? Were you using your personal funds for development? All the best, Hope NoCoDB turns out to be another successful dual-licensed startup.

prox 5y ago

Is there any way to turn this into a desktop app?

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

tecleandor 5y ago

Hi! FYI, I think you are using the wrong logo on Vasyl Rakivnenko testimonial. You using the Spanish Servired (a bank network) logo instead of the Polish Servired (Road Transportation). I think this is the correct one: https://www.linkedin.com/company/servired-sp-z-o-o-/ https://www.linkedin.com/company/servired-sp-z-o-o-/

nocodb 5y ago
Thanks a tonne, fixed it.

towelpluswater 5y ago

This is neat, nice work. Any plans to add Snowflake as a database?

seektable 5y ago
Snowflake is a DW solution - in most cases it is populated from other OLTP DBs and uses as a data source for BI tools. What is the purpose of editing data directly in Snowflake?..

croes 5y ago

Can't seem to get it to run on Windows 10 via npx or git clone. Both ways show error 9009, failed at the sqlite3@5.0.0 install script.