skysight-inc/HackerNews huggingface dataset:
There are tools that will break each statement into a different migration, and apply a larger grouping by the files you create.

I have actually never seen people adopt those. And the "enterprise" tools people tend to circle around seem to create more failure modes than it helps solving. But I imagine somebody uses them somewhere.

Without those tools, you can break your migration around the failure point and mark the first half as complete. You should have some way to mark them, because you always need some channel for "free" management of a database.

Anyway, transactional DDL is great.
The entire point of CONCURRENTLY is to not be in a single transaction.

So you can interleave writes and (partially complete) indexing.

If you want transactional index creation, just omit CONCURRENTLY.
A cool collection and comparison of terminal emulators compared against each other. Just stumbled across this useful site myself. (I use WezTerm btw)
Generally, the Apple Store would be a separate company from Apple phones. A user gets to choose which store they want to use on their phone. Along with other things like which map app is the default.

This way, the different stores could compete - by charging lower fees or offering more services. Like the android store does a bare-bones check of the app and so it only charges 10%. Apple checks every app throughly, so it charges 15%. Some open source store might have 0% fee, have no app checks, no payment processing, and it is 100% on the user not to download infested software.
Script-kidding the Bitcoin blockchain [video]
When I did a running course, I started from a bit above nothing (hence first weeks were boring) and ended at 5 km in 30 minutes (easily, with 8 min remaining). The course took 12 weeks to reach, approx 3 runs a week (so sometimes one extra day off). I was around 35 y.o. then, so it was still relatively easy to get in shape. If you're older, this is more difficult. But the course was nice because I had a (Belgian) woman in my ears telling me what to do. Really easy. You do what she tells you to. And if you can't, you still give it your best. Oh, and dear reader, do yourself a favor: do a proper warming up, every time. You don't want to retract a muscle.
We had to exclude [dead] and eventually even just [flagged] posts from the public API because many third-party clients and sites were displaying them as if they were regular posts. For the ever-fragile HN ecosystem, that is catastrophic. We would get angry emails saying "how can your expletive site possibly condone such expletive expletive comments as <link>" ... and then it would turn out that <link> was a post by some account that had been banned for years.

It's fine if users turn 'showdead' on in their profile to read everything—just please remember that by doing that, you're subscribing to various bottoms of various barrels. But it's definitely not ok when people browse HN with some app we have nothing to do with, run into horrible things, understandably are outraged and then forever have their view of HN imprinted.

IMO this issue is existential for HN. We've spent years and so much energy trying to find a balance between internet openness and human decency, a task which oscillates between barely-possible and simply-doomed, so the idea that anybody anywhere sees anything labeled "Hacker News" that pours all the toxic waste back into the commons is physically painful to me. Much as I dislike the idea of restricting anyone's curiosity about the entire corpus of what gets posted, I don't see what choice we have.
we have something like that from an earlier launch:

https://wasm.supabase.com/

Be aware that the WASM file is 30Mb, but i think it fits what you're describing. details here: https://supabase.com/blog/postgres-wasm
If you enjoy thinking about this, absolutely go watch Pantheon on Amazon Prime.
Not being able to set custom price points for subscriptions is also painful
The usual complaint is that the pyramid scheme stops working (not enough people working to pay the pensions of the old people). This is simplistic: the real problem is that there aren't enough doctors/garbos/crop-harvesters etc as a proportion of the population. Either way the fix is straightforward: bring in some people who'd like a job.

Some rethinking is required -- in the USA Social Security was put in place when the typical recipient was expected to receive a payout for...less than three years.

I have friends in the "reduce the birth rate" community, and they are at least as thoughless if not more than the "birth rate too low" crowd. In the former case their "diagnosis" is inevitably that the wrong people are having too many kids though they hate it when you point that out.

A higher birth rate in sub saharan africa is hardly a crisis: every person in the US emits 5X the CO2 of a person in Africa. Dropping population in the rich, polluting countries can be a step in the right direction.

