Bob Ippolito's Avatar

Bob Ippolito

@bob.ippoli.to

@etrepum on most of the other places

267
Followers
367
Following
84
Posts
29.04.2023
Joined
Posts Following

Latest posts by Bob Ippolito @bob.ippoli.to

constructor, prototype, __proto__?

24.01.2026 01:19 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

but if you're importing into sqlite then everything is text so it all works out πŸ˜‰

23.01.2026 18:30 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

setec astronomy

27.11.2025 20:22 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Sqlite docs with this highlighted:

According to the SQL standard, PRIMARY KEY should always imply NOT NULL. Unfortunately, due to a bug in some early versions, this is not the case in SQLite. Unless the column is an INTEGER PRIMARY KEY or the table is a WITHOUT ROWID table or a STRICT table or the column is declared NOT NULL, SQLite allows NULL values in a PRIMARY KEY column. SQLite could be fixed to conform to the standard, but doing so might break legacy applications. Hence, it has been decided to merely document the fact that SQLite allows NULLs in most PRIMARY KEY columns.

Sqlite docs with this highlighted: According to the SQL standard, PRIMARY KEY should always imply NOT NULL. Unfortunately, due to a bug in some early versions, this is not the case in SQLite. Unless the column is an INTEGER PRIMARY KEY or the table is a WITHOUT ROWID table or a STRICT table or the column is declared NOT NULL, SQLite allows NULL values in a PRIMARY KEY column. SQLite could be fixed to conform to the standard, but doing so might break legacy applications. Hence, it has been decided to merely document the fact that SQLite allows NULLs in most PRIMARY KEY columns.

I am going to become the Sqlite Joker, what the fuck???

23.09.2025 17:55 πŸ‘ 98 πŸ” 5 πŸ’¬ 18 πŸ“Œ 4
Preview
Walking around the app You gotta check stuff out

One of my core engineering beliefs is that if you are building something you should always be holistically looking at it

vickiboykis.com/2025/09/09/w...

10.09.2025 13:26 πŸ‘ 81 πŸ” 15 πŸ’¬ 7 πŸ“Œ 1
Post image

agrifooddatacanada.ca/wp-content/u...

27.07.2025 06:21 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

The M:N threading model with process isolation (all the way up to memory allocation and GC) is Erlang's true differentiator. It really just can't be done anywhere else… hard to bolt something like that on.

27.05.2025 04:01 πŸ‘ 3 πŸ” 2 πŸ’¬ 1 πŸ“Œ 0

you'd be surprised at how efficient the beam vm is, even when you're not using the jit it's a direct threaded model. there's a lot of technical details on the erlang blog over the years www.erlang.org/blog

27.05.2025 03:57 πŸ‘ 3 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
BBS Documentary 20th Anniversary Fundraise Sale This post has two interesting aspects: It will disappear when it’s finished what it set out to do, and it’s also a fundraising for another fundraiser. This is the 20th anniversary of th…

Update: A goodly pile of BBS Documentaries have gone out the door at the increased price, with a little less than a couple dozen still in the box. If you want to pay too much for physical media, this is the time.

ascii.textfiles.com/archives/5755

22.04.2025 14:39 πŸ‘ 24 πŸ” 5 πŸ’¬ 0 πŸ“Œ 0
Preview
Madison Square Garden bans T-shirt designer over 'Ban Dolan' shirt β€” years after he made it Frank Miller Jr. says he was stunned to learn he’s barred from all Madison Square Garden venues, years after mocking the Knicks' owner with a satirical shirt.

Most successful designer & hater of all time πŸπŸ† @fwmj.bsky.social

27.03.2025 01:54 πŸ‘ 14 πŸ” 5 πŸ’¬ 1 πŸ“Œ 5
Irregular status update about reproducible Debian live ISO images

What an achievement:

* All official Debian bookworm live images rebuild reproducibly

lists.reproducible-builds.org/pipermail/rb...

27.03.2025 03:44 πŸ‘ 210 πŸ” 47 πŸ’¬ 7 πŸ“Œ 4

of course there’s still the risk of a successful supply chain attack that passed review and is in the source code, huge accomplishment nonetheless!

27.03.2025 03:59 πŸ‘ 2 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0

What sort of person wants to report something as spam but not also block the sender?

20.01.2025 06:25 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

The Ex-Facebook groups are absolutely popping off in response to Meta’s policy changes 🍿 (for the record, these changes are shit)

10.01.2025 22:40 πŸ‘ 8 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0

Is CBOR popular enough to warrant platform inclusion? I haven’t run across it much

31.12.2024 05:33 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
a video game screen that says i command you to rise ALT: a video game screen that says i command you to rise
27.12.2024 06:27 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
The Mario 64 intro scene with a letter from Princess Peach, reading:
Dear Mario. Please come to the castle. I'm down bad. Yours truly-- Princess Toadstool (Peach)

The Mario 64 intro scene with a letter from Princess Peach, reading: Dear Mario. Please come to the castle. I'm down bad. Yours truly-- Princess Toadstool (Peach)

CATS from the video game Zero Wing (the All Your Base Are Belong To Us game), saying: "I am Locutus of Borg. Resistance is Futile"

CATS from the video game Zero Wing (the All Your Base Are Belong To Us game), saying: "I am Locutus of Borg. Resistance is Futile"

Dracula from Castlevania: Symphony of the Night, saying to Richter "Get out of my house"

Dracula from Castlevania: Symphony of the Night, saying to Richter "Get out of my house"

The transportation advisor from SimCity 2000, saying "YOU CAN'T STAY ON TWITTER! YOU WILL REGRET THIS!"

