skysight-inc/HackerNews huggingface dataset:
it's pretty simple but on various consulting jobs I've had to build SQL databases sometimes with lot's of tables with lot's of columns. Sometimes we switch from on prem to cloud, or vice versa or switch from postgres to sql server, etc. I have this toolkit that automates a lot of the tedious stuff. it allows me to take pandas dataframes and do the following:

- auto detect and convert column types

- save as a parquet file in a folder

- then autogenerate a sqlalchemy table/metadata file in python for all tables with sensible defaults for column types (e.g. 2x the longest string in a column for varchar)

- build the db and all tables

- load data from the files into the tables

this makes it really easy to bootstrap the entire db from a folder of parquet files for testing with sqlite and then makes it easy to move to prod on postgres/sqlserver etc. Before I go to prod i still have to add constraints and keys and indexes but that doesn't take too long. and for dev/testing the data's not too big so performance doesn't really suffer from lack of keys/constraints then we can use something like alembic on the big sqlalchemy tables definition file to do db migrations.

it's kind of like this: https://github.com/agronholm/sqlacodegen but solving an inverse problem.

basically it bootstraps the db and schemas and gets me like 95% of the way there. my quality of life is better with it.
My daughter enjoyed playing Othello at a friend’s house, so I made this we can use on an iPad: https://jawj.github.io/fliptiles/
Yes there are reasons why people want to override them sometimes and this needs to be reverted.

My dad used to sleep in his car for an hour before work, with the engine on to provide heating in winter. Because traffic was too bad an hour later. Just one of the many examples.
Latest vaguely interesting projects I've done, I repurposed an old Nook to be an e-ink family dashboard, showing weather, tidal times and our family calendar.
Ye. I mean increasing the performance of semi-perpormant apps is really hard. It's tiny changes everywhere.

At some point you got even the high hanging fruit and you are changing the order of if-clauses to decrease cache footprint to increase speed.
An automatic fish feeder. I was going on a long trip with my family and needed to feed my fish while we were gone. I remembered I had a servo from an old project. I drilled some holes in a round plastic container, glued it to the servo shaft, hung it off the tank with some wire, and wrote a small Arduino sketch to jiggle the container every 24 hours. It worked better than I thought it would; the fish survived, and in fact seemed so happy that I don't feed them by hand anymore.

I've since built a couple more for my other tanks, and I rewrote the firmware for ESP8266/ESPHome. Now my family can ask Alexa to feed the fish, because of course the world needs that.
The point still stands, there are thousands of papers demonstrating preclinical utility of nanoparticles for many applications, and extremely few actual medicines.
Cache associativity, conflict miss. When too many memory addresses
which are far apart map to the same cache lines while being used and reused in quick succession, causing cache evictions.

Scott Meyers had a very good talk which contained this information: <https://youtu.be/WDIkqP4JbkE?t=3614>

