dagss

29 ms·

241.
by dagss 2y ago
This article details how certain russian trawlers criss-crossed a lot over another cable in Norway that broke some time before... ...and then the same trawlers were in the vicinity of this cable in Svalbard when another trawler criss-crosse
242.
by dagss 2y ago
This allows subscriptions of changes to individual resources... but is more general event streaming a goal? Could it become so? (as in, "give me updates to all resources", not just one). We have been using our own protocol "F
243.
by dagss 2y ago
But if you for instance use MS SQL and the uniqueidentifier type, sorted UUIDv7 is not sorted im the database because MS SQL swapsnthe bytes around. So ULID (stored as binary(16)) is an advantage in that case to avoid making that mistake. I
244.
by dagss 2y ago
1) I think a simple new kind of query hint could go a long way: Declare a table as being "infinitely large" from the perspective of the query planner. So, if a query caused a full table scan or similar against the table, it's
245.
by dagss 2y ago
We do the same thing with Microsoft SQL. Each time the hash of our migrations change, we make a new template DB. That takes about 30 seconds to run all our migrations.. If the hash didn't change, clone the template of the given hash. T
246.
by dagss 2y ago
The article is discussing the usecase where each test/set of assertions as a clean DB. I.e. hundreds of DBs per test run. Are you talking about a single DB reused for each test? That is of course no problem... Our suite spends 3 to 10
247.
by dagss 2y ago
I think the idea is to get a clean DB for every test in your suite. Your solution requires spinning up hundreds of docker images per test run.. We do the same thing as described with MS SQL; takes about 1 sec to get a fresh DB that way. Whi
248.
by dagss 3y ago
Yes, one could. The problem is most programmers who are not aware of this (probably most), will see the UUID and make assumptions that uniqueidentifier type is the most suited one. They are less likely to take a ULID and store it in binary(
249.
by dagss 3y ago
As a Microsoft SQL user (not everyone can choose their DB..), UUIDv7 has the issue that people will (understandably, but ignorantly) store it in "uniqueidentifier", which shuffles bytes around and are no longer sorted on time... .
250.
by dagss 3y ago
The Go way is to pass the long running goroutines a different ctx from the short running. Or even one ctx per goroutine and cancel them dynamically according to whatever logic.
251.
by dagss 3y ago
The convention of passing ctx does almost the same thing though. Make a new context.WitCancel and pass it to the goroutine. It just requires programmer cooperation, but as long as you pass ctx all through the stack down and handle err on th
252.
by dagss 3y ago
Making projects supportable is good. Not distinguishing between objectively bad code, and code that you just don't understand right away because you didn't write it yourself and you do not yet have enough training to skim and unde
253.
by dagss 3y ago
Exactly opposite in my experience. Seniors (10+ years experience) knows what programming language or library or paradigm or monolith or microservice you use isn't THAT important they all have their problems and everything is a tradeoff
254.
by dagss 3y ago
Have you even had a look at the graphs?
255.
by dagss 3y ago
Better for the few outside the tropics who will shut their borders to the sufferings of those in the tropics..
256.
by dagss 3y ago
Well that is what will happen.. one part of the world will get a more temperate climate and at the same time, quite literally, kill people in warmer parts of the world who contributed a lot less to the problem. I know you didn't mean i
257.
by dagss 3y ago
I don't think rooftop solar is that simple: 1) Does the extra cost of rooftop solar go to installers doing a lot more manual work per panel? Installers who need a source of income to live anyway?.. 2) As I see it a lot of the pollution
258.
by dagss 3y ago
This stuff has a latency measured in minutes though, limiting the usecases a lot.
259.
by dagss 3y ago
I feel the best abstraction for hints would be to declare on tables how large you expect them to be -- and even throw errors if query plans with a good scaling cannot be found. Say I could declare "assume this table will grow very la
260.
by dagss 3y ago
Unpoly too (very similar to htmx but the small difference makes it a lot more convenient I feel, I wonder why Unpoly isn't getting as much traction as htmx)
261.
by dagss 3y ago
...but by trying to avoid the bottleneck and moving things to backend, you make things 10x worse resource wise for the DB. So it is not a easy tradeoff. Take any computation you can do in SQL like "select sum(..) ...". Should you
262.
by dagss 3y ago
I thought event sourcing as a data storage strategy and queues as an execution model were orthogonal concepts?
263.
by dagss 3y ago
> If we were 500 million globally, for instance, we would not be having this discussion because there would be no problems. I think even 500 million is too much with current lifestyles. Given that a very large proportion of cur
264.
by dagss 3y ago
> The issue is the global population. Obviously, that's the metric that matters for global issues like the climate and environment. No. "Obviously", the metric that matters is emissions. Or, the integral sum(pers
265.
by dagss 3y ago
I think there's 2 topics that need to be held apart here: 1) Limiting number of children in rich countries. This is what your links talk about I think. Yes, perhaps there is a taboo in place here. Is that relevant to sustainability cri
266.
by dagss 3y ago
> because it tells me that the people promoting the crisis see evidence in everything, Are you saying you really believe that academic papers studying the GLOBAL temperature are using individual local weather events as evidence? That if
267.
by dagss 3y ago
1) No, no local or short-term weather is ever going to falsify or prove anything about the global average . 2) Assuming you are already convinced by the science that the global average temperature is quickly rising; one might ask: What
268.
by dagss 3y ago
My bet is probably 90% (99%?) of home charging is done at 7.2kW or less. 7.2 kW is in the higher end, not "awfully slow". Myself I often charge at 3.6 kW.
269.
by dagss 3y ago
If you know something will happen it is not an edge case, at least how the word is commonly used. Doesn't matter how often. System A delivering its event after system B may be an edge case. Daylight saving time computations are not han
270.
by dagss 3y ago
The point is that the way it is now, you have to guess 3 significant numbers and 3 insignificant numbers. Guessing whether 1st, 3rd or 5th digit is 5 or 6 is something you can be trained for, a skill. Guessing the 2nd, 4th, or 6th digit is

More ›