skysight-inc/HackerNews huggingface dataset:
There are a couple of key features that PostgREST provides that I have not seen in other web frameworks. That's not to say others don't exist, but there are some definitely modeling and security anti-patterns that have become unfortunately deeply entrenched in many frameworks I've had to work with:

1. Your web framework logging into the database as a superuser.

This is huge: "kitchen-sink" frameworks tend to log into the database as a superuser, typically so they can "do migrations" from some SQL-degenerate ORM.

PostgREST (as documented) logs into the database as a user with NO privileges at all, and switches roles (with SET ROLE) to the role defined in the signed JWT token. If you never sign a token with a superuser role, users can never run queries as a superuser. You can also enforce host based security so that your web servers can't even SET ROLE even if they had a bogus signed token.

2. Buffering full database query responses as garbage collected "objects" and then serialize them to JSON.

Another problem proxy frameworks have is that they compose a SQL query, run it (typically as a superuser, sigh), then buffer then entire response in memory, typically as "objects" that need to be immediately garbage collected, and then rendered into JSON in another buffer! Finally the response is then streamed to the browser.

Postgres speaks JSON, and can produce rows of data as JSON natively. This data can be streamed directly to the browser before the query completes. This is a huge cost. Django workers typically need several gigabytes of RAM, proportional to the largest possible query response your database can produce. PostgREST does no buffering, parsing, or rendering, it just streams the json response directly from the database. Processes typically need only one or two hundred megabytes of RAM at most.

3. Tables and Views are elements of an object oriented type system. Not just a storage mechanisms.

Postgres is an Object-Oriented Relational Database Management System (OORDBMS). Tables are not just places you stick stuff, they are types and rows of data are instances of those types. Views are types composed of sub-types, which can in turn be views or tables. Postgres rewrites a query until all the views are expanded, like macros, until it gets one big query you never have to ever see.

PostgREST leverages all of this power of the database, you can model in the language that is the best for modeling data, SQL.
Hackathons are literally the opposite. You are there to deliver something that works, looking pretty is 30 yards down the line of concerns,
I was referring to the moon flights. Of course I know that most of technology is much better today.

I just recently did some comparison between engines of Saturn 1B and Falcon 9 for example.
Thanks for sharing, @feross :)

I'm excited for the future of this community. Open to any feedback on how we could improve things, or suggestions for managing large Discord communities.
I got baited into going to one of those once. I was promised the prospect of spending a dozen hours with friends building something cool, but halfway through I realized we were just doing free labor for one of Latin America's biggest banks and just left.

I'm still longing for events where my friends and I can gather to build something cool, and game jams are the closest I ever got to that.
This is often true in professional settings. "Just build the UI for this, and the API team will catch up". I object-- give me an OpenAPI spec that we agree upon in advance. Front-end today involves building up a lot of in-memory data structures, and I haven't built something useful if the JSON shape I attempt giving you, is not what the backend team is expecting.
The second comment. The telecoms via 5G have been positioning themselves to rent their infrastructure on-demand. The AWS partnership is this but Amazon then re-extending it to developers on their platform as part of their "Cloud" offerings.

I doubt Amazon has many towers of their own here and are almost entirely through one of the telecoms.
Was that a big problem? I thought it was a single-intern sized problem.
"Feels a bit harsh and counter-productive to just tell back end devs to kick rocks."

I agree, but business goals supersede our feelings.
> When Buffalo NY's Tops International Market fired their baker for literally urinating in the cake batter used to make the store cakes, the union stepped in to defend the employee because as part of the union contract employees were not supposed to be on camera to perform their duties. They fought hard to get their baker reinstated and won.

Do you have a source for this? It's a rather serious claim to make without any evidence and I haven't been able to find anything other than your comment when searching.
The only problem with BigQuery is that it's on GCP, so either you have to migrate your whole workload over or you end up eating a lot of data transfer costs.

