OSINTBuddy

OSINTBuddy Ideas/TODOs

• Integrate hstore/use JSON to store entity settings

  • hstore

• Consider adding geospatial support to client, rust backend, and postgres db:

  • postgis: support for storing, indexing, and querying geospatial data.
  • earthdistance: calculate great-circle distances
  • What would this look like client side? Maybe add a geopoint type field to entities? Add a world map to display geopoint enabled entities on? Hmmm

• Add/improve searching

  • pg_trgm: support for similarity of text using trigram matching
  • PGroonga
  • pg_search

• Add admin dashboard showing web server stats and db stats, could maybe use:

  • pgmetrics: Easily collect and report PostgreSQL metrics for scripting, automation and troubleshooting.
  • pg_stat_statement
  • bg_mon
  • postgresql-metrics

• Add support to store all types of files:

  • file-fdw
  • ddl-foreign-data
  • dc_fdw
  • git_fdw
  • parquet_fdw
  • sqlite_fdw
  • zipfile-fdw

• Add audit logs:

  • pgaudit: open source audit logging
  • pgMemento

• Investigate what adding encryption entails and how that would work with the apache/age postgres graphs:

  • acra: application-level encryption for data fields, multi-layered access control, database leakage prevention, and intrusion detection capabilities
  • pgcrypto