Difference between revisions of "User talk:Bucheron"

From paradatabase
Jump to navigation Jump to search
m
 
(2 intermediate revisions by 2 users not shown)
Line 19: Line 19:
 
* is it possible utilize a world-wide unique product-id
 
* is it possible utilize a world-wide unique product-id
 
* where to place internationalization (database or file-system)
 
* where to place internationalization (database or file-system)
* do we need to manage "distributors"
 
 
  
 
== Softwares I use ==
 
== Softwares I use ==
Line 34: Line 32:
 
* Mattermost
 
* Mattermost
 
* Zimbra
 
* Zimbra
 +
 +
<br><br><hr>
 +
[[User:Lx&#38;R|Lx&#38;R]] ([[User talk:Lx&#38;R|talk]]) 08:12, 1 April 2019 (MSK)
 +
:: It's a kind of discussion that should be made point by point and not right now.
 +
:: Our plan:
 +
::# Domain name and hosting
 +
::# People are starting to fill in the database
 +
::# The database begins to be in demand.
 +
::# We are expanding hosting options
 +
:: Wiki is a powerfull engine: [https://en.wikipedia.org/wiki/Special:Statistics Wikipedia statistics]
 +
 +
<br><br><hr>

Latest revision as of 03:16, 2 April 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

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

  • authentication with a key in HTTP header (no session)
  • role-based authorizations


My doubts

  • Is it a good idea to split the "attributes" of an object into two parts :
- id (PK), uniqueName ... in SQL columns
- attributes "nullable" in one or more JSONB columns
  • how to manage object "variants"
  • how to define "family", "category", "type", "group", "product" ... for an efficient hierarchy
  • is it possible utilize a world-wide unique product-id
  • where to place internationalization (database or file-system)

Softwares I use

  • Proxmox
  • Debian
  • Nginx
  • PostgreSQL (PostGIS)
  • Java
  • Vert.x
  • Javascript
  • Gitlab
  • Redmine
  • Mattermost
  • Zimbra




Lx&R (talk) 08:12, 1 April 2019 (MSK)

It's a kind of discussion that should be made point by point and not right now.
Our plan:
  1. Domain name and hosting
  2. People are starting to fill in the database
  3. The database begins to be in demand.
  4. We are expanding hosting options
Wiki is a powerfull engine: Wikipedia statistics