skysight-inc/HackerNews huggingface dataset:
> "Push all your business logic into big long stored procedures/functions - don't be pulling the data back and munging it in some other language - make the database do the work!"

This is one of the categories of opinions that I’ve heard, the proponents of which suggest that databases will typically be more efficient at querying and transforming data, since you’ll only need to transfer the end result over a network and will often avoid the N+1 problem altogether.

You probably don’t want some reporting or dashboard functionality in your app to have to pull tens or hundreds of thousands of rows to the back end, just because you have decided to iterate over the dataset and do some transformations there.

That said, I’ve worked in an app where the Java back end only called various stored procedures and displayed their results in tables and while it was blazingly fast, the developer experience was miserable compared to most other projects I’ve worked with - lots of tables with bad naming (symbol limits in that RDBMS to thank), badly commented (not) procedures with obscure flags, no way to step through anything with a debugger, no proper logging, no versioning or good CI tooling, no good tools for code navigation, no refactoring suggestions, no good tracing or metrics, nothing.

Sure, it might have just been a bad codebase, but it was worse than most of the ones where too much logic is in the back end, those just run badly, so I get the other category of opinions, which suggests that trying to use the DB for everything isn’t a walk in the park either.

There’s probably a good balance to be found and using tools in ways that both perform okay and don’t make the developer experience all that bad.
You realize communism exists outside the Soviet union right? Closing your ears and eyes and loudly going "lalalala" doesn't make the violence and death the US inflicted on most of the third world (yes, 3rd, i.e., not the Soviet union) go away. Millions dead, and you're making light of it. You should be ashamed of yourself.
> A humiliating interview, is a great way to filter out candidates that won't roll over for the Alpha.

