skysight-inc/HackerNews huggingface dataset:
His book SQL Performance Explained is also very enlightening as well. I think the most useful takeaway I got from that book is that the effectiveness of an index is heavily determined by how the application will be querying that table. If you want to design an effective index for a table you should experiment with multiple options and benchmark the queries that the application is going to run.
That's correct though OWL also provides ways to constraint what can be encoded (e.g., the cardinality constraint example I gave). But yes, SHACL is primarily for constraints. I general, there are several other standards than RDFS and OWL I didn't mention in the post. I wanted to give a few example standards to explain to show how RDF + standards forms something more than a regular data model that developers think of.
Every time a democratic US president suppresses a strike, the world acts like it's the greatest thing ever.

A lot of kennedy era political art and the positivity around him was from him "crushing" labor unions, especially big steel. I was struck by this while visiting his presidential library in Boston.

I kind of hate it. The reality is that most people "think" they like unions, but in reality they seem not to.
You can fix that in Windows: <https://wiki.archlinux.org/title/System_time#UTC_in_Microsof...>
Toyota's [IMHO correct] insistance on manufacturing hybrids instead of full-EVs is what is going to help them be so successful. My Camry hybrid gets 50mpg+, and "re-charging" it on roadtrips is as simple as filling the gastank.
SEEKING WORK - Remote | USA

We are a small remote full-stack design and dev team. Our portfolio: https://stratosphere.digital. Some recent projects we've worked on: https://pathways.org/mobile-app, https://axiosint.com/digitalsolutions, https://divvydose.com, https://emulatebio.com, https://conveyour.com, https://www.webvideocaster.com, https://ways2well.com.

Some of the technologies we're most familiar with: Web and mobile design, UI, UX, iconography, illustration, design prototyping, PHP, Node.js, Meteor, Python, Ruby, JavaScript, HTML, CSS, Sass, LESS, Stylus, CoffeeScript, WebSockets, AJAX, MongoDB, Redis, MySQL, Cordova, PhoneGap, React Native, iOS, Android, Browser extensions (Chrome, Firefox, Safari), AWS, WordPress, Joomla, Drupal, C, C++, C#, Java, Objective-C, Swift, pharmacy systems such as QS/1, HL7, HIPAA, Smart Contracts, Motoko, Web3.

We offer hourly rates and discounted monthly retainer options. Contact: via our website or you can contact me directly at eliyah@stratosphere.digital.
This is something people oblivious to their lucky breaks keep saying to themselves.

>you're going to feel lucky when you do finally get a hit.

Yes, because if I try something for 15 times and only 1 time succeed it is not my skills that worked, otherwise they would have worked the first time, it is pure luck. So I feel lucky because I am.
Does sqlite support credentials?
Also, even further down, the large increase in almond cultivation in California.
City Innovate | https://cityinnovate.com | Senior Full-Stack Engineer | REMOTE (USA only) | Full Time | $165-$215K

I’m the CEO and former CIO for the City of SF. City Innovate is a public benefit corporation helping modernize government agencies through document automation (think enterprise Google Docs - smart templates, granular permissions, workflow). We have product-market-fit, are profitable, zero churn, and are growing quickly. We have some of the largest govt agencies in the world as our customers.

We’re looking for a Senior Full-Stack Engineer who is comfortable with Ruby on Rails, Tailwind, and JS to build the next version of our application.

Please apply by sending an email to: remove-this-text-inculding-last-hyphen-product.leadership+hn@cityinnovate.com
Yeah. That's something you would expect databases to be good at. Expecially as normalization and many-to-many relationships make multiple JOINs common, which was my point.
I solve this with an absolute limit on time to 15 minutes a day.

This blocks even educational apps.
In my experience (I know nothing about this) if I needed to join a lot, I’d actually create new tables which routinely aggregated that data into tables I could query more efficiently instead. Especially if it was analytical data which was used for things like dashboard reporting.

