#voice-chat-text-0

1 messages Β· Page 121 of 1

stuck furnace
#

You can achieve something like that with typing.Literal, but it will only work for literals (whose value is statically known).

#

I think you might have to accept that this is something you won't be able to do with the type system.

vocal basin
#

overloads are only hints unless you do some black magic

#
match arg:
    case 'A':
        ...
    case str() | 'B':
        ...
stuck furnace
#

brb

vocal basin
#

I think

#

first matched is what typesystem will take, ig

#

there's match if you have py 3.10+

#

apparently, engineering job actually requires engineering, i.e. solving design problems not just applying existing tools

#

sounds like that should be a paid internship/contract not an interview

#

that's why you have microservices
autonomy both in development and deployment

#

it comes from thoughts like "let's put all people know DataBases in one team"

vocal basin
craggy hornet
#

Hi i can't hear why??

north yew
#

You're deafened

pulsar island
#

youre deafened

#

click the headphones icon

north yew
vocal basin
#

on a phone it might be more difficult to toggle

willow light
#

I live in fear of the day we have a .chatgpt integration

woeful salmon
#

@gentle flint yo

vocal basin
#

.uwu Just passing the output of ChatGPT to .uwu pipeline

viscid lagoonBOT
#

just passing the output of chatgpt t-to .uwu p-pipewine

vocal basin
#

LP was suggesting making .uwu AI-based

willow light
#

We're off to a good start

vocal basin
#

in some sense, programming is an action of explaining what to do
with varying degrees of declarativity

stuck furnace
#

I think to "understand" something is just to have a general model of it.

vocal basin
#

AI has no fundamental restrictions against understanding

willow light
#

I like how the AI acts stoned until I ask about literally anything technical, and then suddenly the entire personality evaporates.

vocal basin
pulsar island
vocal basin
vocal basin
#

...

#

there are reasons why captchas aren't solved by AIs

#

one being:
if you're making an AI to solve captcha, you're probably either working towards improving captchas or you're working against it (as in ToS violation type stuff)

quartz heath
#

Has anybody ever heard of mid journey?

vocal basin
#

who hasn't I'd ask rather

#

I consider this progress

whole bear
#

Big time!!

#

I have a friend using Ai to write all his blog articles with preselected keywords (SEO)

vocal basin
whole bear
#

Yeah its pretty sad.

#

@midnight agate its honestly best as a personal assistant!!

vocal basin
#

@midnight agate if this can be explained to GPT;
though right now I doubt I can explain it to a human with my current level of knowledge;
I think I should just write a proper learning course and only then try to feed it to the AI

whole bear
#

"Prompt Engineering"

#

@midnight agate Same!!!

vocal basin
#

I missed the fun part, I guess

north yew
#

@midnight agate Just gotta let you know that your speaking voice is fucking amazing lmao

vocal basin
#

@midnight agate seems like, it finally learned that comments are not something to overuse?

whole bear
#

@midnight agate you just sound cool man.

whole bear
#

πŸ•ΆοΈ

vocal basin
#

tests taking too much time

vocal basin
#

I know I shouldn't have that much compute heavy tests

#

will fix later

pulsar island
#
    class Battery(models.TextChoices):
        status = models.CharField(default="")
        level = models.IntField(default=0)
        
        @property
        def status(self):
            if self.level =>85
                return self.status("Green")
            elif self.level 55<=>85
                return self.status("Yellow")
            elseif self.level <55
                return self.status("Red")
vocal basin
#

it doesn't parse

#
if level >= 85:
    return ...
elif level >= 55:
    return ...
else:
    return ...
#

or match

torn knot
#

Hi guys

vocal basin
#

sadly

#
match level:
    case int() if 85 <= level:
        return ...
    case int() if 55 <= level < 85:
        return ...
    case int() if level < 55:
        return ...
    case _:
        raise ValueError("invalid level value")  # panic!
#

3.10 is enough

#

it's python anyway

#

Django doesn't use a custom language

#

for execution

#

unlike Flask

#

Flask can't async

vocal basin
#

TDD or just unit tests?

#

there is TDD as red-green-refactor cycle

#

with smallest steps possible

#

there's a generalisation which is just writing tests first

#

TDD says you can't write two failing tests until you make one of them pass

#

which is unrealistic, I'd say

#

TDD works for small and simple things like algorithms and data structures

#

or something, for which the tests are obvious

whole bear
#

@north yew What is that sausage mixed with lamb and beef maybe?? They're like these spicy burgers??

#

more like a burger

north yew
whole bear
#

No, I had a Serbian friend and they made these burgers that you could only get in Serbia. im just trying to figure out what they were lol.

north yew
whole bear
#

Yes!

#

Thanks!!!!

north yew
#

Pljeskavica

whole bear
#

The best!!

#

Not really lol

vocal basin
#

translating code to implement data structures on top of a distributed storage from Python into Rust

#

so, like, asynchronous trees, list, etc.

#

I'm writing in a very Haskell-like style

vocal basin
#

not that

#

like

#

yes

#

how hard Rust is to learn depends on what you apply it to

#

for functional programming, it's easy

#

for systems programming, it's easy

vocal basin
# vocal basin like

suppose you have this

def stack_length(stack: Stack | None) -> int:
    if stack is None:
        return 0
    else:
        return 1 + stack_length(stack.rest)

async_stack_length: Callable[[Awaitable[AsyncStack] | None], Awaitable[int]]

async def async_stack_length(stack: Awaitable[AsyncStack] | None) -> int:
    if stack is None:
        return 0
    else:
        return 1 + await async_stack_length((await stack).rest)

but what if instead you could just do

def t_stack_length(t_stack: T[TStack] | None, t: Type[T]) -> T[int]:
    if t_stack is None:
        return t.pure(0)
    else:
        return (
            t_stack
            .map(lambda stack: stack.rest)
            .bind(t_stack_length)
            .map(lambda length: length + 1)
        )

where T could represent either sync or async

thick pulsar
north yew
#
[8, 6, 4, 4, 9, 5, 2, 9, 6, 1, 5, 10, 2, 10, 7, 3, 3, 8, 1, 7]
[8, 6, 4, 4, 9, 5, 2, 9, 6, 1, 5, 10, 2, 10, 7, 3, 3, 8, 1, 7]
#
['β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“', 'β–“']
vocal basin
#

I forgot

#

there's also Rust server

#

which isn't limited to Rust only streams

whole bear
#

when i use pyautogui, it says that "AttributeError: partially initialized module 'pyautogui' has no attribute 'moveTo' (most likely due to a circular import)" any idea on what this is?

vocal basin
#

what python version?

whole bear
#

umm

#

i believe it is...

#

it is 3.11.3

#

the newest version

vocal basin
vocal basin
whole bear
#

yea its local

#

vscode

#

and im running it on windows

vocal basin
#

what version of pyautogui are you using?