Having used both I do think BigQuery is better in a lot of ways (although it's easier to make it a lot expensive too), but I'm really excited to see Redshift catch up. Adding the serverless options are really great too since my biggest complaint with Redshift was managing the quantity and type of the underlying instances.
"Backend developers on hackathons are not needed"

It's a good thing those horrible old days of "ideas are a dime a dozen; it's the execution that matters" are long, long gone.
So what you mean is actually "No", we won't get rid of it.
How is a private 5G network different from wifi from a consumer/business perspective? Does it have a superior range?

(Honest question)
Cloudflare DDOS protection?
There should be a browser extension which overlays YouTube with likes / dislikes / comments coming from a different site (a Reddit or HN just for YouTube). So people can still see and add dislikes and also unfiltered comments.
Agreed. There is a truly bizarre tendency for people to try to reinvent class based on income, realize it doesn't work very well, add some sort of interest or social dimension to it, and slowly reinvent the classical concept of class with the labels shuffled around. We've already had good class labels, working class, labor aristocracy, middle class, struggling capitalist class (small business owners ie petite bourgeoisie), and major capitalist.

I think it should be some kind of law of the internet. Any discussion of socioeconomic topics ends up reinventing the classic class system on a long enough time scale.
Many thanks! Also want to mention that I could not do the work without the help of the PostgREST Team[1] :)

[1]: https://github.com/orgs/PostgREST/people
I still don't get why AWS keeps using images to display textual content. It's inaccessible and it looks terrible on mobile devices.
This article was released 30 NOV 2021. So 9 years,
Off topic, but this reminds me of that bit from Trailer Park Boys where they steal a rack. So good.

https://www.youtube.com/watch?v=ODIkw4MAeVg

