michelpp

8 ms·

31.
by michelpp 2y ago
Sprouting is an excellent and compact way to get some fresh greens into your diet in a small space. No urine required (although I too do dump my urine on my farm hosts' compost). I live in a short school bus with less than 8sqm of spa
32.
by michelpp 2y ago
Thanks Paul! OneSparse author here, we're still in early dev stages (OneSparse requires some new features in postgres that won't be available until pg18) but my plan is to do a benchmark shootout with various graph tool for postg
33.
Postgres as a Graph Database: (Ab)Using PgRouting(supabase.com)
164 points by michelpp 2y ago|44 comments
34.
by michelpp 2y ago
Yep, it's a completely generic feature, and I'd argue the keyword 'SECURITY' is a noise word and 'LABEL' by itself would be even better, but that's what we're stuck with. As the documentation states:
35.
Nvidia's CEO says 'useful' quantum computers are decades away(finance.yahoo.com)
1 points by michelpp 2y ago|0 comments
36.
by michelpp 2y ago
The performance while querying sqlite objects with sqlite_query() is identical to that of using an in-memory sqlite database. once Postgres 18 is released which contains some specific optimizations around expanded datum lifecycles there wil
37.
Show HN: Postgres-SQLite: SQLite as first-class types in Postgres(github.com)
15 points by michelpp 2y ago|2 comments
38.
Steve Jobs adopted a no 'bozos' policy(fortune.com)
6 points by michelpp 2y ago|1 comments
39.
by michelpp 2y ago
A cool project with this would be 3D print a mini Connection Machine 5 (CM-5) model made out of Raspi CM5 modules. Some tiny led panels would be killer. https://en.wikipedia.org/wiki/Connection_Machine#/media&#x2
40.
by michelpp 2y ago
RLS is very useful and can solve multi tenancy and other problems, but it is complicated and can add a significant per row cost to queries if your policies get complicated. The common path of comparing some constant like the role name to so
41.
by michelpp 2y ago
With the expanded datum api you can also work with subscriptable array types to only expand elements lazily as needed. It might already works if you try it, but support for it might be hardwired only to nested stock arrays, something to lo
42.
by michelpp 2y ago
Here's an example of a simple expanded object to start from: https://github.com/michelp/pgexpanded
43.
by michelpp 2y ago
"War is diplomacy by other means" - Clausewitz
44.
by michelpp 2y ago
Then you need one wrapper per database, with this approach you can have one database per row.
45.
by michelpp 2y ago
I think the right approach would be to store the sqlite database as a varlena type that can be TOASTed and then "expanded" using the Expanded Datum API so that it's a live open database connection for the life of the transact
46.
by michelpp 2y ago
> Here we are talking of graphs in the milions nodes/edges, That ought to be enough for anybody. > would TC support that TC is a purely structural algorithm, it counts triangles so it doesn't take any weights into considerat
47.
by michelpp 2y ago
PageRank is one of several interesting centrality metrics that could be applied to a graph to influence RAG on structural data, another one is Triangle Centrality which counts triangles around nodes to figure out their centrality based on t
48.
by michelpp 2y ago
My twice reading list: - Godel, Escher, Bach - Hoffstadter - The Soul of a New Machine - Kidder - The Emperor's New Mind - Penrose - The Connection Machine - Hillis - Algorithmics - Harel
49.
by michelpp 2y ago
I got this out a bit early to get some eyeballs on it and open it up to community contribution. I have a branch in progress converting the various Python examples and notebooks we have over to SQL. So stay tuned. For docs the best referen
50.
by michelpp 2y ago
I'm extending Postgres with the GraphBLAS/SparseBLAS APIs for sparse and dense linear algebra operations directly in SQL with OneSparse. Like JSON/JSONB did for unstructured data, OneSparse does for matrices, vectors and lin
51.
by michelpp 2y ago
Hello HN! Six years ago I release a prototype integration of SuiteSparse as a Postgres extension, and it received quite a bit of attention here on HN. Since then I have gotten deeply involved in the GraphBLAS community, sitting on the C AP
52.
Show HN: OneSparse – Open Source Accelerated Sparse Linear Algebra for Postgres(github.com)
13 points by michelpp 2y ago|3 comments
53.
by michelpp 2y ago
I found my pic, they spelled my trail name a bit differently: https://athikerpictures.org/hikers/2329
54.
by michelpp 2y ago
I thruhiked in 1995, and while I did go to the ATC headquarters to sign in, I don't recall having my photo taken, but it may have been. I do however vividly recall the photo archive at Rusty's Hardtime Hollow just off the Blue Ri
55.
by michelpp 2y ago
An inexpensive 10 hole Hohner harmonica is a fun and easy way to learn a bit about music and self expression. when I was 10 my parents got me a book by Klutz Press, "Country and Blues Harmonica for the Musically Hopeless" that ca
56.
Berkeley Lab Introduces Specialized Hardware to Speed Up Sparse Computations(hpcwire.com)
2 points by michelpp 2y ago|0 comments
57.
by michelpp 2y ago
This is a nice blog and I like the versioning feature, if you're looking to explore this idea more I made a very simple unversioned FSM extension for Postgres years ago for fun and no profit: https://github.com/michelp&
58.
by michelpp 2y ago
Implement the GraphBLAS API of course! https://graphblas.org/
59.
by michelpp 2y ago
In Danny Hillis' lecture on the architecture of the CM-5 [1], he talks about some of the historical motivation behind the CM-2 described in his thesis paper turned into a book "The Connection Machine" [2] which goes into some
60.
by michelpp 3y ago
RIP Mr. Barth. I carried a dog eared copy of Lost in the Funhouse with me through 20 years of my life, picking it up and putting it down whenever I needed something to shift my perspective or jar me out of a rut. Psychoactive writing at i

More ›