(Personally I'm pretty indifferent to either position. As Herb Stein famously put it: "if something cannot go on forever it will stop". Sure, the latency in this case is quite high but people deal with worse all the time.)
They are?

Your transaction isolation mode defines how they compose.

Unless you are asking something different.
> And remember ... don't be evil, and if you see something that you think isn't right -- speak up! [1]

[1] http://abc.xyz/investor/google-code-of-conduct
Not super surprising for single player games since they're usually much easier on the CPU than multiplayer. I was not getting minimum 60 FPS in Warzone for example.
I'm a little confused by the context and comments here. Is Trieve associated with HN at all or is this an independent/third-party offering? Is the Algolia search going anywhere? Will the search field on HN still take me to Algolia search or is that changing?
> Below replacement rate in most developed countries.

So what -- are those people somehow special?
There's actually a Slate article covering this topic[0]. First, consent was given for certain homes. However, the article also notes that under "exigent circumstances" warrantless searches are permitted:

> In exigent circumstances, or emergency situations, police can conduct warrantless searches to protect public safety. This exception to the Fourth Amendment’s probable cause requirement normally addresses situations of “hot pursuit,” in which an escaping suspect is tracked to a private home. But it might also apply to the events unfolding in Boston if further harm or injury might be supposed to occur in the time it takes to secure a warrant. A bomber believed to be armed and planning more violence would almost certainly meet such prerequisites.

[0]: https://slate.com/news-and-politics/2013/04/boston-bomber-ma...
It’s also that most IT people doing corp stuff don’t even give a crap or even know what half the hardware is these days. I mean our IT department bought developers laptops with 8Gb of soldered in RAM and no expansion then bitched at the dev team when they were told to piss off
Clickable links

https://github.com/gabrielsroka/r

https://docs.python.org/3/library/urllib.request.html

https://docs.python.org/3/library/http.client.html

A more complete example:

import http.client
import urllib.parse
import json as _json
import re
import time

# Set these:
host = 'example.okta.com'
token = ....'

conn = http.client.HTTPSConnection(host)
headers = {'authorization': 'SSWS ' + token}

def main():
res = get('/api/v1/users/me')
me = res.json
user_id = me['id']
print(me['id'])

start = time.time()

for user in get_objects('/api/v1/users', filter='profile.lastName eq "Doe"', limit=2):
print(user['id'])

end = time.time()

print(f'{end - start:5.1f} sec (http.client)')

# Update a user.
# res = post('/api/v1/users/' + user_id, {'profile': {'title': 'admin'}})
# me = res.json
# print(me['profile']['title'], res.headers['x-rate-limit-remaining'])

def rh(method, url, json=None):
_headers = headers.copy()
if json:
body = _json.dumps(json, separators=(',', ':')).encode()
_headers['Content-Type'] = 'application/json'
else:
body = None
conn.request(method, url, body, _headers)
res = conn.getresponse()
if res.reason != 'No Content':
res.json = _json.load(res)
return res

def get_objects(url, **fields):
if fields: url += '?' + urllib.parse.urlencode(fields)
while url:
res = get(url)
for o in res.json:
yield o
links = [link for link in res.headers.get_all('link') if 'rel="next"' in link]
url = re.search('<https://[^/]+(.+)>', links[0]).group(1) if links else None

def get(url):
return rh('GET', url)

def post(url, json=None):
return rh('POST', url, json)

main()
Numerical programs seems like a great fit for DSLs, say Starlark[0] ;-) That's what many C++ libs basically achieve with their heavy use of overloading, tmp, etc

[0] - https://github.com/google/starlark-go or alternatively https://github.com/facebook/starlark-rust
Pedants (1999)
> Huh? The entire point the parent was making is that they do "know" which cell phones were connected during specific times.

As I understand it, the point is that law enforcement does not know this, and thus they send a request to the service provider for all devices within this geofence within this timebox.

The service provider must then search the entirety of the relevant datastores for devices matching the geo- and time requirements.
For your index example, why not just do:

