#development

1 messages Ā· Page 309 of 1

hazy heron
jaunty mason
#

bro i wasnt trying to be "snooty"

#

whatever that means

hazy heron
#

it's safe way to do it

jaunty mason
#

😭

lyric mountain
#

client -> your api -> everything else

jaunty mason
lyric mountain
#

anything ur dashboard needs to do, ask your api

#

never connect to any other service that requires a token

jaunty mason
#

most of it

lyric mountain
#

most?

jaunty mason
#

yea

#

😭

lyric mountain
#

what's remaining?

jaunty mason
#

well most of it is already changed but some features dont work yet and in the early days of this being in development i used the token inside of the website env so it pulled data from the bot itself

#

not from the api

#

imma go eat

#

ill be back in 30 mins

lyric mountain
#

anything else shouldn't leave ur server

jaunty mason
#

alr bet

#

wait its not bad that i have my api token in my frontend right

#

like the token to access my api?

lyric mountain
#

that'd be the client session token

#

that one is fine, and unavoidable

jaunty mason
#

wait have i interpreted client session token the wrong way?

#

sorry english isnt my first language so i might have mislearned it

lyric mountain
#

the session token would be the token you use to identify and authorize the frontend when making requests to your api

jaunty mason
#

oh i thought the client session was when the person was logged in

#

like

#

that session of being logged in?

lyric mountain
#

yes

jaunty mason
#

oh so it is right

lyric mountain
#

they're supposed to be the same token

#

you use that login token to call the api

jaunty mason
#

oh i have 2 different identifiers for those

lyric mountain
#

u dont need a separate token for the api, it's actually better not to

jaunty mason
#

oh

lyric mountain
#

since if you ever need to ban or ratelimit someone from acessing your api, you'd ban/ratelimit the user's token

jaunty mason
#

ohhhhhhh

#

now that ur saying that it does make sense

lyric mountain
#

well, not exactly the raw token, since it'd change every once in a while, but the data inside it

#

unless you're using permanent tokens

jaunty mason
#

hmm

#

makes sense to have them the same

sharp geyser
#

You’ll never be able to run a completely free bot forever

sharp geyser
#

If you plan on it being public, and if it somehow does take off

#

You’ll quickly find out why bots have premium features or paywalls on certain features

jaunty mason
#

well i have my own server so hosting isnt an issue, i like developing so being bored wont pressure me into putting paywalls

#

and for the 80 cent domain ill always have spare 80 cents

#

and i dont know how to make it take off LMAO

#

i have NO marketing knowledge

sharp geyser
#

Yeah well a kitchen sink bot likely wouldn’t, not that I’m trying to bust your balls or anything

#

But there’s hundreds of bots with a lot of features that don’t get used because the more mainstream bots exist

sharp geyser
#

Yeah good luck all the same

jaunty mason
sharp geyser
#

@lyric mountain

#

visualization of the maze I made using a recursive backtracking algorithm

#
function generate_floor_topology(playerId: number, floorNumber: number) {
    const mainRng = new Random(playerId + floorNumber);
    const downstairX = mainRng.NextInteger(0, 14);
    const downstairZ = mainRng.NextInteger(0, 14);
    let upstairX: number | undefined;
    let upstairZ: number | undefined;

    let startX = 0;
    let startZ = 0;

    if (floorNumber > 1) {
        const prevRng = new Random(playerId + (floorNumber - 1));
        upstairX = prevRng.NextInteger(0, 14);
        upstairZ = prevRng.NextInteger(0, 14);

        startX = upstairX;
        startZ = upstairZ;
    }

    const cells = new Map<string, MazeCell>();

    for (let x = 0; x < 15; x++) {
        for (let z = 0; z < 15; z++) {
            cells.set(`${x},${z}`, {
                x,
                z,
                passages: new Set(),
                visited: false,
                hasUpStair: x === upstairX && z === upstairZ,
                hasDownStair: x === downstairX && z === downstairZ,
            });
        }
    }

    const stack: MazeCell[] = [];
    const startCell = cells.get(`${startX},${startZ}`)!;
    startCell.visited = true;
    stack.push(startCell);

    while (stack.size() > 0) {
        const current = stack[stack.size() - 1];

        const north = cells.get(`${current.x},${current.z + 1}`);
        const south = cells.get(`${current.x},${current.z - 1}`);
        const east = cells.get(`${current.x + 1},${current.z}`);
        const west = cells.get(`${current.x - 1},${current.z}`);

        const unvisited: Array<{ cell: MazeCell; direction: Direction }> = [];

        if (north && !north.visited) {
            unvisited.push({ cell: north, direction: Direction.North });
        }
        if (south && !south.visited) {
            unvisited.push({ cell: south, direction: Direction.South });
        }
        if (east && !east.visited) {
            unvisited.push({ cell: east, direction: Direction.East });
        }
        if (west && !west.visited) {
            unvisited.push({ cell: west, direction: Direction.West });
        }

        if (unvisited.size() > 0) {
            const neighbor = unvisited[mainRng.NextInteger(0, unvisited.size() - 1)];

            current.passages.add(neighbor.direction);
            neighbor.cell.passages.add(opposite(neighbor.direction));

            neighbor.cell.visited = true;
            stack.push(neighbor.cell);
        } else {
            stack.pop();
        }
    }

    return {
        cells,
        stairPositions: {
            upX: upstairX,
            upZ: upstairZ,
            downX: downstairX,
            downZ: downstairZ,
        },
        startX,
        startZ,
        dimension: 15,
    };
}
#

It was actually rather simple too

lyric mountain
#

Where's the entrance tho KEKW

sharp geyser
#

Technically no entrance

#

You are spawned inside it

#

so there's no actual need for an entrance

lyric mountain
#

ah

sharp geyser
#

There's also no exit because one of those cells will become a staircase down/up

#

just haven't implemented that part yet mmLol

eternal osprey
#

i know, but my paper tries to compare one model to another.

#

So i feel like that when i use different param configs, i introduce bias in my research

#

cuz then, is the model really better, or did i just use better parameters?

fierce orbit
#

I am feeling lazy rn but does anyone know if there is a discord endpoint where bots can update their own profile pic

deft wolf
#

Modify current user endpoint afaik. You can even set it per server iirc

#

Actually, it's Modify current member if you want to set it per server

#

First one is the general one

sharp geyser
#

Basically any adjacent cells with the same number or letter is a clustered cell with a RoomType

#

I took a maze and turned it into a maze with actual rooms

#

:p

eternal osprey
#

I want to update my iphone to 26.4. Could my google auth keys get lost? I read something about it in the past