It seems excessive at first but the performance is so dramatically better that it makes a lot of sense. Especially if the queries are part of your hot path. I always thought of it like having core business logic tables, then utility tables which are essentially derived from those core tables.
I've never liked Slack, but it's UX perfection in comparison. I'm so sorry you have to tolerate MS Teams. Have you thought of quitting? Joking aside, it says a lot about a company when they use MS Teams.
At most Target and WalMart locations, yes.
> I didn't see anything about this in the repo that everything definitely stays local.

If this is your concern, I'd encourage you to read the code yourself. If you find it meets the bar you're expecting, then I'd suggest you submit a PR which updates the README to answer your question.
If that is the takeaway the industry takes from this, it will be a huge mistake. We are talking about this at all precisely because it was open source. Commercial closed source software can simply be assumed to be compromised. We know of enough instances of it happening that if you still have a knee-jerk "oh that sounds like a conspiracy theory" reaction to that claim, you need to recalibrate your conspiracy theory meter, quickly.
You don’t need MLX for this. Ollama, which is based on llama.cpp is GPU accelerated on a Mac. In particular it has better performance on quantized models. MLX can be used for eg fine tuning etc. It’s a bit faster than PyTorch for that.
Also the practicality and usefulness of this information isn't there for people who already speak German fluently.
Funny, AMD CPUs have started becoming viable (and then better than Intel) five years ago.
We have 7T at my old uni in Alabama
I wonder if this is helping weed out the "africanized genes" (bees that will far more easily sting), or have southern beekeepers given up in that regard?
Location: New Hampshire, USA (GMT-4)
Remote: Yes (Since 2014)
Willing to relocate: No --I would be willing to do periodic travel on-site as needed
Technologies: Python 3+, htmx, Linux, SQL, Tailwind CSS, Vi/m
Résumé/CV: https://www.linkedin.com/in/samuel-woodward-b4170162/ | woodward.fyi
Github: https://github.com/PyWoody
Email: sam@woodward.fyi

I have had the good fortune to spend the last decade working at the ground level of a startup. By starting from the bottom and working my way up to a Senior Director level position, I have been able to get a unique view of how a company functions while being part of the decisions and mistakes a company makes as it goes from being on the brink of bankruptcy to growth on a global scale.

My initiatives to continuously automate as much work as possible, re-evaluate working processes, and improve redundant systems allowed the company to grow at an exponential rate while not increasing headcount. The extra capital this saved us allowed us to easily handle industry-wide downturns without having to cut any of the workforce or pull back on any projects or goals.

I am fluent in Python 3+ and don't have much desire to write anything else at this point.

Areas that currently interest me are

* Climate Change, Climate Tech
* Agriculture, AgTech
* Automotive
* Robotocs (MicroPython)
* Solar
* General Charity or 501(c)(3)
* Research Lab
* National security

but I'm open for anything interesting.

As far as hobbies go, I enjoy woodworking with hand tools, mowing the lawn, and watching whatever the Criterion Channel suggests.

Please feel free to reach out if you have any questions or would like to follow-up. I am always glad to chat! If you're ever in Northern New Hampshire, first round is on me.
A major issue with generated art is precision - you never get perfectly repeatable details.

Let's say if you try to make a Family Guy episode using generated video, the characters would come out slightly different in every scene. You could generate 100 outputs for every scene and try to pick the best one but it still won't be very good.
I've been supplying relatives with ThinkCentre Tiny for about $80 and they are great – https://amso.eu/en/products/lenovo-thinkcentre-m710q-i3-6100...
My sense is that the part about credit/collaboration was actually somewhat overblown among the detractors. What roughly happened as far as I can remember is that JT and another person worked on mmap together with about equal contribution, though the other person might have been the one to have initiated the idea (and solicited help to push it through); then at some point JT decided to make a PR to the main repository in their own name, but crediting the other collaborator as a coauthor, which may or may not have been coordinated with the other person. After that, though, in a fairly characteristic fashion, JT started fielding adulatory questions from their fans (on Github, but also on HN, Twitter and possibly other media) about the change, and quickly switched to simply referring to it as their own, with no mention of the other contributor. The other contributor expressed some misgivings about having their contribution erased, which were picked up by a growing set of people who were generally resentful about JT's conduct in the project. As far as I can tell, when confronted about it, JT at no point explicitly denied what the other person did (and I think the commit logs should all still be there in the fork), but at some point the other person just decided to stop pushing the issue due to being uncomfortable with becoming a playing ball in the fandom war between JT fans and antis.