create index new [..]
drop index old;

At every point, there's always an index to use. We usually have to split releases into several "subreleases":

Release #1

(automatic migration step)
- alter the table
- add a new index which uses new columns (etc.)
(code release step)
- new code goes live and starts using the new index

Release #2 (we call it "post release")

- remove the old unused index

Automation, CI/CD help here. Yeah, it's somewhat error prone, but you usually get used to it. Not saying it's perfect, but manageable.

In any case, you can never make both SQL migration and code release atomic (if you use rolling updates with zero downtime) so you already have to split into such subreleases anyway.
Half measures.
one of the many books with a great premise, but ultimately no actual story
I was able to get the feed and import it into my favorite podcast app (Overcast). I don’t open the app very often.
In an ideal world, probably yes. In a world where proprietary apps for Android/iOS are increasingly hard to live without, I'll settle for Android with root (though some apps try to make that difficult).
> I don’t know why people expect privacy in Vegas, there are more cameras and technology watching you here than anywhere else in the US.

Yeah I can't imagine ever willingly going there (eg unless my work forces me to). It's a very curious choice for a community with so many privacy activists. The shooting excuse for the inspections is stupid. Anyone could walk in and set up in 10 minutes.
US colleges are cutting majors and slashing programs after years of putting off
I've wanted something like this so that I can have a custom bookshelf behind me in teams calls. I was tempted to make one but had no clue where to find book spine artwork.
Point taken. But these days they teach STEAM. Which is a weird way of saying they've gone back to not being STEM. STEM was to focus on the sciency, mathy, technical curricula as opposed to the non-STEM, like art and social things. But to undermine the whole STEM they went and braded regular curricula STEAM curricula so people would think, yeah, it's basically STEM with an "A" in it. Brilliant bastards.
I'm using it, but keep getting

POST https://postgres.new/api/chat 500 (Internal Server Error)

I've tried, reload, create new project and go back, anything. db id oy6g6g6o5qbt78fo
Karpathy's Makemore, built in many different frameworks like JAX, Differentiable Swift, MLX
> Apple users should be able to decide what software and stores run on the device that they own.

They do decide, right when they buy their phone.
i don't think it would work on human vs human because the other one would go find a tool to work in their advantage. In this case, The Rock would get a gun and a car and then you're SOL.
Reckoning for Florida's condo owners as buildings face millions in repairs
Then you must not rent your home. I've lived in rented apartments my entire adult life and while not daily inspections, everywhere I've lived the management has mandatory inspections every few months to check on fire alarms and other maintenance issues as well as making sure residents aren't violating policy by having more than two pets, trashing the apartment, allowing roaches and other pests to fester, etc. It can be annoying, but if I don't own it, it's not really "my" home.
> Importantly at one point he says that Apple lpatform brings in the most money to Patreon.

I'm not surprised.

The dirty little secret people won't talk about is that monetizing anything is so much easier on iOS because Apple users have, in some combination, more disposable income to offer, and are more willing to spend money.

This has been the elephant in the room for my entire career, almost 11 years working in apps. Monetizing on Apple is easier. Getting Apple users to put down money for good software is easier, and Apple users will pay more for the software they want.

There's a lot of reasons for this, many of them socioeconomic in nature that mark out the differences between your average iPhone user and your average Android user, and I don't want to get into that quagmire and be called elitist: all I'm saying is, when Patreon says the vast majority of patrons are buying from iOS powered devices, between iOS being easier to monetize and the general populace being on their phones far more than their computers; yeah that makes complete fucking sense to me. I believe him.
Thank you! Happy to get any feedback after a deeper look
The web standards have changed since the introduction of Acid3. The updated Acid3 test is here: https://wpt.live/acid/acid3/test.html and modern browsers should score 100/100.
Probably unconstitutional as the constitution mandates that each state provide to its citizens a representative form of government, meaning the state's electoral votes need to match the public's votes. It would be unconstitutional to apportion the state's representatives by vote of another state's voters.
Serious flaw in critical applications: Plaintext passwords in process memory
Same experience. So much promise that the way it collapses is disappointing, almost angry-making. I even gave it a second try thinking that maybe I'd just missed something. Nope.

