skysight-inc/HackerNews huggingface dataset:
There’s at least one PL/pgSQL linter out there.

When I worked on a system that used a lot of postgres triggers and stored procedures we built a little mechanism on top of our existing database migration tool that would check a directory of plpgsql files and generate migrations when they were created or updated. It worked fine.

It wasn’t the most perfect developer workflow, and I was suspicious when I first encountered the way the software used all of the stored procedures, however I came to appreciate that we were able to be a bit freer with changes to the application code because of this semi-isolated layer that took care of some critical stuff right in the database.
I will give you a different answer than what I see others saying:

Good noodles are good. You can buy good noodles. If you can tell the difference between De Cecco and Barilla spaghetti noodles then you could easily discern homemade pasta.

If "they all taste the same" then the texture difference is likely not enough to make it appreciable.

I dont even make sauce anymore I just buy a jar of Raos.

Its funny how we compliment a commercial endeavor as "this tastes homemade" and a home cook as "better than what you can buy".
Learning to make homemade pasta is an investment that pays dividends. It’s like a piecrust; the first few times you do it, it seems overly difficult, and you’ll wonder why you didn’t just spend $3 at the store, but then once you get the hang of it, you can do it in your sleep. You’ll wonder how you ever thought it was hard at all. And you realize how much better it is.

I no longer buy noodles unless I want a shape I can’t cut.

My best advice: get a motorized roller if you don’t have a helper or a functioning third arm because you kinda need two hands to guide and retrieve the pasta. I like the roller that goes in my kitchenaid. I don’t love the extruder, the pasta has to be wetter and the final results aren’t as good. This recipe would just jam it since he’s using a low ratio of flour to egg of 3:2.
> But nothing is stopping you from running Postgres in a Docker container, and wrap it in a unit test with the technology of your choice

I agree. I'm in .NET land, I use EFCore as my ORM, and I use EFCore's migration features. My ORM models are in a separate project (same git repo) from both the web server project and test project, and any hand written SQL gets added to the migration scripts that EFCore generates.

I spin up a docker container for postgres, my test code clears any existing DB, creates a DB in the container, and then runs the EFCore migrations on the DB. I have simple tests that make sure my CTEs are working correctly and that things like expected unique indices are also setup.

This works both locally and in Github Actions.

I just wouldn't call any of this a "unit" test. I put all this squarely in my integration test suite. I figure if IO is happening as a consequential part of the test (i.e. not setup/teardown), it's an integration test. I wonder how much that distinction is tripping people up? A lot of people think of unit tests as small, independent, and quick, so by only thinking about unit testing, they automatically rule out tests that have app code call out to a DB.

Based on the sibling comment, I'm going to have to take a look at Testcontainers. I'm not sure how much it'll simplify at this point, but who knows!
The same John Barilaro who resigned as deputy premiere of NSW because it was getting very hard to cover up all the corrupt schemes he was involved in. The same fella who created a special job paying six figures and then handed it to himself, while still in office: https://en.wikipedia.org/wiki/John_Barilaro#Investment_NSW_a...

Of course, there's no corruption here - hence our infallible public rightly perceiving none of it! (/s)
The first data warehouse at Gitlab was postgres! It worked quite well until we started pulling Snowplow event data.

