skysight-inc/HackerNews huggingface dataset:
I agree Django's migration system has a few unfortunate quirks (most notably the help-text-change-migrations), but it's also worked great for Zulip across over 300 database migrations, and I wouldn't recommend anyone do their own migration framework on raw SQL files by hand.

The issues mentioned here in this article are real (E.g. we have a lint rule blocking importing other code inside migration files), but the author is also ignoring the benefits of Django's system, namely that it's a well-documented system that does most of the work of managing migrations for you, and does a good enough job that the vast majority of developers working on a large software project (like Zulip, with 96 people who've contributed changes to database migrations) will do it correctly without special training just from the Django documentation.

And the downsides are certainly minor compared to the obvious downsides with rolling one's own system with raw SQL (E.g. the fact that nothing validates that the model definitions match the database schema in the author's proposal!). I wouldn't recommend anyone take the author's advice for what to do instead, but this article is helpful reading for anyone curious about what issues one will encounter after a few years working with Django.

> How many times have you worked on a project and, after 1-2 years of development, you have changed to a different database?

FWIW, Zulip was originally developed with MySQL, and then about a year into developed we switched to Postgres. It also had a phase where we ran SQLite in development environments. Building on Django made our life a lot easier doing this.

> Once the migrations have been applied to all your testing and production systems, and all your developers' databases, just remove them.

This is only true if you don't care about being able to use tools like `git bisect` where you might want to switch a development environment to older versions and back again (I do this often as part of).

> If you do it in a loop, it results in a "ripple load", meaning you'll run 50 queries, each one fetching one record, while you could have run a single query fetching 50 records, or just adding an extra JOIN to another query.

This is my biggest complaint about Django's ORM -- lazy fetching of foreign keys is great in a management shell but rarely desirable in production, and it results in inexperienced developers doing database queries in loops all the time. We address this with a bit of middleware that formats log lines like this e.g. `41ms (db: 10ms/2q)` (showing how much time was spend doing database queries and how many queries were done) -- which lets one easily identify problematic cases of this both in development and in production.

But if Django had a setting that just disables the lazy fetching of foreign keys feature (making accessing an unfetched foreign key an error), I'd turn it on for Zulip.

See also https://zulip.readthedocs.io/en/latest/subsystems/schema-mig....
It isn't. The problem this program solves is thwarting a naive attempt to alter the state of the USB bus. The design assumes the attacker is not aware of the consequences of adding or removing devices and has no reason to employ spoofed devices or any other Ever Greater Adversary Regression techniques you can imagine.
There's nothing worse than random teams reimplementing a migrations system because they think they know better.

The Django migrations system is far from perfect, but it's light years ahead of anything a small team can build.
Not this specific article, but I do pay to read content.

You don't need so many paying readers to get more money than ads. I also think that people should stop putting ads on their website when the gains are so little.

If writing is your job, write for a proper good media.
It wasn't hacked... But these files came into the hands of an unauthorised user... That seems a lot think something of theirs got hacked...
Optimize Power Automate or Logic Apps Flows
Free will is an illusion. Culpability and responsibility in the moral sense is the wrong question. To put a really fine point on it, whether a person is psychotic and violent because of brain tumor or some other neural or biochemical defect, in neither case can they reasonably be considered the cause of their own psychosis. Nobody "makes" themselves psychotic intentionally, the same way you cannot cure such a condition by mere force of will.

A better question is what gives the best results (mainly for the public at large) as an overall system policy. I guess brain tumors are rare enough that you can probably err on the side of mercy supposing you don't believe the subject is likely to reoffend. But you don't want to make so many loopholes that the deterrent effect of punishment is compromised. And of course you don't want to let people go who are likely to harm innocent members of the public, regardless of whether they are responsible for that condition. These are all empirical questions though. Its incredibly hard to even establish a deterrent effect of punishment, much less measure it to the fine degree required to set detailed policy.

Peter Watts discusses this a little sort of as an aside during Blindsight, I believe.
That doesn't sound very safe.
PSA being down is interesting. I might have thought there would be greater demand for storage units as people clear stuff out of their houses to make room for home offices/gyms/etc.

That said, all the people who've lost jobs or hours are probably not looking to pay $100s/month for an auxiliary junk room.
You mean the jobs that are likely to be at least somewhat less location-dependent coming out of this? (Not arguing for 100% remote or anything like this but still a fairly major shift. I certainly know plenty of people who have already moved out of cities to quite rural locations.)
No, Australia. Just a farming community where you can't guarantee every household even has a computer (hence school-provided for students).

Most of the parents I dealt with treated technology like it might be infectious, and they didn't want to get sick. Most didn't even have email.
Most likely because Bill English died:

https://news.ycombinator.com/item?id=24032820

He was at Xerox PARC, where he helped midwife PARC’s invention of the personal computer and other innovations.
> 15e2

