tlarkworthy

You have to denormalize in very common cases even for mostly OLTP workloads in order to get sortable data into an index. Consider a cloud storage product with folders connecting with a many to one to documents. The product wants to display the most recently used folders ordered by their inner document modification date.

Because composite indexes commonly can't span tables, you have to push the last modification date up to the folder row in order to get the data in the right place to build the obvious index.

Denormalization is a normal and expected optimization to scale a relational database.

You need some actual tax advice. I deduct EU tax from my tax liabilities in US so my US tax exposure is exactly 0. Still have to file US taxes, so my accountant fee exposure is non-zero but it isn't too hard to do yourself once you have a few examples to copy from.

But zero is in the middle, so it must be odd

Lynxmotion is good for servos.

A problem only too familiar to observablehq users, there are quite a few solutions

https://observablehq.com/search?query=Cors&onlyOwner=false

It's got a better name called a transactional outbox https://microservices.io/patterns/data/transactional-outbox....

It has an equivalent but that code is typescript

JavaScript/lua are dynamic and they are fast. It's other choices (GIL) which cause problem rather than the nature of the dynamic language space

I am a paying PA customer and I love the service but I am kinda surprised they only just reached those figures. They have great market awareness in my circles but it just goes to show that developers are stingy and conservative and it's a hard market to do well in. If feel they should b making 10x this number by now given they are internationally known and the biggest alt to a gigantic usecase

People get confused by the wizardly and can't recognize that in many places they are already doing it. A resource orientated REST API is a great example of this paradigm. The API model is declarative... but you interface with it as sequential http calls.

So just do that in code signatures too.

the bridge is just a proxy, the volume if traffic is the same but you now have added a regional hop. Exposing your redis and postgres on the public web is not a good idea, but there are tons of internal usecases, and things like postgres actually have a security mechanism so its not default "insecure"

This would be so amazing. In order to access most vanilla services like redis, postgres etc. you need to deploy a bridge https://github.com/zquestz/ws-tcp-proxy

CloudFlare/Deno etc. all have these workarounds around tunnelling but all that would disappear with this protocol. I made a service for writing servers on the web (https://webcode.run -- somewhat abandoned at this point but it is still running), and a big problem with the approach was the web's inability to make TCP connections.

It was really small and German speaking and wonderfully low tech but not anti-tech. Parent run meant we had regular meetings and had to paint, clean, organise events and vote on executive decisions like buying a dishwasher. It was really intimate and my kids learnt German really well. It was a lot of overhead but it brought us into the community well. The teachers were really dedicated they were amazing. Best start possible. Parents regularly had tensions between them but this is the nature or a random sample of population, lol.

The website is still retro and bulky but at least the cert works! https://kila-mittenmang.de

The molecules in water are more dense than in air. They are talking about density not ratio (PPM)

I used them at my parent run kita in Berlin. Very cheap! I eventually moved them to hetzner due to ssl problems but they had good support and I kept the domain with them.

The music industry will not like this, seems like a short circuit around royalties and the value of a music deal with an artist.

Being dependant on a reliable internet connection sucks, especially when travelling. SSR just won't work for mobile. With offline first, the client is the lowest latency server possible. Yes you should sync too. Offline first, not offline only

It's obviously nonsense. The lowest latency cache and state storage is clientside. You can piss around with multi regions and SSR to minimize latency but that's just placing a lot of regional caches near your users. The nearest place is in their actual browser -> offline first is the future

What about importing sheets too?

I think https://observablehq.com notebooks are a step towards it. Once you get into it it has the fastest feedback loop I have ever experienced. The concept of reactively changing code with partial recomputation of the dependency graph is amazing.

I have done this myself and various tools e.g. slack, Twitter will truncate long urls. Eventually it will break somewhere, not just in the browser. If your tool has a hard limit on information content it's ok, but that does not seem to be the case here.

There is a size limit though that quickly gets exhausted if you are storing text (2000 chars)

I have a lot of trouble pipelining my commits when I get reviewer comments on an early branch, it's very error prone to squash the changes and distribute downstream to avoid merge problems later.

I think this tool is for me, am I able to adopt it without my team needing too?

I moved to Germany and find they are quite outspoken with enforcing community norms

Oh wow, their pyright-browswr package is very nice, the writeup works well!

Wow that's pure gold

It's written in Typescript I would love to type check python in the browser without running pyodine, does anyone know how?

True, the "well-known" path seems to be in a random location but maybe that's a problem with the spec, you might expect it to be off the root of the email domain.

Having worked in a successful developer tool (Firebase) this is utter nonsense. Developers are super cheap. People are ringing their hands over the 10 dollar per month copilot price for the world beat ai to help you code for Christ' sake.

All the books. I think books might be better