vaughan

28 ms·

241.
by vaughan 5y ago
The voltage regulator module serves both CPU and GPU so the thermal issues are related.
242.
by vaughan 5y ago
> my laptop feeling laggy overall Run `sudo watch -d -t -n1 thermal levels`. When levels are above 100, your laptop will throttle. Once they return to 100, throttling will cease. There is a back-off algorithm at play too, so its not good
243.
by vaughan 5y ago
Disable turbo boost. Throttling is not directly linked to any temperature sensor, and turbo boost almost instantly causes throttling, which then takes some time to return to normal because of a back-off algorithm.
244.
by vaughan 5y ago
Tip: Run `sudo watch -d -t -n1 thermal levels`. Throttling occurs when these values go over 100. Throttling is not directly linked to temperature. There is some kind back-off algorithm that means that even if you trip this thermal throttlin
245.
by vaughan 5y ago
Some tips on throttling problems: First, disable turbo boost. Second, point a desk fan at your MacBook. Third, eliminate processes that peg the CPU. --- How to know when it is throttling: Download Intel Power Gadget and watch the Frequency
246.
by vaughan 5y ago
The canvas actually seems less performant when I compared it now. Scrolling is not as smooth. Click `Save as copy` and try it out.
247.
by vaughan 5y ago
If you click `Save as Copy` on the example doc you get an editable DOM-based version to compare. The scrolling is a lot less smooth on the canvas than the DOM. Text selection seems faster but the canvas version is not editable... Maybe they
248.
by vaughan 5y ago
Yeh this is missing right now. I'd love a search indexer that runs locally and incrementally, so that I can search without building/publishing.
249.
by vaughan 5y ago
Combining TypeScript's API Extractor (Microsoft) with Docusaurus is great. You can mix guides/tutorials with generated API docs. For example, I really like having simple API docs in the `readme.md` file, but then also in-depth doc
250.
by vaughan 5y ago
Awesome stuff! Wish someone would do this for Logitech Harmony remote controls. 1. The software was terrible but hardware was awesome. 2. The entire line is discontinued.
251.
by vaughan 5y ago
A counter point would be to look at the Python ecosystem. They have many fewer libraries but the ones they have are very well maintained and widely adopted. JS/Node is full of unmaintained projects that people inevitably need to migrat
252.
by vaughan 5y ago
I feel like there just needs to be a good plugin that gives you proper stats as to how long things are taking and tips to improve things. It’s usually slow css loaders, or too-inclusive patterns for loaders ending up processing node_modules
253.
by vaughan 5y ago
I find it useful to have my vendor dependencies compiled and watched for debugging. There are always bugs in deps or poor error messages, and sometimes the dev tools debugger doesn’t work properly, so being able to modify a dev is nice. Of
254.
by vaughan 5y ago
It’s called incremental view maintenance. Check out: https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...
255.
by vaughan 5y ago
It's surprising that graph dbs aren't more popular. Just as document dbs can be derived/denormalized from SQL dbs, relational dbs can be derived from a graph. Conceptually, data is a graph. I always find the decision between
256.
by vaughan 5y ago
I was thinking today we need a communal collection of diagram templates that we can reach for instead of re-making our own each time. I shouldn’t have to re-adjust my mental model because of some stylistic/level-of-detail decisions by
257.
by vaughan 5y ago
It's probably the simplest solution if you are running batch job once per day. Just ensure you are running one query per filter set, and you have your indexes setup correctly. Maybe you could speed up your queries by using a materializ
258.
by vaughan 5y ago
This approach would be cool if it ran on a database on the frontend too. You could run a complex query against an in-browser DB with a few joins and some params, and then tweak the params, and it would only need to pull down the missing row
259.
by vaughan 5y ago
> I'm curious to hear more about this I think the [FoundationDB layer concept][1] said it well: "When you choose a database today, you’re not choosing one piece of technology, you’re choosing three: storage technology, data mod
260.
by vaughan 5y ago
> If you cannot refresh all of the views, at a single point in time, then there will be internal inconsistencies in your dataset. In the simplest case, I'm talking about regular SQL non-materialized views which are essentially inlin
261.
by vaughan 5y ago
Very clever approach and a great overview of the solution space. > We made significant investment in investigating this approach coupled with basic incremental updating and have a few small projects in production that takes an approac
262.
by vaughan 5y ago
> the right way Yep. I meant it was easy to do it the inefficient way where you just refresh the entire query when any table mentioned in the query changes. You would just have to also check if something was a view and recursively parse
263.
by vaughan 5y ago
Take a standard M-M join where an `Item` can belong to many `Lists`. select l.name, i.name from list as l inner join list_items as li on li.list_id = l.id inner join items as i on i.id = li.item_id where items.completed =
264.
Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?
200 points by vaughan 5y ago|104 comments
265.
by vaughan 5y ago
I miss Backbone too. You could just step through the code in the debugger and it was so compact. With React you can’t really do that. It’s always following an error message saying: “look near this component” which is often deep in the hiera
266.
by vaughan 5y ago
I keep sayin' it - SQL in the browser! I'd love to get rid of all these client-side state management libraries and just drop an SQL DB in there and allow components to subscribe to changes to queries on record updates, and then sy
267.
by vaughan 5y ago
> if you're trying to keep things in sync efficiently I think we are all abusing GraphQL in this sense. Caching GraphQL data is a world of hurt. The easiest way to sync is if your data is in the same model as the way it is stored, w
268.
by vaughan 5y ago
> A typical programming language can express all that SQL can. In a way, an ORM is a cross-compiler from your programming language to SQL. SQL has always been a sort a magical, black-box in that you have very limited control over the que
269.
by vaughan 5y ago
Would be interested in hearing what database and query language you think are better?
270.
by vaughan 5y ago
I think its unfortunate that Prisma is only server-side due to its Rust-based native DB module. I think we can achieve a huge simplification in the industry if we develop a universal state-management solution that runs in the frontend and b

More ›