But, the person can read all rows from the table. You could try to use a view but probably, you would just implement some filtering in your proxy. “Just implement some filtering” becomes a problem when the HTTP Plugin is your proxy. There’s no script language, you can’t do that. Unless, there was a script language built-in to the proxy…
Espresso provides an API as soon as you register your database. It introspects the database schema and populates the repository with the required metadata. Each table becomes a REST endpoint with services such as pagination, filtering, and optimistic locking out-of-the-box.
The DBacesslayer aka DBSlayer aka Släyer is a lightweight database abstraction layer suitable for high-load websites where you need the scalable advantages of connection pooling. Written in C for speed, DBSlayer talks to clients via JSON over HTTP
HTSQL was created in 2005 to provide an XPath-like HTTP interface to PostgreSQL for client-side XSLT screens and reports. HTSQL found its audience when analysts and researchers bypassed the user interface and started to use URLs directly. The language has evolved since then.
XRX is a new web development architecture that is a milestone in elegant simplicity. XRX stands for:
XForms on the client
REST interfaces
and XQuery on the server