This looks like 15 x 10^2 to me. I think all caps hex may be able to avoid such problems.
This can't be real... are you serious? It sounds like one of those silly buisness parabels!
I wouldn't say it's been resolved though. We've only scratched the surface here and it's barely backed by science. A lot of the case law is built on some very outdated philosophies of mind.

There's something quite perplexing to me about the way people interpret these things. When someone murders their mother and goes on a big murder spree and then people try to differentiate "But were they insane?" ....Only, of course they are! Normal people don't go on murder sprees.
I'm so there with the Pinephone as soon as that slide out keyboard comes out.
Agree. This article misses the use case of people using third party apps with migrations. For example. The Wagtail content management team can create migrations that can be applied to MySQL and Postgres databases. Not sure if that is possible writing SQL files.
Qubes, the OS That Can Protect You Even If You Get Hacked [video]
A beautiful property of using ints to represent dates is that you can manipulate them using simple arithmetic. For example, if you want to refer to noon-time on 20200806, you can simply divide the day in two and write it as 10100403. An elegant, DRY solution to a perennial problem.
You said you'd be dropping all v6 packets, not just incoming connections. Not quite the same thing.
As you can see, you'll always have someone replying with the guidelines and act as if we all come here to have the opinion of software people on topics they don't master at all.
You’re a journalist. Source gives you a usb drive full of documents. Source is in reality hostile/compromised, so is the usb drive.
> keep track of what migrations have already been applied and only apply newer ones

The Django migration system does this for you, and it does it really well.
Thank you for asking deep questions and providing specific examples! The degree of scale and complexity varies significantly between companies, so we definitely can't claim that every ETL developer should use such a tool.

