Document Store

This project is a sample for document store database, using:

• Postgresql
• Marten

it shows:

• Sub class (Issue)
• Sub array (Assignee)
• Inheritance (Smurf)
• Indexing sub array (Mapping)
• Indexing text (TextSearch)

---

Postgresql

• Jsonb functions
• sub-array filter
• Index types
  • gin index
  • full text search index
  • similar text index (functions)
• index usage

need pg_trgm extension

Marten

• Docs
• Query
• Include
• Inheritance

Id generation

• marten identity
• hi-lo algorithm
• int/long vs uuid/guid
  • stackoverflow
  • usage => Integers Internal, UUIDs External

Migrations

Marten migration

-- rename column
update example
set js = js - 'old' || jsonb_build_object('new', js->'old')
where js ? 'old'

-- transform array<T> to T
update example
set js = jsonb_set(
            js #- '{prefixPath,old}',
            '{prefixPath,new}',
            js #> '{prefixPath,old,0}') -- take only first item
where js ? '{prefixPath,old}'

Note

• Include with JoinType.LeftOuter and dictionary fails
• IsOneOf for array using include fails
• Containment where clauses