Having the employee commit to more interviews is also a great way to get them into a sunk cost fallacy mindset, which might lead to them accepting a lower offer. There was an article about this on HN a while ago, where it was revealed that Meta would lowball you, unless you had a competing offer on the table (which can be hard to get when you need to do several interview rounds at several companies).
Care to reply with opposing facts? Literally the only German tech firm of note I’m aware of is [https://en.m.wikipedia.org/wiki/Wirecard_scandal].

Do you have some opposing examples?
They did make DES more resistant (but for all we know they had another method of breaking it). But they tried to foist Dual_EC_DRBG on everyone:

https://en.wikipedia.org/wiki/Dual_EC_DRBG
Backend says its MIT in LICENSE

Frontend says it's PRIVATE in package.json
Brain Stores Multiple Copies of Single Memory
honest to goodness, I think this lines up with my experience, at least for men.

Not sure about menopause lol!
Oh the contortions I've gone through with the query planner to get it not to do things.

Also, if you're using JSONB, long strings or other toast entries, your query plan and your performance will be wildly divorced since the planner doesn't factor in a lot of the toast IO and associated memory management. The lesson for others here is if you have JSONB/long text fields, store them in their own table.
Though G maps works in a browser, so you don't necessarily need a phone with google services running.
You've brought a good point. The exact difference between ML and AI is in the focus. ML is focusing on tossing data. Its main success metric is "miles traveled". AI is focusing on producing sense. Its main success metric is "value delivered". Therefore ML is tending to ship empty containers, aka "research to be done by scientists who couldn't find a liver cancer". Adding AI perspective into the mix could actually turn the things around.
Just bookmark the site=wikipedia feed:

https://news.ycombinator.com/from?site=wikipedia.org
No. EdDSA (with any curve) relies on the ECDLP for security, which is broken by Shor's algorithm on quantum computers.
> They just want a job, or worstcase scenario they want to coast and do less time.

I'm not seeing how this is a bad thing? If companies are looking for signals to hire me, I can look for signals that indicate mismanagement, incompetence or toxicity in the workplace (or all of the previous).
That’s why this take came across as unrealistic to me.

Housing has exploded in Canada over the last decade. Even in smaller cities like Ottawa, the prices are more expensive than cities like Chicago.

Then layer on top low salaries, and housing affordability is worse in Canada than many US cities.
there seems to me tons of gatekeeping in this field to put it blunt. but if you want to mix full stack with AI/ML use cases, i think it might be a good idea to just keep track of high-level news and services that allow you to interface between the latest functionalities with an app.

there is enough space for creating user experiences built on top of existing work instead of learning how the sausage is made. but i pray to you to not just stick to text/LLM
Postgres isn't hard to use, but it requires maintenance. You need more scripts, more tooling, more knowledge of DBA, and that may not be necessary. When you're using a database to store a few thousand rows of data, Postgres quickly becomes overkill. Postgres is a V8 engine when all you may need to power is a lawn mower.

I personally prefer to use abstractions like ORMs for most of my database interactions, and direct SQL when those abstractions get in the way (by generating expensive queries and not finding an easy fix without a large refactor).

This way, starting out with sqlite (good enough for most websites I reckon, easy to backup) doesn't interfere with any necessary migration to postgres (like when the need for scaling arises). This also makes setting up tests easier (except for the manually written SQL) because starting an application with a temporary in-memory database is a lot faster than starting a full container.

Unless I'm doing native apps, I'll probably always want to reserve the ability to use Postgres. Sometimes that means hooking up a Postgres account and such, but often that just means sticking with sqlite and leaving my options open for when sqlite doesn't work anymore.
Denormalizing data always locks you into certain access patterns, regardless of your ability to evolve schema.
"I noticed similar issues. I think the reason is that Orion on iOS supports fewer Web Extension APIs than it does on desktop (see the list below). As far as I know, uBlock Origin makes heavy use of the webRequest API, and this seems to be mostly unsupported on iOS. So I decided for me to use uBlock Origin only with the Mac version and rely on Orion’s built-in content blocking on iOS."

"When using the uBlock Origin browser extension on iPhone or iPad, it is unable to block any ads or trackers on webpages. The displayed interception count always remains at 0. This result is consistent whether downloading the version from Chrome or Firefox's software store."

Sounds like from that (may be out of date, some posts complaining are 15 days ago though), it runs but doesn't work:

https://orionfeedback.org/d/7741-ublock-origin-not-working-o...

This is in there officially from Orion:

"This is because Apple limitations, we will continue to improve Orion's native ad-block."

You should maybe give an apology unless you've been actually using it successfully with all features, not just installed it successfully.

Firefox Android actually runs real uBlock Origin in the ways you would expect.
> Aside, anyone have an insight into how do you suddenly get a "tax bill" from the Austrian government for 15k Euro?

Extra income from contracts and failed to set aside enough? I've had big tax bills before, it's not that unusual, and I'd get the temptation of dipping into money set aside if subsequent income has been lower than expected. But tax authorities do tend to be flexible about repayment plans most places. Maybe that's not true for Austria.

The bigger issue there for me, though, is that a scammer is not going to hesitate to fake a tax bill. Why the bank think that would prove anything suggests to me they haven't thought this through very well either.
Your experience seems pretty unique to me.

My family uses Android exclusively (including extended family) and the only cases where performance degraded is with very cheap 10+ y/o phones that could no longer keep up with system updates that now take most of the storage space.

Even those more or less still work after reflashing a leaner FLOSS ROM.

Did you perhaps buy a crapware chinese phone and are receiving bloat/spyware?
The "pedo guy" incident was the turning point, at least publicly. Before that he was eccentric and an emitter of a lot of flowery bullshit ("full self driving next year!") but mostly harmless, and probably doing more positive than negative.

After that it was just one unhinged incident after another, growing worse and worse.
This isn't as much of a problem on Android because it allows installing apks. There's plenty of apps that couldn't possibly be allowed in Google Play that are distributed using alternative means.

It's a much more serious problem with iOS, where if Apple doesn't like your app, your service, your policies, or even your attitude, you just aren't getting your app out to your users, period. But we'll see where EU DMA takes this.
> In France it's mandatory in a company to have a "company union", after 10 employee it's one representative (employee who has part of his paid time dedicated to employees support functions, and it grows to more and more the more employees there is.

In Germany, that's called "Betriebsrat" (something like "company council") with pretty much the same purpose.

And then there's the "Gewerkschaft", which are unions not for one company but for entire sectors of the economy who - through their numbers of members - are able to do collective bargaining for the employees of their fields of various companies. E.g. "IG Metall" being the industrial union of metalworkers, which considering Germanys large manufacturing background is the largest union in the country.

See also: https://en.wikipedia.org/wiki/IG_Metall
Ideally, installing apps from third parties should be as easy as from the google play store.

Today, when I install an APK I get a 10 seconds unskippable warning screen about "potential dangers", and after installing, another unskippable 1 minute "security check" screen. All of this bullshit is 100% done to deter most people from going through, by scaring them or making it a chore.

Also, apps installed through APKs do not update automatically, you have to fetch the updated APK file for every updates and go through this painful process again.

Ideally, we could use third party app stores, that would be allowed to provide the same level of comfort as the play store.
I’ve heard stuff like this from supposedly senior people - if we use mongo we can just store anything, we don’t need to think about a schema (also you can only store short strings in an SQL database)
>Their citizens enjoy good protections in many areas and they get [to] the enjoy the fruit of the American ~suckers~ I mean workers.

Thanks for taking one for the team, American workers.
Love, Europe.

(Much /s for the unironic.)
I see it, that makes sense! Right, I don't think that you'd have a reason to swap RDMS unless licencing issues come up, like with Oracle. Thank you for helping out.
Ask HN: Why is the default audio volume 100?
Almost all volume controls start at 100% by default. Whose idea was that? By the logic of volume regulation, it will certainly be too loud.
You're comparing Android (an OS) with iPhone (a phone brand).
Newer versions of Postgres also support dropping indexes concurrently. I recommend using the concurrently option when dropping unused or unneeded indexes on any table with active writes and reads.
https://www.postgresql.org/docs/current/sql-dropindex.html
> You can only have so much RAM. You can have a lot more than you'd think, but its still pretty limited compared to hard drives.

Your data fits in ram[0].
[0]: https://yourdatafitsinram.net
I was thinking along the same lines, you need professional editing for professional results that seem like they were written by thoughtful individuals.

No differently than any other "content" which is churned out rapidly and mindlessly over the centuries.

To make it appeal to actual readers, somebody has to take these sketchy drafts and refine them with a human touch.

If you want to appeal to thoughtful individuals.

Usually if it takes less time to put something into words than it takes for a person to read those words, something is wrong and people will be able to tell that there has been no professional treatment.
So like how do you do that? How do you store the user record for example as kv?
That's interesting way of doing things, I'll admit. Thank you for helping out :)
Maybe of-topic but related,

For years I've wanted a robot vacuum cleaner with home mapping (to optimize routes, limit sections even by day, etc.), but they all ask you to connect to the Internet in order to use them... It is madness.

Map of your house, habits/presence and so on, I don't want to give any ideas. So I prefer a manual vacuum cleaner as one finish faster and better, at time one do a bit of exercise also.

The only way I could think on buying one of such things is to be able to use all such mapping functions without the device being connected to the internet, and also that nothing could be connected to the device remotely if I don't give permission at that moment (Even to program it I'd prefer to connect it via USB to whatever, with the requirement that the app working as UI cannot connect to the internet, of course).