(language warning if you've never seen the show)
Said by an Italian (old enough to have studied Latin) it is not that easy.

Sure most roots are the same (so you can recognize most words, if taken singularly) but the construction and use of cases and the various declinations makes it tough to read a whole sentence and translate it correctly, also because there may be "false friends".

On the other hand, with some (possibly better than the ones I did) Latin studies, a whole number of Latin derived languages (Italian, Spanish, French, Portuguese and Romanian) become more accessible, at least in written form, because they all use the same (but somnetimes different) Latin roots, i.e. two different Latin words (meaning the same thing or even the same word in a different case/declination) may have become used in different languages, so knowing the "common ancestor" helps.
It's not very clear why I should keep using a normal Redshift instead of switching to Serverless? Anyone has more insights?
The use I see for it is in providing access to critical information in the event of injury or death. One key to family, one to friends, one in a safety deposit box, etc. Copies of legal records and sensitive info can be given to people without the risk it would be misused.

The other use is handing/hiding them out at a convention and making a big ARG out of it. Which sounds like a lot more fun
It’s not obvious? So there is a chance “that’s beautiful” means that the person showing him the painting is beautiful? I’m mystified.
This is true, and part of a larger problem where product managers and BAs come in and try to REUSE components conceived in a hackathon. I hope I never have to see that again.
I think it's builds trust to signal to your users that the product is still young. That sets expectations that there may be bugs but you're looking to actively fix them, and that half baked features will become more stable and usable over time.

The phrase "beta testers" isn't great though. People don't want to pay to test other peoples software. I think "early access" is better phrasing. I'm working on an idea and planning to preview a feature grid with different tiers, then grey it out and have an overlay saying something to the effect of "early access only right now, open your account now and get locked into this lower price." Followed by a list of available features and "coming soon".
At least for “day job” hackathons this seems counterproductive. A big part of winning support to productionize is proving to the naysayers that an implementation is feasible.

For example, at my current job folks are biased to complex, high-risk AI/ML approaches… Instead of figuring out an imperative solution, senior folks tend to just discard it.

A hackathon is a great way to short-circuit artificial technical road blocks and win support from product and business teams to start with a simple solution.
Reads like someone is equally bitter.
When he said "now subtract the two 4 digit numbers" I felt a whole room full of eyes glaze over.
anything big enough that connecting it using wifi might be challenging. E.g. Port, factories, airports, ...
I don't see "many contrary 'scientific' studies" in the news. What I do see is almost universal consensus among climate scientists that humans are accelerating climate change, with a few news personalities criticizing predictions that were off by a few degrees or inches of sea level rise and pretending that those errors somehow invalidate the general consensus. It's disingenuous at the very least to suggest that these errors disprove anthropogenic climate change or that there are valid studies that support both sides.
The Pfizer vaccine: ‘a once-in-an-epoch windfall’
I’ll finally dig into frontend frameworks like react. I’m an old fart (started as C dev) and assumed it was a fad years ago - even thought no JavaScript was the future.

Silly me, now I have to play catch-up.
Another great terminal UI for git is tig: https://jonas.github.io/tig/
USDC has not been audited, they have only had attestations.
What is tough is that most other things are generally not that expensive in many of these expensive places. It's still roughly $14 entrees $9 appetizers and $8 bud lights in many of these expensive cost of living areas just like downtown midwestern cities anywhere else these days from what I've been finding myself personally. Other than the bay area or nyc where you really might see a costly big mac on the menu, it feels like the pricepoints for food service, movie tickets, concerts, car washes, cocktails, in state college tuition, groceries, and most other things are pretty much fixed across the country in metro areas at least whether its LA or Pittsburg you are comparing. It's only rent and housing costs that seem to vary so dramatically in my experience.
Show HN: Extract your Google location history for any date ranges to KML/geoJSON
Actually, you don't need frontend devs as well. Just use UX designer + Figma.
Athena is more of a wrapper over Presto / Trino than Hive. It does not run map reduce per se over your data - its a SQL engine.
I immediately thought of alarm companies like ADT or Vivant who I believe currently partner with cellular providers for access. How much cheaper would it be to swap to 5G as a service versus whatever their current cost model is.
thanks

my bad, I learned something new.

anyway this proves that immutable data structures are not inherently slow, this is infact an optimization that makes things faster.
The UK government is considering withdrawing the requirement for consent to cookies from UK law. To be clear this was an EU Import into UK regulation.
I beg to differ: it's a competitor for custom devices needing to transfer small amounts of data without regulatory hurdles, with the drawback of spotty connectivity given the current coverage map.

But for a moving device (ex: truck) transmitting locally stored data without latency concerns (ex: IOT temperature readings for a frozen cargo) I think it would be much more efficient, with far more coverage: you could have a $20 LORAWAN ESP32 built in individual boxes.

Think of this like Apple airtags, using a mesh network to intermittently transfer data on a best effort basis, but hooked to custom sensors so you fully control the payload
I've seen this sentiment a lot, and it doesn't make any sense to me. How can you "trust the science" and peer review, but only when it's scary? If it's not scary enough, you hypothesize it being biased?

How is that better than the crowd who thinks it's biased the other way? It's just as easy to imagine your publication won't get accepted into the scientific mainstream unless it conforms to the prevailing narrative.

What's the value of peer review if either of these biases (deniers or alarmists) is correct?!?
Being decent at Java, the first programming language i am currently learning :)
public speaking

writing

timeboxing
How are these docs being built? I really like how these look and it looks to be asciidoc based, but I can't seem to find a build script for these.
Impressive, although quite large program!

One suggestion: Use PgUp and Pgdown to scroll a screenful, and use arrow keys to scroll one or two lines. Use shift with some keys to scroll half screens.

Is there a keyboard shortcut to go into remotes or tags panes?
Their conduct already changed the vote. How does a re-vote change their minds?
That feels really, really weird. Next we'll get calls from the insurance company "Hi this call is sponsored by Chantix, and we notice you still smoke.."
I think the idea is by attracting new customers to EC2 via performance/price, and then enticing them to integrate with other harder-to-leave AWS services
A better business model would be to charge progressively based on number of followers. This way users pay not for consumption, but for amplification of their messaging.

