skysight-inc/HackerNews huggingface dataset:
I had to implement a workaround for that for our DW which imports from two different app databases. IMO this should be part of

import foreign schema

but then you would have to qualify the names somehow if you were importing from more than one db. I wrote this as a workaround, it runs every day as part of our data import job.

DROP SCHEMA IF EXISTS fdw_enum CASCADE;
CREATE SCHEMA fdw_enum;

-- Get names of the enums using ::regtype casting and label and sort_order from app_a and app_b.
CREATE VIEW fdw_enum.app_a_enums AS SELECT * FROM dblink('fdw_app_a',
$QUERY$
SELECT
enumtypid::regtype AS name,
enumsortorder sort_order,
enumlabel label
FROM pg_enum;
$QUERY$
) AS t (name text, sort_order integer, label text);

CREATE VIEW fdw_enum.app_b_enums AS SELECT * FROM dblink('fdw_app_b',
$QUERY$
SELECT
enumtypid::regtype AS name,
enumsortorder sort_order,
enumlabel label
FROM pg_enum;
$QUERY$
) AS t (name text, sort_order integer, label text);

-- Ensure enums with the same names aren't defined in both app_a and app_b.
DO
$DO$
DECLARE
matching_count integer;
BEGIN
SELECT COUNT(*) into matching_count
FROM fdw_enum.app_a_enums INNER JOIN fdw_enum.app_b_enums USING (name);
ASSERT
matching_count = 0,
'app_a and app_b-NG have identically named enums. Implement a check that they are identically defined.';
END
$DO$;

CREATE VIEW fdw_enum.upstream_enums AS
SELECT * FROM fdw_enum.app_a_enums
UNION ALL
SELECT * FROM fdw_enum.app_b_enums;

CREATE PROCEDURE fdw_enum.create_type_if_not_exists(name text)
LANGUAGE plpgsql
AS $PROC$
BEGIN
EXECUTE format('CREATE TYPE %s AS ENUM ()', name);
EXCEPTION WHEN duplicate_object THEN RAISE NOTICE 'Enum type % already exists, skipping', name;
END;
$PROC$
;