I don't like this trend of recent years with devices on general. Looks like "smart" is an euphemism for "spy", spy-tv, spy-phone, spy-home, and so on. The key here is, internet connected.
Well, stifling regulation is one problem, but the real reason the EU is behind is the lack of a single place with low taxes on investors and talent.

The effect is compounded by all the smart talent going to SV or large rich cities (London, Zurich), leaving scraps to the rest.

Unrealized capital tax gains being reinvested tax free made Silicon Valley's exponential growth possible (which is the only reason why a16z was forced to back Trump despite the Tech are being overwhelmingly democrat leaning - they're scared they'll be taxed out of existance).
Which dating app.

Never seen any app able to deep link beyond the first level in Settings.
> User X just sent 1 million packets in the last 5 seconds! Shut him down!

How can you tell the difference between participating in a DoS versus uploading a file?
I hope this gets resolved, OrganicMaps is a great app for OSM and is crucial to increasing OSM adoption
Without being specific to this law when you visit a country you follow the laws of that country and hit your home country's. In this case it would mean that apple is not obligated to offer you access to alternative stores while visiting US.
I'm not big into games but the app store listing itself doesn't seem that compelling. Perhaps to people who follow the developer or heard about the game from the friend that's okay but I think to capitalize on traffic from the app store the listing itself could use some work.
I get the relational bit. But can you expand on the Smalltalk one?
That's heavily location and use dependant. Why would Google Maps be better than OpenStreetMap locally downloaded for off-line use into OsmAnd or OrganicMaps? In much of Europe Google Maps can't even compete with OpenStreetMap data as soon as you get to trails, paths, and minor local roads.