Something like

0-100 followers : free

100-1,000: $5/mo

1,000-10,000: $20/mo

...

1M+ : $10,000/mo per 1M

The aligns the incentives and value provided. Someone having 1M followers on twitter has a powerful platform for their agenda whatever it may be. This should come at a progressively higher cost to them (not their followers).
The 5G architecture (and LTE for the most part, but 5G was designed ground-up this way) makes very heavy use of remote resources. An actual 5G base station (and most new LTE base stations) is somewhat like an SDR with very little actual protocol logic locally, it connects to a remote controller that handles all of the "business logic." It's an important change because for various reasons, some good and some not so good, the architecture of these networks is really quite complicated and a base station needs a lot of "support services" to function. Making them all remote is basically the change that allowed cell base stations to go from 120sqft concrete huts to the "microcells" we have today where the equipment fits in a pole-mount cabinet.

So the value proposition here is that Amazon is operating the actual network, which is not a small thing. You just have to install the radio hardware.
If there was a market of people who would pay for such an app, there would be one on the market to satisfy the demand for it. Supply is irrelevant if there is no demand for it in the first place.

Even taking this assertion, it means there is effectively infinite supply so Twitter's service has effectively no monetary value to the consumer. It's still impossible to charge a consumer for it then (and the costs to provide the service have to be paid by a 3rd party in ads).

Edit: It's very difficult to build a network and get to a critical mass like Twitter. I'm still arguing it's demand constrained (people unwilling to pay) because you would see more viable competitors if it were supply.
Also it looks like they did a 3% inflation bump in the last month, as it now says $180,250 on their careers page.

Another 10% salary makes a much bigger difference when your finances are out of control. Once you are living below your means it moves your retirement date around. It's not enough to move your Fuck You, I'm Moving to Tuscany date by an appreciable amount.
Sure, I'm just saying that staking is rent-seeking. If we try to argue that it is not, that argument would also literally apply to the rent.
One theory I have is that the gravity of capital is pushing things towards a world where users pay for more and more web infrastructure costs. Decentralization, it appears, does not lead to democracy, but it does lead to less monolithic servers, and more shared mesh/edge computation. Just good business sense to offload computation on regular users, if the tech is there.
It was indeed on older official releases on those older machines, I never got into the nightly builds that much. I will try both the latest release and latest build this weekend when I work on the new hardware, and I'll report any showstopping bugs.

Now that I think about it, it definitely could be USB related on those other machines too. I've used the same cheap USB KVM for years and it has polling issues in Windows 10, I didn't even consider that might be the source of my issues elsewhere. I'll try it without the KVM and see what happens. Thanks!
How I Use Githubs Copilot (Ruby on Rails Edition)
The people currently in office certainly won't defund themselves. We'd still have to replace them by voting out the incumbents for there ever to be a chance of shrinking these massive bureaucracies (think TSA, DHS, FBI, etc). Also there is an institutional culture of corruption in congress that can only be removed by clearing house. Think of it as citizen imposed congressional term limits. That should be the default as opposed to incumbent winning 90+% of the time.

https://en.wikipedia.org/wiki/Congressional_stagnation_in_th...
Typing with the "wrong" finger because the key is supposed to be typed with the other hand is precisely why I have no desire to use a split keyboard. Let me double up the border keys, please!
There is a professional form of hackathons, often found in procurement opportunities. Participating teams/companies are evaluated via a technical challenge. While not the best way to evaluate for $X-XXXM efforts, they certainly provide opportunity to showcase.

Ive had multiple successes here.

Platform/infra and backend are the most critical parts to get right, and come automated with.

I can staff any team of junior devs enabled by tools like react to quickly implement user interfaces beyond what competitors showcase; but only due to the backbone.
> MacBook Air at $999 is Apple's entry level Mac

that's for the 8gb model

and it's € 1.429,00 on the Italian Apple store

