Simple SQL and REST API interfaces

Microsoft Excel, Google Sheets, Claris FileMaker, and Adobe PDF documents can all use open-source technologies to asynchronously interact with popular SQL databases and REST APIs in near real-time.

Each of these document types provide native functions that can dynamically merge user-supplied parameters in to URLs that trigger PHP scripts.

Depending on the parameters, the script can either execute a SQL query or transaction, perform a look-up, call a stored procedure, run an aggregate query, or interact with an API, and then merge and filter the response back to the document as a single value, a dynamic array, or a custom format.

- A single document can interact with and merge data from virtually unlimited multiple sources.

Simple documents can interact with complicated services...


PHP is installed on roughly 80% of web servers. PHP Data Objects (PDO) and cURL code libraries DRASTICALLY simplify data interactions with SQL databases or REST APIs. Optional HTML interfaces provide authenticated users Create-Read-Update-Delete controls for MySQL, SQL Server, Oracle, PostgreSQL, DB2, or Informix databases and can also optionally create authentication-enabled REST API endpoints for these database types.

Excel, Sheets

Microsoft Excel and Google Sheets documents can calculate and execute SQL and REST API queries that use PDO and cURL to interact with data services and filter results back to spreadsheet cells. Excel spreadsheets can optionally be converted to HTML to run in desktop and mobile web browsers, creating open-source calculating web forms that can interact with multiple disparate data sources in very near real time.

FileMaker, Acrobat

Claris FileMaker documents and Adobe Acrobat PDF forms can also calculate and execute scripts that utilize PDO and cURL to interact with SQL databases or REST APIs. FileMaker additionally provides an extremely versatile multi-user solution development environment, with adaptive data and e-mail processing interfaces that can be securely shared via Apple or Windows desktop application, WebDirect web forms, or the FileMaker Data API.

Connect the technolgies and remove the complexities...

Open-source PHP, PDO, cURL, JavaScript

No VBA, ODBC, JDBC, SaaS dependencies

You run the servers, you own the code

PDO can communicate with a lot of popular databases...

cURL can communicate with a lot of popular REST APIs...

This makes it comparatively easy to do things like...

return real-time
SQL or REST API query results to document calculations...

share calculating web forms that merge data from distributed or disparate sources...

execute multiple key performance indicator queries in real time...

add dynamic SQL
CRUD or REST API functions to your spreadsheets or
PDF forms...

build really well connected desktop and mobile workgroup applications

“Extraordinarily efficient, stunningly cost-effective.”

“Simplified, with additional lightness.”

“Like Zapier or Make, but way, way more versatile.”

Web-enabled desktop or mobile interfaces, simple deployment, minimized dependencies, integrating disparate technologies to build simple or complex data automation solutions.

Take a look at the examples at the top of the page and e-mail with any questions. Thanks!