-- To make this idempotent we create the enums empty then alter them by adding values.
-- So instead of `CREATE TYPE foo AS ENUM ('bar', 'baz');` we do
-- `CREATE TYPE IF NOT EXISTS foo AS ENUM ();
-- `ALTER TYPE foo ADD VALUE IF NOT EXISTS ('bar');
-- `ALTER TYPE foo ADD VALUE IF NOT EXISTS ('baz');
-- This ensure the procedure is re-runnable and can add new values to the enum as they are added upstream.
-- Order is ensured by the ORDER BY in the loop query.
CREATE PROCEDURE fdw_enum.refresh_upsteram_enums()
LANGUAGE plpgsql
AS $PROC$
DECLARE
rec record;
ddl text;
BEGIN
FOR rec IN SELECT DISTINCT(name) AS name FROM fdw_enum.upstream_enums
LOOP
CALL fdw_enum.create_type_if_not_exists(rec.name);
END LOOP;

FOR rec in
SELECT *
FROM fdw_enum.upstream_enums
ORDER BY name, sort_order
LOOP
ddl := FORMAT('ALTER TYPE %s ADD VALUE IF NOT EXISTS %s', rec.name, quote_literal(rec.label));
EXECUTE ddl;
END LOOP;
END
$PROC$
;

CALL fdw_enum.refresh_upsteram_enums();
Can you recommend some recipes for alfalfa? Im fine with nuts so feel free to throw some almonds into the mix.
They could all easily already be dead. We simply don't know.
Well your bio indicates I shouldn't ask ;) but how would you differentiate them? I'm very unfamiliar with the ML tooling space
https://www.bbc.com/aboutthebbc/governance/licencefee
That doesn't seem like the type of problem that can be solved with a drop-in solution.
Well built or not (clearly not) you could not pay me enough to be bolted into a carbon cylinder going down 4000 meters.

Given the whistle blower this company has no hope of surviving any lawsuits, even if the victims (passengers) signed away their rights.
I would assume so. It's Microsoft after all. All big companies have some kind of "bonus" in your salary especially in America. I think 20k is too low to be that. I get more than that and I work in the EU.
The US navy is not attempting to solve the problem space of "Tourist trip to deep ocean locations". Privately owned submersibles have long out-depthed US navy crafts, because US navy doesn't need a small craft to go that deep.
>Why does it matter? Why is that point relevant or being made?

It does matter, because as far as I tell, there’s been zero case the gov was after a person from non-Chinese roots. I’ve also seen similar cases in other countries like some south asians/arab countries, they are only after their own/previous citizens no matter what’s their nationality. Now you may ask why?! It’s simple, those are the most influential to the local public against the current regime than say a white guy lecturing Chinese people about freedom, he/she will never have the same impact than a local one who’s outside and away from any coercive or persuasive or any consequences.
EXACTLY.

I think one of the oddest things is that I don't much see the following view, which is roughly mine:

I'm generally pro the idea of crypto -- but more importantly, whether I love it or hate it, this particular fight was, or should have been, completely expected and anticipated. As in, this was the point of it; anyone into crypto should 100% welcome this battle, if you were paying attention to the idea?
It is and has been since roughly the 14th century. Although, it's apparently a subject of contention amongst grammarians (plural vs singular).

https://www.etymonline.com/word/their
This was 10 years ago for context.
Question for Gitlab: Why did you collect an email address from the user in the first place? Why does it exist in your db?

Now explain why it was not used for it's only legitimate reason for existing in your posession, first, let alone followed up with a few updates as the deadline got closer.

You have a communication channel that not only is good for this, but exists for this exact sole purpose in the first place. If you aren't going to use it for that, then you have no legitimate reason to have it and I want you to delete it.
Ha, udpated the comment.

My point was, why would this content be gated.
It’s definitely more equitable.

It also gives everyone the same incentive to not start shit (even though few ppl are in position to instigate a war) because it could be you and your family that’s sent to fight it.

However, when you’re actually fighting, you want to trust the person fighting next to you. And if that person was conscripted and didn’t want to ever be there, that’d cause a lot of issues.
Oxygen is just about running out in the next few hours, they don't seem to have had any sonar contact, no cable or underwater phone. Getting something like a DSRV (which wouldn't really help if they are at ground level there, because it cannot dive that deep) there will take at least a day. Even if they are still alive, their chances of rescue are nonexistent.
The only thing that irks me about water recycling is the seemingly discriminatory nature of the implementation. This is only from my experience in my area of Southern California where it's been talked about for years, and implemented in certain areas. Those implemented areas have consistently been lower-income, which never made sense to me. I would think the higher-income areas use more water because of lush landscaping (any view of zip codes on Google Earth will show this) and swimming pools (or other recreational use). Also, any changes (like re-piping or whatever) is probably easier in higher-income areas, as the neighborhoods tend to be newer, with more room for construction work.

It just feels discriminatory, like, "Let the poors have the dirty water."
bash scripts have their use cases, many things are shorter and simpler than in Python. But coders should bother to learn how bash works and use shellcheck. Just guessing from how things work in another language typically leads to buggy code. Keeping a daemon always running is not a task for bash. systemd is typically much better at that (although something like exponential backoff in case of failure seem to be tricky)
~600 years of historical English usage disagrees with you [1].

[1] https://public.oed.com/blog/a-brief-history-of-singular-they...
"wage slavery"

Everyone depends on the output of others. Working so that you having something to give in exchange for what you get from others is not "slavery".
Yeah, BBC iPlayer is UK only since it's funded by UK residents
Hopefully it'll over when the first top-level court of any country too big to ignore says "no", at which point anyone trying to be safe will stop allowing LLM-generated code in their codebase.
Looks like it's licensed to "BBC Select" in the US. https://www.bbcselect.com/watch/take-me-to-titanic/
> crime is a universal aspect of money, so of course any form of money would be a facilitator of it.

That's irrelevant. The question is whether crypto in particular facilitates crime, and it does. All airplanes facilitate passenger death, but some are far more dangerous than others. If I'm considering boarding a plane, don't tell me 'well, any plane might crash' - I don't care, I care about this plane, this pilot, etc.
That's true for gold too: Most gold transactions happen in exchanges. But the fact that there are successful intermediaries in the gold market is not an argument against gold's viability as a store of value. Ditto for Bitcoin.
Is there any way for this to end (other than sabotage and other outlandish options) in which this was not caused by a company trying to make money in an extremely unsafe way?
- "Lochridge, who claimed he was discharged in retaliation for being a whistleblower, made his filing after OceanGate sued him in federal court in Seattle that June. OceanGate has accused him of sharing confidential information with two individuals, as well as with the Occupational Safety and Health Administration (OSHA)."

https://techcrunch.com/2023/06/20/a-whistleblower-raised-saf...

I didn't know "sharing confidential information with OSHA" could be a valid (?) cause of action.
Note that the BBC is funded primarily by what's known as a "TV License"[0] in the UK - I think it's entirely possible they could probably increase ads or something for international viewers but understand why it isn't their area of focus

[0] https://www.bbc.com/aboutthebbc/governance/licencefee
Thats was dpreview entire business model though?
AI Leader Proposes a New Kind of Turing Test for Chatbots (The Auto-GPT Way)
Archive.today mirror: https://archive.ph/L1vW3
They had this but there were problems with it, if I recall correctly. So it would be disabled in "times of war" or whatever because if it accidentally popped off it was not a good time for you.
An autistic person may have difficulty reading social cues, but it's hard to imagine a clearer social cue than "this person is wearing a device for the express purpose of not listening to things".
And specifically only protective against getting scammed by someone who does not believe their own bullshit, which isn't always the case.
With everyone writing about LLMs, and not time to read them even 1% of it all, the reason to read A16z is for technical/analytical merit, or for an investment-pumping angle?
If I compare it to USB-based connectors where USB-C never came along.

NACS is like a Lightning plug. From a practical/pragmatic perspective, it was clearly the best plug at the time it was created. It solved real user problems.

CCS a micro-USB 3.0 plug. Maybe you've never seen one[0], but they are a real thing. Let's take an awful plug (micro USB / J1772) and clumsily add a few more wires on to it to make it both more capable and even worse. It does what you need it to do, but nobody has ever thought it was good at it.

[0] https://upload.wikimedia.org/wikipedia/commons/c/c3/Connecto...
I question if perplexity on wikitext is enough, I wonder if someone has checked how well perplexity correlates with https://github.com/google/BIG-bench

Fundamentally, I'm not sure if perplexity on a dataset that's pretty much leaked everywhere will properly measure the task performance of LLMs. But open to being wrong on this.
Perhaps this is the law, but unlike some other states, there is rarely signage to remind drivers (though I doubt even still it would the followed or enforced).
How prescient is the "Hidden Technical Debt" [1] paper from ~8 yrs ago compared to this? See the top of pg4 for a figure that I've personally found to be useful in explaining all the stuff necessary to put together a reasonable app using ML/DL stuff (up until today, anyway).

I see all the same bits called out:

- Data collection

- Machine /resource management

- Serving

- Monitoring

- Analysis

- Process mgt

- Data verification

There's some new concepts that aren't quite captured in the original paper like the "playground" though.

I've kind of been expecting a follow-up that shows an update to that original paper.

[1] https://proceedings.neurips.cc/paper_files/paper/2015/file/8...
Time for a happy story, and a sad one.

When I was a kid in the late 1950s, we had a typical TV of the day, with a dozen or so tubes that would often burn out, so the TV would "go on the fritz".

Dad would pull out all the tubes, put them in a cigar box, take them to the corner grocery and plug them into the tube tester one by one, and buy a replacement for the bad tube. And I would tag along with him.

The next time the TV went on the fritz, I asked him, "Dad, can I pull out the tubes and test them and find the bad one and put the TV back together?" He said "Yes, you can!" So I did.

He was also an avid fisherman and took me and my sister on his fishing trips. I didn't take much interest in that, but he never pushed me into it.

Mom was an accomplished seamstress but didn't have a knack for mechanical things. So when her sewing machine needed oiling or minor adjustments, I found the manual and took care of it for her.

She also had a Smith-Corona Portable Electric Typewriter that came with a touch typing course: a little paper easel with exercises and a set of phonograph records with voice instructions. Given my interest in machinery, I thought this was cool and worked through the entire course, learning to touch type at the age of eight.

Fast forward 40 years.

I will call my late wife Carol, and our two daughters Alice and Becky.

I was working one evening when Alice walked in and asked, "Dad, whatcha doing?" I said "I'm working on some JavaScript code." She asked, "Can I do that?"

My eyes lit up and I said "Yes! You can!"

I grabbed another laptop and set her up next to me and showed her how to write a simple loop and an if statement.

The next evening, Becky asked, "Dad, what was Alice doing last night?" "She was learning to write JavaScript code." "Can I do that?" You can guess my answer.

Over the course of a few days, they started competing with each other! "Dad, am I ahead of Alice?" and "Am I ahead of Becky?"

Around 11 a few nights later, my late wife Carol walked in and said, "Why is Alice up so late?!" I explained that she and Becky had taken a sudden interest in programming and I was tutoring them.

She would have none of it. "They have school at 8 in the morning and we have a curriculum to follow. They can't stay up late doing this!"

We were homeschooling at the time, which I thought was a great idea because it would allow our daughters to find things that interested them and pursue them. But Carol only wanted them to follow a strict schedule with a standardized curriculum that she had bought, even if it bored them to tears and kept them from finding their real interests.

I can't really blame her. She did what she knew how to do. I can only blame myself for not pushing back and insisting that it would be great if our daughters could have an opportunity to dig into something that interested them.

An opportunity like I had when I was young.

Both the girls dropped out of our little programming course after that and never took an interest in it again.

I don't know what could have happened if they had been allowed to pursue this interest.
You're overdramatizing.

Maybe not a lot, but people literally do use it for this purpose everyday. You can't just wave that away, given that it is working to some extent now.
I believe you, (and google translate agrees). But I just never heard it spoken outside those specific circumstances from him. Despite having Italian immigrant parents who spoke a lot of Italian around me. I can't remember but suspect they said gasolina, not benzina.
If any of those conditions are true, why not wait until 2025 when the charging connection is settled?
Another domain, but I feel that way when I watch some universally panned TV show/movie. One where a random person can think of simple changes to the script or plot that would make it far more interesting. I find myself wondering...how did these people recruit hundreds of people, and spend millions of dollars to make this, but no one took a second glance at the script to fix some glaring issue.
Market dominance?
Dont go to any school, just google for marijuana users forum where non technical guys introduct other non technical guys with "artificial" farming techniques and then try to farm small amount of berries in your basement ;)
What is extraordinary is the marketing line "You will go where the US navy dare not tread" will draw in some customers
So apparently this OceanGate company is a VC-funded startup or some such founded "to make underwater exploration cheaper and accessible to private citizens" (Wikipedia quote). Tells me everything I need to know about how this all came to be.
Do you have any obvious examples in mind?
Pretty good reddit community, lots of (N/SFW) models and content on CivitAI. Took me a weekend to get setup and generating images. I've been getting good results on my AMD 6750XT with A1111 (vladmandic's fork).
Do you plan on releasing the source code for the client at any point? I'd love to possibly use it as a reference for some of my stuff
> So, agents have the potential to become a central piece of the LLM app architecture (or even take over the whole stack, if you believe in recursive self-improvement). ... . There’s only one problem: agents don’t really work yet.

I really appreciate that they called out and separated some hype vs. practice, specifically with regards to Agents. This is something I keep hoping works better than it does, and in practice every attempt I've taken in this direction leads to disappointment.
No, that's FTPS. FTPS wraps FTP in TLS; SFTP is a protocol in the SSH protocol that can transfer files and that happens to implement an FTP-like interface.
yes, and they did a horrible job of that. And instead of listening to feedback to improve the app (some improvements of which mods rely on to do their free labor) they aquired and then butchered, they reduce choices.

Not surprised at all this angers the power users.
Nitpick: It is officially Europe but not EU
https://ourworldindata.org/land-use-diets

If the world adopted a plant-based diet we would reduce global agricultural land use from 4 to 1 billion hectares
How do they control the unmanned subs that they use to survey the Titanic then?

They are not tethered?
The Navy's Trieste II went to 20,000 feet (6.1 km) in the 1960s. It dove to the wreckage of the Thresher, among other things and was in service until 1980. It was replaced by Alvin-class of deep-submergence vehicles.

https://en.wikipedia.org/wiki/Trieste_II_(Bathyscaphe)
> Thanks for the reality check

What reality check? One online commenter you don't know contradicts another online commenter you don't know.
No it isn’t. You don’t get to cherry pick the scenarios that someone will be considered an adult for. Either you’re an adult or you aren’t, and “you’re an adult when it’s politically favourable to me” is not an acceptable compromise. I get the impression that you’d be the same type of person to defend the patriot act if it was made about tax evasion instead of terrorism.
> Everyone will have to use the Tesla app, where they can get targeted offers

Sounds like a nightmare. Want to go on a road trip? Either subject yourself to target advertising on your phone or pay a monthly fee. Hard pass!

I don't want to have to use an app at all if I want to charge. And yes, plug and charge is still using an app, you need to use some kind of app somewhere to manage the payment. I'd much rather have the option to just choose what payment I'd like to use before I start charging. Sure, optionally support plug and charge as well, but at least give me the option to not need to go to an app to choose this this card or that card and what not.

> remember that there are over 17000 superchargers in the US alone and the deal with Ford and GM only allows access to 12000 of them in the US and Canada together.

From what I understand, the ~5k chargers that aren't included are the older ones which don't speak CCS and they're usually the lower power ones. Those will probably be replaced over the next few years. Meanwhile all their newer ones will work with all the other compatible cars, so this percentage (~29% currently) will shrink over time, probably pretty rapidly given they're increasing the rate of new charger installation.

And in the end, for a lot of people it probably won't even actually matter. I've spent 2 years so far with a non-Tesla EV and it hasn't been any kind of difficulty for me in the slightest. Will it be nice to get access to another 1,500ish charging locations with a basic adapter? Sure, there's a few more charging locations on the road trip routes I take which will be open to me. Will it actually impact me day to day? Not in the slightest.

Oh no, there's a few thousand old chargers which charge at slower speeds than the new ones a several hundred miles away that my car can't charge at? Guess my car is worthless :'(
Stronger Magic: Harry Fainlight was an overshadowed Beat visionary
Well, it's schrodinger's submersible at this point.
I was a mod on a couple of subreddits that have more than a million subscribers. It's a thankless task. Most mods I've interacted with are absolutely fantastic, spending their free time volunteering for the community and genuinely making the community better. Filtering out spam, harassment is a daily, endless task. The only time people talk about the moderators is when something goes wrong.

The main reason I stopped doing it is because it was just too much work and having the community mainly shit on you doesn't make it more enticing to continue. Everyone assumes the worst about you, how you're somehow in it for the wrong reasons, when for 99% of mods I've interacted with that definitely wasn't the case.
i got an email that the limit in one of my groups is reached.

i just logged in and there is no indication of any limit.

i had to step through every group to find out where the limit was reached.

turns out that there was one group that had two sub groups which added up to 5 members. at the group overview this is listed as "two" (for the two subgroups). it would be very helpful if the group overview (https://gitlab.com/dashboard/groups) would list the total number of people as well as flag every group where the limit is reached or crossed.

but, you say the limit is 5 people. in this group there are exactly 5 people, yet the warning claims 'Your top-level group is over the 5 user limit and has been placed in a read-only state.'

how can that be? 5 is more than 5?

it doesn't matter in my case because this is an old project no longer worked on, so read only is fine, and there is no need to act, but i think you need to work on your system because i am sure there will be more cases like that.

lastly i want to add that while that limit is fine for small businesses, it is an absolute disaster for FOSS projects. FOSS projects don't have the funding to pay for your service, so they won't. their only option is to leave. if any of my projects get any traction then i have no choice but to go look for a more FOSS friendly service. i thought gitlab was that, i wanted to make a point against github and support their most likely competitor by drawing attention to you.

gitlab really does not gain anything by enforcing this limit for FOSS projects. FOSS projects often have many members that are not very active. a busy startup with 5 members probably creates the same activity and uses the same resources as a FOSS project with 50 members because most of those 50 members rarely contribute to the project.

or instead of limiting members, limit how often the more expensive resources are used. like limiting how often the CI is running.

i urge you to consider to allow a higher limit for groups that only have projects that use a FOSS license.