Database Access And Migration

[u-ways]

Development of Database support, mapping and migration.

• Research a suitable database driver in Deno.
• Research a suitable database migration tool in Deno.
• Implement boilerplate for above tasks
• Do a risk assessment on the driver and tool used.

Currently, no final decision has been made to whether we should use an SQL or NoSQL Database.

[u-ways]

Research

List of possible databases to use with Deno:

• MongoDB: NoSQL, widely used and well supported across several cloud platforms.
• Postgres: SQL, great relational database management system emphasising extensibility and SQL compliance.

Deno does not have an official driver for either. So we found community-developed drivers for each:

• MongoDB: manyuanrong/deno_mongo
• Postgres: deno-postgres/deno-postgres

deno_mongo findings:

Unfortunately, the deno_mongo driver is a port of MongoDB Rust Driver: https://crates.io/crates/mongodb As such you will need to use the --unstable flag in Deno to --allow-plugins (i.e. Rust code). This caused other dependencies breaking because unstable features were enabled and thus causing conflicts with exiting code.

deno-postgres findings:

The chosen PostgreSQL driver for Deno is based on node-postgres and pq; Two popular and stable Postgres libraries. It has a great community and under constant development and maintenance. PostgreSQL also supports json_columns and has a row_to_json() function which will suffice for our needs for GraphQL based API that serves JSON.

Risk assessment:

• The module community is healthy. (at the time of writing, the module is the most starred Deno PostgreSQL driver)
• The framework has adequate documentation with example snippets and external learning resources.
• Since the module follows node-postgres conventions. Switching to Node.JS will be straightforward if we used node-postgres (our Node.JS alternative)

[u-ways]

@U-ways & @brett-taylor

• Database integration
• Nessie Database Migration Service

Changes:

• Added Postgres Database integration.
  • Created a pooling connection client.
  • Database configs can be found at database.config.ts
• Add Nessie database migration service.
  • Added README examples for how to create migration and seeding tasks.

[adamJUK]

Looks good.