Abstract: Methods, program products, and systems implementing browser-based database manipulation are described. A browser on a client device can receive a form definition that is generated based on a schema of a relational database and a layout. The schema in the form definition can specify properties of data fields. The browser can display the data fields and other components of the layout in a list. The browser can receive a drag-and-drop input, the drag-and-drop input selecting a data field or a layout component from the list and dropping the selected data field or layout component in a drop zone in a form area in the browser. The browser can determine the drop location, and use the drop location as a parameter to modify the form definition. The layout and the schema can be modified based on the modified form definition.

Abstract: Methods, program products, and systems implementing intelligent data caching are disclosed. A client can send a request for data to a server. The request can include a query and a query context. The query can retrieve more data than can be displayed in a current page. The query context can specify a quantity of data records that can be displayed in the current page. The client can receive from the server two sets of data in response to the request. The first set of data can include row identifiers of data records that satisfy the query. The second set of data can include data records that can be displayed in the current page. The client can store the two sets of data in one or more buffers (e.g., two buffers) and update buffer(s) when different data records are displayed (e.g., when a user scrolls through pages).

Abstract: Methods, program products, and systems implementing browser-based database manipulation are described. A browser on a client device can receive a form definition that is generated based on a schema of a relational database and a layout. The schema in the form definition can specify properties of data fields. The browser can display the data fields and other components of the layout in a list. The browser can receive a drag-and-drop input, the drag-and-drop input selecting a data field or a layout component from the list and dropping the selected data field or layout component in a drop zone in a form area in the browser. The browser can determine the drop location, and use the drop location as a parameter to modify the form definition. The layout and the schema can be modified based on the modified form definition.

Abstract: Methods, program products, and systems implementing collaborative database operations are disclosed. Collaborative database operations can be facilitated by data notification, where a server notifies a client when data being viewed at the client are updated. Notification can be achieved through registration and polling. A client of a database can request data from a server. The request can include a data request and a registration request. The data request can include a query into a database. The registration request can include a specification on conditions upon which the client is to be notified. The condition can include an event type. Upon registration, the client can poll the server periodically to determine whether a result of the query has changed, and if so, what data record in the result has changed. If a data record has changed, the client can request the changed data using an identifier of the data record.

Abstract: Methods, program products, and systems implementing intelligent data caching are disclosed. A client can send a request for data to a server. The request can include a query and a query context. The query can retrieve more data than can be displayed in a current page. The query context can specify a quantity of data records that can be displayed in the current page. The client can receive from the server two sets of data in response to the request. The first set of data can include row identifiers of data records that satisfy the query. The second set of data can include data records that can be displayed in the current page. The client can store the two sets of data in one or more buffers (e.g., two buffers) and update buffer(s) when different data records are displayed (e.g., when a user scrolls through pages).

Abstract: Methods, systems, and apparatus, including computer program products, for generating user interface tools are disclosed. In one aspect, a method includes identifying a resource (e.g., a web page) for display in an interface, identifying one or more user interface elements in the resource, generating a tool based on the one or more user interface elements, and combining the tool and the resource for display in the interface.