My personal main gripe with JT really was the tone they adopted in the Github discussions, and the effect of the large numbers of drive-by supporters, who were often far less restrained in both unfounded claims about Justine's accomplishments and attacks on any critics. (At this point I'd also like to note that I consider some sibling comments to be uncomfortably hostile in a personal way, like the "hit piece" one.) I think that as a public persona, especially one who actively pursues publicity, you have some responsibility to restrain your followers - Justine, I get the sense, instead uses them as deniable proxies, as also seen with the instances where instead of straight up putting their signature on the "RAM usage reduced to 6GB" claim they instead choose to post a collage of screenshots of supporters making it.
In our production environment, we use XFS to run various databases, including MySQL, PostgreSQL, MongoDB, etc. It delivers performance that is either superior to or on par with ext4.

I'm interested to see if there're some ZFS users.
The Z3 didn't have conditional branch instructions.

Konrad Zuse’s Legacy:
The Architecture of the Z1 and Z3 https://ed-thelen.org/comp-hist/Zuse_Z1_and_Z3.pdf
SEEKING WORK | Europe | Remote

Location: Europe

Remote: Yes

Willing to relocate: No

Technologies: Java EE, Spring, Spring Security, REST, HTML/CSS, JavaScript, JQuery, Node.js, Python, Jaspersoft Studio, Eclipse, Tomcat, MySQL, Oracle, Git

Résumé/CV: https://docs.google.com/document/d/1lMjbMfEHKdCETFNXcV3Q4dRu...

Email: nishchalaro[at]gmail[dot]com

I am a senior backend Java developer / consultant with over 11 years in the industry. My expertise is in - building robust, secure and scalable backend services and enterprise Java applications, Javascript based geospatial maps and data visualization. I also have extensive experience with the TIBCO Jaspersoft BI product offering - Jaspersoft Studio, JasperReports Server and JETL (Talend ETL).

I am looking for part-time contract or freelance/consulting opportunities at the moment (up to 20 hours/week).

Website: https://www.nishchalarora.com/

Linkedin: https://www.linkedin.com/in/nishchal-arora
I might have missed it, but this article seems to be making the common mistake of conflating native bee species with cultivated bees. I'd be interested in knowing how native bee species are doing, especially since my understanding is that cultivated bees often compete with native bee species.
Cloud forecasts for eclipse day, April 8 2024
Yes. Every mature ORM that I'm aware of includes tools to trivialize fetching related records in an efficient manner. All people typically have to do is call the right method. In Django, for example, these methods are select_related and prefetch_related.

Also, they don't have to be slow. When benchmarking my hobby golang ORM, I found the performance cost vs hand writing optimal SQL to be in the microseconds per returned row. Small price to pay for everything it gives you: schema migrations, query builder, object mapping, validation, etc. And if you happen to have a particularly hot endpoint that needs to return tens of thousands of rows at once during a HTTP lifetime, you can always dip back down to the driver level.

It pains me that every time the topic of ORMs come up on HN that the comments are full of people warning not to use such a powerful category of tools. Maybe the tools they are using aren't very mature, maybe the underlying technologies are bit dated, maybe the documentation doesn't emphasize performance enough. I'm not really sure what's going on. Hopefully we can improve things so fewer people have issues and instead see performance improvements from using ORMs.
ORM never includes query generation. Some libraries often include both ORM toolkits and query builders, but that's like calling sorting 'encryption' because libraries often include functionality for both. That would be quite silly, and confusing for the reader.
Location: Europe

Remote: Yes

Willing to relocate: No

Technologies: Java EE, Spring, Spring Security, REST, HTML/CSS, JavaScript, JQuery, Node.js, Python, Jaspersoft Studio, Eclipse, Tomcat, MySQL, Oracle, Git

Résumé/CV: https://docs.google.com/document/d/1lMjbMfEHKdCETFNXcV3Q4dRu...

Email: nishchalaro[at]gmail[dot]com

