News for hackers. Stuff that matters.
Re:Ask HN: What's the fastest tool for basic CRUD? by Ididntdothis on Sunday January 19, 2020 @11:59AM (#22092410)
To me it's still surprising that nobody has done something like MS Access or VB6 for the web. They were easy to learn but had enough power to create really complex solutions. The only downside were scaling and multiple user support. These problems shouldn't be that hard to solve.
Re:Ask HN: What's the fastest tool for basic CRUD? by meredydd on Sunday January 19, 2020 @05:12PM (#22094473)
We have in fact built a "VB6 for the web"! It's called Anvil (https://anvil.works), and it has:

- Drag'n'drop UI design (https://anvil.works/docs/client/quickstart)

- Python code (browser-side and server-side)

- A built-in database (https://anvil.works/docs/data-tables/quickstart)

- Multi-user support out-of-the-box (https://anvil.works/docs/users)

- Built in email/cron/secrets/etc

- Plug-in integration with Python code running anywhere else on the internet. You import a library, it connects via websocket to your hosted app, you get two-way RPC between your code any your app (https://anvil.works/learn/tutorials/jupyter-notebook-to-web-...)

Re:Ask HN: What's the fastest tool for basic CRUD? by kls on Sunday January 19, 2020 @12:44PM (#22092683)
I love access, and pushed it at many jobs that I have been at. Many times you have small teams who just are not worth the investment of enterprise systems while they are still growing that part of the business. Access allowed them to solution their needs while the requirements are still in flux. Once a department becomes big enough the access solution serves as a working prototype to generate requirements to build a proper system. It is a shame that Access has fallen out of favor and there really are no web tools that compare to how well it enabled users.
Re:Ask HN: What's the fastest tool for basic CRUD? by chihuahua on Sunday January 19, 2020 @02:04PM (#22093193)
One could argue that Microsoft PowerApps (Dynamics 365 CDS model apps) is the enterprise equivalent of Access. It's extremely easy to build a CRUD app without writing any code.
Re:Ask HN: What's the fastest tool for basic CRUD? by collyw on Thursday January 23, 2020 @06:44AM (#22126755)
Access has always been relatively easy to build an app with close "to no code". The problem is that you still need to understand the principles of a relational database to use it properly and that is usually taught after basic coding.
Re:Ask HN: What's the fastest tool for basic CRUD? by sverhagen on Sunday January 19, 2020 @01:40PM (#22093048)
Except that for most of us there's probably an eternity between "big enough ... to build a proper system" and actually building one.
Re:Ask HN: What's the fastest tool for basic CRUD? by codenesium on Sunday January 19, 2020 @02:27PM (#22093380)
It's because the owner of this patent is a patent troll who sues companies out of existence for building what you're talking about.

https://patents.google.com/patent/US7062502

https://www.theregister.co.uk/AMP/2015/09/07/sunk_by_patent_...

Re:Ask HN: What's the fastest tool for basic CRUD? by potiuper on Sunday January 19, 2020 @06:22PM (#22094861)
How is Access 97 Form Wizard not prior art?
Re:Ask HN: What's the fastest tool for basic CRUD? by mbesto on Sunday January 19, 2020 @01:34PM (#22093001)
There's a whole industry around this - they're called low-code environments.

https://www.g2.com/categories/low-code-development-platforms

Re:Ask HN: What's the fastest tool for basic CRUD? by qpiox on Sunday January 19, 2020 @02:08PM (#22093230)
https://apex.oracle.com is a solution for most of the use-cases similar to MS Access and VB6. But useful only if you have an Oracle database.

I mentioned OpenXava as a development tool in another post. They had their own 0 programming hosted environment with similar ease of use as APEX, but I can't find the link now.

Re:Ask HN: What's the fastest tool for basic CRUD? by skanga on Sunday January 19, 2020 @04:02PM (#22094044)
Re:Ask HN: What's the fastest tool for basic CRUD? by eugeniox on Sunday January 19, 2020 @12:18PM (#22092533)
DaDaBIK (https://dadabik.com/) is available since 2001 and I have heard people referring to it as "MS access for the Web".
Re:Ask HN: What's the fastest tool for basic CRUD? by mamcx on Sunday January 19, 2020 @01:50PM (#22093111)
Same. I'm building the foundations with a relational lang (https://github.com/Tablam/TablaM), because where Access/Excel "fail" was to have a huge disconnect between how use it and how program it. Also because I think the lang could make everything else easier (for example: transform datasources).

Where some tools in this space ALSO fail is to be ONLY for cloud. I think nothing will displace access/excel if don't have a native/local experience.

Re:Ask HN: What's the fastest tool for basic CRUD? by mattmagoo on Sunday January 19, 2020 @12:27PM (#22092578)
You should take a look at Retool. You still need to configure the databases separately in SQL, but the user interface builder is pretty intuitive.
Re:Ask HN: What's the fastest tool for basic CRUD? by purplesquirtle1 on Sunday January 19, 2020 @02:35PM (#22093441)
We're working on a new VB6 for the web platform, and would love your feedback :). Good for quickly spinning up CRUD apps with a few new features such as embedded BI and simple ML tools.

It's still in early access, but if you'd like to play around with it, please don't hesitate to message me at [email protected].

Re:Ask HN: What's the fastest tool for basic CRUD? by zubairq on Sunday January 19, 2020 @12:12PM (#22092493)
We are building something like that at yazz.com, but still early days