Antimemetics remains a top 10 all-time though.
Piecing together the epic of Gilgamesh with NLP
A resident found him in his boat in his back yard and called police.
If only there was a way for people to move from one country to the other…
Workers are stuck in place because everyone is too afraid of a recession to quit
I wouldn’t call Patreon a market maker - it’s closer to PayPal than being a content site. You don’t find creators on Patreon and interact with them there, you find them elsewhere and have them point you to Patreon for one-time or subscription payments.

The issue is not in how the fee is calculated, it is jusy that both Patreon and Apple have far too high fees. Having the EU shake this up at least the Apple side is great.
Semaglutide (Ozempic) was first tested in 2008 if I'm not mistaken, those trials were for type II diabetes. It was only tested for obesity in 2021.

Its reasonable to expect that any serious side effects would hit you whether you are diabetic or obese. The concern I have is how many people are taking it today for cosmetic or vanity reasons rather than because they are morbidly obese and nothing else has worked.

We do know thanks to trials that it seemed safe and effective when tested on a few thousand people. We don't know what happens when someone takes it for decades, or the rest of their life.

I am absolutely not saying there are known side effects that make it more dangerous than what they put on the box. But it is a new and unknown medication being used by a pretty large population today. More importantly to my original point, those taking it almost certainly didn't read the medical research first so it is an unknown to them.
In general, though, doesn’t more (and more reliable) information permit more accurate conclusions? Wouldn’t this type of data reduce the risk of innocents being caught up, compared to asking cops or neighbors to hazard their best guess at who might have been around at the time of the crime?
I know its great and powerful but Go was always the "Google language" to me and as an unsufferable hipster that just turned me off to ever touch it.

I want all the things I spend my years studying to be built by committee or otherwise brief specimens of creative genius. Anything else makes me feel like I'm just learning Marvel lore.
This is a clever idea but if it gets over the line I am very pessimistic about the supreme court allowing it.

I feel like it could go okay if it's in place for a presidential election, and that election has a majority of popular and electoral votes. But if it came into effect and the next election was ambiguous based on whether this compact stands or not, the result would be chaotic at best.

As mentioned in the article, getting congressional approval, and then letting that process go through the courts before enactment, might at least make the deployment reasonable, even if congressional approval may not be strictly required.
On a similar note, the Irish Free State's first Olympic medal was a silver in Painting at the 1924 games, for The Liffey Swim by Jack Butler Yeats, brother of the better-known William Butler Yeats.
Seems like constitution should be changed then.
The estimates we have suggests that wage theft by retail employers is greater than retail shrink, so your theory lacks data to back it up.
2.4G is also the archetypical ISM because USA lobbied ITU-T to make it international garbage band precisely to allow airplanes to use microwaves.

So it's garbage band that works pretty much everywhere.
This comes as news to me! I’ve stayed in Vegas numerous times since then, and I almost always decline housekeeping. I’ve never had anyone come into the room (to my knowledge, anyway). I wonder how selectively this is enforced.
Yes. Because "things are simpler without it." Presumably "simpler" from the point of view of the language implementer as opposed to the user of the language.
You might like Zig too. The C interop is amazing. Last time I checked you could use Zig to just compile C straight up.
This is a while back, but I designed and built an AI-art installation from scratch, where I trained a GAN network to generate abstract art. The generated images was shown on a Samsung The Frame, and below the screen was a button. If you pushed the button, a new and unique piece was generated and shown on the screen.

If you're interested in doing something similar, I wrote an extensive guide of how to build it here: https://github.com/maxvfischer/DIY-ai-art.

The guide doesn't include the ML part, so that you will have to learn on your own and integrate into the project :)
Ranking the Hugo and Nebula Award Winners and Nominees
Completely agree, but you're ignoring that not everyone gets the same enjoyment out of everything.

