skysight-inc/HackerNews huggingface dataset:
I love postgres too. We went from a brittle event sourcing architecture to postgres_fdw, works really well.
We do something similar with a few differences:

We swap entire schemas on every run (one schema being one upstream database or collection of analysis) atomically instead of deleting data and then inserting data. This means anyone querying the dw never sees an empty table, it's yesterdays data until instantly its todays data, consistently for the entire source. If something breaks the data is just stale, never missing.

We don't do long running selects from foreign tables. This is because a long running select of a huge table can take many minutes. If an upstream database deploys a migration which changes the database schema that migration could time-out and stop the deploy while waiting for the select to finish so it can aquire its ACCESS EXCLUSIVE lock. This means we never hold even ACCESS SHARE locks for more than a couple of seconds. Basically the agreement is "the DW should never interrupt the operation of the upstream databases". We do this by a custom batched_create_table_from procedure. For integer id tables it's trivial. For uuid tables we fetch all the uuids in one go into a temp table with an integer id and then get chunks of uuid values at a time. This works well because we're always sending indexed id values to the foreign server so the foreign server can use its primary key indexes to only give us the data we want for that chunk, without scanning the entire table. It's a bit of a hack and I wish postgres_fdw's fetch_size parameter would release locks between fetches. Of course that would break atomicity so I'm doubting it's gonna happen.

We run an external cron schedule which launches an ECS task that runs a bash script with our sql files that define the DW's schema. It's a really primitive DAG with bash & and wait. No scheduling happens in the db itself. This means we can schedule, check logs, monitor, etc like all our other ECS tasks. Some bash magic lets us define basically a DAG, though we run blocks of independent tasks (sql files) instead of building a proper dependency tree between individual tasks.

I learned about ctid recently, that could have worked for the chunking.

We're currently moving to bigquery and DBT for a few reasons. Primarily to be able to handle silly amounts of user interaction data where the experience for analysts is just much better in bigquery. DBT is also really nice, though I do miss the simplicity of just sql files. The development setup for the old DW relied on rebuilding it locally on a developer machine, which eventually ran into storage limitations and people getting lazy and not rebuilding from scratch before submitting their PRs, we just never got around to building proper CI for it. Rebuilding our postgres DW from scratch takes a few hours now, the same logic in bigquery runs in 10 minutes, which is undeniably amazing.
Here is the COVID-vaccination rate across Europe

https://www.statista.com/statistics/1196071/covid-19-vaccina...

I see no correlation
You can try yourself here: https://wyclif.substack.com/p/thought-bubble-mcgonagall-or-c...
Is the pi usually on it's own power supply?
Egypt – Fall of the Pharaohs [audio]
I've been resisting the urge to splurge on an Apple TV to try and solve this particular problem. Useful to know!
So block him?
Location: Turkey

Remote: only option (international travel every 2-3 months is possible)

Schedule a chat: https://calendly.com/gkemaldag/interview-with-kemal

Willing to relocate: No

Technologies: Kubernetes, GCP, Node.js, React.js, Terraform

Linked.in: https://www.linkedin.com/in/kemaldagdotjs/

email: gkemaldag@gmail.com

I'm a math graduate, self-taught myself programming. I'm in the web development business for over 13 years. I've been working in every part of the stack, but last 6 years is focused heavily on SRE/Platform Engineering/DevOps related work.
If you're using a VPN already, youtube won't block you for using an adblocker. At least, not if you don't use an account. I definitely spend less than a dollar a month in time spent keeping my adblocker working, I haven't fiddled with it in years...
The middle-finger update seems to be geo-fenced. On my fully updated shield, the launcher is almost the same as the original one -- it just got a new apps tab on the top; no recommendations, no ads. So hopefully it will stay that way.
The web platform is not defined as “whatever Google chooses to implement”. It’s a collaborative effort.

All of those browsers use Blink, Google’s rendering engine. It’s one single implementation. Something needs two independent implementations to become a web standard. If you look at the specifications, they will explicitly state that they aren’t standards.