> I think most if not all people should agree the build quality of MacBook Air M1 is better than 99% of Dell's laptop

it doesn't actually matter, honestly.

If people need more RAM and don't want to spend a fortune on the pro Apple models, they have to look elsewhere.

An ASUS ROG with 32gb of RAM and a discrete NVidia GPU costs more or less the same of an M1 Air with 16gb (maximum, I wanna stress the concept, that's all you are going to get out of it, forever)
> Imagine you have an E student, 16 years old ... it seems unlikely they'll ever be able to able to hold a job/achieve financial independence.

I'm confused; that sounds like a disability to me. If someone loses the genetic lottery and can't hold a job or achieve financial independence then that does seem like a pretty good use of disability funds. What is the alternative?

Maybe I misunderstood.
Bonus points, he'll get to embarrass her when she gets a bit older with it!

This is a good idea though. Anything that makes your bike identifiable is a good deterrent.
But it wouldn't use high band! So, why not just stick with 4G devices (cheaper, more tested), and existing solutions?
How is this different than Athena?
This... sounds extreme. I've worked in tech since 2014 following the "trade route" method of starting in IT support in a small city in England, through QA, and then into software development. I've been a developer since 2017 and currently work as a senior developer in the bay area. In that time I've moved around quite a few jobs and think I've been not been offered maybe two jobs I've applied to from perhaps twenty that I've applied for - that's without a degree. Most of my friends apply to jobs and get them - it's quite a surprise to hear someone has been rejected. Are people just applying for the wrong jobs? Or bad at interviewing? I'd have quit the industry if I was rejected from 25 jobs in a row let alone 350. Maybe these are low effort one-click applications to roles with 1000s of applicants?
Well, yeah, that's what it says. But how exactly is "checking my browser" for 30 seconds or more (I gave up on it after that) supposed to prevent a DDOS attack?
> If this were true wouldn't every employee take their labor somewhere more profitable?

Yes, this is what happens when the labor is something that can effectively be independent, operate without massive capital investment, or be relocated easily. E.g. doctors, programmers, lawyers, plumbers.

But many kinds of labor are only useful in a coordinated context, requiring capital support and infrastructure, perhaps due to economies of scale, natural monopolies, regulatory restrictions, and the like. So that kind of worker must be embedded in a firm to be effective. Currently, policy is written to support corporate firms, and suppress cooperative organization and independent labor, so there's not really an option for most workers to depart. There's no such thing as an independent one-man freelance car manufacturer, for instance.

This is the distinction between the marxist concepts of petit-bourgeoisie and proletariat.
"In (x place) there are (y bizarre events)" articles tend to overstate the popularity of the event. Yes, there is a Sauerkraut Festival in Ohio, but no, sauerkraut isn't a huge American cultural phenomenon. This especially happens with articles about Japan.
> This could be extremely useful for security. Maybe even the death of VPNs.

If that's true, I wonder if this affects Tailscale's business and how.
> 5G isn't really like 4G upgraded. It's more its own thing.

This is my understanding as well, but I have no idea about any of the details. I know there's something cool about "beams". Do you (or anyone) have a good "entry-level" article/doc that outlines some of the major features that makes it so different than 4G?
Sorry, I tend to abbreviate too much. Given the context of the article (new sexy cool redshift features ripped from Snowflake) I meant to convey “the direction redshift is heading in seems too little too late”.
>If you were able to show the idea, it looks sexy and everybody is nodding — you won.

Is this a "hackathon" or just a "pitchathon"?

I'm ok with the idea of a "pitchathon" but don't call it a Hackathon...
what? 5 users?
This is the kind of active truth reengineering that brought us here in the first place. You are the one pushing a narrative about protesters with your framing and language. Much edgy media such as the Jan 6 protester exclaiming it was a revolution are clearly compliant with this rule despite its breadth. Perhaps more focus on raw truth and what people agree to share would be better than all the heavy interpretation up front?