whole bear
#

i dont know, how can i find that?

vocal basin
#

shown in pip freeze

whole bear
#

thanks

#

it says...

#

PyAutoGUI==0.9.52

#

@vocal basin what do you think the issue is?

pulsar island
wise cargoBOT
#

Settings/local.py line 23

SECRET_KEY = 'django-insecure-okc1n%x5k8_=a_dag$75a55g_#rpg&**^76x5mu@fp^xsxxqs&'```
lavish rover
#

oof

fallow musk
#

@pulsar island that's motivating. You have no idea how much I needed to hear that x)

#

Effort *

#

I'm here, I was just considering switching careers as I'm struggling with a leak x)

#

As in a memory leak, I'm coding with C.

#

It's the language I use the most yes.

#

Hahahaha

#

It's brutal.

#

Yup, that's what's happening rn

#

It's part of a school program. I literally have to recode Wolfenstein in C. (That's the very first fps game ever made)

#

They do hate us

#

I'm using pure c. No game engines no nothing.

#

T-T

#

the only thing i'm allowed to use is a graphic library

#

a very bad one called mlx

#

You too!

#

Good luck for your interview

#

You got this!

#

My progress for the wolfenstein game x)

#

Still have a long way to go x)

#

yup

#

I agree

#

Hahahaha

#

Wow

#

That's overwhelming

#

And for like viego they would have to customize it's ult for every other existing champion

#

that's crazzy

#

That

#

That must be such a stressful job

#

no way

#

NO WAY

#

I thought they got paid very well

#

yikes

#

damn

#

Ive read about the drama going on with riot

#

I don't want to do gaming x)

#

Eventually I would like to switch to AI

#

Smart

#

You too!

#

Sure thing

fallow musk
#

Hey! @midnight agate

#

Hahaha

#

Did you get your coffee?

#

Cool music

#

Hey! @somber heath

#

Well, in the grand scheme of it all we're all just behaving according to the chemicals in our brains.

#

so judging normally is very illogical

#

I'm here

somber heath
#

@sick harbor πŸ‘‹

robust quiver
#

why is the 2nd edition expensive???

calm hearth
#

@somber heath Join us in Voice Chat-O

somber heath
#

Hi hi. Did you need something?

#

Beg pardon?

#

Yes.

#

@calm hearth πŸ‘‹

calm hearth
calm hearth
somber heath
#

To do with...?

gentle flint
calm hearth
#

IDE

somber heath
#

That's not something I'm familiar with.

calm hearth
#

What to do now

gentle flint
#

google?

somber heath
#

Panic.

gentle flint
#

in the disco

calm hearth
calm hearth
gentle flint
somber heath
gentle flint
#

yes

#

cuz we don't know

calm hearth
gentle flint
#

so what we would do is google it

calm hearth
gentle flint
#

but then you might as well google it yourself

calm hearth
#

okay

#

letz see

gentle flint
#

third result

#

"python | intellij idea documentation"

#

you could also google how to install plugin in intellij

#

presumably you install other plugins the same way as the python plugin

calm hearth
gentle flint
#

see
install plugins

calm hearth
gentle flint
#

what does it say

gentle flint
calm hearth
gentle flint
#

which is what you want, isn't it

calm hearth
#

that's not the problem

gentle flint
#

then what do you want

calm hearth
#

this is the problem

gentle flint
gentle flint
#

have you tried googling that

calm hearth
gentle flint
#

"configure interpreter python plugin intellij"

calm hearth
#

ltz see

#

found some results

#

i'll continue with pycharm for the moment

gentle flint
#

it's up to you

calm hearth
gentle flint
#

but you can run into similar issues anywhere

#

fixing them is something you're going to have to learn if you keep programming

#

and this is a perfect example

#

narrow down the issue, google it for steps to try

#

try those

#

narrow down the issue further

#

until you have a working solution

somber heath
#

Keep asking questions, though. But yes, it does do to look up instructions first, try to follow them, then, if you're still having trouble, ask for help.

calm hearth
gentle flint
#

which is exactly what you seem to be trying to do

somber heath
#

People are going to be more amendable to helping if you demonstrate that you've tried and just got stuck. πŸ™‚

rugged root
#

Never seen this before. Kind of neat

frosty star
#

haaaaay

#

hiiiii hemlock

#

yeah ive been busy

vocal basin
#

wait, what language are we discussing?

#

/system

rugged root
vocal basin
#

it might be ugly sometimes but it's consistent

rugged root
#
view : Model -> Html Msg
view model =
    div []
        [ button [ onClick Decrement ] [ text "-" ]
        , div [] [ text (String.fromInt model) ]
        , button [ onClick Increment ] [ text "+" ]
        ]
vocal basin
#

I know someone who writes Rust like this

#

(style-wise)

rugged root
#
type Msg
    = Increment
    | Decrement


update : Msg -> Model -> Model
update msg model =
    case msg of
        Increment ->
            model + 1

        Decrement ->
            model - 1
vocal basin
#

until I have an automated tool to format Rust like this, I'm not using it

rugged root
#

You can possibly customize it?

#

Elm has a formatter that comes with it

#

So it can do it for you if you hate writing the style

vocal basin
uncut meteor
#

It is an intentional design choice that there are no configuration options for gofmt. The benefit of eliminating bike shed discussion about formatting choices is considered to be more important than the cost of not permitting people to use their preferred style. The usual saying is that gofmt isn't anybody's preferred style, but it's adequate for everybody.

rugged root
#

That's for Go

#

... there are no configuration options for gofmt....

#

!format

wise cargoBOT
#
String formatting mini-language

The String Formatting Language in Python is a powerful way to tailor the display of strings and other data structures. This string formatting mini language works for f-strings and .format().

Take a look at some of these examples!

>>> my_num = 2134234523
>>> print(f"{my_num:,}")
2,134,234,523

>>> my_smaller_num = -30.0532234
>>> print(f"{my_smaller_num:=09.2f}")
-00030.05

>>> my_str = "Center me!"
>>> print(f"{my_str:-^20}")
-----Center me!-----

>>> repr_str = "Spam \t Ham"
>>> print(f"{repr_str!r}")
'Spam \t Ham'

Full Specification & Resources
String Formatting Mini Language Specification
pyformat.info

uncut meteor
#

!zen one way

wise cargoBOT
#
The Zen of Python (line 9):

Errors should never pass silently.

uncut meteor
#

😭

vocal basin
#

there's % but it's deprecated

you should know how to read it and replace with modern methods but not how to write it

uncut meteor
#

!zen be one

wise cargoBOT
#
The Zen of Python (line 14):

Now is better than never.

uncut meteor
#

oml

rugged root
#
This `model` record does not have a `pasword` field:

68|     , viewInput "password" "Password" model.pasword Password
                                                ^^^^^^^
This is usually a typo. Here are the `model` fields that are most similar:

    { password : String
    , name : String
    , passwordAgain : String
    }

So maybe pasword should be password?
vocal basin
stuck furnace
#

πŸ‘‹

vocal basin
#

"there are two types of languages: functional and functioning"

#

3 minutes per year of downtime

#

at most

#

Erlang focuses on lightweight processes

#

How can we build large self-healing scalable systems?

In this talk I will outline the architectural principles needed for building scalable fault-tolerant systems. I'll talk about building systems from small isolated parallel components which communicate though well-defined protocols.

Programs will have errors in them and will fail so I'll tal...

β–Ά Play video
#

"er(r)" vs "go"
"one is to think before doing, another is the opposite"

vocal basin
#

so, like:
you might get any data, you have to deal with it as appropriate as you can

rugged root
#
view : Model -> Html Msg
view model =
    div []
        [ viewInput "text" "Name" model.name Name
        , viewInput "password" "Password" model.password Password
        , viewInput "password" "Re-enter Password" model.passwordAgain PasswordAgain
        , viewValidation model
        ]


viewInput : String -> String -> String -> (String -> msg) -> Html msg
viewInput t p v toMsg =
    input [ type_ t, placeholder p, value v, onInput toMsg ] []


viewValidation : Model -> Html msg
viewValidation model =
    if model.password == model.passwordAgain then
        div [ style "color" "green" ] [ text "OK" ]

    else
        div [ style "color" "red" ] [ text "Passwords do not match!" ]
uncut meteor
#

Anatomy of a book

vocal basin
#

align everything, make automatic formatters unhappy

viewValidation model =
    if model.password == model.passwordAgain
        then div [ style "color" "green" ] [ text "OK"                      ]
        else div [ style "color" "red"   ] [ text "Passwords do not match!" ]
rugged root
#
type Msg
    = Name String
    | Password String
    | PasswordAgain String


update : Msg -> Model -> Model
update msg model =
    case msg of
        Name name ->
            { model | name = name }

        Password password ->
            { model | password = password }

        PasswordAgain password ->
            { model | passwordAgain = password }
vocal basin
#

github pages

#

if you want back-end, then just pay

rugged root
vocal basin
#
match bool(condition):
    case True:
        ...
    case False:
        ...

match None:
    case _ if condition:
        ...
    case _:
        ...

match condition:
    case c if c:
        ...
    case _:
        ...
#

!e

match:
    case _:
        ...
wise cargoBOT
#

@vocal basin :x: Your 3.11 eval job has completed with return code 1.

001 |   File "/home/main.py", line 1
002 |     match:
003 |           ^
004 | SyntaxError: invalid syntax
vocal basin
#

__match_args__ or something

uncut meteor
#

!e

match = catch = 5 

match match:
    case case:
        print("what")
wise cargoBOT
#

@uncut meteor :white_check_mark: Your 3.11 eval job has completed with return code 0.

5
vocal basin
#

!e

import keyword
print(keyword.softkwlist)
wise cargoBOT
#

@vocal basin :white_check_mark: Your 3.11 eval job has completed with return code 0.

['_', 'case', 'match']
vocal basin
#

note _ also

#

C# has _ as soft kw too

uncut meteor
#

!e

match = case = 5 

match match: 
  case case: print("what")
wise cargoBOT
#

@uncut meteor :white_check_mark: Your 3.11 eval job has completed with return code 0.

what
rugged root
#

!e

match = catch = 5 

match match:;  case case: print("what")
wise cargoBOT
#

@rugged root :x: Your 3.11 eval job has completed with return code 1.

001 |   File "/home/main.py", line 3
002 |     match match:;  case case: print("what")
003 |                 ^
004 | SyntaxError: invalid syntax
vocal basin
#

!e

match = "what"
match match: 
    case case: print(case)
wise cargoBOT
#

@vocal basin :white_check_mark: Your 3.11 eval job has completed with return code 0.

what
vocal basin
#

just use (,)

#

and :=

#

but for match it fails

rugged root
#

She's being too gentle

vocal basin
#

@woeful wyvern you don't really need to update all three at the same time

#

if you have

library
library user
library user
#

install off of git

#

yes

#

yes

#

a specific commit also

vocal basin
#

with private repositories, you will have problems if you do Docker and stuff

rugged root
vocal basin
#
requirements.txt
    your_library @ git+https://repository_site/username/your_library.git@65656b40c6971253284f34752ffc86a0d29902b3
rugged root
#

Is that the SSH key though?

#

That feels.... risky

vocal basin
#

eh

#

that's commit

#

all my library code is public

#

technically

vocal basin
vocal basin
#

have git configured via ENV

#

temporary ENV

rugged root
vocal basin
# vocal basin this is what I use

and for transitive dependencies I have two options for each library:
library installs no commit-specific deps
library[full] installs everything it depends on

gentle flint
#

bottom comment

vocal basin
#

Language H is a proprietary, procedural programming language created by NCR based on COBOL. The first compiler was developed in August 1962 to run on the National-Elliott 405M and produce object code for the National-Elliott 803B. It is believed that the "H" stands for John C Harwell.

vocal basin
#

what would "FILING" keyword be used for

wise cargoBOT
#

day2/main.cbl lines 1 to 4

IDENTIFICATION Division.
    PROGRAM-ID.     Aoc2022Day7Part2.
    AUTHOR          "GDWR"
    DATE-WRITTEN    "07-12-22"```
