HNHacker News
TopNewBestAskShowJobs

petilon

5,019 karma · joined October 8, 2011

submissionscomments
petilon··on Prefer strict tables in SQLite
The point of strict mode is that the RDBMS performs data type validation when inserting/updating data. If you use a text column for storing dates, you can store any string in the column, not just valid dates. That's not strict.
petilon··on Prefer strict tables in SQLite
> https://sqlite.org/flextypegood.html

Both the advantages and disadvantages section is missing key arguments.

Key argument in favor of flexible typing: Easy to evolve schema. When you are using SQLite to store data in your embedded database and your requirements change, do you want to create a new database and migrate data each time? Evolving the schema in-place is much easier, and if your application is the only one reading/writing data into the database you will not be surprised by the fact the column that previously stored integers now contains strings as well.

Key argument against flexible typing: The schema is a contract, and when multiple applications read and write to a single database, and these applications are updated on their own schedules, storing the wrong type of data in a column will break the other applications. Strict adherence to the contract is necessary for applications to collaboratively read and write data. When a table is created by one application and used by another, the data types must be what you agreed to.

petilon··on How the terrorist group Boko Haram uses frontier AI
Boko traditionally refers to Western or secular education (as opposed to Islamic education).
petilon··on Prefer strict tables in SQLite
Right, and that's a serious limitation when in strict mode.
petilon··on Prefer strict tables in SQLite
Right, and that's the problem. There should be DATE and BOOL as well, especially in strict mode.
petilon··on Prefer strict tables in SQLite
The downside of strict tables is that some data types are not available, such as Date.

Strict should really be the default. If a database is shared by multiple applications then you should be able to rely on the declared data type. If one application stores a string into a numeric column that breaks everyone else.

On the other hand, the main use case for SQLite is embedded databases. And that means only one application is using the database. In that scenario being able to evolve the schema (as opposed to creating a new database and copying the data over) can be seen as an advantage. The application's code knows what to expect in each column--including mixed data types.

petilon··on SpaceX wants to launch 100k more Starlink satellites for 100x the bandwidth
It is very important for an unstable/eccentric person like Elon Musk to be the new AOL and "own the internet", which is what could happen if he launches 100k satellites. Elon Musk will use his power to make political decisions.

Musk has acknowledged withholding Starlink Service to thwart Ukrainian attack on Russia. Musk had conversations with a Russian official that led him to worry that an attack on Crimea could spiral into a nuclear conflict, so he made the decision to thwart Ukraine.

Right or not, such decisions should be made by elected representatives, not an eccentric trillionaire.

I am rooting for Blue Origin's Terawave: https://www.blueorigin.com/terawave

petilon··on SpaceX wants to launch 100k more Starlink satellites for 100x the bandwidth
SpaceX has many investors, not owners. If you don't have any say in how the company is run you're not an owner.

SpaceX utilizes a dual-class share structure where CEO Elon Musk retains between 82.4% and 85% of the total voting power, despite only owning roughly 42% of the company's actual equity.

petilon··on Apple sues OpenAI, accuses ex-employees of stealing trade secrets
This may be just one bad employee, i.e., Mr. Tan. Your quoted sentences say OpenAI did such and such, but it may all be just Mr. Tan. That's not to say OpenAI is not responsible because they are supposed to give strong guidance to new hires that they are not to bring any confidential information from their former employer.
petilon··on How the terrorist group Boko Haram uses frontier AI
"Boko Haram" translates to "Western education is forbidden". Using Western AI as an educational tool seems like hypocrisy.
petilon··on How the terrorist group Boko Haram uses frontier AI
Surely even terrorists want to die for a cause, not during practice.
petilon··on New York City to ban deceptive subscription practices
Will New York City residents be able to avoid AT&T's "Administrative and Regulatory Cost Recovery Fee"?

https://www.al.com/news/2026/07/att-customers-your-cell-phon...

petilon··on American A.I. Companies Say Chinese Copycats Are Quickly Catching Up
They can, that's how they know. The concern is that if they block, some legit users will get blocked as well, due to false positives. Remember, the distillation may not be happening from Chinese IP addresses.
petilon··on Shadcn/UI now defaults to Base UI instead of Radix
After watching the movie everyone in the audience goes back to their offices, and what do they use to improve their productivity? Right, AI.
petilon··on Shadcn/UI now defaults to Base UI instead of Radix
Isn't that a bit like working in the movie industry and no longer being able to enjoy films because you are always thinking about how they were made and noticing their flaws?
petilon··on AI has torched the market for junior programmers
> Or people who were remote got called back to the office.

That's not the explanation according to this article [1].

> Or they lost their job while living elsewhere and had to move to the Bay to find a new one.

It is hard to afford Bay Area rents -- even if you have a job. I can't see someone looking for a job signing a 1-year lease at these rates. Also, unlike the old days, interviews are remote, being physically present in the Bay Area doesn't give you an advantage.