For example, I enjoy doing electrical work, but hate plumbing. I'll do the former, but hire someone to do the latter.

Last year we bought a house that had a bunch of windows with missing screens. I ended up making new frames for all but one of those windows. The last one I didn't get to with the time constraints I had, and I've been procrastinating for the past year because it's a repetitive, fiddly job that doesn't really give me any joy. I'm sure I'll get around to the final screen eventually, but not every DIY project gives enjoyment for everyone.
Aha. I was surprised to see that ~30% of web pages loaded by Firefox were still not https. A 6-year-old graph would explain why!
We have a similar setup; but there are still scenarios where you need a IF NOT EXISTS. A classic example of a table on dev being close to empty, and a table on prod being huge and taking longer than the default timeout ~30 seconds.

Depending on what the timeout is (connection timeout, transaction timeout etc) the DDL operation _may_ still be running. But the migration "process" has failed. So you end up having to slightly modify the attempted migration to account for the fact the thing already exists.

It's an increasingly rare occurrence, probably a few times a year. Like anything the more we do it, the better we get at pulling left and preventing issues in the first place.
It often is arbitrary. Also, the rules as enforced by the awardee institution often differ from the funding agency's written rules. The people who are responsible for reviewing purchasing are only responsible for making sure no rules are broken, not with producing anything, so they tend to interpret the rules conservatively and just say "no" if they're not sure. The IT department also may try to block anything they didn't pick even if the funding agency would allow it. (Speaking from experience with university bureaucracy.)

It's not out of concern for cost-benefit ratio (overhead from parts selection and assembly) or anything like that. Getting something useful done is solely the researcher's problem.
It's not just you.
I gave up on Wez for that reason and after my comment on https://github.com/wez/wezterm/issues/4706 was ignored and issue autoclosed.
I can purchase ebooks on my Amazon Kindle Fire that runs Amazon apps on Android fine.

I bet I would also be able to purchase ebooks on the Amazon Kindle app installed from the Amazon Appstore on my Google Pixel phone.
It's for the benefit of the restaurant, because it given them the opportunity to disown the responsibility to their workers compensation.
SimpleFIN is not free but it's very cheap ($1.50/mo, cheaper annually) and has an easy to integrate API. I use it with Actual Budget after giving up on Firefly III because of data import issues and it supports every financial account I have. Annoyingly several of my upstream financial institutions force me to manually reauthenticate the connection every time I want to import data, but that's my banks being stupid and otherwise it works flawlessly.

Firefly III at one point was planning to support SimpleFIN as well but it seems to have dropped off the radar. https://github.com/firefly-iii/firefly-iii/issues/5396
I recommend asking around in your social circle of other homeowners. If you know someone who deals with houses a lot, like a realtor, ask them for recommendations. I got my handyman rec from my realtor, and he's fantastic.
> Yeah, it's somewhat error prone, but you usually get used to it. Not saying it's perfect, but manageable.

Of course; I'm just saying this is why people want idempotency and use "if not exists", especially in MariaDB/MySQL land.
Somewhat fresh kitty user (a few weeks now).
What's your ssh issue?

Also saw Wezterm pop up last week and definitely decided I'll give it a go here soon.
I am not a lawyer, but the language of the opinion [1] seems to indicate that the geofence itself is not admissible, but evidence obtained as a result of it is still admissible:

> On November 4, 2022, Smith filed a Motion to Suppress—
which the other Appellants joined—seeking to suppress all evidence derived
from the November 2018 geofence warrant which was used to identify them
as suspects.

They were identified as suspects, and further investigation produced more evidence, which formed the case. What they are saying is that the good faith exception prevents this from tainting all derived evidence in this case, which seems reasonable.

The good faith exception is an exception to the exclusionary rule, not to the admissibility of the evidence itself.

[1] https://www.ca5.uscourts.gov/opinions/pub/23/23-60321-CR0.pd...