Advertisement · 728 × 90

Posts by Bob Ippolito

constructor, prototype, __proto__?

2 months ago 1 0 0 0

but if you're importing into sqlite then everything is text so it all works out 😉

2 months ago 1 0 1 0

setec astronomy

4 months ago 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???

6 months ago 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...

7 months ago 81 15 7 1
Post image

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

8 months ago 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.

10 months ago 3 2 1 0
Advertisement

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

10 months ago 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

11 months ago 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

1 year ago 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...

1 year ago 209 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!

1 year ago 2 0 2 0

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

1 year ago 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)

1 year ago 8 0 2 0

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

1 year ago 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
1 year ago 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

1 year ago 22089 8526 1249 3384
Advertisement
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...

1 year ago 749 126 37 23

The Russell starter pack

1 year ago 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.

1 year ago 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...

1 year ago 33 4 1 0

Asahi bought Peroni in 2016

1 year ago 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

2 years ago 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

2 years ago 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 😬

2 years ago 1 0 0 0
Post image

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

2 years ago 1 0 0 0

Nice! That’s a lot of hard work

2 years ago 1 0 1 0
Advertisement