An interoperability project isn’t going to consider working on things that have been explicitly rejected by every implementer but one. That’s not how interoperability happens.

Google need to go back to their specifications and resolve all the security and privacy problems with them so that they can convince at least one other rendering engine to implement them. If they can't do that, there’s no chance they are candidates for interoperability work.
Why do you say that?

I don't think the Youtube product managers really care enough about Vision Pro to prioritise making an app for it. That doesn't mean they strategically disgree with the product and actively wish to hamper it.

Indepedently of Vision Pro, I think they just might not be that enthusastic about third party youtube apps.
9 industry experts share advice on buying space technologies in 2024
Return to Office mandates boost company profits? Nope
The main consequence to him so far has been a lot of people thinking less of him. It was also consequential for the subjects of the tweet, and to a much lesser extent, to all of us who've been exposed to it.
Puff of smoke and a flash of a mirror. There's nothing in that "paper".
Its more than just regulation, have you seen your login system. You have to login and pick another product to login. It's just so clunky compared to how it started out. Its like your team has never used your own product as a customer. Before you explain why its like that, i'll tell you - it's some internal reason to do with your team or internal structure that your customers don't care about & will never see.

Just curious as well, how many legit companies percentage wise are there vs the spammers - that makes it hard for most customers vs the spammers.

I'll see if I can write in, fyi we signed up to Messagebird first over 6 years ago so have seen it deteriorate as a product over time.
SEEKING WORK | France | Remote (anywhere)

I'm a senior backend developer : mostly Ruby on Rails and Python / Django.

I prefer medium-term contracts where I help out backend teams that have hiring difficulties. I really enjoy mentoring junior devs and fostering best practices. I love to figure out odd bugs and set up tooling to improve codebase health. I like to travel so I'm all for meeting the team when starting the contract and from time to time.

I also do short-term contracts, mostly where I build protoype apps (full-stack with React or Vue) or set up scraping scripts.

LinkedIn: https://www.linkedin.com/in/erwan-keribin-a837a084/

Email: [removed because spam is still a thing]
Sensitive Information Exposed at Test
I like your illustrations.
You could imagine a situation where they can do that.

But practically what happens is the phone connects to a sat, the sat connects to a local ground station, then across conventional fiber to another ground station, up to a sat and then down to the other phones.

The are likely doing that because regulation and so on. But the do what you suggest.
You shouldnt leave a cat alone for that long anyway for that to become a concern. Indoor cats become bored very quickly if they dont get enough playtime
Being usable was largely about timing, though.

None of the choices that compromised our device - or those of most of our competitors - were choices we made because we thought they were right, or best, but because we were forced to by timing and what was available at what cost, and failed to realize that the result was too compromised to stand a chance.

Put another way: Had Apple launched an iPad in 2000, it would've had exactly the same hardware usability issues. There were no good, cheap enough touch screens, or displays, or cheap enough RAM, or cheap enough flash, to deliver what they did later at that time at any price, much less affordable enough.

Timing it when the available components were good enough and cheap enough was how they got it usable and affordable.

Trying too early and drawing the wrong conclusions was also why a lot of their competitors had moved onto a very different track in terms of design.

If you e.g. look at Palm devices that started to get network connectivity etc., from ~2000, you'll see the grid of (user-installable) apps w/touch and no keyboard, and Blackberry-like devices w/keyboard "won" for a while because people took users rejection of crappy, limited resistive touch as a rejection of touch. (I walked around with a Palm device for several years from '98 or so, and couldn't understand why "normal people" rejected them - it felt like scifi)

[EDIT: UMPC was from 2006; and not the type of devices I'm talking about - they're a couple of generations of hardware later; the UMPC if anything were part of that bastardization of the earlier touch focused devices as manufacturers declared the "cleaner" devices dead and buried in the market place without understanding why]
I can’t believe that countless people have internet-screamed at me that this platform is so much better than tvOS. I’m cringing.
Despite mass layoffs led by Meta, it's still hard to hire the right tech talent
"Normal" people don't use command-line apps. Making 'real' things that other people use can be a huge motivator for early learners.
Maybe I am doing it wrong. But I tried the following commands to test it on h264/h265 and 1080p/4k sources:

