FeResPost Web Site                     FeResPost Online User Manual

IV.2.6 Saving and retrieving Results from an SQL database

“Result” and “Group” objects can be saved into SQL BLOBs for storing or manipulation in SQL databases. This feature has been introduced to allow the management of persistence of intermediate results calculated with FeResPost.

A small example is proposed here illustrating this feature. The example deals with Nastran dynamic analysis Results that are stored in an SQLite database. This type of operation may be useful, as the access to dynamic analysis results from an XDB file may sometimes be very impractical. In particular, the insertion table is organized in such a way that Results can be accessed separately by subcases.

This example is based on SQLite database system but the adaptation to other SQL database systems should not be a problem. To run the example you must first install the “sqlite3” ruby gem on your computer.

IV.2.6.1 Saving objects in an SQLite database
IV.2.6.2 Retrieving objects from an SQLite database