status.txt

Still in prototype status

Todo:
=====
* Access rights GRANT for user not enough (i.e. Schema) - i.e. tambora
* dump directory?
* Daily dump - Permission of directory cre/postgres/dump/db/....    check write access before init db
* Check init db
 * init from bz2-file -> bzip2 -dk file.bz2  / gz -> tar -xvzf file.tar.gz
 * BUG: init of multiple dbs. !!
* Citus
* POSTGRES_EXT allows to access DB for user globally by proxy/url (todo: specify list of dbs) 



* RabbitMQ
 https://github.com/gmr/On-Rabbits-and-Elephants
 https://livebook.manning.com/book/rabbitmq-in-depth/chapter-10/71

* https://blog.timescale.com/blog/top-5-postgresql-extensions/amp/
 ZomboDB, TimescaleDB
 https://github.com/zombodb/zombodb


* possible extensions
 * https://www.marktechpost.com/2024/06/11/a-new-era-ai-databases-postgresql-with-pgvectorscale-outperforms-pinecone-and-cuts-costs-by-75-with-new-open-source-extensions/
  * https://github.com/timescale/pgvectorscale
  * (https://github.com/timescale/pgai)

 * https://github.com/sraoss/pg_ivm  (make materialized views up-to-date)




---
Add new container for pgadmin
https://www.pgadmin.org/download/pgadmin-4-apt/

How to store csv...
https://www.postgresqltutorial.com/export-postgresql-table-to-csv-file/
COPY persons TO 'C:\tmp\persons_db.csv' DELIMITER ',' CSV HEADER;
---

Security:
#openssl
https://adamtheautomator.com/postgresql-ssl/
#kerberos?



 Done:
 =====
  * CREATE EXTENSION cube;  https://www.postgresql.org/docs/9.4/cube.html  (max 100 components)  
   Usage:
   * Vector Space NN
    * cube extension  https://www.postgresql.org/docs/10/cube.html
    * https://github.com/netrasys/pgANN
    * https://dba.stackexchange.com/questions/163207/quick-nearest-neighbor-search-in-the-150-dimensional-space