#

I don’t habe any account, the keys are purely on my phone

lyric mountain
lyric mountain
sharp geyser
#

wdym

eternal osprey
lyric mountain
#

like, instead of picking the M rooms all over the place, they'd all be nearby

#

making a larger "blob"

#

gonna use poe delve map as example

#

notice the background (ignore the yellow lines)

#

blue background means ice biome, notice how they're all grouped together

sharp geyser
#

yeah, I mean the printing of the map was kinda weird, it was more of a proof of concept. I haven't rendered it fully yet. I can still tweak it some

lyric mountain
#

if I wanted to farm that biome, at least it's all nearby

sharp geyser
#

That's fair

#

My thinking was opposite of that though

#

I want scattered rooms

#

Plus these are based off types

#
export const enum RoomType {
    DeadEnd,
    Corridor,
    Corner,
    Junction,
    Hall,
    StairChamber,
}
#

iirc m was a hall

#

so there was likely multiple m cells

#

any that were near each other got grouped together into one cluster

lyric mountain
#

oh

sharp geyser
#

I never really thought of it as biomes

#

Would be interesting to introduce on later floors

#

My goal is for the dungeon to be infinite

#

the lower you go the harder it gets

eternal osprey
opaque pollen
#

Wow that's pretty cool. U use canva for that?

#

@hazy heron

hazy heron
#

no, 100% of that is written code

#

I don't really like using these programs

#

I'm still having issues with antialiasing tho

opaque pollen
#

Bravo, if I was there near u id give u a fist bump. My blackjack is text based šŸ˜† If I have time ill try to make it look nicer

sharp geyser
#

@lyric mountain Visual representation of the maze complete, it spawns a new room as you exit the previous one, though I think I might add a buffer that it will spawn a few rooms at a time so it doesn't constantly look like it's generating.

lyric mountain
#

Ooooo

#

Ominous

#

But yea, try to generate until you hit a turn, and then +1

#

So u never get a non-generated hallway

sharp geyser
#

Yeah

#

I am working on that

#

Right now I do generate an extra room

#

but if I leave that extra room it has to generate a new set of rooms

#

fixed that problem

#

I can cover up any other unpleasentness with animations and such. Like the door fading away or something which will block the momentary odd-ness of the room generating if its a long hallway

lyric mountain
#

If ur going for terror vibes u can also use darkness to mask it

#

As in, barely able to see two rooms ahead

sharp geyser
#

rn there's a foggy atmosphere around the entire place

#

but rooms that haven't been "Mapped" (visited) yet will have an extra layer of fog in them

tall talon
#

how this thing is done ? how buttons can be set inside embeds?

deft wolf
#

It's a container, not embed

tall talon
jaunty mason
#

finally got ticket transcripts to be able to be viewed in my website

swift edge
#

just maintain the privacy thing (make sure tickets are not avaiable publicaly)

jaunty mason
#

they are tied to ur discord id

#

nobody else can view them

swift edge
#

but

#

admins of server should be able to view it too

jaunty mason
#

everyone with manage channels

#

😌

swift edge
#

add a public and private ticket thing that helps

jaunty mason
swift edge
#

nice

jaunty mason
#

u get a link in ur dms that u can share publicly

#

šŸ‘

#

or don’t

jaunty mason
#

people won’t find it either way

swift edge
#

does it require user login?

jaunty mason
swift edge
#

is there a toggle?

jaunty mason
#

u can set it to private or public

swift edge
#

thats really convient

#

convenient*

jaunty mason
#

absolutely

#

took me a while to get it to work

swift edge
#

i made that too

jaunty mason
swift edge
jaunty mason
#

nice

#

that’s a lot

#

how’d u do it

swift edge
jaunty mason
swift edge
#

yea

hazy heron
#

Hi

deft wolf
prisma apex
#

They don't check websites, they check what they entered on top.gg

hazy heron
#

bruh

frosty gale
#

i love how buying a work laptop using a reseller usually means when you get any issues with said laptop/hardware you can bypass the support system entirely and speak to the engineers directly

#

feels so weird emailing MSI employees directly about my laptop running like ass instead of going through a clueless support rep

stark kestrel
#

Conference was fun, hopefully next year I can go as well šŸ˜€

stark abyss
#

i finally launched a mobile app guys!

#

I did it

jolly totem
#

Huhh

sharp geyser
#

Made a little downloader tool :p

#

using tauri

#

was fun

warped turret
#

Dayum

frosty gale
#

why tf is this a thing on cloudflare

#

if you suspect something is malware then... take it down?

deft wolf
#

Cloudflare can only take down stuff hosted by them afaik

frosty gale
#

they are proxying the site though, they can completely cripple the site by just not doing that though

#

the website owner would have to either use something else or directly serve the site

deft wolf
#

I read their report form or something like that and at it states that if someone use them as proxy only they will report it to the hosting provider of this website

#

They’re probably not legally obliged to do it themselves, so they don’t I guess

#

"Because Cloudflare does not have the ability to remove content from a website, it is our practice to forward abuse complaints to entities like the hosting provider and/or website owner to follow up. Please specify:"

frosty gale
#

yeah wouldnt surprise me, i find theyre quite complicit in regards to abuse

#

they wont take down a malicious cloudflare account, but if the cloudflare sales team contacts you demanding for you to pay 20k more a month bc the sales rep hasnt reached their monthly quota yet and you refuse to pay thats when accounts start being taken down lmao

deft wolf
#

xd

slender wagon
#

hey guys, so im about to add a feature that might make discord hate me.
Its mass adding roles to all discord server members. And i expect alot of servers that add my bot to proceed with this step.
So lets say a 20,000 member server adds the bot and proceeds with this and maybe a few other servers.
Will i get rate limited hard and what would be the best way going about this?

deft wolf
#

You should be ratelimited per server so 1 big server shouldn't affect other servers

#

As for the ratelimits themselves you simply have to respect to them. Yes, it will take a bit of time depending on the server size but those are the limitations you can't really bypass without breaking ToS I guess

slender wagon
#

okay

eternal osprey
#

Only the hosting platform can

sharp tiger
#

How can we track votes on top.gg in our server

sharp geyser
#

Updated my video downloader to use yt-dlp and ffmpeg so it can work with virtually any website (providing yt-dlp supports it)

deft wolf
#

And now it's interesting

idle forum
#

Is that any bot having an anti event scheduled and application commands integration , Automods rules update , bans but secure dose ??

#

Discord has a number of guild intent but secure is 26 Intents covered , but can't able to work over mass ban because Discord api can only trigger it can't stop in a middle any dev have fixed it ??

