Difference between revisions of "User talk:Bucheron"
Jump to navigation
Jump to search
(Created page with "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 obj...") |
m |
||
| Line 19: | Line 19: | ||
Software I use: | Software I use: | ||
| − | + | * Proxmox | |
| − | + | * Nginx | |
| − | + | * PostgreSQL (PostGIS) | |
| − | + | * Java | |
| − | + | * Vert.x | |
| + | * Javascript | ||
Revision as of 12:57, 29 March 2019
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:
- Proxmox
- Nginx
- PostgreSQL (PostGIS)
- Java
- Vert.x
- Javascript
