Assuming you are aware that NocoDB claims to support MySQL, Postgres, MariaDB, SQLite as well as SQL server, what was your suboptimal experience with MSSQL?
nocodb dev team was very generous for me when helping me evaluate their product for my use case, including creating a test environment to understand my request.
I ended up not using them, but they created an issue for me on GitHub, saying my request was on their roadmap.
Do you support custom layouts (including big text boxes for certain fields, or at least a pop up zoom), and embeddable subforms? Yes, I am basically looking for MS Access for the web, and I realize I'd have to give up A LOT, but certain things I just need (a gui for designing complicated forms is nice to have, but not necessary, but the layout is).
Yep, master form (single row or multi, row select loads children) with detail child(ren) (usually multi row, but sometimes single), direct relationship or via xref table(s). Hope that makes sense?
I don't mind so much having to write some plumbing code if necessary as long as I can get the job done.
This is fantastic, especially as we see trends around owning your data. Tools like this allow us to migrate away from proprietary solutions like Airtable or Google Sheets.
On the other hand, I could also see this being used as somewhat as an "Admin UI" for SaaS software administrators.
Yes, it could be easily used as Admin UI. We create a virtual schema for every database that we connect to. If there are schema changes done outside noco GUI - then noco has a sync option that does automatically sync the changes.
Spreadsheets has limits to number of rows/cells. And they tend to corrupt after certain limit easily. Then things like creating relation between sheets or deriving different views are not possible/easier in spreadsheet. This is when teams using spreadsheets start to move to databases. But it involves a lot of effort to build a spreadsheet like product on databases. This is where noco helps.
NocoDB[1] is a Free & Open Source Airtable alternative that transforms your own existing databases like MySQL/Postgres/MsSQL/SQLite into a smart-spreadsheet.
Happy to answer any queries and you can also join our discord[2] for any help.
We're using knexjs to connect to databases. If knexjs generally works with your Cockroachdb. We should be able to work as well. Please reach out on our discord for any help.
The "how it works" section is just some short soundless YouTube videos that don't explain what is going on. I think they need to work harder on explaining their product.
Budibase also has a more comprehensive UI builder, internal database, forms, configurable onboarding, free SSO, Kubernetes support, a cloud platform, off the top of my head.
I think the product direction holds some real value.
However, as a potential customer I do not know what this product can do from browsing the webpage for a short a mount of time. Hints like "Airtable alternative" is no use to me when I don't know what Airtable is good for.
The Videos (as commented by other hn'ers are not really helpful in showing what's going on).
In noco we've the concept of primary-value (like primary key) and that shows up automatically when you join with other tables (defaults to 'title'). However the primary value column can be changed to any other column too (by hovering on the column name).
Other tools in the list do not give the smart-spreadsheet automatically when you connect to databases. And frankly, these are two different tools we are comparing.
This has been my experience with internal tool builders too. The barrier to entry is quite high to try most of them and it's really hard to have a whole team test them out.
This adoption issue was part of the inspiration for Wax [0] which lets you build internal tools on top of Google Sheets. If your team is already using Sheets, it's much easier to add the missing pieces there vs. pushing people to an entirely separate platform.
What I do not like is that it tries to subscribe me to a newsletter on a self hosted app (you might not recognize the checkbox at the first look). And the google feedback form inside the app is quite weird. Besides from that it seems quite interesting, especially for non-coders.
38 comments
[ 4.5 ms ] story [ 86.9 ms ] threadDefinitely worth keeping an eye on this project.
I ended up not using them, but they created an issue for me on GitHub, saying my request was on their roadmap.
https://github.com/nocodb/nocodb/issues/580
Oh and they quickly researched a solution to an installation bug I was experiencing.
https://github.com/nocodb/nocodb/issues/579
TL;DR: great customer service from nocodb, so I'm happy to consider nocodb for future projects.
What's a Page Designer? Do you mean forms for data entry? Or report pages (read-only data)?
By page designer - its about custom reports from the data.
I don't mind so much having to write some plumbing code if necessary as long as I can get the job done.
On the other hand, I could also see this being used as somewhat as an "Admin UI" for SaaS software administrators.
NocoDB[1] is a Free & Open Source Airtable alternative that transforms your own existing databases like MySQL/Postgres/MsSQL/SQLite into a smart-spreadsheet.
Happy to answer any queries and you can also join our discord[2] for any help.
[1] : https://github.com/nocodb/nocodb
[2] : https://discord.gg/5RgZmkW
Can it scale to B2C number of users? Are there technical limitations that prevent this if we keep adding servers?
However, as a potential customer I do not know what this product can do from browsing the webpage for a short a mount of time. Hints like "Airtable alternative" is no use to me when I don't know what Airtable is good for.
The Videos (as commented by other hn'ers are not really helpful in showing what's going on).
This, for me, was easiest to try out. And quite impressive, honestly.
The key point was that in each table, the 'title' column (created by default) has a special meaning as they show up in the join columns cleanly.
Amazing and congratulations.
In noco we've the concept of primary-value (like primary key) and that shows up automatically when you join with other tables (defaults to 'title'). However the primary value column can be changed to any other column too (by hovering on the column name).
Other tools in the list do not give the smart-spreadsheet automatically when you connect to databases. And frankly, these are two different tools we are comparing.
This adoption issue was part of the inspiration for Wax [0] which lets you build internal tools on top of Google Sheets. If your team is already using Sheets, it's much easier to add the missing pieces there vs. pushing people to an entirely separate platform.
0 - https://www.wax.run/
Thank HN: A customer found us on Hacker News and wrote our first angel check - https://news.ycombinator.com/item?id=28606258 - Sept 2021 (6 comments)
Show HN: NocoDB – Open-Source Airtable Alternative - https://news.ycombinator.com/item?id=27303783 - May 2021 (157 comments)