idle forum
tall talon
# idle forum

i did learn it it was hard to learn but i did manage to create those

idle forum
#

nice man

tall talon
#

do you have any suggestion?

idle forum
#

can u see my security systems

tall talon
idle forum
#

no its about cv2 man

tall talon
idle forum
#

no see that antinuke systems

idle forum
tall talon
#

its nice one

#

mine have less Security options

idle forum
#

0 bypass man

#

mine is

tall talon
#

šŸ”› Anti Channel Create
šŸ”› Anti Channel Delete
šŸ”› Anti Channel Update
šŸ”› Anti Role Create
šŸ”› Anti Role Delete
šŸ”› Anti Role Update
šŸ”› Anti Ban
šŸ”› Anti Kick
mine have those with anti link and anti spam

idle forum
#

i have challenged 100 + nukerss

#

yep quite good

tall talon
#

mine is not a security but

#

but i add it for fun

idle forum
#

but secure is proven anti nuke

tall talon
tall talon
idle forum
#

tq man

#

once i get verifed i will launch for global

tall talon
idle forum
#

all the nukers will cry

tall talon
#

my bot is verify and its only in 6 guilds

idle forum
#

no i am tellinng about top.gg man

tall talon
tall talon
#

my bot is verifyed by discord and its only in 6 guild

idle forum
#

mine is in 54 srvs and 17 k users

#

man

tall talon
#

nice

idle forum
#

tq

#

in wanted to test dm me for server inv man

tall talon
#

but they tricked me and they did take my account too

idle forum
#

nice man

tall talon
idle forum
#

this can be easily bypassed man

#

but secure cnt

tall talon
#

and it created weaknesses

idle forum
#

yep

#

@tall talon

#

i cant send u link

#

check dm

tall talon
patent pumice
#

bro lying for zero reason

deft wolf
#

Yea sure

#

Also advertising here is against rules, fyi

idle forum
#

We was chatting

#

Reading things

#

Man

#

@deft wolf

tall talon
#

and the the other 2 owner of the bot Safa and Sina was my friend

swift barn
tall talon
#

and thats for the other bot

stark kestrel
#

k

crystal furnace
#

Hi it is not very relate but I want to ask. How I can accept Github commit safety from my Discord bot developer team. Like they can put malicious code into this.

digital swan
frosty gale
#

yeah you solve that with pull requests, dont allow direct pushes to your master branch, only through pull requests you can approve

dusty mural
deft wolf
#

Least suspicious file sent on discord channel

idle forum
#

😶

#

Suspicious

crystal furnace
clever tundra
#

@ivory siren Sus file / likely crypto scam bio

crystal furnace
digital swan
crystal furnace
digital swan
crystal furnace
clever tundra
knotty night
#

taken care of

eternal osprey
#

hey the novnc console of datalix, why doesn't it allow copy and pasting?

#

My password is like 64 bytes i can't login by typing it all llmao

deft wolf
#

Better to ask them I guess

crystal furnace
#

The onwer of Security Bot

eternal osprey
#

for a silly reason tho

deft wolf
#

xd

eternal osprey
#

they ahd an outtage i said there was a fire cuz i saw people sayin that

#

so yeah that was my reason

#

tried to appeal a year later but they said no again

deft wolf
#

Yea, sound very silly but florian wasn't in the mood I guess

#

I asked there, let's wait for any response

eternal osprey
#

thank you brother

#

i appreciate you

deft wolf
#

Reason is not provided but looks like florian did it on purpose I think

eternal osprey
#

unfortunately. Means that i just can't work till i am home again

#

thanks for helping šŸ™‚

tall talon
crystal furnace
neon leaf
#

tsgo is peak

eternal osprey
eternal osprey
#

How do yall check for unused dependencies?

#

I use depcheck but it never finished for me, even while waiting hours so pretty sure its caugt up in cyclic dependencies

digital swan
#

just manually search each one

slender wagon
#

anything in here that might require attention, question for the experienced cf users

stark kestrel
#

attention for what

slender wagon
#

optimization

stark kestrel
#

unnecessary analytics

neon leaf
#

depending on ur app ur cache rate is low

#

otherwise nothing useful in that

stark kestrel
#

"Analytics & logs" has more useful analytics

slender wagon
#

its cuz my api is serving uncacheable contnet

#

which is cached but on the backend itself

#

but no need for cf to do anything about it

rustic nova
eternal osprey
rustic nova
#

mhm

#

sure

frosty gale
#

its really good that cloudflare offers all of this for free but on the other hand they are such a sleazy company

neon leaf
#

they are the only reason im not bankrupt yet šŸ™

#

94% cache rate

frosty gale
#

would be cool if fastly offered a free tier too

frosty gale
# neon leaf 94% cache rate

i wonder if you can technically host your entire website using cloudflare by making all of its pages cachable and relying on cloudflare to serve the content with occasional polls from cloudflare to your backend to update the content

neon leaf
#

ma'am, that is called cloudflare pages

stark kestrel
#

^

#

aka Workers now that pages is deprecated

frosty gale
#

are they free?

#

what a steal

#

why are we still hosting in 2026

neon leaf
#

because meh rust support duh

stark kestrel
neon leaf
#

and uh back when my site was 100% worker based, I had some good amount of downtimes because of how bad D1 was (and maybe still is)

#

wasnt even a ton of load, just bad system at the time where ur d1 db would be on one host that could go down

neon leaf
dusky idol
#

Hello, I need some SERIOUS help with Mongodb, can someone please help me out?

#

Please anyone who's an expert, I just can't access my data at all, my pc restarted after a crash and since then I can't even connect to my cluster/connection that was on my laptop

#

i just keep getting this error

#

I've tried talking to chatgpt for hours to come up with solutions

#

nothing is working

#

please ping me if anyone can help me out

frosty gale
spark flint
#

@ivory siren aha

eternal osprey
#

Best place to sell a ticketbot lmao

#

selling it to a bunch of developers šŸ„€

#

Bro needs to learn marketing techniques

deft wolf
#

Advertising in Tim's cave smh

ivory siren
#

Banned by william

dusky idol
#

its not working no matter what i tried with help of someone and chatgpt

#

i dont know what to do

#

does anyone know how can I extract data directly from wired tiger files

neon leaf
#

wtf is rustfmt doing

eternal osprey
#

i got locked out from mysql

#

turns out i can bypass auth using a single command?

#

how is that any secure.

tall talon
# eternal osprey how is that any secure.

