HNHacker News
TopNewBestAskShowJobs

santiagobasulto

1,944 karma · joined May 4, 2012

Founder of DataWars: datawars.io. Prev, co-founder @ rmotr.com (Acquired by INE, inc 2019).

@santiagobasulto on Twitter.

Want to try DataWars? app.datawars.io/register

Want to reach out? santiago [dot] basulto [at] gmail

meet.hn/city/45.0677551,7.6824892/Turin

Socials: - github.com/santiagobasulto - x.com/santiagobasulto

---

submissionscomments
santiagobasulto··on Have I Been Pwned 2.0
When it mentions that your password has been leaked for a service, is this the plain text pwd (that service somehow stored that way) or is it a hash? Was the website salting the passwords (so no rainbow-table attack could happen)? What key derivation function were they using? Etc...

I feel the red circle with "Password compromised" is way too simplistic if this wants to be a TRUE trusty site regarding cybersecurity. If they just want to show fear and sell 1Password ads, I understand it, I won't consult it anymore. But if they want to really step up their game from a technical perspective, they should include more details.

santiagobasulto··on OpenAI wants to buy Chrome and make it an "AI-first" experience
This sounds a bit clickbaity, they could just fork Chromium and build their own version as Edge or Brave. After all, they already have the distribution (ChatGPT).
santiagobasulto··on Transformer Lab
Perfect, thanks very much! It looks like an amazing tool. Cheers!
santiagobasulto··on Transformer Lab
Could this be run as a web interface? For example, getting a GCP instance with GPU and deploying it there and accessing it from the browser.

EDIT: Seems it has a client/server model and the server can be installed somewhere else: https://transformerlab.ai/docs/install/advanced-install

But I'm wondering if this is an electron based app and I could run the client on a web interface as well.

santiagobasulto··on WebTUI – A CSS Library That Brings the Beauty of Terminal UIs to the Browser
Yes, GUIs and Web interfaces can support keyboard navigation. But I have NEVER found one fully exploiting this. Linear (ticket tracking app) is maybe the only one that comes to mind as a good alternative, but nowhere close to the fluidity achieved by TUIs.

I think the reason is "limitation", if you have to design an app that CAN NOT use a Mouse, you'll be darn sure it'll work well with the keyboard.

santiagobasulto··on WebTUI – A CSS Library That Brings the Beauty of Terminal UIs to the Browser
> TUIs are an abomination of design that poorly mimic actually beautiful UIs

My mother used to have an early "digital company" back in the 90s in Argentina. We are from a small town in the "Patagonia region"[0] and there was only 1 programmer in the whole town. The guy was a huge nerd that had spent some time studying in Buenos Aires.

Long story short, my mother hired this kid to build software for him. This is around 1992 so it was all DOS.

This guy built a full TUI software with CRUD operation, reporting, "cron jobs" (some stuff that I never understood but would run every night), printing, etc.

Until this day I remember the people working at my mother's company how they just FLEW over the software. It was all keyboard and hotkeys. They'd just go back and forth, print stuff, enter data, connect with the Fax machine, all with their keyboard in this black screen full of green, white and orange glyphs.

I NEVER found any other software that is SO powerful and efficient and user friendly as TUIs.

[0] The "true" Patagonia region in the East of Arg.

santiagobasulto··on Microsoft’s original source code
I couldn't find the precise reference that mentions that they found the source code for the Basic interpreter and just "copied/ported" it. I did read they'd go "dumpster diving" to learn assembly. But not that they found and just ported the source code. Where is it?
santiagobasulto··on Microsoft’s original source code
Microsoft (and maybe even Bill Gates personally) generated a strong "dislike" sentiment to the hacker community. But we can't deny that he and Paul Allen were pure breed hackers and helped a lot the development of technology. Of course, we all prefer OSS and we'd pick Linus (or insert OSS dev name here) 100 times over one of the "evil capitalists"/s, but nevertheless they have to be recognized.
santiagobasulto··on Introduction to System Programming in Linux (Early Access)
If you can't afford this book yet, Prof Weiss has multiple courses listed with his course notes, which are EXTREMELY detailed and well written: https://www.cs.hunter.cuny.edu/~sweiss/courses.php
santiagobasulto··on Finland's National Allergy Program Successfully Reduces Allergic Diseases
> Antibiotics should only be used in cases of true need

This is going to be a big deal in the next 20 years.

I’m from a third world country and the usage of antibiotics is SO irresponsible. People take them (and give them to their children) as candy.

santiagobasulto··on Finland's National Allergy Program Successfully Reduces Allergic Diseases
> Strengthen immunity by increasing contact with natural environments
santiagobasulto··on Apple pulls data protection tool after UK government security row
What happens if a British citizen/resident buys an iPhone in the USA?

Btw, as a European citizen, I always buy my devices in the USA. We can complain about the US as much as we want, but Europe is on another level.

santiagobasulto··on Markdown's Big Brother: Say Hello to AsciiDoc
I agree. The first time I heard the name I had the same impression.
santiagobasulto··on Thank HN: My bootstrapped startup got acquired today
Congratulations Paras! What are your plans next? Do you have to stay, new venture or just chill and enjoy?
santiagobasulto··on Show HN: Atlas of Space
The project is amazing, thanks and congrats.

