more people should use this logo!

I have been struggling to understand the window functions. I understand its use case like when you want to rank countries population per continent however the syntax is so weird it doesn't make any sense what actually happening

How does the sql server process this? does it run on every row? is there any benefit of using it over subquery?

sorry if this question is too dumb :(

Hello,

I have been learning rust and want to make something exciting so I though why not build a Lisp compiler in Rust B)

so here what I did today. https://gist.github.com/anon2834678263/bcaa06e934f7b478be79203553f170ee

the tokenizer isn't ready and might have horrible bugs but at least I got comfortable declaring immutable variable by default, not surrounding stuff with parentheses unnecessarily. oh and also Enums which is most powerful thing in rust as people say.

I am still not satisfied though since the code looks more like C than Rust xD

maybe some experienced people can correct me :)

hello,

TLDR: just enable DoH

Today, my friend and I were talking about SNI and deep packet analysis shit done by the government. I insisted that since they do this kind of shit they can block access to certain sites like TPB and other freedom websites. he suggested that I just enable DoH in firefox and see the magic happen. I didn't believe him until I enabled DoH and magic. I can access every censored website.

so just saying that sometimes the bypass is much simpler than we think!

also I am thinking that even if the DNS request is encrypted cant they see the TLS client hello message and block it? or is it impossible?

hello,

I have a domain and I am seeing chatgpt hitting my server very hard I am thinking about replacing my website content with gibberish so when chatgpt reads it, it will mess up their training data hopefully

apparently you cant use an alias

Hello,

I have decided to degoogle myself however I am wondering there are some services which I use which only allows google login. so like what can do about it? also does android run without google account?

Hello,

I have been hosting my project on vercel and I really don't like it at least the free version. so I wanted ask is there any open source and free alterantive of vercel. of course I won't be hosting the production server there but I don't want to pay for it when I am developing it.

Thanks in advance <3

I have seen a lot post talking about how Chinese companies collect US citizens data but I never seen a Chinese person complain about it. Do they think US doesn't have the power to abuse that data?

Really curious

it's actually pretty easy you just have to pull the "base model" instead of instruction model. and then easily fine tune using Modelfile. now the newly generated model will not have any concept of "as an AI model I can't do x". it will just do whatever you want at least that's what I think I haven't tested it yet.