Soft: ffmpeg -i {src} -map 0:v -f null -
Hard: ffmpeg -hwaccel cuda -i {src} -map 0:v -f null -

the result I get is:

Source Hard Soft
1080p-h264 25.1x 37.1x
1080p-h265 26.4x 36.5x
4k-h264 5.5x 7.1x
4k-h265 5.5x 6.5x

this is on an old CPU (i7-6700K) and a somewhat recent GPU (RTX 2060) and with ffmpeg 6
Somewhat, but not completely: Visibility and center of gravity are also safety aspects, and a big battery doesn't per se make the former worse and actually (usually) makes the latter better, being mounted under the floor. So if an ICE model has one rating (or demands one kind of license), it makes some sense not to penalise an electric version but have the same limitations for that: It is worse than its fuel-driven counterpart only in the "F = ma" sense, but not otherwise. (To take a somewhat contrived example, an Audi E-Tron is probably less likely to flip over on top of a pdestrian than an A7. Or, recent talk about battery fires notwithstanding, to catch fire in doing so.)
Do you know which of these would be best suited to customization? I'd like to create a linux live distro only run a single application.
Most of this codebase seems to be Rust. I'm not sure how good the Qt/Rust experience currently is; there might well be room for another player in that space.

More generally, I get the impression that the current state of the art in cross-platform desktop-first UI development leaves a lot to be desired, so, tentatively, I applaud any and all efforts in this space, especially the ones that attempt to implement something from the ground up, rather than introducing unnecessary layers of leaky abstraction.
Everyone with a Mac?
Hi Jake,

Could you provide an estimated salary range for a Software Engineer with 2-3 YoE?
The volume issue persists on SmartTube
Ask HN: Looking for a Co-Founder and CTO for an EdTech Startup (50-50 Equity)
Hello - I'm looking for a technical co-founder to embark on a journey to build the Masterclass.com for startups.

The company will focused on creating software where neuroscience and entrepreneurship based content and courses are made simple and easy to apply.

I need a long-term partner who knows his/her craft, is willing to always learn more and aims to literally create something people want.

If you need any details please feel free to leave a comment or write me an email at:
tiberiusdinu95@gmail.com

Are there any people out here willing to join?

Thank you for your time!
Japan's digital nomad visas to require ¥10M in income
Show HN: Write Documentation Easily
Docs+ is a low-code easy way for developers to share Onboarding documents, API documentation, and much more in an easy way. Create sections and sub-sections, create unlimited pages, and share via a single link to anyone! Docs+ has a huge roadmap ahead and We're happy to hear feedback and make the product better!!
The higher up you are, and the more you represent an organisation, the less immature behavior or poor judgement you cannafford orbare entitled to. USN nuclear sub commanders get replaced for DUIs, because poor judgement is not acceptable. Creating public outrage with drunk rantabon social media falling back on an employer is nothing a normal employee woild get waway woth, let alone a CEO.

But in a world where everyone seems to think they are Elon Musk, and not Steve Jobs anymore, it is no surprise this behavior is shickingly common.

No, CEO and other public figures from a company should be held to even higher standards than the rank and file.
VSCode stopped supporting an old glibc version and near EOL users are in trouble
I have a strong aversion to comments like this, because they come across as extremely generic. Are you really very knowledgeable about the Dutch justice system, that being where Philips is headquartered? Philips are gonna lose at least $400m from this: what makes you so certain that the justice system is "completely broken", or that manslaughter charges are what they deserve? Have you compared the justice system with, let's say, Russian justice or Zimbabwean justice? I think the latter are a great deal more broken.

Casual cynicism is as foolish as casual naivety, and more toxic and dangerous.
The friend you gain will be a fairweather friend though, most likely.