vocal basin
#

let's revive language H

vocal basin
rugged root
#

Huh, their package repo is interesting

faint raven
#

;compiler !epython book = input("what is your favorite book?: ") print(book) print("My name is {}, I'm {}".format("John",36))

vocal basin
#
print(f"My name is {name}, I'm {age}.")
tender swallow
#

hey

#

lol whts happening here ?

rugged tundra
faint raven
#

are you a programmer? or engineer?@tender swallow

vocal basin
#

I think I should try using MongoDB at some point
I helped more people with it than I've written lines of my own MongoDB-related code (which is zero)

#

Ryan Dahl?

tender swallow
rugged root
vocal basin
rugged root
#

That was the Dino I was thinking of

uncut meteor
faint raven
#

@tender swallowsame me too

tender swallow
tender swallow
faint raven
tender swallow
faint raven
#

yeah

tender swallow
#

cool

faint raven
#

pretty much you do can anything as long its not inappropriate

tender swallow
#

ig i have to complete my 50 msgs....to able to turn on my mic there....lol

faint raven
#

i can't spell

vocal basin
#

"sock puppet" always reminds me of Bryan Cantrill doing OpenSolaris community impressions
https://www.youtube.com/watch?v=-zRN7XLCRhc&t=1767s

Fork Yeah! The Rise and Development of illumos

Bryan M. Cantrill, Joyent

