Datacentric group

* https://datacentric.group/

CRUD framework

* https://github.com/alexpdp7/v2f
* https://github.com/alexpdp7/zqxjkcrud

* A completely declarative SQL CRUD framework
** CRUD definition is done through SQL objects (schemas, views, etc.)
** Permissions
** Row auditing
** Multiple components
*** Server-side HTML frontend
*** REST API
** Commercial frontend for design

Federated real-time communications using open protocols

* https://github.com/alexpdp7/frtcuop

Pure HTML5 decentralized IM system

* https://github.com/alexpdp7/imnei

* Uses web push
* Conversations are URLs to be shared
* "User identity" is a private URL to be shared to handle multi-device
* End-to-end encryption
* Can have WebRTC audio/video
* Anyone could run its own instance, as it is clientless there is no friction to have multiple providers
* Broadcast channels to be a pseudo-social network

SQL Query tool

* ipython notebook style interface
* Backend + multiple frontends
** HTML/JS Frontend
** Curses frontend
** Native GUIs frontends
* Smart join completion

Parallel execution framework

* A tool to run stuff such as CI builds which need sophisticated parallelization
* Create differently sized resource pools (for CPU-bound tasks, "API"-bound, etc.)
* Local execution of workflows on a workstation, remote execution on a CI server
* Handle task dependencies and artifact passing from parent to child tasks
* Capture stdout/stderr of tasks, allow viewing in realtime
* Timestamp stdout/stderr for crude profiling
* Implement a CI system on top?

Development stack

* Easy to deploy modular platform of:
** Identity Management (FreeIPA)
** Git repo with code review (Gerrit)
** Ticketing system (Redmine?)
** CI (Jenkins)
** Binary artifact repository
** Monitoring system (Nagios)

Scalable personal cloud

* 1..n node VM/container hosting platform
* ZFS storage
** Use https://github.com/marcan/takeover.sh for easy set up of a ZFS mirror root system
* Automation ready (Ansible, Salt, Foreman, etc.)
* Monitoring friendly
* Apt for single public IP
** Integrated DNS/DHCP
** VPN interfaces
** Reverse proxies

Userland WASM Linux distro

* Bootstrap a Linux distro to run on WASM
* Should be able to run as a non-privileged user, installed in the user's home directory
* Focused on userland programs, not a full OS
* Should be able to run on non-POSIX filesystems
* Could replace Docker/containers for developers
* Similar to https://github.com/WAVM/Wavix

C64 Roguelike

Software development book https://github.com/alexpdp7/wakat

Development environment setup

* Spin a VM (locally or in the cloud) which runs your project
* Synchronized workspace using Syncthing

SQL2

* A new language that compiles to SQL
* Handles RDBMS differences
* Makes queries composable (e.g. declare a query object, then add paging/sorting, for framework usage)
* Declarative join via foreign key constraint names
* Better ordering for code completion (e.g. FROMs first)

See https://github.com/EvgSkv/logica

Streaming DB

* Simple relational database
* Can act as replication target of other databases
* Supports a limited SQL subset that can be easily reasoned about functional dependencies
* Can stream efficiently the results of an SQL query (e.g. keep a query running and receive new/modified rows)
* Supports efficient replication of a subset of a database (initial checkpoint + streaming or batched updates)
* Functional dependencies could be used to create materialized views *and* indexes

That's probably https://github.com/MaterializeInc/materialize , but it's not OSS.

Key escrow for everyone

* Easy-to-use key escrow/secret sharing
* Provide emergency recovery of passwords, keys, 2FA, etc.

Deterministic embeddable simple language for calculator and notebooks

* https://github.com/alexpdp7/plankalkul/ , that deprecated https://github.com/alexpdp7/pdp7_calc/ .