I am a senior backend Java developer / consultant with over 11 years in the industry. My expertise is in - building robust, secure and scalable backend services and enterprise Java applications, Javascript based geospatial maps and data visualization. I also have extensive experience with the TIBCO Jaspersoft BI product offering - Jaspersoft Studio, JasperReports Server and JETL (Talend ETL).

I am looking for part-time contract or freelance/consulting opportunities at the moment (up to 20 hours/week).

Website: https://www.nishchalarora.com/

Linkedin: https://www.linkedin.com/in/nishchal-arora
10 Years of Hacker News "Ask HN: Who Is Hiring" Trends
Still behind cancer and heart disease.

More people are cheeseburgering themselves to death in this country.
Even if it’s not perfect, don’t apologize for your foreign language skills. You are still better off than a native speaker by knowing at least one additional language. And if they happen to know another language that wasn’t learned from a young age, they will understand. I’ve noticed that people usually appreciate it, and you start to see happy smiles when you speak their language, even if it’s not perfect—except English, some even get hostile if you didn’t have the local accent, maybe a Hollywood effect that the evil guy always speaks with accent.
Where do you want to publish the course to?
I had a severe anaphylactic reaction to Remicade, it was a terrifying experience. The doctor had seen it a few times before so apparently it's not uncommon.
HTML+CSS, as little JS as is possible if any at all. Notepad++

I have a (currently offline) site that uses REBOL+Vanilla for self-modification.

Why complicate your life any more than it needs?
This is a really conservative view about what ways to make art are valid. Generative art is nothing new and it can be pretty awesome sometimes.
The US simply has massive unmet demand for agglomeration and nowhere is providing it
I am trying to learn Erlang. The idea is to write a CRUD app which is a multi-user PWA app completely without framework. For front end, HTML, CSS and JS with reefjs for reactivity (these are are things I already know).

The idea is to experiment and stress test with the idea of write once run forever to the max. See how far can I get. Any resource for Erlang will be much appreciated.

Currently using exercism and Joe's book of Programming for the concurrent world 2nd edition. I guess beginner topics are covered. More interested in advanced erlang topics for which resources seems hard to come by. Specifically related to security since I would want to know how to go about the security of the backend using erlang.
Location: Hanoi, Vietnam

Remote: Yes (UTC+7 , UTC-5 OK)

Willing to relocate: Yes

Technologies: - Python [advance] - Java - Javascript - Bash scripts [Advance] - MySQL - MongoDB - LLM - Langchain - ReactJS + Redux - VueJS - Airflow - Kafka - TensorFlow - Pytorch - OpenCV - SciPy - NumPy - Pandas - Wordpress - Scikit-learn - AWS - Google Cloud - Docker - Kubernetes