In August 2010, illumos, a new OpenSolaris derivative, was born. While not at the time intended to be a fork, Oracle sealed the fate of illumos when it elected to close OpenSolaris: by choosing to cease its contributions, Oracle promoted illumos from a downstream reposit...

β–Ά Play video
tender swallow
tender swallow
#

should

#

i

#

type

#

things

#

this

#

way

#

to

faint raven
#

no don't do that

tender swallow
#

lol...sry

stuck furnace
#

@tender swallow Don't spam please hyperlemon

stuck furnace
#

Spamming to meet any criteria will get you temporarily or permanently banned from voice, and potentially the community.

faint raven
#

just keep typing like the way you were earlier

vocal basin
tender swallow
tender swallow
#

soo i suppose everyone here is probably programmers ...ryt ?

rugged root
#

@vernal warren

vernal warren
#

SyntaxError: invalid decimal literal
103545 INFO: Matplotlib backend "svg": ignored
Traceback (most recent call last):
File "<string>", line 12, in <module>
File "C:\Users\Pc\AppData\Local\Programs\Python\Python310\lib\site-packages\matplotlib\backends\backend_svg.py", line 11, in <module>
import uuid
File "C:\Users\Pc\AppData\Local\Programs\Python\Python310\lib\site-packages\uuid.py", line 138
if not 0 <= time_low < 1<<32L:
^
SyntaxError: invalid decimal literal
103893 INFO: Matplotlib backend "template": ignored
Traceback (most recent call last):
File "<string>", line 12, in <module>
File "C:\Users\Pc\AppData\Local\Programs\Python\Python310\lib\site-packages\matplotlib\backends\backend_template.py", line 34, in <module>
from matplotlib.backend_bases import (
File "C:\Users\Pc\AppData\Local\Programs\Python\Python310\lib\site-packages\matplotlib\backend_bases.py", line 45, in <module>
from matplotlib import (
File "C:\Users\Pc\AppData\Local\Programs\Python\Python310\lib\site-packages\matplotlib\backend_tools.py", line 19, in <module>
import uuid
File "C:\Users\Pc\AppData\Local\Programs\Python\Python310\lib\site-packages\uuid.py", line 138
if not 0 <= time_low < 1<<32L:
^
SyntaxError: invalid decimal literal

terse needle
#
>>> 1<<32L
  File "<stdin>", line 1
    1<<32L
        ^
SyntaxError: invalid decimal literal
rugged root
terse needle
vernal warren
vocal basin
#
pip uninstall uuid
#

@glad sandal Language H

vernal warren
#

ok i will try

vocal basin
#

let's create Language# H#

#

and introduce nullable STERLING
syntax:

STERLING????????????????
stuck furnace
#

@terse needle how well moderated is that server?

#

I guess we could add it to the whitelist Β―_(ツ)_/Β―

rugged root
#

Not against it, just not sure how relevant it is

somber heath
#

Quackages.

vocal basin
#

"just use illumos"

#

@woeful wyvern pip install -r requirements.txt

#

what are deploying on

vocal basin
woeful wyvern
#
requirements.txt
    py2sqlite @ git+https://github.com/antudic/py2sqlite.git```
vocal basin
#

you don't need to manually build a wheel out of it, pip will do it automatically

woeful wyvern
vernal warren
gentle flint
vocal basin
#

(non-PyPI as in not hosted at PyPI)

uncut meteor
#

Hunting for Switzerland’s Hidden Mountain Fortresses
Exclusive! Grab the NordVPN deal ➼  https://nordvpn.com/johnnyharris Try it risk-free now with a 30-day money-back guarantee!

I went to Switzerland to hunt for bunkers, something I’ve been planning and dreaming about for years. The result wasn’t just a wild trip through the mountains. It was...

β–Ά Play video
gentle flint
vocal basin
#

sounds like an awful idea

#

unless used with LFS

#

"military-grade: cheap and simple enough to be used by military"

vocal basin
# gentle flint can't you put the wheel in the git repo?

I have more or less the same view on it as this answer provides

I suspect the reason is that a wheel is basically a "compiled artifact", so you wouldn't usually find those committed into a git repository
https://stackoverflow.com/a/72487748

vocal basin
gentle flint
#

@glad sandal sΓ€po vill veta var du befinner dig

glad sandal
#

πŸ’€

#

Windows 95 support!

#

@lucid blade move to vc 1

rugged root
somber heath
#

"Ooga booga poor people"

vernal needle
#

hello?

#

can you help me with del() in python

#

i have no idea 😦

woeful wyvern
#

del is a keyword, not a function

vernal needle
#

so how I use it ?

#

any example :))?

woeful wyvern
#

You use it to "delete" variables, usually I only use it in lists/dicts

#

For example, instead of doing mylist.remove(mylist[index]) you can do del mylist[index]

vernal needle
#

oh i see

#

thanks πŸ‘

rugged root
#

I hate printers

#

I'll be on call in a bit

#

But I just have to let everyone know

#

I hate printers

woeful wyvern
vocal basin
#

@gentle flint for extension modules

#

if you can't add typing

vocal basin
ivory horizon
#

wnna play code clash?

gentle flint
#

no thx

whole bear
#

thats cool

molten pewter
vocal basin
#

Hemlock is now a single sound soundboard of "No"

#

if people use it instead of external ones, there's a benefit:

#

you can disable it

#

I'm totally for this becoming a de-facto monopoly on soundboards used by discord users

molten pewter
vocal basin
#

<? print $paginakop?>
what a clickbaity title

gentle flint
#

not to mention the very descriptive content

#
query($sql = "select * from tractorpullingwekerom_nl_paginas where itemby = '$paginaid' order by positie desc"); while ($row=mysqli_fetch_array($result)){ $itemfoto="images/noimgitem.jpg?curtime=".time()."'"; $id=$row["id"]; $titel=$row["titel"]; $filepage=$row["pagina"]; $fotopagina = str_replace("_"," ", $filepage); $selection = "tractorpullingwekerom_nl_afbeeldingen"; $result2=$db_init->query($sql = "select * from $selection where pagina='$id' and itemfoto='x' order by positie"); while ($row=mysqli_fetch_array($result2)){ $afbeeldingtitel=$row["titel"]; $itemfoto="images/".$fotopagina."-".$afbeeldingtitel."-item.jpg"; } print ""; print ""; } ?> 
#

on the page

ivory horizon
#

bye.

vocal basin
#

incorporating leap seconds reliably is unreasonable

#

they are unpredictable

#

too chaotic

#

panic! in the kernel

#

wth are these names

#

LX changed to L for a minute

gentle flint
vocal basin
#

another one on the "Australia's always on fire" topic

gentle flint
#

The Centralia mine fire is a coal-seam fire that has been burning in the labyrinth of abandoned coal mines underneath the borough of Centralia, Pennsylvania, United States, since at least May 27, 1962. Its original cause and start date are still a matter of debate. It is burning in underground coal mines at depths of up to 300 ft (90 m) over an ...

