From ffe74b92dd79cf4c029c46d2ff33b6b71698330d Mon Sep 17 00:00:00 2001 From: Will Budicm Date: Mon, 26 Oct 2020 06:18:43 +1100 Subject: [PATCH] Upd to defaults. --- Current Development Check List.md | 8 +++---- Installation_ProgresSQL.txt | 38 +++++++++++++++++-------------- 2 files changed, 25 insertions(+), 21 deletions(-) diff --git a/Current Development Check List.md b/Current Development Check List.md index 4f15b18..f303080 100644 --- a/Current Development Check List.md +++ b/Current Development Check List.md @@ -8,12 +8,12 @@ * Static pages setting for the pages directory. * Search on multiwords should rank by encounter of words specified and display first. (That one is difficult) -* Multi db driver type support. Earth stage requires same SQL related code to work on at least one more DBMS type other than SQLight. - * PostgreSQL is most likelly candidate as MySQL is not easy to install for the average user. - * Developing and adopting to MySQL or any other system is not prerogative, as it works well as it is with inbuild simplicity. * Provide markdown text functionality to html pages. For quick vanila plain documentation. -* Auto collapse/epand on multi line logs by 0-none as default. Setting to 1 or more showes only that number of lines. (That one is difficult) +* Auto collapse/expand on multi line logs by 0-none as default. Setting to 1 or more showes only that number of lines. (That one is difficult) * ✔ Implement title bolding on logs using markdown, so tags can be avoided, for multiline logs. +* ✔ Multi db driver type support. Earth stage requires same SQL related code to work on at least one more DBMS type other than SQLight. + * PostgreSQL is most likelly candidate as MySQL is not easy to install for the average user. + * Developing and adopting to MySQL or any other system is not prerogative, as it works well as it is with inbuild simplicity. ### v.2.0 SUN RC2 Encountered diff --git a/Installation_ProgresSQL.txt b/Installation_ProgresSQL.txt index 6f30ad5..efe2f12 100644 --- a/Installation_ProgresSQL.txt +++ b/Installation_ProgresSQL.txt @@ -1,3 +1,24 @@ +# Notes + +ProgresSQL Server is a full database service solution (RDBSM). Handling interaction, like multipe enterprise schemas, databases, users and backups. +These all are and can be handled outside the scope of the LifeLog application. +However, it is not required or recomended to have a fully managed database system service, just to use for the LifeLog app. + + +Modify the following anon driver property tag in dbLifeLog/main.cnf to specify: +< + +The alias is by default assumed the actual database name as well as the user. + +Modify the following anon property, to have the SQL Server provide multiple users as different aliases to loging into specifed single database. +< +to something like, to make logins now database users: +< +Where 'lifelog' is the database. + +Hope all works for you, and happy logging! + + # Install ProgresSQL sudo mkdir /usr/include/postgresql sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main" > \ @@ -26,23 +47,6 @@ dpkg -i libpq-dev_12.4-1.pgdg20.04+1_amd64.deb ###Than run again driver install sudo cpan DBD::Pg; -# Notes - -ProgresSQL Server is an full database service solution. Handling interaction, like databases, users and backups. -These all can be handled outside the scope of the LifeLog application. -However, it is not required or recomended to have an fully managed database system, like this, -just to use the LifeLog app. - -Modify the following anon property tag in main.cnf to specify: -< -The alias is by default assumed the database name, and the user. - -Modify the following anon property, to have multiple users as aliases loging into same database. -< -to something like: -< - -Hope all works for you, and happy logging! -- 2.34.1