Philosophically, I see our diff tool playing a similar role to autocomplete/autorefactor in an IDE. Can you type/change every word manually? Yes. Is it a good use of your time though?
The recommendation to use an AMD GPU still stands, since it's passed into the VM. I've been using an RX 560D on Catalina (the one that didn't advertise having 2 fewer CUs, grrrr) without any graphical trouble.

iCloud mostly works, the only two apps that I can't get working are iMessage and FaceTime. This is a common issue for all Hackintoshs, it's not a VM specific problem. It comes down to needing to provide a real Apple SN that matches the kind of Mac you set your Hackintosh to identify as. I'd half recommend picking up a broken / for-parts iMac off eBay to lift the serial number off of (and to say you do actually own a Mac =P ).

I did have some trouble doing passthrough of NVMe drives in the past. I don't know if this was the VM's fault or the fact that it would get hooked by Linux on the host boot and then be unbound before booting the VM. I haven't tried again in the last 18 months, so it's entirely possible any issue there got fixed. I've been booting from an iSCSI volume from my NAS (QEMU hides this fact from macOS).

I should add that I moved away from the Apple ecosystem awhile ago in terms of my personal data. I use a mix of Google services and NextCloud (hosted on my own hardware). My Apple ID getting banned isn't too much of a concern for me. I've never heard of someone actually getting their Apple ID blocked for using a Hackintosh, I figure there are so few people actually doing it it's not worth it to Apple to enforce.

That being said, I don't know how they'd respond to a wealthy company using a bunch of Hackintoshs. I still don't understand how they expect people to properly do CI/CD for iOS without macOS in a server / virtualization environment though. My employer uses rack mount sleds for Mac Minis, but without proper IPMI, managing them is a pain. I wish you could license macOS for a virtualization environment so you could deploy a few 1U dual socket 64 core EPYC servers (128 core / 256 thread total) rather than 4x 6 core boxes per 1U.

Either that, or they should let the toolchain run on more than just Macs. I think that is one of the major features of React Native - you can develop your apps on whatever machine you want. You only need a proper Mac when you're bundling for release.
I wish there were a simple and easy way to connect to a satellite, at the same kind of level of effort as .. say .. connecting to a BBS in the 80's .. and access it, just like an 80's BBS - i.e. upload a message, wait for a response while the thing flies overhead/across the globe, etc.

I guess this project kind of achieves that in a way. If you can build the hardware you can access a very elite messaging system.

It just seems to me to be a great place to put a BBS. I wonder if there are satellites up there that have that kind of interface ..
>But the moves threaten to upend huge swaths of the real estate market and the half-trillion dollar market for commercial mortgage-backed securities.

And?

Seriously. We either have to choose to be a market that is somewhat free or not. At this point, the government is choosing winners and losers. It is a repeat of 2008. Oh no, it is too big to fail.

Someone will come by with the investment to buy what is left. Perhaps they will run it better. Prepare better.

We're going through this with airlines and cruise companies now fighting for more money and loans from the government. Perhaps Delta grew too large to be what they are now. Maybe there are too many malls in existence. Maybe the method in which we collateralize mortgages doesn't make sense anymore.

Our economy has developed the too big to fail mindset and forgotten, largely, you can lose.
> I'm just interested in pivot points where companies decided to switch from technology x to technology z, and what made them do it.

There's a lot of articles and blog posts on that topic, enough to keep you occupied for a long while. Here's one:

http://www.smashcompany.com/technology/my-final-post-regardi...

Here's another

https://blog.asana.com/2017/08/performance-asana-app-rewrite...

> I meant, "When did people stop deciding to greenlight new projects using PHP?"

Did they, though? I haven't noticed. Do you have any source on that?

> Would you be interested in such a chart?

No.
re: "who you know" -- this may indicate the opposite.

Consider how "looked down" this kind of investment would be, if the CEO has a bad record.

Yet, they still invest -- why? Because they think they will make a good return
No country Will extradite their own citizens, though. If intel wants the person punished, they have to sue them in the country they live in.
Thanks for putting together this list -- I've been bookmarking VC sites and manually referring to them in my job search which obviously does not scale.

Feedback:

* Table mode vs card mode would allow one to digest more data
* Allow clicks outside the modal to close the modal pop-up
* Allow a right-click or specific job posting to be opened in a new window
* Scroll to top of new fetched results after pagination

P.S. Is the front-end (React) code available somewhere where one could hypothetically contribute?
A large proportion of those debt collectors are gigantic soulless corporations that nobody would mind watching suffering somewhat - but that's the same as every industry. There are a lot of smaller property owners that are really hurting here and pausing debt collection might free those owners from debts but it won't put food on their table.

This is, unfortunately, a very complicated problem.
Great point. Right now you can build in the insanely expensive San Francisco Bay Area for something between $400 and $500 per square foot. $330 is certainly not a great improvement.
Wouldn't the publishing part just be standard copyright infrignement and just a civil matter?
It's not misleading.
The vegetation that is flooded decomposes anaerobically and releases methane. So there's an ongoing release over the years that it decomposes. They've measured these emissions at different dams over time, and the worst (where forest is flooded) results in nearly 2.5 times the GHG emissions as the worst coal plants.

For instance the Balbina hydroelectric reservoir in Brazil was responsible for 39000 tons of methane each year (https://www.researchgate.net/publication/252089237_CO2_emiss...)

That was a 2011 paper on a dam that was finished in 1989.
If you can materialize those .bcp files as tables, then yes, absolutely.
You can look at what actually happens in abandoned malls - bored teenagers and college students calling themselves "urban explorers" check them out and engage in some graffiti in a long abandoned site or trysts at most.

Gangs would find them goddamned useless as territory because there is no income stream there. There isn't anyone to make money selling drugs to or johns for clients to pimp out. That is why the damn mall closed in the first place!

The low traffic ironically makes it a poor place to lay low as "I saw some guy enter an hour or so ago" becomes useful instead of vague and useless.

That similar noticability and lack of good pretexts makes it a poor choice for a meth lab compared to a random trailer or basement.

They wind up such an economic wasteland that they aren't even good for criminal purposes which is vaguely impressive. That is essentially the one "upside" of their separation from residences. They aren't like the Opium Den/Crackhouse/Methhouse because they lack the attractiveness to be an attractive nuisance.
It's an unrealized asset. It can be included as a footnote on his personal net worth but isn't part of it until it's sold. For a founder, the red-tape involved in selling stock is significant and they must wait for the market to absorb the announcement of their intention to sell. I recall when Bill Gates sold something like $200M of his stock to pay for his lake-side mansion and that the SEC filing went out of the way to express that Gates didn't really want to sell anything but it was the only way he could finance his new mansion... in other words, there's no insider knowledge about Microsoft that prompted his selling. For Zuck to cash out he would have to announce well in advance and then say he's going to sell X percent every first trading day of the month (or whatever period he defines) whether the stock is going up or down in order for it to not be taken as an insider move.

(In fact, selling covertly or converting stock to any financial instrument covertly -- what's called "buying a collar" -- is quite illegal and will land you in jail if caught.)
It's clear that the Google where you worked existed in a parallel universe from mine. On my home planet, google netcap required a forecast per-product, per region pair, years in advance, and the product group got charged back for the capacity requested, not for the usage, so nobody was requesting extra.
A great segue question would be: what's the real environmental impact of "Light Stone", compared to cement, wood, or CLT, or others?
GitLab employee here. We just have dropped browser support for IE11 in May with our major 13.0. Nobody complained about us removing it despite us announcing it in January. [0]

Already removed some polyfills, biggest win will be transpiling just for modern browsers [1]. This all ties in nicely with general performance initiatives.

[0]: https://gitlab.com/gitlab-org/gitlab/-/issues/197987

[1]: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/36840
What you're describing just sounds like a more labor-intensive method of following those people. The purpose of following people is so you can see that same content aggregated into a feed.
Curable insanity is the question though.

Some people go insane from brain tumors and CSF leaks. These can be cured, and can literally return a person to a "normal" state of mind overnight.

Then there are things we just can't cure yet because there's a seemingly unfathomable amount of stuff going on in the brain with regards to chemicals.

If their cause can be medically cured with past results backing a return to normalcy... I think that should be a large part of the legal discussion and attempted if the defendant requests. Whether or not they lie about being normal again after the procedures? Well, that's a question as hard as why are some people just dicks.
Asking for the name of a public employee is doxxing?
this sort of thing is already more or less settled law..if you take some medication that impairs your ability to function, that might well serve as a defense during prosecution...same thing applies to brain tumors...of course there are other factors involved...
May be a good time for Intel to open-source FSP anyway. They've been dilly-dallying around it for a while now. There were some phoronix articles about it a year ago.
do you know why HH is named such ?

>>the function of a gene is not exclusively tied to chromosomal location<< ...epigenetics, ultrastructure of expression systems

"Since when is the universal way to identify a gene its locus" since molecular genetics...and gene mapping.

this whole thing started with the idea that gene lables are arbitrary meaningless tags by extension not a problem to change labels to stop a spreadsheet program from mangling data. so now that we both know that genetic labels or tags or whatever you prefer to insert, are far from arbitrary thats the end of that.
Some fines in a few countries are based on income, most notably Finland, which has issued fines in the tens of thousands for minor infractions like speeding. https://en.wikipedia.org/wiki/Day-fine
Framing the question indeed...

I'm allergic to bee stings and I'd prefer not to have my neck swell up to the point where I can't breathe because I accidentally sat on or pinched an insect. And I don't want random insects biting me or my children, spreading disieses, etc.

Residential areas are called that because they are built to accommodate humans, I don't see anything particularly problematic about not having bees there.

And I do realise they pollinate a lot of plants - again residential area - I don't have anything against bees on farms or in nature.
You're right about the slowness! I just noticed it now. I'm confused why though -- I don't actually see it spawning a lot of processes, and the slowness is far beyond what could be explained by that. Even a single process call appears to run much more slowly. I haven't dug into it but maybe the I/O pattern is funny?
> Correction: We’ve updated this article to clarify that the units currently under construction by Mighty Buildings are not entirely 3D-printed, but the next iteration will be.

Very important correction.
The next fragment, "else they'll have to declare bankruptcy", is pretty much the answer. And as we learned in 2008, they're also "too big to fail", so that won't be happening.
Switching costs is a fair point. I think the biggest improvements can be made in UX and in having great APIs which enable integration and automation.
While it doesn't mean it will happen, depending on what is leaked now and in the future, possibilities include:

1. Verify that debug features that are remotely exploitable are actually disabled in consumer releases of their hardware.

2. Re-implement proprietary parts of the boot sequence, such as activating memory controllers, in an open and public manner that can be more easily looked over for flaws, security and otherwise.

3. Modify parameters and tweak hardware for additional stability or performance enhancements, especially undocumented or disabled(on lower graded chips of the same architecture) aspects of the hardware that may be present.

On the other hand barriers include legal issues depending on what country people working on these originate from, ethical issues, and even industry barring, and this is not exhaustive. Consumers, especially consumers in countries not concerned about the legal aspects will likely gain the most advantages, if any are present.
Another thing important that the author doesn't mention is that if you try to keep your sql model on the postgres side.. you will be able to introduce other languages (for example to optimize hot paths)

I agree 100% with the author, if you check other open source projects (on other languages) they mostly are based on the patch version sql feature. Sorry, the migrations feature from my point of view it's absolutely over engineered..

I also agree with him, that doesn't make too much sense to keep Django+drf, when if you use fastapi+pydantic+asyncpg you got all the real innovation on the python side..

Also it's not a good argument that following the Django religion will let to proper future maintenance.. think on channels and the big mess around them :)

Sorry, I'm perhaps a bit biased, started with Django 0.9 till 1.9.. and right now I'm not using it for anything new.. on the way I swapped for go, and later come back to python thanks to asyncio.
Not if I want it to be converted to a date ;-)
Trump’s TikTok Crusade Makes US Censorship Look a Lot Like China’s
Hm thats from 2012.

I think there is a more recent one, 2017-2019, that even more closely matches the my experience for the last 5 years
Thats why you should also track other metrics when AB testing performance changes. During my time at IG, even small perf improvements almost always corresponded to stat-sig improvements in engagement metrics. 100ms is a pretty significant performance win, definitely not noise - the other thing is that those wins often scale by the quality of device & connection. So a 100ms win for a high end desktop on fiber internet could be multiple seconds for a low end mobile on 3G.
Animated Map: The History of U.S. Counties over 300 Years