You can bypass it by using sudo, and using sudo means you are an administrator of the system and require authentication. So, without it, you can't do it, which makes it secure.

eternal osprey
#

still introduces a single point of failure

eternal osprey
#

i did a full system hardening. Took me 2 days and some change, 96 on lynis

frosty gale
#

it usually is recoverable but it depends on the tools available and what the issue is

#

when corruption happens its usually only a small part of the data thats had a booboo, but 99% (or even 100%) is still intact

eternal osprey
#

it would be sick if there was like an additional database layer, sort of a containerized database

neon leaf
#

you have bigger issues if you have the root password

eternal osprey
#

i mean if they have root access you are cooked anyways lmao

eternal osprey
#

I mean i did move everything to my non-root user and actually disabled root login as a whole.

frosty gale
# eternal osprey chloe like if they compromise your root password they can get into the database.

yes thats true but its not really an issue, if someone has your root password and direct access to your instance with the ability to switch user accounts/elevate then thats your security defeated, the database is just an afterthought in that matter
but, the difference is mysql requires you to have root privileges to reset the password/gain access, so you could setup much stronger protections against getting root access than simply entering a password
plus if someone has root access even if mysql didnt provide a way to reset a password/query it with sudo you could still easily modify the database/reset passwords anyways
if thats a concern then you'd have to run your database instance on another machine or on the cloud, but even then someone can compromise that šŸ˜“

#

on my instance for service accounts i mitigate this by disabling su and sudo (i.e. risky binaries that have the root bit set) so even if you knew the password you wouldnt be able to elevate out of it unless you find another exploit

south cosmos
#

how to change server count plish

frosty gale
#

have to love getting a heart from your soulless CTO on a PR

neon leaf
#

is this a recession indicator

frosty gale
#

only if i overthink

fierce orbit
south cosmos
fierce orbit
#

Once you upload it the stats, it should change automatically

south cosmos
fierce orbit
#

Are you using the correct package and have correct params

eternal osprey
#

But my password is 48 bytes i don’t think they can leverage that

south cosmos
eternal osprey
#

Furthermore, @frosty gale , i require 2fa each time sudo is used.

#

It may be ovekill but i don’t mind the extra step as i rarely use sudo

wheat mesa
#

Been there done that

#

I work at a small company so it’s the CEO & VP enslaving me for some stupid feature then hitting me with a ā€œawesome!ā€ when I say it’s done at scrum

eternal schooner
#

guys can someone help me with a discord bot or no

#

am trying to make one but he lit doesnt even wanna speak

#

he only joins the server and then he is muted

lyric mountain
#

show code

idle forum
#

due to dicord voice all bot bots self muted

#

once u added any encoders , or any music libs then it will play music but that time it will auto defend

wise sand
#

Hey question about posting stats to Top.gg
Are the stats verified in any way? What would stop me from making my bot say it's in 5 million servers?

neon leaf
#

your bot invite displays an estimation

#

that can be cross-checked

wise sand
#

But it's not automatic, is it? It relies on reports

deft wolf
#

The world is full of snitches

#

Idk if you want to risk being banned from top.gg just to display bigger server count

#

It doesn't affect positioning anyways because votes matter the most

wise sand
#

s'good that the server count is only indicative tho

frosty gale
#

i set my bot to 10 million servers and no one knows

deft wolf
#

Thank goodness it's just us in this chat and no one is going to report it

#

God bless Tim's Cave

lyric mountain
#

it's basically the shopping cart dilemma

#

nothing will happen if you take it back to its place, nothing will (likely) happen if you leave it in the parking lot

neon flicker
#

Is bot development still as active as it was back then in around 2021-2022?

#

And it's feels good to see KuuHaKu and NyNu every time I visit this server yearly here

neon leaf
#

no clue why kuuhaku still isnt experienced but ye hes been here for a looong time

lyric mountain
#

šŸ‘‰šŸ‘ˆ

neon leaf
#

also kuuhaku the cursed 100 line sql query you helped me write like a year ago is still in prod and going strong

lyric mountain
#

nice, still using mat views for caching?

neon leaf
#

we may be talking about a diff one

#

I had to migrate all the stats stuff to clickhouse because it was getting ridiculous

#

5min+ for a single query

#

im scared to touch it now even though u did reduce it by alot

lyric mountain
#

ah the cte one

full stump
#

Jjk redeem botisalive

lyric mountain
#

@unkempt ocean ??

#

ah, it's just a bot command used in the wrong server

eternal osprey
#

Kuu can you help with extracting data flow graphs from js

#

😭 šŸ’€ šŸ’€

steel oxide
#

@woven elk this is how i did mine...is there a better way? probably, but i'm no css expert KEKW

a[href*="vote"].button .flex.gap-2::before,
a[href*="vote"] .flex.gap-2::before {
  content: '';
  display: inline-block;
  width: 25px;
  height: 25px;
  background-image: url('https://cdn.discordapp.com/emojis/1432781728136560833.webp?size=256&quality=lossless');
  background-size: contain;
  background-repeat: no-repeat;
  background-position: center;
  margin-right: 0px;
  flex-shrink: 0;
}
crystal furnace
west timber
#

Anyone knows V2 components in .js

uneven tartan
quartz kindle
#

bills

prime cliff
#

🚨 CRITICAL: Active supply chain attack on axios -- one of npm's most depended-on packages.

The latest axios@1.14.1 now pulls in plain-crypto-js@4.2.1, a package that did not exist before today. This is a live compromise.

This is textbook supply chain installer malware. axios

Socket

A supply chain attack on Axios introduced a malicious dependency, plain-crypto-js@4.2.1, published minutes earlier and absent from the project’s GitHu...

stark kestrel
#

they get yeeted fast enough

#

one more reason to pin your dependencies by hash or version

idle forum
#

Hii

deft wolf
#

Why it's always crypto scams

sharp geyser
#

Because it’s really easy to pull off and how do you catch them

#

Unless it’s changed within the past few years wallets are anonymous for the most part

stark kestrel
#

They're pseudonymous

sharp geyser
#

Oh well yeah

#

Close enough

frosty gale
#

thats why its a good strat to not update packages to latest immediately

#

doesnt completely solve the problem but helps mitigate it by others battling it out :)

steel trellis
#

because we still default ^ in 2026

neon leaf
#

dam quick deletion

deft wolf
#

I love that I asked about crypto scams and someone sent me a private message saying I look like someone who’s active in the crypto "business" KEKW

neon leaf
#

still wild to me how active and profitable crypto scams still seem to be in 2026

lyric mountain
#

even nigerian prince scams are still profitable