Besides, if you have a wireless signal, you can always just of the browser with Google Maps.

A real backup means having a paper map when hiking, and just following the local road signs when driving. When things really go wrong, Google Maps is just about the last thing to use.
N=1, here.
Where i am it's 2 weeks and has to be declared online (so the employee can't withdraw it, without the boss agreeing to keep them on).

2 weeks in der EU is common, 1 month rarer...3 is a lot and leads me to believe there's a lot of € at stake in this case.
Ask HN: How do you sync your Git repos across machines at home?
I have a multi machine setup and I don't want to use a third party service as a proxy to what I could be doing locally.

One obvious answer is to stand up my own local git server, perhaps finally put those Raspberry-pi's.

Any suggestions to improve upon this?

Even if I do go down the path of the raspberry pi, how do I configure it to hide behind the router where it is shielded from the external internet. (I want it completely disjointed from the internet if possible)
The best thing here imo is the 'x-step coffee day' (how complicated/burdensome does it feel to make coffee today), that's brilliant.

I don't think these techniques ever generalise that well, everyone needs to find something slightly different that works best for them. For example, I do accumulate stuff in a todo app and an aura of dread with it, but I can't imagine starting a new list every day, that's even worse to me. I do sometimes find it useful to add stuff I'm going to do anyway, as described, though - gets the endorphins going I suppose, gets me into the swing of ticking some things off before tackling something bigger that's been sitting there a while.

That works just with tasks/chores in general too, even if not listed. Last weekend I decided I needed to thoroughly wipe down the kitchen counter, which necessitated washing up first, and then before I knew it I was cleaning the oven. Hadn't intended to do that at all, it did need it though. (Of course, almost as soon as I had a nice clean door again, the bulb blew... Maybe I'll get around to that today.)
Maybe by this measure if you "turn it up to 11" it wont hurt your ears?
Good Lord the level of incompetence is terrifying
I believe what the author has in mind is the fact that you need to create your LSI at the same time as you create the table, you cannot add them later (until GSI). So there's some truth to what they are saying regarding access patterns.
Same here, I have a Samsung XCover Pro bought 4+ years ago that still feels the same as when I got it. The only thing notable is the lack of 5G support, but it's only when I switch between it and my work phone (which has 5G) that I really notice the browser loading times.
Thief Stole Thousands of Burgundy Bottles but Never Drank a Drop
Weight Loss, Diabetes Drug Could Slow Alzheimer's Progression,Preliminary Study
Yet epic if it wanted they can release the game on macOS but they don’t want to
No, nowadays many official documents come with a URL (often in the form of a QR code) linking to a digital copy of the document stored on a governmental server.
> is there case law where courts reach in and modify licenses separate from the authors' explicit intent

