Ideas

Btw, I probably won’t build most of this and some of the ideas are awful and or not feasible, think of this as a place for brainstorming…

Some Ideas

• chord and sankey diagrams: https://onlinejournalismblog.com/2020/06/08/a-journalists-introduction-to-network-analysis/

• https://stackoverflow.com/questions/6365710/database-content-versioning#12611949 - https://wiki.postgresql.org/images/6/64/Fosdem20150130PostgresqlTemporal.pdf - https://ashimabha-bose328.medium.com/temporal-queries-made-easy-working-with-time-based-data-in-postgresql-823b1073d9e1

• visualize data via method of loci?? hmm, humans are really good at remembering spaces and there’s already the idea of “memory palaces”. How could I take advantage of spatial memory for other purposes? - https://drossbucket.com/2021/06/30/hacker-news-folk-wisdom-on-visual-programming/

• for shared reports/public cases have an opinion spectrum - inspired by: https://sonny.alvesdi.as/how-to-run-an-se-spectrum-online

• finish integrating https://react-tooltip.com/docs/getting-started

• heatmaps would be cool: hover to see heatmap ui

• colored edges according to source entity color: hover to see colored edges

• hmm, maybe I could approach geopoints somewhat like this: hover for map idea

• what could I bring to the table by having both context menu (right click on entity) transforms and a “advanced transforms” panel? example of “advanced transforms” panel

---

• for notes add ability to toggle “cursor highlighter” aka visualize attachments? https://codepen.io/ig_design/embed/KKVjpXx?height=508.42578125&theme-id=39533&default-tab=result&slug-hash=KKVjpXx&pen-title=Custom%20Cursor%20Effect&editable=true&user=ig_design&name=cp_embed_5 on second thought this doesnt seem like a great idea but Ill keep it here
• more visual programming inspiration: https://botwiz.dev/
• https://liambx.com/blog/tuning-edge-animations-reactflow-optimal-performance
• draggable edge labels example, seems nice to have: https://github.com/Mimi848/Reactflow-Portfolio/blob/main/src/Examples/DraggableEdgeLabels/ButtonEdge.tsx
• https://retool.com/workflows - i need functional nodes too, hmm
• code base visualization should be possible if I build out the plugins correctly: https://github.com/mitate-gengaku/Repree
• cool metadata handling ideas and inspiring UI here: https://open-metadata.org/
• submit OSIB to https://wbkd.notion.site/17bf4645224281e4bf61ce34fa671059
• powerpoint, and pdf export are neat ideas: https://www.juristic.io/products/structure
• update docs with manifesto/principles page - https://doubleloop.app/principles
• SSO integrations
• spend more time researching encryption at rest and in transit and pros/cons of doing so
• Finish integrating ABAC
• achieve SOC-2 Compliance
• “62/108 issues 57% \ in progess” https://doubleloop.app/ - add progress for generator transforms on a plugin

---

• https://www.langflow.org/ this UI looks sweet, making me think I should hire a designer to get my UI colors and whatnot looking right
• named groups? https://www.otelbin.io/
• https://github.com/target/strelka-ui
• https://hirinfotech.com/visual-web-scraping-your-2025-guide-to-no-code-data-extraction/
• https://github.com/paradedb/paradedb
• a thing which provides briefs for entities/graphs (and topics?) (aka feeds?)
• a thing which allows entity transclusions
• add hindsight bias for market overview page
• a thing which allows you to attach notes to entities
• a thing which provides grouping/“breadth first” for entities
• a thing which allows graphs to be shared publically, potentially could crowd source annotations as on Genius / Hypothesis
• a thing which “programs your attention” through spaced repetition aka designing the environment to modify the users attention. Think: “{cron} for your entities and entity notes”
  • Systematically, we can generalize spaced repetition to:
  • a priority queue of entities
  • an interactive environment which presents sufficiently high-priority tasks
  • feedback actions which modify a things subsequent priority
• https://github.com/openreplay/openreplay/ - prompt users and ask if we can enable openreplay?

OSIB: Plugin Ideas

• Searxng

• Shodan

• + Many other sources from that OSINT book I have…

OSIB: More 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?

• 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