User talk:Bucheron

Well, this is the place where you can chat with me !!

My vision of pdb:

• a central RDBMS managing one or more databases
  • databases with strong long-term definitions of object classes
  • with event data synchronization capability on regional "slave" servers
• Dedicated projects separated by "domain of interest", each implementing services or micro-services on https servers

(for example, interaction with the public, interaction with "manufacturers", synchronization with external data, media management, authorization management, etc.)

• authentication with key (HTTP header)
• role-based authorization

My doubts:

• Is it a good idea to split the "attributes" of an object into two parts:
  • id (PK), uniqueName ... in SQL columns
  • variable attributes (nullable) in one or more JSONB columns
• how to manage object "variants"

Software I use: - Nginx - PostgreSQL (PostGIS) - Java - Vert.x - Javascript