I share some of the concerns of other commenters of having postgres do everything. Having a separation of concern around orchestration in particular seems wise. That said, getting something up and running using just pg makes sense and it's always possible to refractor.
What is GALS?
Username checks out. Guess you're going for 100%?
yes. (It's not really the 'root' user, but it trusts blindly and can do things such as installing apps without user confirmation.). In my other blog post about gms, the JS bridges would be running in the privileged scope.

You agreed to this in Google's privacy policy when installing Android.
I called someone a nerd once, but it turned out they didn't feel it had been "reclaimed" like a lot of people do. I apologized, and we had a nice chat about the paths language takes. It was nice. More situations like this should go like that, but it seems like doubling down, making excuses, or going on the attack is too easy.
Top Sports Betting APIs
How do you expect that to be respected when you have things like illegal surveillance or eminent domain? A well behaving government wouldn't be the target for this, and a badly behaving one wouldn't respect it anyways.
Depends. It's used for welding, and the output is iron (magnetic):

https://www.youtube.com/watch?v=5uxsFglz2ig

I assume it would be too difficult to trigger the thermite reaction in the field with WWII tech, among other problems.
'Avatar' VFX Workers Vote to Unionize
Even a supreme court can be wrong sometimes. In the US that's been happening more often of late.
The Mystery of Chernobyl's Post-Invasion Radiation Spikes (2023)
Av1 consumes most modern CPUs at 4k+. Sure if its 264 with 1080p res you haven't had issues.
For documents that require a longer process, I prefer formats that I can use comments and TODO in, with a text editor that feels familiar.

Other than that, I strongly agree. Word is also de facto standard when you want others to open and edit your document.
The same laws benefit you as well as politicians. You can pick up the phone, call your neighbor, and discuss politics at any time without fear of reprisal from the authorities. Try doing this in Cuba or China, you will end up in prison. In my view, every citizen in a democratic country is not only permitted to but obligated to participate in the political process, which is why political activity is exempted. If you don't want to participate, if you don't vote, or inform yourself of issues, you still benefit from all the same freedoms & protections of the law as those who do participate.

This is an important point, because the exemption of political activity is due to the protections of political speech. Imagine if it were not this way, the party in power could simply fine or even arrest their opponents for trying talk to people over the phone. This happens every day in nondemocratic countries. This protection should not extend to AI though. AI doesn't vote. AI doesn't have a voice in a democracy. So allowing AI to benefit from this exemption should not be permitted. I tolerate PEOPLE calling me, because I am a voter and they are voters and we must all discuss the direction our laws should go or who our representatives should be (when we have time). But AI should have no place in the political process. Not for robocalls, not for choosing representatives, and especially not for lawmaking.
This is what I use. I'm used to it but don't like it.

The noise doesn't bother me much. By the time it ramps up I'm asleep.
Google products by launch date:

Search: 1998
Gmail: 2004
Maps: 2005
I used to use Mutt, but now I don't because my email has its own special domain, and the email hosting service I use doesn't let me export IMAP and POP3 details unless I pay them.

Currently, I just open vim in the terminal, write what I need, then copy the text. I open dmenu using a shortcut, type something like "unwr", which is sufficient for selecting the "unwrap-clipboard" script of mine, press enter, which unwraps the text on the clipboard. Finally, I paste it in the email client.

I know it might seem a bit tricky, but it's better than what I did before. I used to set the textwidth to a really large number like 9999, highlight the text I wanted to unwrap, and then type 'gqq' for formatting. And don't forget, you also have to wrap the text back if you don't want to change the original format of the text file you wrote.

You can use soft-wrapping in vim, but I don't prefer it. Soft-wrapping is not as convenient to me as hard-wrapped text when using vim shortcuts. For instance, if you are using soft-wrapping in vim and you press 'o,' the insertion mode will start at the end of the paragraph because vim will consider the entire paragraph as a single line. However, there are many situations where I only want to insert text in the middle of a paragraph. You will also most likely set j to act like gj and k to act like gk, to make the cursor move between lines that are visually separated but actually form a single line. I don't like this either.
Why? It's because you're making other people pay a large part of the cost for your convenience. We aren't going to tolerate it forever.
Dry and fresh have a different texture to the mouth to begin with and fresh ones are cooked in 2-3 minutes instead of 6 to 15 minutes for dried ones.

Now between homemade fresh pasta and industrial fresh pasta yes I find a difference but mostly in texture. Between my homemade pasta and homemade pasta from the local italian grocery it is mostly a matter of taste (amount of salt, using eggs or only water, etc).

I rarely do homemade dry pasta because it involves a lot of space.
First I clicked on "View PDF". Then on the PDF page I clicked on the Download button in the upper right corner. This gives me a PDF with the Creative Commons notice in the left margin of every page.
AI learns language through the experience of a single child
> You have just described a good ORM used well.

No. I did not. ORM is an "object–relational mapping." It maps data relations onto objects.

https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapp...

> how often do you actually switch databases?

Very often. Virtually all of the systems I write have at least two back-ends to maintain that flexibility. At the very least, I'd like my systems to run well locally for development but also to scale. The easiest way to do that is to e.g. support both SQLite and Postgres, but there are other ways which make sense.

In proprietary settings, I like having a BATNA. The architectural flexibility means I get better prices on hosted services and aren't liable to turning into a cash cow through lock-in. That's savings even if I'm not switching.

> If your object model is already clean and following relational principles, then mapping into that model is exactly what you want.

This is where your thinking broke. A good object model is NOT a relational model, and a good relational model is NOT an object model.

Learn the theory of both. They're both good theories, but they're different.

An ORM makes sense if you want to use an object model, but want the backing store to be an RDBMS.

> But what ORMs should be able to do (and I haven't found one that does this well) is generate SQL migration scripts for you, which you store. Those would be frozen relative to the database schema version, so all the above problems go away.

I believe that's one instantiation of what I wrote: "This may and ideally should have added functionality, for example, around managing and organizing database migrations." It's actually exactly what I was thinking.

Some ORMs do this not badly, actually. Don't let the perfect be the enemy of the good. A simple system which does 90% of the work of generating a migration (with manual verification and tweaks) is often better than a complex one which tries to do 100% of the work.

> The underlying relational model is powerful and elegant. SQL itself is not. SQL is disliked by the founders of the relational model.

Citation required.

In either case, ORMs aren't translating just syntax, but also semantics. That's where the problem lies. If you're not doing that, you're not an ORM.

> Good ORMs let you incorporate the relational model into your code.

You're confused about what an ORM is. ORMs essentially map an RDBMS onto an object model (which an OODBMS does natively). The two models are fundamentally different. It's a translation layer.

Any good database library will let me "incorporate the relational model into my code." That's not an ORM.
OK, but it seems to me that, even now, the market isn't exactly crazy about VR googles. They're expensive and the novelty of them is fleeting (haven't tried the Apple ones).
>The sleep period consistently occurred during the nighttime period...was not interrupted by extended periods of waking...
That's not true for postgres scanning: https://duckdb.org/2022/09/30/postgres-scanner.html

So i would think we'd see similar speedups for sqlite even without copying any data
Yeah I did this for a while and went back to store bought pasta. I just don’t have the time. It’s definitely more delicious but at 4x-8x the time cost.
If you want an open internet don’t use the app and just use the website that works.

Good grief
InstantID: Zero-Shot Identity-Preserving Generation in Seconds
I mean the software is never used inside the EU. The final product is built outside and later imported, so you don't know what software was used.

An example: EU is approving very restrictive legislation about pesticides for use inside the EU but it happily allows importing food grown in other countries using the very same forbidden substances.
I need to try it. I assumed it wasn‘t possible because no recipe I have in my books ever did pasta dough without eggs.

Thank you! TIL.
100% Agree, humans love drama. Especially when they aren't in it.

Natural responses to this would be "I don't like drama" and I would say the same, unfortunately this isn't the case for most of humans.
I didn't say it's a solution.
Pandas? Polars?
If Google care in the least for kids they would scrub all of those games that are predatory, introduce gambling addiction mechanics, use annoying and confusing in-game ads, and gateway to older even more addiction focused apps. Notice I didn't even mention all of the information hoovering.

And of course the Play store is desperate for you to provide a credit card at every single opportunity so you can maximize the potential of kids doing accidental buying.

It is a complete scam.

I honestly don't know how television got such strict laws and regulations on children's programming, when viewed in comparison to the complete wild west, that is the modern app store.
macOS Emoji panel works slowly when more than one "Input Source" is set
Nothing I said was about automation per se being bad? I'm not sure where you got that from. I was specifically talking about the relative carbon emissions of machine learning models doing something versus human beings doing something, and that the former doesn't have an advantage over the latter in emissions in my opinion. I don't think that really applies to automation in general, because I wasn't really making a point about automation, I was just making a point about the relative emissions of two ways of automating something. I actually agree with you that in principle automation is not a bad thing, and that economies can eventually adjust to it in the long run and even be much better off for it, although we would probably disagree on some things, since I think our current economic system has a tendency to use automation to increase inequality and centralized power and resources in corporations and the rich as opposed to truly benefiting everyone, because those with economic power are going to be the ones owning the automation and using it to their advantage, while making the average person useless to them and not directly benefitting us. But that's an entirely different discussion really.
Show HN: EnhancedJournal – Elevate Journaling with AI Insights
Hey HN! I'm a Toronto developer passionate about journaling. I created EnhancedJournal.com to apply LLMs to my journal entries, providing insights and reflective prompts by analyzing my entries against a psychology database. The platform prioritize privacy; all entries are encrypted, ensuring personal data remains private. The once-a-day entry will always remain free forever as well. Open to feedback and discussion. Thanks for checking it out!
The things they show you on primetime news is what will bother you. ;)
Okay, but what other choice do I have? Neuralink?
Why would I want to drive somewhere just to shop? I don't care about rain. If it is absolutely pouring I don't need to to out. I don't feel the need to live entirely disconnected from nature.
Not lack of citations but lack of literally anything to back up a pretty egregious claim. Also what does deforestation have to do with corruption?
its definitely a lot more work than just buying pasta :P
Since your project is apparently about robots, how do you handle concurrency with Oberon? Or how can you avoid it? In case you're willing to share experience, you can contact me on me@rochus-keller.ch. (Btw: I'm currently working on a low-level version of Oberon without GC which can be used as C substitute.)
You are right, of course. I had Meliès in mind, not sure why I wrote Lumiere brothers.
I don't understand, how is this sarcasm?
Now we need Taylor SWIFT to develop iOS apps....
What would be a good way to choose a color palette for a gradient background?
>>However, if XXX of party YYY subsequently starts getting death threats or other harrassment as a result of this statement being made, there is a problem.

How can you control that, though? Are people responsible for the mental state of all their followers? Or do they have to ensure that every utterance is so milquetoast that no action would ever come of it?

I'd have less of an issue if these rules were to be applied in a politically neutral fashion, but we know they never will be.
I'm not in any list and get like zero per day. One a week maybe. How am I so lucky?
Skitsnack spritt av friskusar som vill impa på andra (jag var också sådan, tills jag blev frusen på gamla da'r) eller av klädindustrin. Låt oss skylla på norrmännen, det var säkert Helly-Hansen.
Top SaaS Boilerplates Directory: Features, Names and Prices
tldr: here's the directory https://www.launchnow.pro/saas-boilerplates-directory

If you've planned on purchasing a boilerplate for your next SaaS, chances are you would have stumbled upon this GitHub repo:
https://github.com/smirnov-am/awesome-saas-boilerplates

It's amazing, but still a considerate amount of effort in finding the one you want based on features & your budget.

Then I came across these directories:
- https://saasboilerplates.com (love the ability to filter by stack! but prices not listed on main page, have to open each individually, no way to sort by price or search)

- https://saasitron.com/ (quite comprehensive! but again no prices listed on main page and no way to sort or search)

So I built one: https://www.launchnow.pro/saas-boilerplates-directory

It has all the above in a single page + functionality to sort by your budget. I plan to keep it updated and will keep on adding more boilerplates soon.

It's free to use, hope it makes your decision to purchase much easier.
https://en.wikipedia.org/wiki/Birds_Aren%27t_Real
Word has comments. They work well as todo markers if they don't need to be retained (just make a comment to mark something and then delete it when it is resolved).
AFAIK this is a webview that Christian is hijacking certain navigation events on. So the app itself isn't really native/probably wouldn't support this feature.
Why don't many executives take pay cuts to avoid layoffs?
one time i was on twitter and some asshole was tweeting mean, stupid stuff and i was like who is this asshole? what is e/acc? and then i realized he was the president of YC and it made me sad. and then i learned more about e/acc and i decided how dumb that shit is
A question to experienced Pandoc users:

I want to write a small book that I want to generate in 3 formats: HTML pages, EPUB and PDF. What is the best input format (source format) for the book? Pandoc Markdown? CommonMark? GFM?

I'm a little hesitant to committing myself to Pandoc Markdown or any Markdown because they all have tiny differences with each other. Each is like its own standard.

I considered Org-mode for some time but there are so many edge cases in which Pandoc does not parse Org-mode properly. I mean sometimes simple things like internal links are not rendered properly by Pandoc in the generated output.

So what's the best format to write the input in? Any ideas? Opinions?
So ~10% of users?
We actually have more control of our bodies than our cultural norms allow us to admit. see also: https://www.wimhofmethod.com/breathing-techniques
GDPR is easy as a small organization IF you are not greedy for other people‘s data. Keep your hands clean.
I own (part of) a small company that makes software for a small market and we had absolutely no problems with GDPR because we try to not collect any data we don‘t absolutely need.
It‘s not very complicated if you just invest some thought into your processes and don’t spy on your customers. Most of the time you don‘t need the data but someone wants to sell you a product to gather it.
Not saying it is you but most people saying they don't have the time also spend hours watching stuff on streaming.

This is definitely the kind of stuff you can do while listening to a podcast, watching a show. Additionally cooking in general is an activity I actually like to do. Give me good music, a nice bottle of wine and I can spend a lot of time in my kitchen.
Not necessarily for explosives, or you might want to wire your explosive into eg a switch to ensure it triggers under the correct conditions. From TFV, they are an invention of a saboteur division.

I guess you could use them for a number of other options, like tapping a line, although you'd probably be better off just twisting the wires in that scenario.
Or let people retain the housing they want and tax the encroaching multibillion dollar institutions lmao
>> Richard Morse, a former contributor and one of the support group admins said: “It is so disheartening to see nine years of developing the Duolingo Welsh course being thrown away by disinterested politicians.

I mean, there has to be public employees actually running the thing. It's not like a politician itself wrote anything.

This kind of behavior is so prevalent in big institutions. I wonder if it wouldn't be more effective for the Welsh government to just hand out money to the current mantainers so they at least can take it as a part-time job. The Welsh gov wouldn't be able to take credit for it, but...

Preventing thins would be as easy as to put all courses behind VCS though. Someone fucks up, just roll back.
To your last point, it might be more constructive to point out the specifics of why you are against corporate political speech as opposed to a somewhat-binary left/right of the political spectrum.

One benefit I see of it is normalizing the presence of historical out-groups (racial minorities, gender minorities, etc.) that have always existed in society.

But, in practice, the "support" can be paper-thin and the chasing of support from out-groups simply as a means to push profit margins is sometimes obvious and thinly-veiled enough to the point of growing discontent towards the groups that they're ostensibly supporting.

This sort of critique (even if I can't guarantee its accuracy) is a bit more nuanced and feels a little bit less cargo-culty than just left/right.
"Google layoffs x percent of its employees".
HN: Fckin Google!

"Here is an option to support a platform you use without watching ads".
HN: Go fck yourself!
Great guide, especially for beginners/laymen.
The point remains that Pre and Post Musk Twitter are NO different when it comes to inflammatory tweets.

The players and ordering has changed only.
Programming Language Design: Safe, Shared Mutability with Unboxed Types