Ideas

Some Ideas

Sketching with ideas across the whole stack…

OSIB: Plugin Ideas

• Searxng

• Shodan

• …

OSIB: Client Ideas

• Visual entity builder, drag and drop then label input fields for entities. Automatically generate the Python code for these visual entities

• Visual entity function builder/connect transforms to different entities?

• …

OSIB: Database and Backend Ideas

• Continous graph monitoring to pull fresh data (mark and remove dupes)

• 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