Live data from Hacker News

Show HN: Forms – Easy custom database applications

sonadier.com

1–10 of 62 posts

Re: Show HN: Forms – Easy custom database applications

#3
We just finished releasing a new version, basically it's a frontend for creating relational database applications. If anyone's familiar with Microsoft Access, it's a lot like that, except it's web-based and comes with a user/permissions management system. I'm looking for feedback, and can answer any questions!

Re: Show HN: Forms – Easy custom database applications

#4
post #2

How does it work? Does it output your forms as SQL that can be run against say PostgreSQL? Does it generate an HTML web form that you can save offline that connects to a database?

A lot of what we're trying to do is abstract some of the backend systems to allow for quick building. When you make a form, we host it on our servers, provide an accounts system for inviting team members and a permissions system for controlling access. Right now we're working on securely implementing both custom SQL queries and javascript-based scripting for backend validation and frontend customization.

Re: Show HN: Forms – Easy custom database applications

#5
post #2

How does it work? Does it output your forms as SQL that can be run against say PostgreSQL? Does it generate an HTML web form that you can save offline that connects to a database?

A lot of what we're trying to do is abstract some of the backend systems to allow for quick building. When you make a form, we host it on our servers, provide an accounts system for inviting team members and a permissions system for controlling access. Right now we're working on securely implementing both custom SQL queries and javascript-based scripting for backend validation and frontend customization.

Ok, so for arguments sake it's a persistent form builder rather than anything really to do with building things for databases?

Re: Show HN: Forms – Easy custom database applications

#6
post #5

Earlier quoted context omitted.

A lot of what we're trying to do is abstract some of the backend systems to allow for quick building. When you make a form, we host it on our servers, provide an accounts system for inviting team members and a permissions system for controlling access. Right now we're working on securely implementing both custom SQL queries and javascript-based scripting for backend validation and frontend customization.

Ok, so for arguments sake it's a persistent form builder rather than anything really to do with building things for databases?

We're still working on exposing lower-level operations to advanced users. I'd still say we're a database builder, since we provide a system for making relational connections, and allow all CRUD operations on records. A form builder would probably only provide Create.

The accepted keywords for this kind CRUD-application builder are pretty generic, to be honest. The biggest one that I see used is "Online Database", which is so broad it's nearly meaningless.

Re: Show HN: Forms – Easy custom database applications

#7

We just finished releasing a new version, basically it's a frontend for creating relational database applications. If anyone's familiar with Microsoft Access, it's a lot like that, except it's web-based and comes with a user/permissions management system. I'm looking for feedback, and can answer any questions!

please consider open sourcing it in the future when the time is right.

Re: Show HN: Forms – Easy custom database applications

#8
post #7

We just finished releasing a new version, basically it's a frontend for creating relational database applications. If anyone's familiar with Microsoft Access, it's a lot like that, except it's web-based and comes with a user/permissions management system. I'm looking for feedback, and can answer any questions!

please consider open sourcing it in the future when the time is right.

Absolutely! I definitely want to give back when it's a bit more complete, considering all of the open source libraries we took advantage of.

Re: Show HN: Forms – Easy custom database applications

#9
It looks like your access control is table level. Have you considered what it will take to provide row/column level controls?

Also, the report builder looks like it doesn't allow you to set up complex reports (range queries). Can you add an abstract WHERE clause constructor? That would let you do things like collect all orders in the last week that were over 20 dollars, late on their delivery, or fulfilled by the new guy. You might want to look at BI tools like Pentaho or Microstrategy to see if you can build something similar on the analysis end.

Finally, do you offer change tracking and backups? No one wants to lose a LOB database because someone ragequit.

Re: Show HN: Forms – Easy custom database applications

#10
I really like this!

I was playing around and noticed "Number" field will return an "Internal Error" upon saving if numbers are out of _undefined_ range.

(e.g. "0-99999999") and does not care whether the range is valid or not.

- It is unclear what the meaning for "Regex" under 'Advanced' Number Form: Is this _just_ a label, or does it provide functionality of some kind?

- Seems like "Save" in the upper right corner should assume "Done" is True in the lower left corner.

My questions are purely rhetorical btw.

Post reply on HN