lyric mountain
deft wolf
frosty gale
#

I'm wondering how to buy bitcoin but I'm just not sure of how the blockchain works, or how the Ethereum plasma maintains the integrity of the crypto mining, I would love for someone to tell me how to setup my wallet and fill it with bitcoin using something like coinbase

#

did i use enough buzzwords to get a scam dm

neon leaf
#

you forgot nfts

deft wolf
#

NFTs are still a thing?

stark kestrel
#

^ is fine-ish if you at least make use of your lockfile

stark kestrel
#

dmca countdown started

neon leaf
#

true

deft wolf
#

I'm too clueless for the AI stuff

eternal osprey
#

I did data flow analysis using babel to extract the paths

#

Its fragile and has some loops but works

warped turret
#

Hello

eternal osprey
#

ehh panic

#

axios got fucked

deft wolf
#

Yesterday iirc

eternal osprey
#

yeah

#

how do i check if i am a victim lmao

eternal osprey
#

good luck hope yall aint fucked.

eternal osprey
#

i am so lucky that i was asleep around 1 am yesterday

#

compromise happened around 3-6 am (amsterdam time)

#

i immediatelly removed ^ everywhere, but so lucky i had a lock.json

#

next step:
removing nay package i don't use or can replace easily lmao.

#

i swear hackers are on the run lately, everything's getting hacked.

grave ravine
#

🤣🤣🤣🤣 everyone with node.js has a RAT on there pc/server. Including me šŸ’€

stark kestrel
#

People keep on using npm i with the lockfile and ^

neon leaf
#

pnpm install --frozen-lockfile ā¤ļø

eternal osprey
#

Also checked for which update o had. I had axios 1.14.0

#

The hack was 1.14.1

#

Also i checked for the compromise indicators such as any outbound connections, /tmp/ folder, none came back as positive

#

I was lucky asf

#

I mean the hack happened around 3 am i was asleep anyways

deft wolf
#

IBM mentioned šŸ”„

small tangle
stark kestrel
#

So you install the state of the lockfile

#

If you have pipelines running that use ^ and npm ci, you'd still get the state of the lockfile

#

And dependency updates should happen in their own PRs either way, so have a cleaner track of them

small tangle
stark kestrel
#

Should also be used as a whole using CI/CD pipelines so that you don't get issues

slender wagon
#

Its good that i started using Rust

#

These npm packages are very unstable lately

neon leaf
#

i wouldnt call rust crates much better

frosty gale
#

rusts crate ecosystem is very similar in nature and philosophy to npm IMO albeit suited to fit the language

neon leaf
deft wolf
#

Where is "your mom" on this scale?

uneven tartan
#

I was expecting the same thing

#

It looks like it might have pulled the universe down under the frame tho

deft wolf
#

True

neon leaf
vital mirage
#

do yall fw the website

clever tundra
sage bobcat
#

One message removed from a suspended account.

#

One message removed from a suspended account.

void sun
#

Hello everyone

tall talon
bright ruin
#

ya urs is awesome

bright ruin
tall talon
#

I did make it even better šŸ˜

bright ruin
#

Fucking lit

#

I love it

bright ruin
# tall talon

i might have to try and replicate a little šŸ˜

eternal osprey
#

Wow djs got sick

bright ruin
#

idk if i could tho lmao

eternal osprey
#

Still on v14 or is a diff version out

tall talon
#

For its own support server

bright ruin
#

ooooh

#

still awesome

tall talon
#

I will help if you need

tall talon
bright ruin
#

bro it took me so long to even minorly figure out the components reference thingy

tall talon
#

They could do better but its enaugh

bright ruin
tall talon
bright ruin
#

i bet we watched the same videos

tall talon
#

But still they could do better

#

They could add more style builder

bright ruin
#

Yea

gentle wagon
#

implementing AI to manage discord servers šŸ™‚

bright ruin
#

im excited to see what else they make

tall talon
#

Im application developer i work on Flutter they could use more of flutter design it will be awesome

gentle wagon
tall talon
bright ruin
#

did you just do that through the gpt api? or was it some other

tall talon
#

Since Claude client code is out i could learn from it and make a discord bot that can do everything from a server from how cloude could from terminal

bright ruin
tall talon
#

I may start learning from now on

tall talon
bright ruin
#

everyone here has such good ideas

#

i love this

#

im happy i discovered this channel

tall talon
bright ruin
#

yesh

gentle wagon
#

10 uses

tall talon
gentle wagon
#

or unlimited if you buy premium

gentle wagon
tall talon
gentle wagon
#

it can always be better

tall talon
gentle wagon
bright ruin
gentle wagon
dusty socket
#

how and where do i go to find testers for my bot?

deft wolf
#

Your bot's support server is the best place

frosty gale
#

we work with a b2b service thats had an outage recently and they sent an email to all customers about it but they didnt send it as a bcc or individual email to each person so theyve leaked the email of all of their major customers to everyone on that list šŸ¤¦ā€ā™‚ļø

#

rookie mistake

#

just saw they sent another update email and this time they bcc'd everyone in so they realised their fuck up lmao

neon leaf
#

is it bad that I still have barely any clue what these email terms even mean

frosty gale
#

tbh bcc is a bit niche

#

bcc is like cc or to field and the recipinent in the bcc list gets the email, but no one else sees that they were sent the email in the headers

neon leaf
#

ah

frosty gale
#

a more common use of it is a bit sinister bc its when managers bcc in HR when firing you after they invite you to a vague sounding call

dusty socket
#

how do i get the project Creater tag?

deft wolf
#

You mean the role? You need to have an approved bot or server on top.gg

deft wolf
#

Then ask for it on #support and some mode will give it to you

dusty socket
#

ty mate

eternal osprey
#

Hey, does anyone in here use WAZUH as siem?

slender wagon
#

Do you guys know how long discord usually takes to answer intent requests

clever tundra
slender wagon
#

Okay.

clever tundra
#

The few weeks was during Christmas tho so not that accurate

slender wagon
#

I was trying to get server member intent
Idk if they will accept it tho

#

I need it for the setup of the bot where u can chose to give everyone in the server a certain role

clever tundra
#

That's probs one of the easier intents to get soo

slender wagon
#

Oh ok

slender wagon
#

I've noticed my site is quite slow for the US users. Should i start hosting in different states?

#

Currently it;s running on a dedicated hetzner server

#

but then i have to worry for the db read/write as well

neon leaf
#

I do it using read replicas currently.

primary is eu-01 with the main pg db
theres also eu-02 which has a read replica pointing to eu-01, writes go to eu-01
these 2 servers share a redis sentinel cluster for ratelimits

