denorm
materialite
Our great sponsors
denorm | materialite | |
---|---|---|
1 | 2 | |
26 | 64 | |
- | - | |
0.0 | 9.1 | |
about 1 year ago | 16 days ago | |
Python | TypeScript | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
denorm
-
How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design
> Continuous aggregation
I found this to be a very common need, so I created [denorm](https://github.com/rivethealth/denorm) for doing this in vanilla PostgreSQL. (It also does incrementally updated joins as well.)
(I expect the performance of a native implementation to be superior. Unfortunately, I use managed database services.)
materialite
-
Ask HN: How Can I Make My Front End React to Database Changes in Real-Time?
Hey, Electric co-founder here.
Yup, our reactivity is quite simple at the moment, as described, and works quite well because SQLite is so fast. There are other projects doing more sophisticated reactivity algorithms, like Riffle/LiveStore, which has a reactive DAG optimised to avoid re-rendering and https://github.com/vlcn-io/materialite, which is like differential dataflow for live queries.
They're quite bleeding edge at the moment, but you can expect more efficient primitives for incremental view maintenance / efficient subscriptions to land in the embedded database layer quite soon.
Just also re: above, shape filtering for partial sync landed in v0.10 https://electric-sql.com/blog/2024/04/10/electricsql-v0.10-r... :)
-
Let's learn how modern JavaScript frameworks work by building one
I've stopped paying close attention to the web framework scene in the past couple of years, as most of the interesting ideas on this topics are usually coming from different communities. But as I understand, the majority of popular web frameworks (React, Vue3, Angular) are still using tree diffing or hybrid "signals"+tree diffing strategies.
In my opinion, one of the most interesting ideas to explore in this problem space is a hybrid solution: differential dataflow[1][2](model) + self-adjusting computations(view-model + view).
1. https://github.com/vlcn-io/materialite
2. https://timelydataflow.github.io/differential-dataflow/
What are some alternatives?
dev-setup - macOS development environment setup: Easy-to-understand instructions with automated setup scripts for developer tools like Vim, Sublime Text, Bash, iTerm, Python data analysis, Spark, Hadoop MapReduce, AWS, Heroku, JavaScript web development, Android development, common data stores, and dev-based OS X defaults.
butterfloat - The greatest view engine for the modern web
timescale-analytics - Extension for more hyperfunctions, fully compatible with TimescaleDB and PostgreSQL 📈
capable-js - An effect system for building multi-stage UIs, powered by async generators.
patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
pota - pota is a small and pluggable Reactive Web Renderer. https://pota.quack.uy/
full-stack-fastapi-template - Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.
pyar - Python program for aggregation and reaction