A bit of an off-topic comment, I can't cease to be amazed by the quality of HTML apps we can build these days. I remember the days when rendering too many rows on a table could completely break the browser.

santiagobasulto··on Ask HN: Who's building on Python NoGIL?
May I ask which benchmarks you saw? I was looking for some reliable one and couldn’t find them.
santiagobasulto··on CISA: Do not use SMS as a second factor for authentication [pdf]
I can't believe this is not more mainstream. I really appreciate CISA putting it in writing so I can start citing. But seriously, isn't this OBVIOUS?

I was today facing an issue with my BANK because they're locking me out of my account. The reason? I travel around the world and sometimes SMSs won't make it. Also, it's extremely easy to exploit. You can steal someone's phone number with just a bit of social engineering (at least in Europe's carriers). Also, you can steal a phone, remove the sim card, and it'll work anywhere (yes, you can password protect SIM cards, but not everybody does it).

santiagobasulto··on Amazon S3 now supports the ability to append data to an object
This will require some serious buffering.
santiagobasulto··on Show HN: Aide, an open-source AI native IDE
I think it's confusing for people that only one big green button shows "Download for mac" and the other download links are at the footer.
santiagobasulto··on Show HN: Aide, an open-source AI native IDE
There are download links for other platforms at the footer, and below the main CTA button says "Looking for other platforms?" which takes you there.
santiagobasulto··on State of Python 3.13 performance: Free-threading
With these new additions it might make sense to have a synchronized block as in Java?
santiagobasulto··on We're Leaving Kubernetes
> The difference here is Gitpod being stateful, which is notoriously hard on Kubernetes, though easier now than ever before!

We've always had issues with stateful kubernetes setups. Can you share what makes it easier today than before? Genuinely interested.

santiagobasulto··on ChatGPT Search
This is great news. But it gives me anxiety the fact that I'll keep accumulating chats on that left bar without any ways to manage them or search through them.

Today I was looking for an old (and useful) chat I had a few months ago and I had to export the whole chat history, wait for the zip file, and write a Python script to find what I was looking for :/

santiagobasulto··on INNER JOIN ON vs WHERE clause (2009)
For me, idk why, it feels too "ORACLE-ly". I stopped using Oracle after administering an 9i until ~2010 and I never want to go back

But yes, `USING` is convenient and pleasant to the eyes.

santiagobasulto··on INNER JOIN ON vs WHERE clause (2009)
Guys, I ran an EXPLAIN in a dockerized postgres server. You can see it in the screenshot I shared. Why did you assume I was just trusting the LLM? Jeez, Hn.
santiagobasulto··on INNER JOIN ON vs WHERE clause (2009)
I did a quick test in Postgres using the sample Airlines database.

Here are the two tested queries:

Query 1:

    SELECT 
        t.passenger_name, 
        t.ticket_no, 
        bp.seat_no
    FROM 
        Flights f
    JOIN 
        Ticket_flights tf ON f.flight_id = tf.flight_id
    JOIN 
        Tickets t ON tf.ticket_no = t.ticket_no
    JOIN 
        Boarding_passes bp ON t.ticket_no = bp.ticket_no AND tf.flight_id = bp.flight_id
    WHERE 
        f.arrival_airport = 'OVB';
Query 2:

    SELECT 
        t.passenger_name, 
        t.ticket_no, 
        bp.seat_no
    FROM 
        Flights f
    JOIN 
        Ticket_flights tf ON (f.flight_id = tf.flight_id AND f.arrival_airport = 'OVB')
    JOIN 
        Tickets t ON tf.ticket_no = t.ticket_no
    JOIN 
        Boarding_passes bp ON t.ticket_no = bp.ticket_no AND tf.flight_id = bp.flight_id
Then I ran EXPLAIN for both of them and the query plan is THE same. So there's not a big difference at least in Postgres.

Here's the GPT conversation: https://i.imgur.com/dIzcfnc.jpeg

It doesn't let me share it because it contains an image

santiagobasulto··on INNER JOIN ON vs WHERE clause
Crazy that there are no in-depth answers with some EXPLAINs and profiling. Just mentions to ANSI standards.

EDIT: I realized I completely misread the question. I thought it was asking the difference of using a WHERE clause or putting conditionals in the JOIN (see my reply above for an example). The original SO questions is about an old-school CROSS JOIN `table1,table2` (which is a cartesian product in relational algebra) and a JOIN.

Edit 2: "old school" in the sense of joining tables before JOINs existed. I think it was System R the first engine to introduce efficient JOINs vs cross products.

santiagobasulto··on Ask HN: Can calculus be taught without differentiating or integrating by hand?
> I don't think that excludes the possibility of Ramanujans or Dizzy Gillespies existing

I wholeheartedly agree with this.

santiagobasulto··on Ask HN: Can calculus be taught without differentiating or integrating by hand?
Yeah, my bad, I was mostly referring to "music industry". Music is 100% like math. Music is math, and math is music.

Edit: inb4, I did read Hofstadter's Gödel, Escher, Bach.

santiagobasulto··on Ask HN: Can calculus be taught without differentiating or integrating by hand?
This analogy doesn't make any sense. Music is not like math and the music industry is not like industries that are related to calculus.

Music theory is NOT required to play in a band or write a movie score. Check Gustavo Santaolalla's for an example of a great composer with ZERO musical bg.

← PreviousPage 4 of 19Next →