for us I have
us-east-01 with a read replica, writes go to eu-01
us-east-02 with a read replica, writes go to eu-01
these 2 servers share a redis sentinel cluster for ratelimits

for sg i have
sg-01 with a read replica, writes go to eu-01
no sentinel cluster because only one node.

whether you can do it like this heavily depends on your app though, mine is essentially 99.5% reads, 0.5% writes, and 99% of those 0.5% can be done in the background

#

usually for something global youd not use a multi-primary setup (like yugabytedb) cross regions due to immense latency, instead you could have multiple, completely seperate db clusters

#

so data is first checked against the local cluster, then against other regions

#

/if you use uuids, you can embed cluster info into the uuid to auto route

slender wagon
#

hmmm i do have alot of writting

neon leaf
#

then before you get a phd in this, make sure you are making as little db calls as possible in endpoints

#

if you do 8 queries per request, thats not gonna help

#

if you do 1 massive query, that will help

slender wagon
#

its kinda important like the app is simple. one of my main features is verification

neon leaf
#

something important is that sometimes its faster to have the api endpoints only in one region and the rest of the assets everywhere

#

compared the hosting the api everywhere

#

because one api roundtrip is cheaper than many db roundtrips

#

and for assets, well there location is key

slender wagon
#

i mean i use cf for the rest of the site

#

that doesn't bother me

vast owl
#

hey!

Is scrolling in iframes blocked in topgg?

#

ah nvm, seems only blocked in preview

slender wagon
keen hazel
#

šŸ™‚

frosty gale
#

what 0x7d8 said for databases, in terms of the app itself best way is to make your app container friendly and deploy them on 2 servers then manage with kubernetes or whatever

slender wagon
#

So for now in europe my page fully loads in around 400-500ms
But in the us its like 1.5s+

frosty gale
#

youll need a load balancer too probably that also selects the best region but yeah im sure you already have an idea in mind

keen hazel
#

Everyone ignoring mešŸ™‚

slender wagon
#

Im mostly concerned for like the db

#

Since it is write heavy what im doing

slender wagon
neon leaf
#

well, you likely have an architectural issue

#

if something takes 1.5s vs 500ms

#

because ping is ~100ms-~200ms from us to eu

slender wagon
#

Full page load

neon leaf
#

try makijng your assets available globally first

slender wagon
neon leaf
#

and keeping api in one region

slender wagon
#

If u mean by a cdn

frosty gale
#

tbh also if youre smart about caching and batching queries you could delay having to implement database replicas alltogether without a noticeable speed delay for visitors across multiple regions

neon leaf
#

realistically even on write heavy loads a replica is a good idea

#

it serves as a backup too in case you wipe your main cluster (def didnt happen to me twice)

slender wagon
#

Lol

neon leaf
#

or something like cf workers/pages

slender wagon
neon leaf
#

wouldnt rely on that very much

slender wagon
#

Okay

neon leaf
#

unless you properly do cache headers

slender wagon
#

So i might need a worker

neon leaf
#

or cf pages which i heard were being deprecated even though half my websites run on it so ty cf

#

i think they just merged it tho

slender wagon
#

My actual website is only 50kb the dashboard is on the heavy side but still not that crazy

#

Im using solidjs for the dashboard

#

What i wanna cache hard is the verification page where 99% of the users will be going to anyway

neon leaf
#

if you use any modern bundler, the js assets emitted will contain unique/random identifiers so they can be cached by path

#

which is perfect because you dont need to worry about expiry

#

the index.html will point to the unique ids and thats the only thing thatd be served slower

slender wagon
#

Im gonna look into it tonight and document a before n after

#

Will drop it here just so u guys can critique something

polar verge
#

Anyone else hosting with Railway? I’m still small scale enough to use their free tier but I’m wondering about folks experience with them at higher usage.

slender wagon
#

So i managed to fix the caching of my website using cloudflare.
Its 1h cache per node and dropped the speed from 1.5s to 900ms in the US
In europe it went from 400ms to 240
I just made some cache rules sine i had nothing set up properly.

#

That full page load not just endpoints

#

I guess its pretty decent for now until i feel like getting read replicas etc

#

I really think its a overkill for the size of the project atm

frosty gale
#

but nice'

slender wagon
#

:)

slender wagon
#

The free tier is mostly a marketing stunt

#

But i haven’t used railway so i can’t really talk about that

#

My point is they are usually overpriced

#

I had to email Spectrum last night. It had my website blocked

#

It still is im awaiting a response. But i have a feeling its because of the .cc tld

stark kestrel
#

cc is like xyz, the heaven TLD of scams

slender wagon
#

yeah

#

i have unblocked it so far from a bunch of ISP's

eternal osprey
#

Working on finding unused dependencies

#

Is there any tool that is able to find those? Or ahould i ask ai to help lol. My codebase is way too large for manual search

#

Will take me a few days

plush comet
polar verge
frosty gale
#

"ai will replace 95% of software developers"
meanwhile ai:

#

google still has some work to do

mellow jacinth
#

wildlands šŸ”„

eternal osprey
#

Simple, checking the package i am using and i can somewhat remember where it is used at cuz i have coded it all myself

#

Due to supply chain attacks rising i want to remove most packages

#

and just code it myself

neon leaf
#

in 99% of cases those small packages won't be the targets

#

but still always a good idea to clean up

eternal osprey
#

I mean i am using node-fetch while fetch is native.

#

http-proxy-agent while i am pretty sure fetch has built in proxy support

#

Physics simulator, gonna be a bit harder though.
Fuse-js and string similarity for fuzzy matching… honestly will rewrite it all

frosty gale
#

am i the only one speaking to cursor like an abusive partner in a relationship

quartz kindle
#

have people finally started fighting dependency bloat? lmao

sharp geyser
#

or trying to get it to solve a puzzle but it hallucinates shit

eternal osprey
#

Took me a beating from axios

#

Sadly i have to keep a handful such as scure base and solana

eternal osprey
robust garnet
#

is this a privacy breach

#

and should i remove a specific category or the whole command

deft wolf
#

Looks normal for me

robust garnet
#

It shows a number of how many servers the bot is in

#

Tho it doesn't show the server itself

robust garnet
strong creek
#

Hi

#

I need help I got banned from a sever

#

!mod

deft wolf
robust garnet
fierce orbit
chilly pine
deft wolf
#

They left anyways

robust garnet
#

im using sqlite for db is it bad ????

deft wolf
#

Huh?

robust garnet
#

does using it get you banned

deft wolf
#

