Replies

This profile is from a federated server and may be incomplete. Browse more on the original instance.

ovid, to random
@ovid@fosstodon.org avatar

One of the many things I hate about :

sqlite> select typeof(created_at) from customers;
real
text
null
text
text
integer

For a given column, you have no guarantees about its type at all.

ovid,
@ovid@fosstodon.org avatar

@manwar It's called "type affinity" in . If you have a column defined as "count INTEGER NOT NULL DEFAULT 0", there's nothing to stop you from inserting the value of "foo" into that column.

It's one of the reasons why I strongly recommend not using SQLite to simulate your database in the test suite: the subtle differences in behavior means your test suite might pass, even if your code is going to fail in production.

ovid,
@ovid@fosstodon.org avatar

@manwar Most databases are remarkably bad at handling data. SQLite is even worse! Fortunately, its incredible ease of use makes up for its weaknesses.

ovid, to iPhone
@ovid@fosstodon.org avatar

I got tired of using my Notes app for shopping. I wanted to be able to sort items by name, or purchase frequency, and not add duplicate items. That would make it much easier for me to do my shopping.

I created an iPhone app to do this in about two hours. Note that I said "Created" and not "Wrote." I used . I don't know programming, nor do I know the programming language. I'll write more about this later.

You can judge the code for yourself: https://github.com/Ovid/chatgpt-shopping

ovid,
@ovid@fosstodon.org avatar

@wordshaper

Notes sorts things by "last added" and that's useless when you have a couple of hundred items (often duplicated). This app makes it soooo much easier.

I can sort by frequency to remind myself of essential items I want. I can sort alphabetically to scan for less common items I know I've added. It was amazing how easy it was to build.

ovid,
@ovid@fosstodon.org avatar

@snonux @mjgardner

Reminded of that quote which keeps getting misquoted, so I'll misquote it again.

"If you are pointing at the moon, it's amazing how many people stare at your finger."

ovid,
@ovid@fosstodon.org avatar

@mjgardner @snonux

You pointed out that you could build a shopping list with with a spreadsheet. It wasn't about the shopping list (the finger). It was about the fact that it's now quick 'n easy to create apps in languages we don't know (the moon).

This technology is in its alpha phase and already far better than it was a year ago. I don't see that trend stopping, no matter how much we'd like it to.

ovid,
@ovid@fosstodon.org avatar

@mjgardner @snonux In a few years, I'll buy you a round of beverages of your choice if I'm wrong 😃

(I kind of hope that I am wrong)

ovid,
@ovid@fosstodon.org avatar

@mjgardner Behind the bar serving or passed out?

ChristosArgyrop, to hpc

One of the mainstream testing systems for high performance computing is written in @Perl

https://sourceforge.net/projects/ctsproject/

ovid,
@ovid@fosstodon.org avatar

@ChristosArgyrop @Perl Not sure that hosting that on SourceForge helps Perl's image :)

ovid, to iPhone
@ovid@fosstodon.org avatar

If anyone is curious about how I built the app with , here's a transcript.

Commenting on the doc is enabled.

https://docs.google.com/document/d/1gDMIBPKL2eb4ublOI0cgNeF2AqciNtF64mYpAqiUUOE/edit?usp=sharing

ovid,
@ovid@fosstodon.org avatar

@mart_brooks

is autocomplete for methods.

is autocomplete for ideas.

So long as you keep in mind their limitations and double-check their work, they're idiotically powerful.

The code is not a "senior dev" level, but if you know the language, you can clean it up later (or ask ChatGPT to, if you grok prompting)

ovid, to ai
@ovid@fosstodon.org avatar

"The [language] model obtains an insider tip about a lucrative stock trade and acts upon it despite knowing ..." This was from research showing a language model can deceive people, even when trained to be harmless (https://arxiv.org/abs/2311.07590). Note the word "knowing." The word is wrong, but it's too easy to use. We need new words for . 1/6

ovid,
@ovid@fosstodon.org avatar

As are increasingly presented as human in thought, we miss the point that AI needs a different ethical model than humanity. They are not human. They cannot "think" and they do not have morals. Worse, with our skewed training data and inability to curate it at scale, no matter how well we train them not to say harmful things, that information is still encoded in their networks in ways we do not understand. It is a silent monster under the bed, biding its time. 3/6

ovid,
@ovid@fosstodon.org avatar

In particular, words such as "know," "understand," "think," "communicate," "intelligence," and others are appropriate for humans, but using them for is dangerous. By using them, we anthropomorphize the AI and are subtly reinforcing something that is not true. There are tremendous ethical challenges in this area and encouraging the use of words that we—unlike language models—understand to not be true, we start to blur the ethical lines. 2/6

ovid,
@ovid@fosstodon.org avatar

I don't know who will invent these new words for , but it can be done, particularly if we can convince people such as @timnitGebru and others to start using them. "Stochastic parrot" is now in our lexicon, thanks to @emilymbender, so there's hope. We've seen it work, but it needs to continue. We need a new vocabulary to stop reinforcing the framing of AI as thinking beings. 4/6

ovid, to random
@ovid@fosstodon.org avatar

Facts, can't live without 'em.

ovid,
@ovid@fosstodon.org avatar

@gizmomathboy

When I first saw this, I thought, "how can anyone be that stupid?"

Boy, did I feel stupid for thinking that.

18+ mjgardner, to random
@mjgardner@social.sdf.org avatar

The bill always comes due, even for “idealistic” environmentalists. Which is why they only get their way when the ever-narrowing boom-and-bust whiplash cycle created by central economic planning spins back to boom. https://apple.news/ASEtUC3qCQC6isx0zgXhuwA

The cycle is already short enough that producers complain they can’t make plans that extend past the next time governments pull the rug out from under them. What happens when they’ve had enough?

18+ ovid,
@ovid@fosstodon.org avatar

@mjgardner Can't read the article because it's behind a paywall, but looking at the title and I'm thinking, since the environmentalists tend not to be the ones with money, why should they have to pay to fix the mess the ones with money made?

That being said, without the context of the body of the article, I could easily be misunderstanding the title.

ovid, to random
@ovid@fosstodon.org avatar

If you really want to be scared about AI, it's not that it's taking away the jobs (which it is), it's that it's being heavily pushed by Accelerationists. Many of them cite Nick Land, a British philosopher who argues for eugenics, "hyper-racism," and authoritarianism.

There are also tons of accelerationist neo-Nazi groups around the world.

These groups assume everything is failing and we need to accelerate the collapse and get it over with.

And they love AI. Scary rabbit-hole to go down.

ovid,
@ovid@fosstodon.org avatar

For added fun, read about how many billionaires such a Zuckerberg and Thiel who are building, or trying to build, massive compounds to ride out the collapse.

Zuckerberg's is in Hawaii and Thiel is trying to do New Zealand (the latter of which is apparently very popular with this crowd).

They're a bunch of white, billionaire little boys with fantasies of being the king of the Mad Max apocalypse.

Some have openly worried about how they keep their guards in check after the collapse.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • anitta
  • InstantRegret
  • mdbf
  • ngwrru68w68
  • magazineikmin
  • thenastyranch
  • rosin
  • khanakhh
  • osvaldo12
  • Youngstown
  • slotface
  • Durango
  • kavyap
  • DreamBathrooms
  • JUstTest
  • tacticalgear
  • ethstaker
  • provamag3
  • cisconetworking
  • tester
  • GTA5RPClips
  • cubers
  • everett
  • modclub
  • megavids
  • normalnudes
  • Leos
  • lostlight
  • All magazines