samwillis

12 ms·

91.
by samwillis 2y ago
Very much this! I was also at a thing at their office a few weeks ago (some thing? "Local Thirst"), and Steve gave a demo of this. It is incredible. I've joked before that the last generation of human machine interfaces ware
92.
by samwillis 2y ago
This is a great article. There was a previous attempt to bring async io to Postgres, but sadly it went dormant: https://commitfest.postgresql.org/34/3316/ A more recent proposal was to make it possible to swap out
93.
Bad Keming – Where kerning's so bad it's keming(badkeming.com)
8 points by samwillis 2y ago|1 comments
94.
by samwillis 2y ago
Hey, it's possible to use PGlite on the client, along with Drizzle. Our "Linearlite" example show this (albeit without Drizzle) with a "write through the database" pattern to sync back to the server. Live demo: htt
95.
by samwillis 2y ago
Dynamic linking on iOS is complex, and Android also brings some toolchain complexities. It would be possible to do a native build and link it, and that is a route we are also exploring, but a single C file that can be linked with any existi
96.
by samwillis 2y ago
A couple of things here: - the WASI build is targeting WASI snapshot preview 1, and so should work in any compatible runtime. - for the web, currently we use Emscripten, but we are considering moving to a single WASI build there as well. We
97.
by samwillis 2y ago
It's similar (ish), but I think unfortunately the comparison distracts from your core point and observation. Musk Inc. is, in essence, a privet equity company. He raises a fund, and invests it along with his own cash into a business he
98.
by samwillis 2y ago
Yep, there are on-shore plans, but there is a lot of NIMBYism that results a resistance to these necessary projects.
99.
Playground Wisdom: Threads Beat Async/Await(lucumr.pocoo.org)
171 points by samwillis 2y ago|97 comments
100.
Let's unite the startup ecosystem in Europe with a standardized ‘EU Inc'(eu-inc.org)
15 points by samwillis 2y ago|4 comments
101.
Hybrid Search with PostgreSQL and Pgvector(jkatz05.com)
35 points by samwillis 2y ago|1 comments
102.
CMA objects to Google's ad tech practices to help UK advertisers and publishers(gov.uk)
3 points by samwillis 2y ago|0 comments
103.
by samwillis 2y ago
Richard Hipp, creator of SQLite, has implemented this in an experimental branch: https://sqlite.org/forum/forumpost/5f218012b6e1a9db Worth reading the thread, there are some good insights. It looks like he will be
104.
by samwillis 2y ago
I love this explanation. It's interesting to consider the question of what this would look like if you put Postgres, rather than SQLite, in process? With PGlite we can actually look at it. I'm hesitant to post a link to benchmarks
105.
by samwillis 2y ago
While both points are true now, there is a lot of work happing to bring both column storage and separate compute and storage to Postgres. The pg_duck project has the eventual aim to implement a column storage engine for Postgres. There are
106.
NASA Decides to Bring Starliner Spacecraft Back to Earth Without Crew(nasa.gov)
197 points by samwillis 2y ago|2 comments
107.
by samwillis 2y ago
This is super cool, love these sort of projects. It's crazy what you can achieve with typescript types, what about inferring sql query results types from a raw sql query string: https://github.com/nikeee/sequelts
108.
UK's Browser and Cloud Investigation may fail to allow Web App competition(open-web-advocacy.org)
2 points by samwillis 2y ago|0 comments
109.
by samwillis 2y ago
Sadly I don't think this would happen, particularly if Ordnance Survey is responsible, all their data is paid for access. We have a very different model for access to data produced by government agency use to that in the US. USGS Topog
110.
by samwillis 2y ago
Yeh, I don't think it's the tech choice that's the problem. It's the choice to change the tech that has caused this. A clean rewrite of a wireless networking stack that does real-time synced audio streaming and devic
111.
by samwillis 2y ago
This is a really good summary of what's technically changed inside the Sonos system, and how it's caused a lot of these problem: https://www.linkedin.com/pulse/what-happened-sonos-app-techn... Essentially the
112.
by samwillis 2y ago
This looks like a great task queue, I'm a massive proponent of "Postgres is all you need" [0] and doubling down on it with my project that takes it to the extreme. What I would love is a Postgres task queue that does multi-st
113.
by samwillis 2y ago
Yep, we are actively working on native support. (I work on PGlite)
114.
by samwillis 2y ago
The virtual dom makes implementing a declarative templating system easer, and declarative templates are easer for a developer to reason about, and less error prone, than having to mutate the dom directly. People often mistakingly describe t
115.
by samwillis 2y ago
Redis is a very different database, I'm not sure you could do a comparison that was meaningful in any way.
116.
by samwillis 2y ago
No branch yet, we're still in the early research and experimental stage.
117.
by samwillis 2y ago
Yes, they should all work. We save the query as a view and then introspect it to see what tables it depends on. It then uses pg_notify to watch for changes. The plan is to integrate pg_ivm ( https://github.com/sraoss/pg_
118.
by samwillis 2y ago
Ah, screen shot is out of date. We are on v16.3.
119.
by samwillis 2y ago
This is high on my list, I have a few ideas how to do it, one being a "PL/JS" extension that calls out to the host JS environment to run JS functions.
120.
by samwillis 2y ago
We have the (accidentally undocumented) execProtocolRaw api that lets you execute Postgres wire protocol messages. If you use that you can then use a Python Postgres wire protocol lib to get all the type support.

More ›