Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The primary target technology for the database is Postgres.The , making use of JSONB feature to implement the expected entity extensibility mechanism is implemented using the JSONB feature of Postgres.

Other database support

...

Microsoft SQL-Server

Existing implementation Legacy implementations of openIMIS make use of Microsoft SQL-Server database.

The migration strategy puts the database migration to final stages (to ensure an iterative approach).

Early version of openIMIS supports SQL-Server.

(To be validated) The extensibility mechanism makes use of SQL-Server JSON feature.

Other

Support of other databases must be studied on case-pre-case basis. The use of an ORM framework (Django) is of great help in this area.

However, being database vendor-agnostic is not an easy task and requires many precautions.