This is an effect of access pattern rather than size, but some access patterns are dictated by size.
Ok now what about „80% of all interaction will be voice driven by 2020“. source: Verge.com , 2016. It is probably not even 1 percent.
Some information on the CMOV can be found on the Intel Optimization Reference Manual (https://cdrdv2-public.intel.com/671488/248966-046A-software-...).

Torvalds was famously critical of it (https://yarchive.net/comp/linux/cmov.html); part of the criticism is now moot though, due to low latencies on modern processors (it seems 1 cycle or less, although the instruction consumes internal flags).

His idea seems to be still applicable and consistent with Intel's recommendation: make branches predictable, and only after, use CMOV for the remaining ones. His fundametnal assumption is that "even if you were to know that something is unpredictable, it's going to be very rare.".
That's because "property" normally implies private property, so adding the word "public" inverts it. It's not merely another category of "property".

Public IP is called the public domain, and is the most permissive of all.
How do you keep water touching sensors working long term? I tried similar sensors but they all get rusted / oxidized to work properly after a certain time.
Would love to see a blog about this setup. I, not old, always want to dump much of my music & simply want to listen whatever is next (& miss it if I don't listen) just like radio.
The problem is his disdain for "easy". It's one thing to create composable building blocks, but frequently, 99% of users will use them in the exact same way, so you might as well produce the easy thing on top of the simple thing, too.

The Clojure tools.build process has this exact problem. It's too low-level, so everyone got to write their own build scripts on top of that to do the same thing as everyone else. Now there's a situation of a 1000s of bespoke build scripts and 3-4 different front-ends, all effectively doing the same thing.

"In my line of work, sister, sometimes a second chance is a chance to mistake the same mistake twice" - State and Main
How do you get such am image please?
It's funny how people struggle so much to write branchless code.

The code is clearly not branchless as written, and relies on non-trivial optimizations for it to happen.

Just write it correctly to begin with.
> Crypto isn’t a core competency for the standard library authors and this it’s better to offload that responsibility.

Ring is mostly C/Assembly. Good bye safety ! Offloading core security routines is such a bad design.

> The other reason to prefer a smaller standard library is that it can often be difficult to strip away the unused bits from the resultant binary.

It’s actually already handled quite well, and could also be behind feature flags.

Really, a standard library with feature flags and editions would make rust ridiculously much more productive… such a waste.
It's common for businesses to abandon markets with burdensome regulation, I think your perspective may being distorted by software where there is little cause because regulation of software is uncommon. If you look to any highly regulated product like vehicles or medical devices products are often market specific (food too, but there are additional reasons there). But even online it's far from unheard of: post GDPR many US media outlets simply ban Europe entirely, and the requirements there seem far less burdensome than making generative AI accurately and specifically attribute their 'sources'.

Depending on the specifics someone might bolt on an attribution network but the results will frequently be nonsense. A tool like that might be somewhat useful on its own (since it could attribute non-AI output too), if its limitations were understood but essentially it would just be an internet search (which already exists, so presumably its not enough!). If it would satisfy the regulation it would make business sense to build it over blocking, but requiring it would also act as a moat that decreased competition in the field and as a result harm all of us.
> I doubt I will ever get to the level of fluency where I 'just code' with it, rather than intermittent stripes of coding & fuming.

I know what you mean. I feel much more productive with it nowadays and many things just make sense now, but it took me a long, long time to get to that point. Rust is very much not beginner-friendly, and while I think it was worth it this is why it will never replace certain other languages. I don't mind the compilation speed as much as some people seem to do, but the learning curve definitely is a problem.
> Science is about describing reality accurately

Disagree with how you've generally phrased it. Science is much more about provability, given enough evidence. The evidence could be invented, or not. I would agree that it is about observing reality with many given limitations.

I don't believe science cares that much about being 'accurate', mainly because we use fundamentally flawed models of the universe to justify our research, and then go on to abusing 'p' given the outputs of those models.

I am of course, being a little of a hardass here, but until we invent/discover something better than models, I will always hold this opinion.
Hey, sounds like a very cool project.

I'm wondering: have you considered setting up a Peertube instance and what were the reasons for not doing it?

Other question about not giving away your private data to big tech: Why is S3 better than a private YouTube channel?
this is lovely!! neat, clean and useful. I'm gonna use it, thanks for making it!
Out of curiosity, what do you hope the AI will do with your thoughts?
My related story: we have door phone system in our apartment house and I wanted to get a notification whenever our flat got buzzed. I hacked the phone in our flat - attached a circuit directly to the wires leading to the coil of the buzzer and through arduino to the pc. Then I stitched together some code utilizing firebase to send notifications. Worked like a charm until google began to require credit cards for the free stuff.
Driving simulator in unreal engine. Can do ADAS and now has a real HUD which is warped and quasi raytraced.
I love this for her and for me. Best gift you can give to a music lover
I'm not talking about the side effects of the drug, just the obstacles and risks associated with going after that kind of life. I'm also not saying the obstacles are good, but rather that we should be a little more careful in removing them without a clear picture of what to do next.
What age is too young to become a startup founder?
I’m 19, and I’ve got this idea that I think is viable and I’m thinking about applying to yc but I’m kind of worried I might get funded due to my age.
> The somewhat frightening creature is prominent in every neuroscience textbook and even has its own Dungeons & Dragons character, with bat wings for good measure.

I hope Dr. Dosenbach realizes that the D&D homunculus is based on the older (and probably still more common) sense of that word and not the neuroscience diagram, and this is just a dumb joke rather than a serious statement...
Their swype-style keyboard is an absolute joke—perhaps the most infuriating part of my iphone. I know that it’s easier to criticize than it is to implement, but my god, just a basic markov chain would yield more intelligible results than the shit it comes up with.
> Seamless remote editing with Emacs GUI is not a thing.

TRAMP has been a thing for a very long time: https://www.gnu.org/software/tramp/
> the things Americans call "shock absorbers" do not, in fact, absorb shocks.

??

"A shock absorber or damper is a mechanical or hydraulic device designed to absorb and damp shock impulses."
I built a website that you can bring up in multiple browser windows, or on multiple adjacent monitors attached to independent computers. Each browser displays a unique QR code. A user can navigate to a second webpage, activate their camera, and point their camera at the QR codes. Each QR code will switch to a unique AR code, then the user can project a single continuous image across all the monitors. It mostly works but I’m missing some 3d math to make the image line up perfect when the angles are weird.
Minidisc lover here - I bought my first MZ-R50 in 1998 and a quarter of a century later I still occasionally use it.

With secondhand players getting expensive now what are the odds of somebody bringing out a new one? I'd pay good money for something that's backwards compatible, has the same chunky metallic look and feel and comes with a few new features.
Kunstkabinett
My father was an amateur historian. He used to work with a lot of pictures often of poor quality. I guess his worst was a photo of a road sign printed in a book sometime in the 70s, and then recently not even scanned but taken from a book page with a phone. So I made a tool for him that allows to undo unwanted bending and also helps with the dirt: https://github.com/akalenuk/unpager
I mostly deal with Hilton brand hotels for both work and our newish “hybrid digital nomad” lifestyle where we hop across cities in the US for 7 months a year.

We stayed in Hilton brand hotels for around 160 days over the last year.

You don’t get loyalty points and days don’t count toward status when booking through a third party. With Hilton, those loyalties points can account for 20%-35% toward future stays. Meaning if I spend $100, I will get points worth $20-$35 toward future stays. Based on rooms I’ve already booked this year with just points, we are staying free for 25 days in 5 cities this year. Of course point accumulation is a lot slower for most people. But there are a lot of people who stay in hotels using other folks money when traveling for business.

Most hotels chains also have a “lowest price guarantee” where they will match a price found on a third party site.

This isn’t even mentioning all of the hassle you can avoid dealing with hotels directly if things go wrong or if you just don’t like the service.

Last year, I booked a 7 day half work half personal stay in San Francisco at the Hilton Financial district. It was a run down dump. I went to the front desk, told them I would be cancelling the rest of my stay and booked another hotel - the Hilton Parc 55 - for the rest of the week.

The first hotel charged me for one night. That would have been much more of a hassle going through a third party site. First you would have to hope that Hilton gave the money back to booking.com and then go through the hassle of getting your money back from them.

On that same note, I booked a regular room at Parc 55, messaged the hotel on the app before I got there and asked did they have any free Diamond upgrades available. They upgraded me to the fitness room - with a gym inside the room - for free. You don’t get those benefits when booking through a third party.
Burger King Used Netflix’s New Show “Beef” for Branding
The new Netflix show "Beef" is making a huge splash with its great storyline, depicting how anger is an emotion caused by our own desires.

At times when we feel depressed or unfulfilled in our lives, certain life moments can cause us to show our anger in different ways.

I could go on about defining anger and the Netflix show, but what I want to talk about is the genius emotional marketing from Burger King.

Brand integrations in movies and TV shows offer opportunities to connect brand values to different stories.

In Netflix's "Beef," both of the main characters are seen eating Burger King's chicken sandwich.

In both scenes, they are at their lowest point in life. In another scene, a side character named Paul talks about how Danny, the main character, feels fulfilled and loves eating that sandwich from a Burger King franchisee that takes an hour and a half to visit from his house.

Both eating scenes connected Burger King to emotions that regular people go through in everyday life, and their favorite burger and place to eat is an escape.

It allows them to feel fulfilled with eating and get a break from their fast lifestyle. This makes people connected to the Netflix show try that sandwich when they feel low.

Brand integrations in movies are normal, but only a few have mastered it because it costs.

Nike is running its own animation studio with sneaker integrations in every movie they release. Apple Originals also feature their products based on the role of characters in the movies.

It's a long-term strategy to shape their brand image and remind consumers of their purpose.
Somebody asked about the Dewitt Clause in the Slack, and got crickets.
If you have no family and friends you can do that. But don't
I like S3/B2 because the vendor only ever sees encrypted bytes. All decryption/plaintext is on the device. YouTube does not get you there. In fact their entire model is predicated on watching your every move.

As far as Peertube, I don't know enough about it. If I put a massive-bitrate video in some weird format on it, and then try playback on a crappy phone, will it work? If I go through a short tunnel, will it buffer or degrade quality gracefully? I don't want to worry about it.
I'm English and my wife and kids are french so naturally all our devices are set to french - our Google speakers do not understand my terrible french accent but bizarrely work perfectly when I speak English but only if I do a completely over-the-top french accent.
Source: https://jaskaransaini.com/how-burger-king-used-netflixs-show...
Scott’s cheap flights (going.com now) has basically implemented this in a nice little paid service. I got sub-$400 roundtrip direct from Seattle to Dublin. If you can snag even just a deal a year, it’s well worth the small yearly price!
Former Apple Employee here: I still remember for one WWDC my colleague’s talk had to be altered to change all mentions of “A-Series” socs to “A7 and later” to avoid triggering “Hey Siri” on every single person’s phone in the audience.
It's honestly a complete travesty. Strongly considering ditching my iPhone for the upcoming Pixel Fold or whatever it'll be called.
I feel like all non mainstream phones are not a safe bet anymore.

I bought a Unihertz Titan Pocket last year, was super excited because it was a tiny form factor and a real keyboard.

- Google Messages did not work. Had to use Verizon Messenger app.

- Wifi randomly drops out.

No solutions anywhere to be found. Went back to Pixel.
For reference: to be part of a hotels “rewards program” just requires you to create a free account.

What privacy concerns are you alleviating by not signing up for the hotels loyalty program? They are going to ask for ID when you get there and many require a credit card hold.
there are two things I’ve built that maybe aren’t groundbreaking but I think fit the brief. Might be helpful context that I’m not a professional programmer so these are both hobby projects.

1. I have too many aunts/uncles/cousins but we have a long (30 year at least) tradition of doing a family gift exchange over the holidays. After one too many years of forgetting who I had or having my mom get asked by my aunt what my cousin should get me I build a website for my family that allows them to manage a gift list. Started as a super basic Django app and that was about 7 years ago and every year I add one or two features. Now it’s got all kinds things like notifications and will even help you track your incoming packages and know if they are gift wrapped or not.

Thing 2, was a wedding evite/website for
My wedding. At the time I looked around and hated how impersonal all the evite options were, so I created a website with a cms that would give every user a customized, personalized experience. Invited to the rehearsal dinner? you see that dates and details. Are you one of my friends? You get the set of content with our inside jokes. It didn’t need any kind of login or passwords but provided everyone with a custom page. It also provided me with a full database to manage rsvp, song requests, track who gave us gifts (and what), etc. Yes my partner thought it was overkill (to answer that question) but it was super fun to build and ended up getting retooled for my sister in law’s wedding last year.
iCloud Drive still sucks and it terrifies me I have so much stuff on it when it doesn’t even do snapshots (the way Dropbox does).
This is one area where Profile-Guided Optimization (PGO) can help a lot! With PGO, you run your program on some sample input and it logs info like how many times each side of a branch was taken. From there, you can recompile your code. If the compiler sees that one side of the branch dominates, it can emit code to prioritize that branch. However if the branch counts are approximately even and the branch is hard to predict (n.b. this is technically distinct from having even branch counts), then the compiler can know that the CPU would have trouble predicting the branch, and can emit a cmov instruction instead.
We were using facebook exclusively for the 'private group' feature with a some friends in 2012. We liked the fact that it was private and asynchronous.
But I didn't like the fact that it was tied to facebook. I decided to put into practice what I've learned that year at my informatics school and created forum written in php. It was not much but we liked the fact that it was ours.

Ten years later, I'm still fiddling on it and it has grown to a real open-source project that you can find on github [0]. It's still primarly here to serve me since I'm the only maintainer but starts to be driven by external propositions. It's meant to be easy to deploy, easy to use, cheap in resources and reliable.

[0] https://github.com/zusam/zusam
That caught my attention as well. I followed the sources and found this:

https://kotaku.com/mtg-aftermath-leaks-pinkertons-wotc-magic...

Another thing I didn't know is how much money is involved in these card things.
Reading a bit of the paper, it seems the title is indeed meant to be tongue-in-cheek ambiguous.

The first example in Table 1:

"I’m afraid the cat was hit by a car."

Disambiguation 1: I'm worried...

Disambiguation 2: I'm sorry to share that...
Maybe it’s just wanting to understand critical systems which will influence many aspects of our lives ?

As all the AI bros like to say, “there is no magic”, so let’s see how it works then?
> Bluesky Social might be the real antidote to what ails Twitter.

It is too early to tell. But if there is any viable and serious 'Twitter alternative' it is BlueSky. I predict that you will see it rise once it gets rid of its invite system and has a front-facing web app. But that is half of the story.

The other part is if it's able to effectively weaken Twitter's network effect by 'normal users' voluntarily and naturally switching from Twitter to BlueSky, (not techies) and continue to post and read on BlueSky and not run back to Twitter.

But having normal users sign up without reading a guide or telling them how to 'choose a instance' is a great first impression.

We'll see if they will learn the lessons and mistakes from Clubhouse's invite system process and Mastodon's horrific search functionality and forcing people to choose a instance, with the user signup process causing mass confusion for normal users.
I did. You’re just wrong.
https://uops.info/uiCA.html it's really cool!!
> Unless apple acquires OpenAI, Siri is doomed.

They surely have enough ressources to train a competitive LLM themselves...
Wow, the dispatch queue is so deep! The trace makes a lot of sense, thanks for sharing it. I must have been unclear if it sounded like I was saying cmov was a bottleneck - my argument is just that it's not going to be especially faster than a branch in the general case.

Great point that memory reads are going to dominate a binary search - at that point the CPU will be spending a lot more time waiting for memory than it is spending executing your branches or cmovs.
Heh. Even most Cognitects had no access to the Datomic source.
Cyber Resilience Act (CRA): Comply or Withdraw?
Hidet: a deep learning model to detect when you’re ready for your bidet to activate
not OP, but one of the tricks is to activate the sensors only when measuring, so there's no constant DC applied to the sensor wires/pads. once you have that, reduce measurement frequency, so to mainimise the time when voltage is applied to the sensors. for example once every hour for moisture is sufficient, and 1/sec isn't really going to help much.
No I'm still solo developing.

Would having a few more people working on it make stuff move faster? Undeniably. But I don't think lack of manpower is an obstacle at the moment in the same lack of hardware. It's reasonable to expect there's an upper limit to how big a project you can manage as a single developer, but I don't think I'm there yet.
Wholeheartedly agreed. Even if the student has the absolute best of intentions, you have no way of knowing that the laptop doesn't have say, malware on it.