somber heath
#

Burning Mountain, the common name for Mount Wingen, is a hill near Wingen, New South Wales, Australia, approximately 224 km (139 mi) north of Sydney just off the New England Highway. It takes its name from a smouldering coal seam running underground through the sandstone. Burning Mountain is contained within the Burning Mountain Nature Reserve, ...

#

6000 years old.

gentle flint
novel sleet
#

always look on the bright side of life~

Eric from the Monty Python film is singing at RSA
https://www.youtube.com/watch?v=Xo8g6yM0mVc

To see additional RSA Conference 2023 livestreamed content throughout the week, visit our Full Agenda here: https://www.rsaconference.com/usa/agenda/full-agenda

For more RSA Conference 2023 event information, visit our website at https://www.rsaconference.com/usa

β–Ά Play video
vocal basin
#

!e

print(f"{.5:0%}")
wise cargoBOT
#

@vocal basin :white_check_mark: Your 3.11 eval job has completed with return code 0.

50.000000%
flat sentinel
#

Bad Ischl

faint raven
#

my code sucks

#

!epython score = "you scored {:.0%}" # this line tells you the percentage! print(score.format(0.50)) # the format is displaying the number of the %

wise cargoBOT
#

@faint raven :white_check_mark: Your 3.11 eval job has completed with return code 0.

you scored 50%
faint raven
#

!epython print(f"{:.50%}")

wise cargoBOT
#

@faint raven :x: Your 3.11 eval job has completed with return code 1.

001 |   File "/home/main.py", line 1
002 |     print(f"{:.50%}")
003 |                     ^
004 | SyntaxError: f-string: expression required before ':'
vocal basin
#

@glad sandal commercial or closed-source?

desert wolf
#

Talking some kind of enterprise FOSS slack for admins?

vocal basin
#

I don't think charging for a open-source code is sane idea

desert wolf
#

have you seen the world we live in?

vocal basin
#

in "the world we live in" developers charge for support and closed-source extended features

desert wolf
#

yes, and people also charge for FOSS

vocal basin
desert wolf
#

don't need to argue me that..

#

(not that I recommend it whatsoever)

lunar ice
#

Pip install scrapy

glad sandal
faint raven
vocal basin
#

free and open-source software

#

note the word free

vocal basin
vocal basin
faint raven
#

@vocal basin thank you friend

vocal basin
#

I guess

#

time to check

vocal basin
#

so weird

#

go go VS Code
another funny thing is when your terminal starts to be 100 times slower

#

though the real fun starts when reloading doesn't help

lunar ice
#

I am super Man

vocal basin
wise cargoBOT
#

5. Do not provide or request help on projects that may violate terms of service, or that may be deemed inappropriate, malicious, or illegal.

lunar ice
rugged root
#

I need a nap

#

"In Soviet Russia, research does you!"

#

@mild quartz I'll miss you

vocal basin
#

to pay for open-source, you need your profit to depend on open-source

#

this # formatting is so cursed...

#

what has gone wrong there

rugged root
#

Da fuq?

#

That's... weird

#

What language is that?

vocal basin
#

TOML

#

I think it's just an error/typo

rugged root
#

Would assume so

#

@dense ibex Sup brah

dense ibex
#

hi

sweet lodge
#

Oh my dog

#

It’s been 82 years

#

Hi dΓ©v

dense ibex
#

hello my friend

vocal basin
#

I can't work (hireability-wise) so I don't really have any option for now other than doing random quasi-open-source stuff

#

the more I hear stories like that, the more I lose faith in academia specifically and humanity generally

#

the best thing about the project I work on right now is that AIs have absolutely no clue how to make things like that

#

well, one of good things

gentle flint
#
jobs:
  test:
    name: ${{ matrix.os }} / ${{ matrix.nsq-version }} / Python ${{ matrix.python-version }}
    runs-on: ${{ matrix.os }}-latest
    strategy:
      matrix:
        os:
          - Ubuntu
        python-version:
          - "3.7"
          - "3.8"
          - "3.9"
          - "3.10"
          - "3.11"
        nsq-version:
          - "nsq-1.1.0.linux-amd64.go1.10.3"
          - "nsq-1.2.0.linux-amd64.go1.12.9"
          - "nsq-1.2.1.linux-amd64.go1.16.6"
        include:
          - os: Ubuntu
            python-version: "3.12-dev"
            nsq-version: "nsq-1.2.1.linux-amd64.go1.16.6"
vocal basin
# rugged root Well now I'm curious

there's too much specific and hard design choices which can't be solved generically
like, it requires actual thinking and domain-specific considerations almost everywhere
it's also in Rust, so AI is going to get so many things so much wrong

vocal basin
#

Discord should have an option to open any chat to the right, not what it has right now

vocal basin
deft bison
#

Hey, I'm in high school and I'd like to know what you would recommend me to look into if I want to get a job in programming. I know the basics of java and python. Thanks and sorry if my english is kinda bad, I'm from Germany

mortal burrow
#

πŸ‘€

rugged root
#

πŸ‘€

vocal basin
#

:eyes:

#

":eyes" is what British Empire did

rugged root
#

Well done

#

That's really strong

rugged root
dense ibex
gentle flint
#
  unittests:
    strategy:
      matrix:
        python-version: [ '3.8', '3.9', '3.10', '3.11']
    runs-on: ubuntu-latest

    name: Unit tests, Python ${{ matrix.python-version }}

    steps:
      - name: Check out source repository
        uses: actions/checkout@v2
      - name: Set up Python environment
        uses: actions/setup-python@v2
        with:
          python-version: ${{ matrix.python-version }}
      - name: Install packages
        run: python -m pip install .[test]
      - name: Run unittests
        run: python -m pytest tests
vocal basin
#

3.12 seems to not have rc yet

#

testing is not TDD

#

not all unit testing is TDD

#

just don't worry about TDD if it's not beneficial/fun/any good for you
but writing unit tests is quite useful and generally relatively simple, if done correctly

#

for game dev, extract as much as possible into unit testable parts

#

you can also add monitoring and validation for the system (the game)

#

@rugged root a test at a time not tests

rugged root
#

How do you mean?

#

For which

vocal basin
#

for TDD

#

you can write tests before code without TDD

#

it's quite normal

vocal basin
#

if that doesn't hinder the performance too much

#

go go Sphinx

#

3.5 is the oldest one I worked with

#

"so for my little world, 3.4 is prehistoric"

#

learn all three ways (asyncio, threading, multiprocessing) and more
and learn when to apply them

#

3.12 isn't rc

#

it's a

gentle flint
dense ibex
#

!user