If the person you disagrees with becomes your friend then that’s a good sign!
Breathing 101
How does this work in the face of unrelated refactoring? Say you first fix a bug somewhere, with a great commit comment. Then some refactoring happens, and the affected function is moved to a new class in a new file. Are you still able to track the original git comment?
Some satellites do appear to flash because they are tumbling: https://www.satobs.org/tumble/tumbleintro.html

The flashing of satellites will generally be gentler than the short burst strobing of an aircraft.
It depends on a library pigments that treats the Terminal as a TUI and not just like plain shells that just treat the terminal as a coloured teletype
The new Tether division will provide a “smart education environment” for students.
Tether Edu will concentrate mainly on developing markets across the globe.
One of USDT Issuer Tether’s new initiatives is an educational division that will provide seminars, classes, and other opportunities to learn about blockchain and other digital technologies. With the help of industry leaders and trailblazers, the new Tether division will provide a “smart education environment” for students. Tether USDT is the biggest stablecoin in the world by market capitalization.
Is Salesforce the program that your sales staff uses the most? What if the CRM software allowed them to manage sales agreements as well? Watch our webinar to see how your business can benefit from Salesforce integration with contract management software. Your company can benefit greatly from connected systems and procedures in a number of ways, from enhanced compliance to data exchange. Avoid missing out!
Not to solder, but to use a crimped connector - the good ones come with hot-glue-lined heat shrink so you crimp the wires for a great connection, then heat the connector and the shrink glues itself down, making a totally sealed connection.

If it's just low volt, low current, low mechanical stress stuff indoors - just twist and solder and wrap a bit of elec tape around it. But if it matters, break out the crimp tool.
Using VR goggles that have no capability of viewing anything VR makes them just regular goggles though?

This tank simulator from the 1970s is a great example of early VR:
https://www.youtube.com/watch?v=AcQifPHcMLE
I wonder if there's anything earlier..
When a nerd tries to reference Tupac.
Heinous cringe.
To all the newspapers I loved
They scale well in the sense that they display the same thing at different sizes without loss of quality. But that’s not the only thing that matters. The primary goal of an icon is legibility.

A large text editor icon might have a pad with a pencil, squiggles on the page, rings binding the pages at the top, etc. But if you scale that down, it might lose legibility.

For good icon design, you don’t want the same thing but smaller, you want fewer, simpler elements. So you might drop the rings at the top, then as you get smaller you might drop the squiggles on the page, and if you go small enough, you might want to change to just having the pencil.

Most people don’t bother with this. They just shrink things down. If that’s what you do, then SVG solves that problem. But that’s not great icon design. Great icon design needs to adapt to smaller sizes, not just grow and shrink.
I really appreciate you taking the time to reply to this, because the argument is crystal clear in my head, I just struggle to convey it to others.

> The structure of mathematics is infinite. Just because it exists as something unrealized does not at all mean it is equivalent to something manifested with substance as you suggest.

Being "manifested with substance" is something you experience from the inside of the universe. How do you know there is substance? Because you experience it with your senses, that's all.

> you don't know what input to give.

You don't have to. Nobody needs to give any input. It's enough that if a given input were given then a given output would arise. The output would arise from the input regardless of whether anyone ran the simulation.

It is true that 123+456=789, even if nobody ever calculates it.

> you can't practically compute all outcomes for all possible inputs since it's an infinite address space.

It doesn't matter that it's infinite. I'm saying you don't need to compute it, the outcomes were already there. Computing the function doesn't change anything. That's why if the universe can be simulated it doesn't have to be.

> When you play an FPS game, nothing that happens in the game isn't "implied by the initial configuration", yet you can't have an accurate output of how each match will go.

You don't know how any individual match will go because it is non-deterministic (like the coin-flipping example), but the set of all possible outcomes can be inferred from the starting state based on the rules. They're all already there in the vast structure of all that is possible in the game. You just only simuulate one path.