Résumé CV: [Resume/CV Link](https://bit.ly/hunglethanh)

Email: lehung [AT] gmail.com

Website: [hunglethanh9.github.io](https://hunglethanh9.github.io) Linkedin: [linkedin.com/in/hunglethanh](https://www.linkedin.com/in/hunglethanh/)

Hello, I'm Hung. I am a Full Stack Engineer and Product Manager with 10 years of commercial experience and community building (esp. SaaS, Automation test) in prototyping, MVP, software development, as well as maintenance and DevOps. Great communication skills, Startup experience, team leadership, passionate about programming, self-starter, OK with freelance/consulting as well as full-time work.
As someone newly diagnosed with ADHD (and likely/suggested, but not formally-diagnosed ASD), I'm digging into both to understand how my experience differs from others. This includes things like strengths, weaknesses, the usual stuff, but I'm interested in the common ground between "neurodiverse" and "neurotypical" brains (talking in general terms here) as well as how both "sides" can better work together. Use strengths to fill in the weaknesses, that sort of thing. Eventually I may start writing some of this down more formally, but as of right now, I'm just a guy trying to understand his own brain.
April Fools' Day Articles (2024)
Share any April Fools' Day web postings you've seen today
I'm a big fan of SQLAlchemy. While not without its quirks, it lets you write relational-style queries, but in native Python, and automatically maps the result sets to objects. If you have N+1 issues with SQLAlchemy, you probably would have had them with your own custom-written SQL queries also.
> Headlines are so non-specific that you could “deliver” a headline that could easily not really meet a customer need.

I don't think so - the headline is simply the goal. If the goal is not "Customer will buy this" then your headline is simply fluff.

After all, look at the example headlines:

“You can now rent VMs through an API”,

“we rolled out FSD autopilot”,

“Treasury is available in India”.

Those are all goals!

"Urgent"[1] requests to deliver small fixes don't, ultimately, matter to business, both provider and supplier. I've never seen business switch software because of bugs. If that was the case, Windows would never have gained the foothold it had over business.

No business drops their existing system because it occasionally eats some data, resets everyone's session, or similar. The cost to switch to a competitor is simply too high.

[1] As a long-time veteran of software development (25 years), all customers prioritise all their reports "urgent or higher".
> It's clearly optimal since my CPU is listed as only being capable of going 780 gigaflops

780 GFLOP is the iGPU spec. Is this a valid comparison?

https://nanoreview.net/en/cpu/intel-core-i9-14900k
Tomb Raider Anniversary is from 2007. I wouldn't count it as an indication of how capable the GPU still is.
I use it in production so i can crawl instagram (and others) without paying for proxies. Tor is single threaded so I have 6 docker containers that run tor proxies to get more bandwith out of it. The best thing about tor is that you set it up once and it will work forever for free.
That's not suppressed, at least not in the same way things were suppressed in the late 19th and early 20th centuries. "Ruling that the strike would be illegal under the Railway Labor Act" is a long way from "send in the US Army to break up the strike".
https://www.advnture.com/news/makoshika-visitor-narrowly-esc...

Funniest quote in the article

> Bob Muldoon, chief ranger at Makoshika State Park, slammed the behavior, particularly with velociraptor attacks on the rise. “We keep seeing this sort of totally reckless behavior by Instagrammers looking for supposedly easy likes.” With raptor sightings on the increase, the hashtags #raptorsighting #whosaclevergirlnow and #myraptoreggs are currently trending on TikTok. “It’s a worrying trend,” he says.
Modern Fortran's only parallel feature is coarrays, which operate at the whole program level.

DO CONCURRENT is a serial construct with an unspecified order of iterations, not a parallel construct. A DO CONCURRENT loop imposes requirements that allow an arbitrary order of iterations but which are not sufficient for safe parallelization.
If you haven't already, I'd add Nonviolent Communication to that already very good list!
Intelligence agencies mastered fooling people about their bona fides in person a long time ago. Meeting someone in person will stop casual individuals who just want to crash the project for the lols or some other personal-level reason, but it would have been barely a bump in the road for this clearly-nation-state-level attack.
> Right, the only thing that convinces me is team and hiring dynamics. But that’s not what these tools advertise.

And that's fine, these tools don't solve what you search for.

A dozens of controls multiply with a dozens of events are already a quite big amount of points of failure, so people gladly trade it with the dependencies (what's the issues with dependencies anyway?).

So yeah, not many people want to be good, and only hire good people like you to use the hand tools and "just do it correctly". Most acknowledge their downsides and use proper tools to aide them.
> Why AWS, Google and Oracle Are Backing the Valkey Redis Fork

Because they don’t want to pay? Simple answer. The article also says as much.
There's nothing in the ORM that prevents you from doing what the article describes; hell, the article describes doing it with the ORM, and, double hell, the ORM does the right thing by default, at least as far as avoiding N queries goes.

The solution is to know how a database works, instead of thinking that Product.objects.filter(color="red") and [product for product in Product.objects.all() if product.color = "red"] are exactly the same thing.
Gerrymandering Isn't New - But Now We Have a Solution
The Failure of Silicon Valley Bank and the Panic of 2023 [pdf]
FWIW I use Ollama and Open WebUI. Ollama uses one of my RTX A6000 GPUs. I also use Ollama on my M3 MacBook Pro. Open WebUI even supports multimodal models.
Very apt username
systemd merged a change to using dlopen for compression libraries recently https://github.com/systemd/systemd/pull/31550 which is a safer linking method in that sense.