I'm pretty sure that's a username of a banned user

robust garnet
#

who uses that for a username omg

#

had me terrified

#

cause i used it

#

i think my bots turn is coming soon to be reviewed

#

possibly tonight or tomorrow

#

are there any basic things i need to check i think i did almost everything

#

added a privacy policy, doubled checked every command and hosted it on railway

eternal osprey
#

I was locked out of my vps.

I used chroot, and mounted disk in the sys rescue terminal.
Is it normal that it says that the ssh key fingerprint has changed after rebooting, or should I assume a MITM is taking place?

neon leaf
#

ty gemini

frosty gale
#

i cancelled my google one subscription bc of it

neon leaf
#

i love it for language related stuff and things where i need giant contexts

#

because claude has immense dementia for me

neon leaf
#

my report on switching from String to CompactString for most strings on MCJars:
very minimal to no changes in memory fragmentation

frosty gale
#

tbh for me the concern isnt really memory fragmentation but rather the overhead of unnecessary allocations for small strings

#

fragmentation is prob very much workload specific

neon leaf
#

yeah I'll keep it for that reason

#

my main fragmentation issues come from 40kb vecs out of redis

grave peak
mellow jacinth
#

yeah

#

its awful at times

grave peak
#

have you considered using gemini on their ai studio platform instead?

neon leaf
#

its still not available in germany

#

I am outsourcing my gemini test api keys to someone in spain

grave peak
#

first response is gemini-3-flash; second is deepseek-v3.2

digital swan
#

@ivory siren

deft wolf
#

Wild

slender wagon
#

Not that it is bad. But people with malicious intent might use it to see how good their attacks are doing

#

Unless you don’t disclose the server ip, domain.

#

I might be a bit paranoid tho

robust garnet
#

can i talk about my submission here and confirm if everything is okay

fierce orbit
#

I mean yes the chances of attack are real but I am working on adding some protections

languid mica
#

oh nvm im a dumbass, the page didnt load fully

fierce orbit
languid mica
#

you havent uploaded on youtube in 2 months

fierce orbit
stark kestrel
deft wolf
#

How disappointing it is to see a new message on #development only to go there and find that there’s no new message at all (it was just a scam that’s been deleted) weirdsip

neon leaf
#

@knotty night

eternal osprey
#

hey guys, does anyone know a way to decode values such as _0xdg0sk etc

neon leaf
#

@knotty night

bright ruin
#

lol

deft wolf
#

150+ hours in roblox

#

That's crazy

bright ruin
#

yay my bot finally got approved

eternal osprey
#

Or was this ping not meant for me lmao

neon leaf
#

there was a scam below you

deft wolf
#

You missed it

#

The best $20 I've ever spent

frosty gale
#

reminds of the project where youtube videos are used as storage

foggy helm
#

@knotty night hello?

knotty night
#

hey

foggy helm
# knotty night hey

My bot is currently running on 15 servers, but top.gg shows it as only 2 servers, and this issue persists.

#

Can you help me?

clever tundra
neon leaf
#

okay gemini šŸ¤ž

dusty socket
#

can i ask for votes on my bot and i also vote back

hazy heron
#

nuh uh

deft wolf
#

Vote for vote is crazy

frosty gale
#

holy ai gen

chilly pine
#

kina

#

like

deft wolf
#

Looks too generic imo. Just like every "discord bot website template" on github + the name is too long and limits you to just discord bots but there are more bots out there than just Discord one + you could sell more than just bot codes

chilly pine
#

idk how to explain it

deft wolf
#

The name is also confusing because it sounds like a discord bot builder, not a marketplace

chilly pine
hazy heron
#

every ai website looks the same

stark kestrel
#

One more website that has the exact same look as other website these days

#

LLM generated websites use templates, that template is everywhere

#

If you want something special/unique, remake the whole website

#

It screams LLM/template generation and uncreative

chilly pine
chilly pine
deft wolf
#

No one wants their website to look ai generated

#

It will just scare off people

chilly pine
deft wolf
#

Not hate but you aim to gather the developers to sell their non ai generated discord bot code. I don't think people who don't use AI to code will send their code on a ai looking website

#

People who don't use AI and can spot it with the naked eye will most likely avoid such websites like the plague

chilly pine
deft wolf
#

I'm genuinely curious how difficult it would be to create a functional website using only AI weirdsip

frosty gale
#

but i found it often struggles with edge cases which creep their way into the final build

#

the company i work in has made their new website only using V0

#

that said for serious projects you still need at least a little bit of knowhow otherwise you'll quickly fall behind using just AI

digital swan
#

yeah it's pretty good and works quite well but it does struggle heavily with some things, and fails to get specific things right

#

for me personally using it to add extra things onto existing features where it can copy the same patterns it works amazingly

chilly pine
frosty gale
chilly pine
frosty gale
#

i mean its basically the industry standard nowadays for building web-only apps with maybe a simple backend without any technical knowledge so pretty good

#

damn that is really expensive

#

very easy to reach 1m input tokens alone

chilly pine
frosty gale
#

the water bills cant be this high bruh

craggy pine
#

@knotty night ^ lol

deft wolf
#

Holy happy wife on discord

spark flint
#

msg needs deleting though

clever tundra
#

bro responsible moderator 'unknown' in logs 😭

eternal osprey
#

Tbf i have been using codex from chatgpt and its pretty good

#

8$ a month for unlimitrd file uploads, access to codex.

#

eventhough the coding is worse compared to claude it ain’t horrible. So if you just check what its doing you’re good

#

I see people racking ip 2k$ bills on ai usage and i am deadass trying to figire out how

#

I only use codex for boring tasks but a whole app? Hell nah

chilly pine
eternal osprey
#

I did some bounty hunts for free

#

I saw exposed databases, api keys, bro it was funny aag

#

Asf

#

One question btw, does a login to a google account in safari give them access to my data or somehow?

#

Its my work google but try to seperate them. I used private mode in safari

scenic adder
#

My app works really well but I might have to get two jobs just to handle the AI, while my app is in 22 servers, my app is in 2 servers with over 100k members and its actually killing my wallets.

small tangle
#

Or how about you limit the usage? stare

lyric mountain
#

there are wayyy too many users to be able to have such a feature open to everyone

#

it just doesnt scale well

scenic adder
lyric mountain
#

That you'll spend even more the more servers your bot get added to

#

Eventually becoming unsustainable

wheat mesa
#

Also might be worth considering if you actually need those nicer-tier models instead of using the cheaper ones like Gemini 3.1 flash, they’re still quite well-suited to natural language tasks