(The main caveat in my argument is that it begins with "IF the universe can be simulated" -- if you don't think it is possible to define a computable function that would simulate the universe given arbitrary time and space etc., then the rest of my argument is irrelevant).
I might be missing it but I don't see any mention of actual VR videos (180 and 360).

It probably would require a huge dev effort to support, but that's definitely a miss compared to the offical Quest app.
Senators find tech CEOs' responses hollow after four-hour hearing
C# cannot be an all-in-one language. Neither can be any other, including Rust. There are use cases for each language and a team that understands and adapts this mentality will outshine others.

“You should not have any special fondness for a particular weapon, or anything else, for that matter. Too much is the same as not enough. Without imitating anyone else, you should have as much weaponry as suits you.”
― Miyamoto Musashi
All Iron Ventures | Tech Lead/Senior Full-Stack Engineer | REMOTE (Europe / Middle East / Africa) with 2 days each month in Spain | Full-Time

All Iron is a European early stage venture capital firm based in Bilbao. With ~€300M under management, we invest in Seed and Series A startups across Europe. So far, we have invested in 50+ companies including success stories like JobandTalent, Seedtag, TuLotero or Preply amongst others and our graduation rates place us in the industry’s top quartile.

Venture investing is no longer a domestic and (only) relationship-based business. Modernising how venture firms work is a key competitive advantage, that here at All Iron sits at the core of how we do things. We are building our very own tool, Pareto, which is becoming the most relevant platform for the investment team’s day to day. In the last twelve months, Pareto has allowed us to gain a competitive advantage in a very competitive market by both saving time and identifying interesting companies ahead of our peers.

If you are passionate about building product to significantly improve how we run our day to day, using large amounts of data (to identify interesting companies to potentially invest in) and want to join an entrepreneurial firm, you will not be disappointed!

What are we looking for:

* 3+ years experience as a Data Engineer or Full-stack Engineer

* Someone who is a self-starter, scrappy, and pragmatic

* Experience in Google cloud, Django, JavaScript / TypeScript with React, SQL and Spark

* Experience as a tech lead or an Engineering manager is a plus: we have an external team of engineers whom you’ll be working closely with

* Experience working at a small startup and/or as a solo engineer is a plus

* Ability to travel to Bilbao (Spain) ~2 days each month is a must

If you are interested and would like to join us, please send your CV to hr_aiv@alliron.com. Please mention you saw this through Hacker News.
what what what? I've been using Premium for years what is this feature exactly? I don't see it. Cheers.
> No generic types .. No proper error handling .. No enumerations

Have a look at this version of Oberon which has generic modules, exceptions, enumerations and much more: https://oberon-lang.github.io/

Also a concurrency concept is work in progress: https://github.com/oberon-lang/oberon-lang.github.io/blob/ma...
Is it just me, or does nobody here remember the random baloney they did or said when they were in high school or college? People being frustrated and saying things that aren't quite acceptable is fairly common, seemingly especially when alcohol is involved.

Can we all just like I dunno chill out a bit? Who cares, and how does this affect me?
Yeah, that's what I meant, but I don't think they work well if you have to solder more then a few parallel wires because then it gets really bulky. Not really good for production work, imho.
Alaska, Hawaiian Airlines CEOs discuss status of $1.9B merger
Doctors have no business calling, medicine isn't done through phone. Contact is possible: when I don't answer spam calls from banks, they send me sms stating their business.
Sounds like a great reason to not use iOS.
I use these:
https://www.amazon.co.uk/-/dp/B073RMRCC3/

Far less bulky than they appear because they shrink while being heated so they're barely thicker than the wire. They can also be bent while hot which lets you get joints into tiny places.

So far, haven't had a single one fail, although I'm still dubious at using them on corroded or non-copper wires.
It would matter to me, or maybe a Vision Pro user. If Google is holding out as a negotiation tactic, there may be an official app in the future, if Apple compromises on revenue share.

If it is contempt or another reason, maybe the possibility if an official app is less likely.