The transportation advisor from SimCity 2000, saying "YOU CAN'T STAY ON TWITTER! YOU WILL REGRET THIS!"

My big project: The Death Generator.
It's a tool for making fake video game screenshots, just fill in new text and it'll give you a (generally) pixel-accurate image back, the correct fonts and everything.

deathgenerator.com

08.12.2024 07:17 πŸ‘ 22108 πŸ” 8539 πŸ’¬ 1253 πŸ“Œ 3388
Preview
Accused Kitchener hacker unmasked after threatening woman online Kitchener-based hacker Alexander β€œConnor” Moucka was unmasked after making threats against a woman on the messaging app Telegram. Moucka threatened Allison Nixon, the chief research officer at Unit221...

Who wants to be next?

www.therecord.com/news/waterlo...

29.11.2024 08:33 πŸ‘ 751 πŸ” 126 πŸ’¬ 37 πŸ“Œ 23

The Russell starter pack

23.11.2024 06:59 πŸ‘ 3 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Me wearing a tux speaking at the 2024 Mission Bit Gala

Me wearing a tux speaking at the 2024 Mission Bit Gala

I think at this point I'm almost unrecognizable to people that haven't seen me in a few years. Got fit riding bikes, decided to grow some facial hair after crashing a bike in a race a few months ago, and I even bought a tux to wear at the first @missionbit.org gala since I become board chair.

22.11.2024 06:39 πŸ‘ 11 πŸ” 0 πŸ’¬ 4 πŸ“Œ 0
Colourful example artwork generated from the library

Colourful example artwork generated from the library

First release of @texel/colorβ€”a minimal and modern color library for JavaScript. 🎨

Features:
- extremely fast
- extremely compact
- oklab, p3, rec2020, a98rgb, prophoto, srgb + more
- gamut mapping + wide gamut support

Repo β†’ github.com/texel-org/co...

02.08.2024 17:42 πŸ‘ 33 πŸ” 4 πŸ’¬ 1 πŸ“Œ 0

Asahi bought Peroni in 2016

31.05.2024 02:03 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
tea.xyz causes a flood of spam pull requests to open source projects
This crypto skeptic I've heard of once said "Show me the incentive and I will show you the outcome."
 A project called tea.xyz promised people they could "get rewards for [their] open-source contributions", complete with a flashy website describing how it would "enhance the sustainability of open-source software". So far, it's achieved the exact opposite. Promising to reward open source contributors with crypto tokens, the project asked users to verify their access to open source projects by merging in a YAML file containing their crypto wallet address. This kicked off a flood of pull requests to prominent, often non-crypto-related open source projects by people who had never contributed to the project (or, often, any open source project), but who wished to merge in a file describing them as a "code owner".

tea.xyz causes a flood of spam pull requests to open source projects This crypto skeptic I've heard of once said "Show me the incentive and I will show you the outcome." A project called tea.xyz promised people they could "get rewards for [their] open-source contributions", complete with a flashy website describing how it would "enhance the sustainability of open-source software". So far, it's achieved the exact opposite. Promising to reward open source contributors with crypto tokens, the project asked users to verify their access to open source projects by merging in a YAML file containing their crypto wallet address. This kicked off a flood of pull requests to prominent, often non-crypto-related open source projects by people who had never contributed to the project (or, often, any open source project), but who wished to merge in a file describing them as a "code owner".

Particularly impacted by this project was the open source blogging platform Ghost, which was used as an example in the demo video released by tea.xyz, and which received several PRs of this kind. A somewhat flummoxed maintainer of the repository replied to one PR: "[I]n practice the TEA project is not helping to support the Ghost project, but is instead causing a rush of self-serving PRs to be submitted to cash-in on other people's work. ... This why people hate on crypto." A maintainer of another unrelated open source project called "ghost" also reported receiving an influx of spam PRs. This is not the first time crypto has generated massive Github spam, although another recent incident was (blessedly) mostly limited to open-source crypto projects and didn't waste the time of non-crypto-related projects as this one has.

Particularly impacted by this project was the open source blogging platform Ghost, which was used as an example in the demo video released by tea.xyz, and which received several PRs of this kind. A somewhat flummoxed maintainer of the repository replied to one PR: "[I]n practice the TEA project is not helping to support the Ghost project, but is instead causing a rush of self-serving PRs to be submitted to cash-in on other people's work. ... This why people hate on crypto." A maintainer of another unrelated open source project called "ghost" also reported receiving an influx of spam PRs. This is not the first time crypto has generated massive Github spam, although another recent incident was (blessedly) mostly limited to open-source crypto projects and didn't waste the time of non-crypto-related projects as this one has.

tea​.xyz causes a flood of spam pull requests to open source projects

February 26, 2024
https://www.web3isgoinggreat.com/?id=teaxyz-spam

27.02.2024 14:49 πŸ‘ 79 πŸ” 17 πŸ’¬ 3 πŸ“Œ 8

I saw someone wearing one of these at dolores park the other day, had to hold back the laughter so I didn't look like a maniac

02.02.2024 19:46 πŸ‘ 5 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Old dead board

Old dead board

Working projector

Working projector

Apparently LG HU80KA projectors get a fatal blue screen of death even if you don’t use them very much… but you can find replacement β€œlg chassis assembly” boards for ~$20 (discontinued EBT65116402) or ~$510 (replacement EBT66594301). The $20 board worked! Probably should order a backup 😬

23.12.2023 05:13 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

me too, had a good run up through the hermit period… trying to get back there

21.11.2023 16:28 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Nice! That’s a lot of hard work

21.11.2023 15:38 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0