[1] https://www.sfchronicle.com/bayarea/article/remote-work-stab...

petilon··on AI has torched the market for junior programmers
What kinds of people are they hiring? 1 BR that used to be $2750 last year is now $3400, clearly they are getting paid a lot.
petilon··on AI has torched the market for junior programmers
Unless AI capabilities keep increasing and AI starts usurping more senior roles.
petilon··on AI has torched the market for junior programmers
In silicon valley, apartment rents are up 20% relative to one year ago. People are getting hired, clearly. Not sure who.
petilon··on Rob Pike – 'Concurrency Is Not Parallelism' [video] (2012)
After watching the video I can see how go lang makes it easier to write correct concurrent programs. But with AI writing the code these days, it is just as "easy" to write correct concurrent programs in Java (because AI is doing the work). Java's virtual threads are light weight, just like go's routines. Java's LinkedBlockingQueue offers roughly the same functionality as go's channels. I would like to hear from go experts as to why I am wrong. Does go have any inherent advantage if AI is writing the code?
petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
Relatively speaking Trump 1.0 had a sane cabinet. Yes, there were some crazies, sure, but relative to the people he has around him now, they seem sane.
petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
If the President hires someone who then restarted research that previous admin stopped for being too dangerous, does the President get no part of the blame? The buck stops with the President. If he hired the wrong person--and he has hired plenty of wrong people this time around--he gets the blame for the disasters they cause.
petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
Not sure what is partisan about this. Some facts were presented. Not opinions, facts. If you dispute any of the above is factual please back up your assertion with citations.
petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
Citation needed. If you are going to say NYT article is wrong we need more than just your words.
petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
Not many people know that Trump had a hand in starting the pandemic.

Here's what we know: In 2014, Obama administration halted the so called "gain of function" research because of risk of laboratory accidents. In 2017, the Trump administration restarted this dangerous research. See links below.

https://www.nytimes.com/2014/10/18/us/white-house-to-cut-fun...

Excerpt: [Obama administration] White House announced Friday that it would temporarily halt all new funding for experiments that seek to study certain infectious agents by making them more dangerous. The White House said the moratorium decision had been made “following recent biosafety incidents at federal research facilities.”

https://www.nytimes.com/2017/12/19/health/lethal-viruses-nih...

Excerpt: [Trump administration] on Tuesday ended a moratorium imposed three years ago on funding research that alters germs to make them more lethal. Critics say these researchers risk creating a monster germ that could escape the lab and seed a pandemic.

So, Trump restarted the dangerous research that Obama had shut down. You may be thinking, what does that have to do with Covid? Covid started in Wuhan, China, right?

It turns out that the Trump administration, through the National Institutes of Health (NIH), provided funding to the EcoHealth Alliance, an American non-profit organization focused on studying emerging diseases. The EcoHealth Alliance, in turn, provided funding to the Wuhan Institute of Virology in China for researching bat coronaviruses. The rest is history.

And then Trump also disbanded the pandemic preparedness team in 2018 just in time for the pandemic. See link below.

https://www.washingtonpost.com/outlook/nsc-pandemic-office-t...

petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
You do what you have to do when people are dying in droves due to a pandemic and morgues are running out of room.
petilon··on Global review confirms mRNA vaccines are safe, effective and full of promise 
The science doesn't matter to this administration unfortunately: https://www.bbc.com/news/articles/c74dzdddvmjo
petilon··on Department of Commerce has lifted export controls on Claude Fable 5 and Mythos 5
> China has not been threatening military annexation

Maybe not in Europe, but ask their Asian neighbors.

> The USA is far more dangerous a "friend" than China is an acquaintance.

That's true and will continue to be true for 2.5 more years. European countries too have had bad leaders (like Germany), but have recovered. So too will the US.

> China is a far better international partner than the USA.

China is not a democracy and does not share western values.

petilon··on Crypto firms have spent $189M so far on 2026 US election, report says
This just came out: Trump reports more than $1.4 billion in income from crypto ventures [1]. He received more than $500 million from World Liberty Financial, a crypto venture he and his sons co-founded. Trump reported another $635 million from the sale of his $TRUMP meme coins.

$TRUMP meme coin shot up to $75 two days after launch. It has lost most of its value [2]. Guess who got rich off the people who invested in $TRUMP coin?

A UAE-linked investment firm acquired a 49% stake in Trump's World Liberty Financial for $500 million just before Trump's January 2025 inauguration, directing significant upfront payments to Trump family entities.

[1] https://www.reuters.com/world/us/trump-reports-more-than-14-...

[2] https://coinmarketcap.com/currencies/official-trump/

petilon··on Supreme Court upholds broad conception of birthright citizenship
That's partial jurisdiction at best.
← PreviousPage 5 of 34Next →