We have an API which returns 600 MB of JSON.

Because client "Wants to see everything first and then apply filters, just like Excel".

FML
Edit and ofc thier laptops with core i3 and 4GB of ram can't even process that.

My server has constaly 40% CPU usage.... Even when there are NO requests.

I'm searching "wtf is going on" for the past 2 days.

0 results. Clients are unhappy, sales team is unhappy. Noone is happy and I don't have an answer. Grrrrrrr.

*Goes back to reading logs

By server I mean Azure WebApp, not a VM/ohysical server

Me : "hey front end dev, here is an API returing a list of objects, put them in a table"

*Some hours later

Front end : 'Done !"

Me :" Where are the totals?"

front end : 'Api doesn't give me totals"

me : "Calculate them. Just do a sum"

front end : 'I don't know how".

Yeah, "front end" apprently means only html css.... FML

You win Linux. That was the last straw. I will never install ANY linux distribution ever again.

Setup a simple FTP server. What can possibly go wrong ?

Ok now I want it to point to /media/ftp

Easy, right ?

Just add local_root=/media/ftp

Weeeeellll nop.

Not working. Completly ingnoring this setting, all users log to home directory.

#chroot_local_user=YES

tried, no effect.

I'm wiping this server and installing windows server there.

Too bad, the process started very well, the machine is fully confiogured, ready to go, DNS working every thing working. Except this shitty FTP.

So FUCK YOU linux wioth config files, WELCOME windows with nice GUI where I can just SELECT the default ftp folder

I can't take any more CRUD.

That's it.

It seems all I do every day is CRUD, CRUD and more CRUD.

It's easy, it's fast, but fuck me... Give me at least some data manipulation to do, SOMETHING where I actually need to enable my mind, and not just "write code while watching netflix".

Me : Sending company wide email.
5 seconds later,
Me : "Oh new email"
Me : From myself :(

Today is a sad day.

I loved Songza from day one. Google bought them, but kept their functionality alive via google music.

Today goole transferred google music to youtube music.

My beloved algos and functionalities of original Songsa are GONE. And their new shitty service propose only playlist. 0 AI, 0 machine learning.

Anyone knows a free music plateform I can migrate to ?

Fuck you Twillio.
You bought a perfectly good email service (SendGrid) and now this service is just.. failing.
All of theirs Ips are getting blacklisted. Our clients are calling us (Of course they are).
People cannot reset passwords, cannot get ANY email notification.
Right now, SendGrid is blacklisted by majority of anti spam systems.
Twilio, fuck you again. This service we were using for more than 5 years without ANY problem. Twilio fucked up.
Fuck you Twlio again. And when we create a “critical” ticket, all you have to say is “Meehhh we’ll contact you in a week” ? REALLY ? Even Microsoft contacts us in 2 hours for critical problems.
Sorry it needed to come out.

I am a Windows person. I always argue how great it is.

Well, not today.

I was today years old when I learned that you CANNOT uninstall store app via store ;p You need to go to settings / apps and functionality / your app / uninstall

The photo app (Yes the one bundled with win10) doesn't work if you use Hard drive compression AND it is a symlink for OneDrive (So you don't need to keep all photos on the drive). Fucking Paint works without problems.

Email client : If you alt+tab too fast after hitting 'Send email", there is 50% chances that email won't be send. Basiclly you need to hit "send" and wait until you see it in "sent" folder.

Well, as i'm ranting, here for Linux too :
I have a small ubuntu server VM, worked very well for last 6 months. Now "System in read only mode". Fucking apt-get upgrade fucked with something. I don't want to look, so I'll just rebuild a fresh vm.

And macOS should take sometyhing too : Who the fuck decided "enter" is for editing the name of file ?! really !

Well, ALL os are shit, all have downsides, I need my own OS. But I still want AA games... So windows for me.

Any code should be simple and easy to read / understand.

I just reworked an old stored SQL proc.

Went from 102 lines to ... 10.

More I code, more I realize that maintainability, readability, comments and unit tests are more important than actual code. (And performances ofc. But if 1 line code does it in 1 second and 500 lines code in 0.2 seconds, I’ll take one line solution every time)

I was around 12. My mother just took a new position as Algorithmic and programming teacher (Mathematics before) for high school seniors. (Around 16-17 in Russia back in a day).

So sometimes, I waited for her after school, listening (just a bit) what she was teaching.

Then one day I was waiting while she was giving an exam of 2 hours to seniors (End of year exam). In 20 minutes, I doodled a thing on a piece of paper and showed my mother. I was correct on all questions and all flow diagrams (Was not called like this back in a day).

From this moment, I knew, programming and logic are for me.

At the end of high school (So I was 17), I received the collective message from most girls in my class saying : “ You felt in love with computers and ignored us”. They were right ☹, I realised it way later.

I’m fucking lost.

So, situation. I have a SQL table with about 3M rows (not a lot).

I have indexes. Indexes are used. BUT when I add where clause (On indexed column), it’s super slow. Around 10 seconds.

If I do select * (ALL 3M rows) and THEN I filter then on webserver side, it takes 0.5 seconds.

HOW my manual filtering is faster than DB filtering with indexes? I even tried bubble sort. Bubble sort is faster than SQL ‘where’. HOW ?!

I do not understand….

And if I add group by….. WELL, 25 seconds SQL time. 2 Seconds if I do select all and group by in code manually.

