Offtopic

28 January 2026 10:21

Yup. JSON type. I don’t have it locally.
Dbeaver had this duckdb, when I googled I saw that it could wrangle parquet, json files with sql. So I started using that

Offtopic

28 January 2026 10:15

As little as possible.

Offtopic

28 January 2026 10:14

ORMs are a thing in Python but not as unanimously considered good in Go.

Offtopic

28 January 2026 10:09

We recently had orm optimisation run

Offtopic

28 January 2026 10:07

Not a single one. The configuration file is YAML, the record keeping is SQL(ite).

Offtopic

28 January 2026 10:06

That just decreases the input of useless data. The core data layer issue remains. Like loading big json into memory.

I was thinking of duckdb. But that’ll help with parsing speed/memory usage. It’ll be efficient.

But the ever growing size of JSON will take space when we load it. Down the line, it’ll be in terra-bytes. And loading that in one go, will need memory.

Offtopic

28 January 2026 10:02

The suggestion is:
Some ban reason allows for user data to be not stored. If user is banned with that reason: no upsert/insert required

Like if someone is ban spamming, that user record don’t need to be saved.

Depending on group, this rule expands.

Offtopic

28 January 2026 09:58

because "Hello" doesn't have memory address, but variable s have memory address

Offtopic

28 January 2026 09:57

/channel/pythonofftopic/1258301

What do you think?

Or is initial optimisation grasping straws? 🤔

Offtopic

28 January 2026 09:28

Long story short, strings are immutable. But sure you can something with pointers to strings.

Offtopic

28 January 2026 09:26

so can you change strings using pointers?

Offtopic

28 January 2026 09:24

Go in my opinion is the best programming language, it is very simple to work with and fast.

Offtopic

28 January 2026 09:21

Why should one use go language. Is it good? I m just curious about it

Offtopic

28 January 2026 09:18

New bot ? I can suggest something if we know what the exact problem is.

Offtopic

28 January 2026 09:18

Oh, Gitlab is something different...

Offtopic

28 January 2026 10:17

you can do the same in postgresql also btw

Offtopic

28 January 2026 10:15

I thought sqlite would suffice, especially considering the previous "storage". It's also less maintenance. I love little maintenance.

Offtopic

28 January 2026 10:10

With duckdb, we can query json with sql from what I worked with. I use it to query parquet

Offtopic

28 January 2026 10:07

I see. You changed it to sql.

Offtopic

28 January 2026 10:07

No, there won't be any JSON files anymore.

Offtopic

28 January 2026 10:05

Oh, I think I get it. You try to save storage space. But the issue is the format of the old bot, not the format of the new bot. I'm also thinking about saving storage space, but at a different dimension. I'm thinking about whether or not to persist all messages. Or if images should be part of that and where I'd put them if they were.

Offtopic

28 January 2026 09:59

I'm not sure what the suggestion is, but I'm generally leaning towards keeping more information. Like the content of the message a person has been banned for.

Offtopic

28 January 2026 09:57

var s = &"Hello" //this does not work
//but
var s = "Hello"
var pointer = &s // this does

Offtopic

28 January 2026 09:31

https://pkg.go.dev/flag should be educational. The first example takes a pointer to an int to change its value. And it's standard library.

Offtopic

28 January 2026 09:27

"change" is very broad.

Offtopic

28 January 2026 09:25

I remember I tried this, it was giving me error, maybe something else was wrong 🤷‍♂

Offtopic

28 January 2026 09:22

I like it. Any[1] other language would be working equally good.
[1] Some exotic languages excluded.

Offtopic

28 January 2026 09:20

We are aware of the technical debt of the current bot. Also, it's not the time to suggest any features or ideas, since we don't have it yet.

And we have a good idea of what it needs to be able to do to replace Doragonsureiya eventually.

Offtopic

28 January 2026 09:18

I’m thinking about optimising what initially go in.

It’s purely data layer issue. Loading of it and querying

Basically, there are rules which are deterministic reason for user to be never able to resurrect.

For example, non English, spam, piracy

Offtopic

28 January 2026 09:17

Still Gitlab. And yes, but the Gitlab one is the only one that'll work.