wise cargoBOT
#
dΓ©veloppeur backend merdique (.jake#0001)
User information

Created: <t:1580002257:R>
Profile: @dense ibex
ID: 670802831678373908

Member information

Joined: <t:1609774606:R>
Roles: <@&267630620367257601>, <@&764245844798079016>, <@&764802720779337729>, <@&463658397560995840>, <@&897568414044938310>, <@&542431903886606399>

Activity

Messages: 13,842
Activity blocks: 3,487

Infractions

Total: 4
Active: 0

deft bison
#

Thx

vocal basin
gentle flint
#

!pypi build

wise cargoBOT
vocal basin
#

for building there's caching

#

if the issue is that you have to "rebuild everything"

vocal basin
#

what you're doing sounds like what you shouldn't be doing

#

adding dev container functionality on top is faster than installing stuff into a dev container

#

wdym "buster is old", it's only 2019

#

not as bad as having to use ubuntu 14

gentle flint
#

that's 4 years old

#

pretty old

#

it has python 3.7 iirc

vocal basin
#

@lucid blade
there are some whitelisted servers

deft bison
#

think discord wouldn't die... it't too big

vocal basin
#

too much lock-in rather than too big

deft bison
#

and for privacy reasons I think it would be an improvement

#

hate the 50 messages requirement... I'd like to talk, but I'm missing that...

#

where is the devcon?

lucid blade
#

DEFCON

#

its the worlds largest hackercon

deft bison
lucid blade
#

YEH

deft bison
#

already watched some ccc talks

#

do you have talks that I can watch wich are interesting?

#

like titles would be realy great

lucid blade
deft bison
#

why would you get into trouble?

#

understood πŸ˜…

#

can you tell me some channels in voice where to find good talks?

lucid blade
deft bison
#

I'm from Germany, so no problem for me πŸ™‚

#

I'll go to bed. Bye

faint raven
#

!e ```python
score = "you scored {:.0%} on your drug test"
print(score.format(1.0))

i literally pass my brug test!```

wise cargoBOT
#

@faint raven :white_check_mark: Your 3.11 eval job has completed with return code 0.

you scored 100% in your drug test
somber heath
#

@worthy cypress πŸ‘‹

silver sluice
#

hello

ivory horizon
ruby brook
#

hellooo @somber heath

somber heath
#

@whole bear You good?

whole bear
#

Someone called I had to leave sorry

#

Yeah all good thanks

junior ermine
#

hey!

#

guys can you help me with a problem compiling my code?

#

actually it works in the ide, but not when i package it in an ee

#

exe

#

1 sec

#

headphones

whole bear
#

auto-py-to-exe

junior ermine
#

im using that one

#

actually...

#

it runs , but many

#

maaaaaaaaaaaaaany times

#

it runs itself and never do anything

#

i mean it opens itself many times

#

and use a lot of memory

#

but does not do anything

#

i think i do

#

should i remove it?

#

its setted to 5000

#

what ?

#

oh yes

#

1 sec

whole bear
#

The depth of the recursion stack

#

Yes that won't be enough if your function never reaches a point where it stops calling itself

somber heath
#

!code

wise cargoBOT
#
Formatting code on discord

Here's how to format Python code on Discord:

```py
print('Hello world!')
```

These are backticks, not quotes. Check this out if you can't find the backtick key.

For long code samples, you can use our pastebin.

whole bear
#

Can you show us the code where you have that function?

junior ermine
#

lemme send it to your pv

#

i cant here

whole bear
#

`

junior ermine
#

how?

somber heath
#

!paste

wise cargoBOT
#
Pasting large amounts of code

If your code is too long to fit in a codeblock in Discord, you can paste your code here:
https://paste.pythondiscord.com/

After pasting your code, save it by clicking the floppy disk icon in the top right, or by typing ctrl + S. After doing that, the URL should change. Copy the URL and post it here so others can see it.

junior ermine
somber heath
#

I don't use Python to exe software, so I may be of limited help, but let's take a look.

junior ermine
#

tks

whole bear
#
if lang == 'en':
  for ent in doc.ents:
    print(ent.text, ent.label_)
  os.system("main2.exe")
else:
  os.system("main2.exe")

Are you sure this piece of code is correct?

junior ermine
#

maybe not

#

lemme check

whole bear
#

Because you're calling main2.exe anyways

#

The only difference is you're printing something

junior ermine
#

those programs are my translators

#

they are lready compyiled

#

then why it runs in the ide?

#

thanksss

#

but it does run in the ide

#

not i n the exe

#

yes it is

#

it is in the same folder

#

yes

#

yes i do

#

how can i solve?

#

im compiling it again

junior ermine
somber heath
#

@feral valeπŸ‘‹

#

Yahoy.

#

Okiedoke

#

@wintry mothπŸ‘‹

#

You can use ChatGPT if you don't care about the answer it gives you being right or not.

wintry moth
#

Wsp

#

.

#

Facts

somber heath
#

We're doomed.

wintry moth
#

I dotn have permission to speak idk why πŸ’€

somber heath
#

!voice

wise cargoBOT
#
Voice verification

Can’t talk in voice chat? Check out #voice-verification to get access. The criteria for verifying are specified there.

somber heath
#

Speedbump to keep the screamers out.

#

Computer says no.

woeful wyvern
#

player_id | score | time_duration

wintry moth
#

Dm i need more time to talk

woeful wyvern
#

SELECT * FROM Attempts ORDER BY score, time_duration LIMIT 1;

somber heath
#

I'm listening.

#

Mr. Hemlock comes here quite regularly.

#

About half an hour ago.

#

@rapid chasm

#

Yes.

#

@lost remnantπŸ‘‹

lost remnant
#

hii

somber heath
#

Hemwok

#

Howlers.

#

"Ah, yes. A headache. Let's go stare into a screen."

#

Dogs roll in poo.

#

Washing your hands is a reasonable after-petting action.

rugged root
somber heath
#

Spilled fluids are a slip hazard.

#

Wiping them up is prudent.

rugged root
#

True dat

lunar ice
#

!voice

#

!voice

rugged root
#

That'll tell you what you need to know about the voice gate

lunar ice
rugged root
#

That's fact

terse needle
#

@rugged root isn't this awesome

=> (import functools)
=> (defn [functools.cache] fib [n]
...   (match n
...     0 0
...     1 1
...     _ (+ (fib (- n 1)) (fib (- n 2)))
...     )
...   )
=> (fib 100)
354224848179261915075
=>
rugged root
#

I understand it, but I hate it

somber heath
#

Define D drive.

rugged root
#

But I think that's my irritation with prefix operators

terse needle
#

I'm not a fan of the way decorators are implemented but i'm not sure how else they would do it

#

I think decorators are more suited to pythons syntax and really in hy we should be using macros

rugged root
#

So in the case of:

terse needle
#

because python decorators are very lisp macro inspired

rugged root
#
(match n
  0 0
  1 1
...)

That's just saying if 0 then 0 and if 1 then 1?

terse needle
#

yes

rugged root
#

And since it's just the value it just returns it

terse needle
#

it just evaluates whats on the right hand side if it matches the left hand side

rugged root
#

Since it'd be the last thing the function sees

#

Right

#

Wait

terse needle
#

and they are implicitly returned

rugged root
#

Hold on

safe pumice
rugged root
#

How do you mean?

terse needle
#

if it matches 0 it evals 0 and returns it

rugged tundra
lunar ice
terse needle
rugged root
lunar ice
somber heath
#

Muted, but listening.

#

Define d drive.

safe pumice
#

(FastChatEnv) PS D:\Users\nasan\FastChat> python download-model.py anon8231489123/vicuna-13b-GPTQ-4bit-128g
Traceback (most recent call last):
File "D:\Users\nasan\FastChat\download-model.py", line 196, in <module>
links, sha256, is_lora = get_download_links_from_huggingface(model, branch)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Users\nasan\FastChat\download-model.py", line 130, in get_download_links_from_huggingface
fname = dict[i]['path']
~~~~^^^

somber heath
#

What type of device is the d drive? Because d is just a mapping name.

#

Righty.

safe pumice
somber heath
#

Yo.

pallid hazel
#

sigh.. another script rebuild.. turns out building an async framework to run nonasync i/o requests speed things up a little bit.. offered a layered timeout for batch runs, but overal introduced some flakeyness.. so back to rewriting a refined processpool, threadpool version.. working ok so far..

#

mostly due to a subprocess call burried in the nonasync section.. it didnt like that, and trying to feather async to it didnt really seem functional or ideal

rugged root
#

Yeeeahhhhhh fair

#

Converting to async would be a chore, unfortunately

pallid hazel
#

sadly the async packages for snmp arent session bound.. so it would hammering devices with a new session every request that are grouped.. walks, bulkgets are fine.. requires a lot of reprocessing.. but for testing they introduce a monkey wrench for what im doing

#

where as now i can keep a session alive while waiting on its turn in tests..

somber heath
#

I once guessed a coin toss eleven times in a row. So for $20 a pop, I'd be $220 up on the deal.

#

We didn't try for twelve.

#

My friends started to get a little weirded out.

dense ibex
#
TypeError: sqlalchemy.sql.elements.TextClause.bindparams() argument after ** must be a mapping, not list

angry_akarys

somber heath
#

SOMEONE has to be.

#

@dense ibex drop it here

dense meadow
#

yo yo

#

guys

somber heath
#

@dense ibexTeach them for extra credit.

rugged root
#

@wintry beacon

wintry beacon
somber heath
#

This, but tumbleweeds.

wintry beacon
somber heath
#

Oh man. I just realised.

#

You know how they made the movie "A Dog's Purpose"?

#

A Cat's Purpose.

#

Alternatively, A Cat's Purrpose.

wintry beacon
#

Lame

wind raptor
#

What is a cat's purpose though?

safe pumice
rugged root
#

py -0p

safe pumice
#

(FastChatEnv) PS D:\Users\nasan\FastChat\repositories\GPTQ-for-LLaMa> py -0p

  •           D:\venvs\FastChatEnv\Scripts\python.exe
    

-V:3.11 C:\Python311\python.exe
-V:3.10 D:\Users\nasan\anaconda3\python.exe
-V:3.9 C:\ProgramData\Anaconda3\python.exe
-V:ContinuumAnalytics/Anaconda39-64 C:\ProgramData\Anaconda3\python.exe

rugged root
#

py -3.10 [other stuff you need to do]

safe pumice
#

(FastChatEnv) PS D:\Users\nasan\FastChat\repositories\GPTQ-for-LLaMa> python -V
Python 3.11.0

#

(FastChatEnv) PS D:\Users\nasan\FastChat\repositories\GPTQ-for-LLaMa> py -3.10 [other
stuff you need to do]
D:\Users\nasan\anaconda3\python.exe: can't open file 'D:\Users\nasan\FastChat\repositories\GPTQ-for-LLaMa\[other': [Errno 2] No such file or directory

rugged root
#

py -3.10 -m pip list

#

!paste

wise cargoBOT
#
Pasting large amounts of code

If your code is too long to fit in a codeblock in Discord, you can paste your code here:
https://paste.pythondiscord.com/

After pasting your code, save it by clicking the floppy disk icon in the top right, or by typing ctrl + S. After doing that, the URL should change. Copy the URL and post it here so others can see it.

safe pumice
#

python setup_cuda.py install

#

py -3.10 -m pip list

rugged root
somber heath
#

"StOrAgE iS cHeAp..."

safe pumice
#

python setup_cuda.py install

safe pumice
wind raptor
#

'C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.8'

safe pumice
velvet tartan
wind raptor
#

!stream 762972477479059489

wise cargoBOT
#

βœ… @safe pumice can now stream until <t:1682608966:f>.

mild quartz
whole bear
#

A friend of mine keeps trying to get me to work on a quant trading project, but im too much of a noob.

safe pumice
#

Crystal can you please me in a different Channel

#

@velvet tartan

mild quartz
#

Ilya Sutskever (Hebrew: ΧΧ™ΧœΧ™Χ” Χ‘Χ•Χ¦Χ§Χ‘Χ¨; born 1985/86) is an Israeli-Canadian computer scientist working in machine learning, who co-founded and serves as Chief Scientist of OpenAI.He has made several major contributions to the field of deep learning. He is the co-inventor, with Alex Krizhevsky and Geoffrey Hinton, of AlexNet, a convolutional neur...

stuck furnace
#

Oh you should check out Freddy the robot πŸ˜„

#

It could assemble a toy car from parts scattered on a table.

lucid blade
stuck furnace
#

You can use a technique called "smoothing" for stuff outside the training data.

#

Although I think what Hemlock is talking about is giving the model agency to explore its environment.

lucid blade
stuck furnace
#

A model-based agent acting in a partially observable environment has to make decisions about how best to gain information about that environment.

#

This is classic agent-based AI stuff πŸ˜„

#

The model we typically use for uncertain environments is something called a "Markov decision process" (MDP). So that's a term you could search for.

#

Anokhi, just wondering, what was your route into AI/ML?

somber heath
#

@lucid blade SaD

#

Act on hand gestures.

whole bear
#

You guys should look into drones and LiDAR. They’ve been using LiDAR on drones recently to 3D scan areas to build 3d models. There’s been a few companies doing the cloud processing and using AI for things like maps.

#

I fly a cinelog 25

lucid blade
#

photoscan

whole bear
#

I’ve seen a lot of photogrammetry!!

#

I haven’t messed with it.

lucid blade
whole bear
#

Surveying is also a kind of a gated field, so it’s tough to sell LiDAR to avg consumers.

somber heath
#

KD vector math.

lucid blade
whole bear
#

I just miss in game trading, but it turns out that creates black market economies. The future sucks πŸ˜‚πŸ˜‚

lucid blade
#

i still think gaming was 100x better in the 90s

stuck furnace
#

Things that look like exponential growth often turn out to actually be logistic growth πŸ˜„

#

I tend to take the economic view, that new technology is essentially just improvements in efficiency, and those improvements eventually have diminishing returns.

whole bear
#

theres DNA hard drives.

stuck furnace
#

There's a scheme in London to use waste heat from the London Underground to heat buildings πŸ˜„

#

Ah we switched to a heat-pump based dryer recently, from gas powered.

#

Even in fairly low temperatures they can work reasonably well apparently.

#

Thermal camera?

#

Well all matter gives off radiation. The frequency of the radiation is proportional to the temperature.

somber heath
#

We are little lamps.

ivory horizon
#

need to increase my voltage

stuck furnace
lucid blade
ivory horizon
#

start using nokia 3310

rugged tundra
#

Want ChatGPT query bot in Discord?

lucid blade
stuck furnace
#

Something I think would be cool is an AI powered tool for front-end testing. I.e. you give it an screenshot of a web page, and a textual description of features that should be present, and it tells you whether that is the case.

lucid blade
#

^ +1

#

i skateboard and climb

lucid blade
#

yo

stuck furnace
#

Can you go back over that last part?

#

What does the query look like currently?

silver sluice
#

Hi LX

stuck furnace
#

@woeful wyvern πŸ‘‹

silver sluice
#

I love you

#

Im a buff male btw

#

πŸ’ͺ

whole bear
#

@silver sluice I used to go to a MMA gym where the coach constantly made political jokes. It kind of felt the same.

silver sluice
#

I like political jokes, but I dont say them around people who are uncomfortable with them

#

(Im from the balkans, our politics are different btw)

#

My county is going to have its 5th election in the span of 2 years lol

woeful wyvern
#

SELECT missionId, score, totalTime FROM Session WHERE teamId=53 GROUP BY missionId ORDER BY score, totalTime;

stuck furnace
#

When you group by, you need to aggregate the groups.

woeful wyvern
#

SELECT missionId, score, totalTime FROM Session WHERE teamId=53 GROUP BY missionId, score, totalTime ORDER BY score, totalTime;

uncut meteor
#

a greg ate

#

yum

stuck furnace
#

Can you remind me what result you want?

woeful wyvern
#

SELECT missionId, score, totalTime FROM Session WHERE teamId=53 GROUP BY missionId, score, totalTime ORDER BY score DESC, totalTime LIMIT 20;

uncut meteor
#
SELECT
  s.score, 
  DISTINCT s.missionId, 
  s.totalTime
FROM 
  Sesssion s
WHERE
  s.teamId = ?
GROUP BY 
  s.score DESC, 
  s.totalTime ASC;
#
SELECT s.score, DISTINCT s.missionId, s.totalTime FROM Sesssion s WHERE s.teamId = 53 GROUP BY s.score DESC, s.totalTime ASC;
stuck furnace
#

a greg ate gregs

terse needle
stuck furnace
#

Β―_(ツ)_/Β―

#

!otn a a greg ate gregs

wise cargoBOT
#

:ok_hand: Added a-greg-ate-gregs to the names list.

stuck furnace
#

Cya

uncut meteor
#

cya

woeful wyvern
ivory horizon
#

select p.id, p.mission_id, p.scores, p.total_time from ( select mission_id, max(scores) as mx from sessions where team_id=? group by mission_id) t join session p on p.mission_id=t.mission_id and p.scores = t.scores order by p.total_time where p.team_id=?

woeful wyvern
#

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=t.missionId and p.scores=t.scores order by p.total_time' at line 1

rugged root
#

@mystic lily Will depend on the kind of site it is

#

And their terms and conditions

#

Ideally if you can use their API, that'd be best

#

@teal jetty Sup

mystic lily
#

will there's no api and donno about t and c

rugged root
#

What're the sites?

woeful wyvern
#

select p.id, p.missionId, p.score, p.totalTime from ( select missionId, max(score) as mx from Session where teamId=53 group by missionId) t join Session p on p.missionId=t.missionId and p.score = t.mx order by p.totalTime;

mystic lily
#

sites like betfair

dense ibex
#

@rugged root are you busy rn?

rugged root
#

What's up

#

Migrate to vc1?

#

Easier to talk

dense ibex
#

sure

woeful wyvern
#

select p.id, p.missionId, p.score, p.totalTime from ( select missionId, max(score) as mx from Session where teamId=53 group by missionId) t join Session p on p.missionId=t.missionId and p.score = t.mx WHERE p.teamid=53 order by p.totalTime;

#

SELECT * FROM Session WHERE teamId=53 ORDER BY missionId, score DESC, totalTime

#

SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY missionId ORDER BY score DESC, totalTime) AS ranking FROM Session WHERE teamId = 53 ) ranked_sessions WHERE ranking = 1;

rugged root
#

@worthy cypress Do you have the code I can look at?

ivory horizon
#

cya guys.

gentle flint
#

ah

#

sql

quaint venture
#

can i ask what are you programming?

terse needle
long iron
#

hello

terse needle
rugged root
#

@faint pivot Enjoying my crappy old let's plays?

faint pivot
rugged root
#

Bah, not really

faint pivot
#

idk its nostalgic

rugged root
#

Oh yeah?

faint pivot
#

How can you even see???

#

lolol

rugged root
#

True, looking back I do need to play through some of those again

faint pivot
#

kaizo mario 2

rugged root
#

The spider - mankind’s most ancient and deadly nemesis. As a licensed Kill It With Fire exterminator, it’s time to fight back! Assemble your arsenal of increasingly excessive weapons, track spiders across suburbia, and burn everything in your path!To defeat spiders you must exploit their one weakness: FIRE. Or bullets. Or explosions, throwing st...

Price

$14.99

Recommendations

2382

Metacritic

68

β–Ά Play video
#

I never did finish Kaizo 2 did I

#

Maybe I should do that again... see if I'm even capable of it

faint pivot
#

How can you see who clicks on your 'connected apps'? never knew it was possible

rugged root
#

So it's not that I can see that

#

Your mic started playing the audio

faint pivot
#

WAHT

#

how

rugged root
#

And I (obviously) recognized my intro and voice

#

No idea

#

You on speakers?

faint pivot
#

no headphones ahhaha

rugged root
#

Weird

faint pivot
#

my life is built around audio problems, i'm not shocked

rugged root
#

I think we have another person with that issue as well

#

HA

#

Fair

faint pivot
#

let me try again with another YT video

#

hear anything?

#

weird

#

sussy discord ngl

#

thanks for letting me know before I truly embarrass myself

vivid palm
#

hi

#
  • hi
  • this is
  • a list
#
  • a
  • b
#
  1. a numerical
  2. list
terse needle
#
  • test
pallid hazel
#

@rugged root you done a voice over?