Does not make ANY sense to me.
What am I missing ?

Hmmmm,

Someone forgot to renew SSL

Normal people : Save thier work regulary.
Me :

Oh no matter, notepadd++ saves opens files somewhere, i'm good with that.

There are important lohins, passwords, some temp stuf and work in progress for something, there are backups and information needed.

!DEV

My mice stopped moving "efortlessly".

So I added a bit of scotch. Mice is working again very well and you don;t feel the drag !!

Yeah I should update my keyboard / mice, as they are in horrible state.

Linux is great
Linux can be customized

Welp, not so much. Simple things are not possible to do.

After 1H research I can't have timestamp near each line over SSH.

I'm not talking "history", i'm talking live.

basiclly I want to see timestamp on every single output line.

Basiclly this :

https://unix.stackexchange.com/ques...

But running automaticly for each command ever.

To be fair, same problem exists in PowerShell on windows
https://stackoverflow.com/questions...

And no, I don;'t want to switch to some random halfbaked teminal.

Trying to do something "particular"on linux. Prepare yourself to have 30+ tabs of browsing opened.

BUT ! it's strating to work ! (I'm doint some bizzare SQL stuf to speed up my DataBase deployment in local and be able to get a fresh copy of production in under 30 seconds)

https://imgur.com/a/HJzHYQ8

C# :
Welcome to C#, as it is a very powerfull and typed language you will never have issues with Equals and "==".

Also C# : (image)

Edit : It's actually wrking as expected, but I would';ve guessed that "==" would wotk for basic types

Well well well.
Story time.

Since we are working from home for the past 4 months, I finally decided to install a Microsoft SQL server on my home server. (Mostly was using Azure)

My server is running Windows Server 2012 R2.
Tried installing SQL 2019 : fail, 2016 : Fail, 2012 : Fail. Some obscure message about some DLLs not being at right version. (And a warning that it is no recommended to install SQL server on domain controller, but I know, it is my home setup, not roduction)

“Ok fine, I’ll install it on my PC instead”. Windows 10 PC. NOPE. “Cannot install on a compressed drive”. Welp, wtf ? (Of course you cannot select destination install folder, I could’ve put it on another drive).

So here I am. Working 100% on Windows, installed Ubuntu server 20 LTS in Hyper-V, Installed Microsoft SQL server on it (BTW, install is very easy compared to windows). And that shit is working. And new “Terminal” app does support SSH out of box, no need to add Putty !

So as a Windows user, I needed Linux to make Microsoft SQL techno work.

Nothing will ever surprise me anymore. (BTW it’s fucking fast. I like SQL server on Linux)

Best android APP :

DNS666

/change my mind

FrontEnd developper :

Hello here is the STATIC page you asked. Only takes 300 MB of frameworks to make it work.

Are these people on crack or something ?

Recruiting front end right now… I’m tiered of this BS.
95% of applicants: “hey I don’t understand what you want, but look at my cool, ToDo app in <INSERT ANY framework>”
“Ok, now add a quick search in your todo project”
“Oh wow, it’s like 5 days work lol and should be managed at back end. I Shouldn’t care”.
How HOW these idiots even have a job ?
I’m out of words. I want to scream, pull my own hair and (Weirdly enough) watch a DareDevil movie

Hmmmm,

not sure how to feel there :)

https://twitter.com/shadraza1/...

I find it technically very cool, moraly still not sure. I have terminator PTSD

Not a rant. Just how far technologie came.

on the right:
1 Episode of a new show, 4k hdr etc : 9GB

On the left:
Whole season (26 episodes) of startrek Voyager (DVD quality).

I find this pretty much fun.

Hello.
So we have a query inside our company :
We are developers. We are (At least supposed to) logic.
Do you think We developers can influence environment of the planet?
For my self : Not sure, but I would like to believe that more my code is optimized, less resources it will use.

To all developers working on publicly visible APIs or writing public documentation.
DON’T BE A DICK !
Do not just put a screen capture of your curl request which takes 10 minutes to write by hand.
Do not show me list of arguments as an image.
Have AT LEAST one executable demo project (Any language)
And, it’s 2020, add a fucking proxy generator.
How hard can it be?

Why do I even go back to https://www.theverge.com/ ? Why ?

So, I quote :
"Sandra L., who also requested that I withhold her surname, used Examity for a midterm in her astronomy class at Ocean County College in New Jersey"

How many Sandras in astronomy classes do you think they have at Ocean County College in New Jersey?

"We protect identity of sources"

Me :

I will use .Trim() before ToLower(), so ToLower has potentially less characters to iterate over.

Also me :

What ? Only 5.000 rows ? Let’s load them all ! It’s faster then use “where” and “group by”. No problems !

A usefull function, everyone should have near by. May requires some optimisations.

/// <summary>
/// DoEs tHiS To tHe pRoViDeD StRiNg. StArTs aLwAyS WiTh a cApItAl
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static string DoThIsToThEtExT(string s)
{
var array = s.ToCharArray();
Parallel.For(0, s.Length, (index) =>
{
if (index % 2 == 0)
{
array[index] = array[index].ToString().ToUpper()[0];
}
else
{
array[index] = array[index].ToString().ToLower()[0];
}
});
return new string(array);
}

Can someone rollback the 2020 patch already ? It's buggy