News for hackers. Stuff that matters.

A comment on A Relational Spreadsheet. Parent comment

Re:A Relational Spreadsheet by SloopJon on Sunday February 26, 2023 @12:26PM (#34947322)
If you're asking for a GUI for simple CRUD on an arbitrary table, I think that's pretty common. What database are you using, and what API are you using to access it? (Edit: and on what O/S?)

If one of the obstacles to data entry is normalization, perhaps an updatable view if your database supports it.

[ Parent | on HN ]
Re:A Relational Spreadsheet by deepspace on Sunday February 26, 2023 @03:31PM (#34949068)
> I think that's pretty common.

Not as common as you might think. It is a hard thing to search for, and the ones I have been able to find all suck.

I wrote a PHP application a long time that allowed you to create a GUI for an 'arbitrary' SQL database table, using an XML schema to configure the appearance, validation etc. of the fields. Life got in the way, and I stopped development before it was ready for prime time. Fifteen years later, I went looking for something with similar functionality and was surprised at how few options there still were.

[ Parent | on HN ]
Re:A Relational Spreadsheet by masfuerte on Sunday February 26, 2023 @05:01PM (#34949988)
A bit more than 20 years ago Microsoft released a desktop product that automated producing a CRUD interface from an XML schema. It looked very nice but it was immediately withdrawn. I was puzzled at the time but I guess now they were threatened with a patent. This might explain why there weren't more products solving this obvious problem. Patents should have expired by now though.
[ Parent | on HN ]