What are you on about? The explicit purpose of a license is that it's users do not have to worry about anyone else's "explicit intent". A license needs to be unambigious about it's terms, else it's just not a good license, hence see the discussion in this thread about the meaning of derivative works.

It may very well be that the FSF/RMS/GNU Project had some intent on it's use when creating the GPL/AGPL v3, but a court in another jurisdiction will not care. I have no idea how to get a hold of the FSF when I'm being sued for license violations in europe and even if so, I doubt a court would care about the FSF's interpretation, given that they're likely not a party to the proceedings.

I'm surprised that people on an US centric site believe that intent in US jurisprudence matters, because in a legal system largely based on precedence, it really does not.

> No, again the difference is incorporation. In order to subclass something you have to incorporate it into your code.

You have to do the same thing in order to use API's. I'm sorry, unless I don't understand something here, this doesn't make sense.
In this thread, we're making a comparison to running Sqlite. Fault isolation is not an argument.

And you don't have to run Docker to run Postgres, it's just an easy way to do so. Even airgapped.
Why the clickbait title? It cheapens the first impression greatly.
Python isn't hated AFAICT, though people will profess to hating building large projects in it (myself included), but many of those people also love it for shorter programs and scripts.
> In competitive markets prices approach the cost of production rather than absorbing all of the disposable income of the customer. If you have uncompetitive markets, that is a separate problem with its own solutions.

All markets are a bit uncompetitive — if they were not, if they were perfectly elastic and frictionless cows in a vacuum, then not only would anyone making a profit be undercut by someone willing to make less profit, a cycle which would repeat until profits became zero, but so too would wages be undercut by anyone else willing to provide the labour for less, with the same cycle driving income to subsistence + internet in our present case (or pennies per kloc when LLMs get better).
A Man Who Was Not There – What Einstein Is Doing in "Oppenheimer"
I was checking out their docs and ran across this option for channels:

> HLS Direct does not transcode content and can perform better on low power systems, but does not support watermarks and some clients will have issues at program boundaries

Sounds like that might be what you’re looking for?
I haven't used row level security, but wouldn't it be easy to set the table up such that only a dedicated recovery role could select rows that have deleted_at set? Then the view wouldn't even be necessary.
You can also shard with postgres, how is that a USP of Mongo?
I have always asked the first part of your first question, but it never occurred to me to ask the second part as a follow-up. It reveals a lot about a manager - if there isn’t a thoughtful answer that’s a red flag for me.
Out of curiousity what were the things you shouldn't have used node for?
A family member works in banking phone support and the scams people get caught by are unbelievable. Every week people are convinced by scammers to give their bank cards to a taxi that arrives at their house (supposedly sent by the bank), they transfer 1,000s of euro to foreign bank accounts (supposedly at the request of the bank to safeguard the funds), they lie to the bank (somehow convinced by the scammers), etc.
Indeed, but with a major difference:

Your side has a significantly higher cost technical dependency than we don't have.
Do check the settings! IIRC blender specifically has a toggle between a 2-button and 3-button mouse. Maybe even single button is possible, I remember using ctrl and alt with a stylus.
Caveating a few things: Firefox nightly works pretty much just as well and as stably as the regular build and brings back extensions. Months ago they did something with PDFs that made them ridiculously slow, and nightly for some reason doesn't let me open PDFs in other apps like stable does. But the combo works for me. I agree that this is Mozilla's fault, though. Until most websites stopped working (how is beyond me but for example github wouldn't let me click links) I used the last version before the redesign
You can install ublock origin but it doesn’t actually do anything on Orion on iOS. I tested it not too long ago, maybe things have changed but Orion still uses WebKit and iOSes APIs. I have heard Orion’s default ad blocker isn’t bad though.
Or artemisinin, which was discovered by Chinese researchers reviewing TCM texts discussing treatments for malaria. (The lead researcher, Tu Youyou, received a Nobel Prize for her work in 2015.)