grave peak
#

I require server admins to use their own api key for model usage on their server, whether it be Google or OpenRouter. Obviously, this approach is a bit less accessible and isn't free, but the model usage costs are offloaded in the servers my own API keys aren't submitted to

frosty gale
#

i wonder how gpt 5 nano performs tbh its incredbily cheap

#

not actually bad for the cost

#

probably more than good enough for conversations

#

takes a long time to reason though

grave peak
#

wtf is that o1-pro pricing

frosty gale
#

apparently o1-pro reasons much more so technically its better per answer for what its optimized to do, but probably not for most things

#

probably just an inefficient model though which is why theyre charging so much

scenic adder
#

Its about 200 to 300 a year though

#

So ig thata fine

wheat mesa
#

I’m too lazy to even pay $15/month for a host lol, I’m cheap af

eternal osprey
#

Save money, buy a good vps, run a local LLM

grave peak
#

I was billed $4.28 aud last month running my bot's vps

wheat mesa
#

Gonna run you like $20k to run models bigger than 12b params

crimson vapor
crimson vapor
broken zenith
#
:error: An error occurred: Command 'image' raised an exception: HTTPException: 400 Bad Request (error code: 50035): Invalid Form Body
In content: Must be 2000 or fewer in length.

:> 🄲

scenic adder
#

Its not like I love spending money but I use what works and manages well.

scenic adder
#

Find a way to cut it and send whats necessary then try again.

wheat mesa
#

3.1 flash also has a 1M context window

#

Cheaper as well

scenic adder
wheat mesa
#

not quite sure I understand what 3.1 Pro does that 3.1 Flash can’t in terms of natural language

scenic adder
#

Each api had different features and has either stronger or weaker abilities to read and write along with the analysis is all different

wheat mesa
#

Also not entirely sure what your use case is either though

scenic adder
wheat mesa
#

Not sure what that last part means

#

I’m like 99% certain that 3.1 flash also has vision/image modalities

scenic adder
scenic adder
#

Though its late, I have to go

#

Gn

grave peak
#

are you referring to short-term memory? like the number of messages from the users and the bot being sent to the model?

frosty gale
#

you can easily keep costs reasonable if youre smart about it

#

summaries are almost a must have when maintaining any long-term context

#

also the least capable models which are much cheaper arent bad whatsoever, theyre probably good enough for what youre trying to do which i assume conversation and some basic engineering stuff

deft wolf
#

No

clever tundra
#

@knotty night ads?

deft wolf
#

I love my poor english

knotty night
#

please dont send anything like that @fickle valve

broken zenith
frosty gale
deft wolf
#

Sorry, I didn't meant to be mean

crimson vapor
#

flash is so cheap

eternal osprey
#

i am trying to install canvas

#

but why the fuck is it saying:
Cannot find module '../build/Release/canvas.node'

#

i have rebuilt my packages, built from binary, everything

#

nothing works

digital swan
#

are you using sharp? i had a similar weird issue and turns out they conflict

frosty gale
#

got this random email, not going through with it but wanted to share, thoughts?

#

idek how this would work, eventually your employer would find out unless you literally dont have meetings

stark kestrel
frosty gale
#

i knew there was something more sinister behind it

stark kestrel
#

that blog post was also presented at a conference i went to like 3 weeks ago, the video recording should be available in a few days/weeks

deft wolf
#

If you see "low-risk" or something like that you know it's a scam

eternal osprey
#

anyone that used cloudflare tunnels before? I am trying to securely expose my localhost:3000 process, but i have problems installing it.

#

I continously get a pubkey error.

neon leaf
#

@delicate zephyr

hard zenith
#

Pokemon feeder with egg hunt.
Eggs are colored and provided by the community DoggThumbsUp

modest pine
#

@hard zenith what do you use to make your bots?

hard zenith
modest pine
#

@hard zenith DMs rq please

clever tundra
civic sundial
#

how does this work ?

deft wolf
#

You click on it and it selects a given command in the chatbox

slender wagon
deft wolf
#

That sounds like a fun command

slender wagon
#

someone bonked this guy's pricing table what the hell is this

#

😭

deft wolf
#

Holy, my eyes

#

There is no way someone looked at this and said "yes, that's it"

slender wagon
#

that person is in the server but i wont ping him to save us drama

neon leaf
delicate zephyr
humble gyro
#

ayo thanks

#

sadly i already paid for a yearly :(

viscid sapphire
slender wagon
frosty gale
#

i dont even use copilot for free 😭 😭

slender wagon
low raptor
quartz kindle
#

do not redeeeem

deft wolf
slender wagon
#

CodeRabbit CLI can fix your agent’s code before it everĀ opens a PR - https://coderabbit.link/fireship Free forever for any open source project.

Last week, Google surprised us all by shipping their latest micro model Gemma 4 under a truly open source license. But what's the catch? Let's run it...

#coding #programming #programming

šŸ”– Topi...

ā–¶ Play video
neon leaf
#

dam, i just found out you can do this in rust

src/
  main.rs # mod logs
  logs/
    something.rs
  logs.rs # mod something works!

instead of

src/
  main.rs # mod logs
  logs/
    mod.rs # mod something
    something.rs
#

is this pointless knowledge? yes

neon leaf
#

@lyric mountain you want to help me on a query šŸ˜„

#

im giving up on doing it myself before even starting

lyric mountain
#

hm?

neon leaf
#

for a given config uuid, i need to paginate a list of config values, i need to join it with the first and latest build that uses it (so 2 rows per value), then I need to order by first build.id

lyric mountain
#
SELECT c.*
FROM configs c
INNER JOIN (
  SELECT *
       , min(bc.build_id) OVER w AS first_build
       , max(bc.build_id) OVER w AS last_build
  FROM config_values cv
  INNER JOIN build_configs bc ON bc.config_id = cv.config_id
  WINDOW w AS (ORDER BY bc.build_id)
) x ON x.uuid = c.uuid AND x.build_id IN (x.first_build, x.last_build)
ORDER BY x.build_id
#

maybe

neon leaf
#

SQL-Fehler [42803]: ERROR: column "cv.id" must appear in the GROUP BY clause or be used in an aggregate function
Position: 49

bleak nimbus
frosty gale
#

looks interesting but im not sure how trustworthy their benchmarks are

stark kestrel
frosty gale
#

true

lament rock
#

Gemma 4 is pretty fn good

tall talon
lyric mountain
#

there

slender wagon
#

imagine you try to provide support for the free version of your bot and this is the kind of responses you get

neon leaf
#

btw im already completely lost on what the window is doing