Can a PDF Form Function as a Mini-Database Without an External Database Connection?

The answer is yes, and I thought other Acrobat form developers might be interested in an alternative approach I eventually developed.

Years ago, Acrobat provided ODBC database connectivity that made it possible to connect a PDF form to an external relational database. After that capability was discontinued, I spent considerable time looking for another way to provide database-like record management from within a PDF form.

I eventually developed a different approach using Acrobat JavaScript, a JavaScript object, JSON, and hidden PDF form fields.

Rather than connecting the PDF to an external relational database, the records themselves can be stored and managed within the PDF.

The JavaScript object provides the working structure for managing the records. JSON provides a compact means of serializing the structured data, while one or more hidden PDF form fields provide persistent internal storage. Acrobat JavaScript ties everything together by controlling how records are created, retrieved, searched, updated, displayed, and deleted.

Using this approach, a PDF form field can serve as a unique record identifier. When an ID is entered or a record is selected, JavaScript can locate the corresponding stored record and automatically populate the appropriate PDF form fields.

In effect, the PDF becomes a self-contained mini-database for applications requiring a relatively modest number of records.

This approach is not intended to duplicate the scale or complexity of Microsoft Access, MySQL, SQL Server, or another full-scale relational database system. Rather, it provides an alternative for PDF applications that do not require that level of database infrastructure.

One advantage is that the records remain with the PDF application itself. No external database server or cloud-based storage is required, and I have successfully implemented this architecture in PDF applications that operate using the free Adobe Reader.

I am posting this because I remember older Acrobat Community discussions asking how a PDF form could retrieve a record based upon a unique ID and automatically populate other fields. At the time, the solutions generally involved external database connectivity. I thought other Acrobat form developers might find this alternative architecture useful or interesting today.

[ personal information removed - Mod. ]