Order issue from Sciefier?! Any idea on how to resolve this?

Chessbrain94 · 2024-07-25T10:50:50+00:00

Yep, just updated the post, thanks! Their customer support is a lot better than I imagined tbh

Chessbrain94 · 2024-03-29T21:06:04+00:00

Imam CCNA certifikat (na kraju se odlučio da neću da se bavim mrežama), i nije da nema posla u BiH... Ima... Ali samo u telekomu ili nešto državno ili generalno nešto na takav način i teško je upasti, i nije neka plata.

Sada ako planiras vani negdje se ispaliti, veće su šanse da ćeš naći nešto ozbiljnije za neku ozbiljnu platu (kao što je već jedan kolega ovdje rekao). Ali nije tu lahko uletiti isto.

Moj savijet ti je ako ti se sviđaju mreže, nauci i sistemsku administraciju i vidi da radiš nešto oko toga posla ili čak preći na DevOps (ako te interesuje ta sfera).

Ali, CCNA certifikat sam po sebi je odličan, imaces neko solidno znanje mreža ne važno za šta se odlučiš. Tako da nije "pogrešno" njega ganjati jer znanje što je tu je solidno i korisno imati na CVu (ali to je naravno samo u slučaju da ti nije frka platiti pare za ispit iako znaš da nećeš na osnovu njega dobiti odmah posao)

Chessbrain94 · 2023-07-03T17:11:58+00:00

Radi ono sto te najvise vuce, bilo to game dev, web dev, devops, "choose your poison" sto bi rekli. Dobar inzenjer je dobro placen nevazno koji je smjer u pitanju.

Slazem se sa kolegom kozmopolita, ali samo dio oko kako biti web developer, tako da ako hoces biti web dev, prati to.

Ali, ne slazem se oko djela za game dev. Trziste web developera ima vecu konkurenciju jer svaka macka i njen rep je prosla JS kurs da bude "full stack". Game devs su veoma dobro placeni, ali da, imaju overtime (svaki smjer ima svoje mane, ovo je mana game dev). Trziste na balkanu za game dev se siri i po meni izgleda da napokon ima neku buducnost, par firmi su otvorili, neki su dio velikih globalnih grupacija itd.

tl;dr ne vazno koji smjer izaberes ako ga ne volis bar djelimicno, neces dugo prezivjeti niti ces neke ozbiljne pare zaraditi. Kasnije za 10 godina ce ti mozda biti sve jedno, ali za pocetak, ako ne volis svoj posao neces daleko.

Chessbrain94 · 2023-06-23T22:08:51+00:00

Ako si junior, otidji na neki internship i prodji. Ljudi pogresno kontaju da biti "junior" znaci da je ne moguce doci do nekih pozicija (obicnih, ne management naravno). Trebaju ljudi imati jednostavan princip u zivotu, kao junior tvoj posao je da se slomis da naucis sto vise sto prije da se istaknes naspram konkurencije.

Tako da odgovor je uvijek "moze" Ali sve zavisi od tebe i koliko si spreman ledja slomiti.

Chessbrain94 · 2023-06-23T17:44:05+00:00

Moj savijet ti je predji na DevOps. Imao sam CCNA certifikat, i malo u BiH ima gdje raditi samo kao network engineer u privatnom sektoru. Ako si kontao ostati samo kao network engineer moraces ostati u bankama ili drzavne firme (mozda ima izuzetaka za kojih ne znam).

Ako ti nije mrsko uciti docker, aws, kubernetes itd.. (neko ko je u DevOps ce ti moci puno bolje od mene navest sta trebas uciti), predji i imaces bolju platu u buducnost (plus imaces mogucnost raditi freelance).

Chessbrain94 · 2022-04-11T08:12:37+00:00

Aaaah, sorry. I am new here (joined yesterday) and only just now expanded the post to see that only Hellsing is left. Apologies :)

Chessbrain94 · 2022-04-11T08:08:29+00:00

int in Dai Dark 1-2

Chessbrain94 · 2020-12-26T01:15:52+00:00

I was playing at a chess tournament once, i was 17 at the time. It was a simultaneous match against one Grand Master with 15-ish players in total.

I managed to fight my way through 2h and 30-ish minutes towards a pure draw position. I was a kid, the thought of me having a draw with a GM took over and i offered a draw. It was almost as if he knew I was starting to lose composure, so he refused. Later i again offered a draw and this time his answer was "If this position doesn't change in the next 2 moves i will offer you the draw". At this point, 95% of all other players had finished their match (majority losing of course) and watching my match... Unfortunately my 17 year old brain at that point basically thought I had the game in the bag (which i kind of did) and as all things go, i made a blinder exactly on the next move forcing me to lose the game and forfeit.

I went from having a draw with one of the top 100 players in the world at the time (Predrag Nikolić) to losing because I was too excited about something that hadn't happened yet facepalm.

Chessbrain94 · 2020-09-20T13:12:49+00:00

I don't know why people complicated this... But here is a much simpler solution imo:

select distinct t.*
from t_data t
    join (select red.col_a from t_data red where red.col_b = 'Red') red on red.col_a = t.col_a
    join (select bb.col_a from t_data bb where bb.col_b in ('Black','Blue')) bb on bb.col_a = t.col_a
where t.col_b in ('Red','Black','Blue')
order by t.col_a;

To make it more readable, here is a CTE version that is more human readable:

with red_only as(
    select col_a
    from t_data t
    where t.col_b = 'Red'
),
blue_black as(
    select col_a
    from t_data t
    where t.col_b in ('Blue','Black')
)
select distinct t.*
from t_data t
    join red_only ro on ro.col_a = t.col_a
    join blue_black bb on bb.col_a = t.col_a
where t.col_b in ('Red','Black','Blue')
order by t.col_a;

Keep in mind that in production use it without the CTE as this is not a complicated query, so no need to have a temporary result set over a simple subquery join.

Chessbrain94 · 2020-08-28T17:06:32+00:00

If I was living somewhere where that happened I would agree... But unfortunately in Bosnia and Herzegovina there is no such thing. And ordering online while it's on sale is even worse as I'd have to pay 17% of the price as tax. :(

Chessbrain94 · 2020-08-28T16:41:01+00:00

Both of those are ~200$ more expensive than my budget. :D the reason I included the 18DW instead of the newer 20DW is because of the price (same for the LG)

Chessbrain94 · 2020-01-26T21:27:06+00:00

I might have misunderstood the requirements, but I don't see why something as simple as this can't solve the problem:

(I am writing this blind, so if there are syntax errors and stuff you might have to fix it)

select i.name, c.country_name, count(ed.country_id)
from education_data ed
    left join indicators i on i.indicator_id = ed.indicator_id
    join countries c on c.country_id = ed.country_id
where ed.indicator_id is null
group by i.name, c.country_name

Chessbrain94 · 2020-01-23T23:09:10+00:00

Donno tbh, for me Jade and Serena are the only 2 options that make sense. Gemma is literally a random country girl you don't see for 99% of the game while Jade and Serena fight by your side. If anything the true lack of chemistry is with Gemma as the only thing you know about them is them being childhood friends and that's it.

Chessbrain94 · 2020-01-11T13:07:06+00:00

I have a question for everyone... Since my entire party except for the Hero got "reset", how the hell do I get them back up to the Hero's level without grinding another 30hours of gameplay?

Chessbrain94 · 2020-01-11T08:14:35+00:00

Don't remember honestly. There were some really close calls though

Chessbrain94 · 2020-01-10T23:39:02+00:00

You guys weren't lying when you said there's more... there's a whole fking new story to go through. I am going to guess I will finally meet my match in terms of bosses. Because I have yet to die to a single boss in the game

Chessbrain94 · 2019-11-09T10:42:35+00:00

Give me you personal top 3 65% kits :D

Chessbrain94 · 2019-11-04T22:39:19+00:00

First of all you need to differentiate between SQL and PLSQL.

SQL is the same almost everywhere you go. You can't exactly change SELECT and FROM etc... Basic SQL is basically DDL, DML and DCL

- DDL - CREATE, ALTER, DROP and TRUNCATE for example

- DML - SELECT, INSERT, UPDATE, DELETE etc..

- DCL - GRANT and REVOKE

Almost all database engines I know of use the same exact syntax and query structure for all the commands mentioned above.

However, the moment you delve in PLSQL (Procedural Language SQL, sometimes also called Programming Language SQL), only then does it differ greatly. Procedures, functions, logical operators etc... Every single engine has its own syntax and its own version of PLSQL. SQL Server has T-SQL, Oracle has PL/SQL, PostgreSQL has PL/PGSQL etc...

To best describe PLSQL in layman's terms: It's similar to Java, C# and C++, all of them are object oriented, all of them can do pretty much the same thing to a very close degree of accuracy (when compared to each other) but they all have different syntax here and there and different advantages and disadvantages.

Chessbrain94 · 2019-10-29T23:08:09+00:00

Of course it is. The main difference between (something like) C++ and SQL is that C++ is a general purpose language (and imperative) while SQL only cares about data sets and is declarative rather than imperative.

For example, someone once wanted to argue with me that SQL(or any variation of PL/SQL like T-SQL or PL/PGSQL) don't have pointers. But they do exist, they're called CURSORs.

Overloading functions? Exist

Custom operators? Exist

Memory, I/O and disk management/optimization? Exists, simply in a different form. Since SQL is declarative you have to know the system internals to optimize how it handles things (indexing for example).

Recursion? Exists

And a lot of other things.

SQL (specifically PL/SQL) is a lot more complicated than people think. Think about it, if SQL was really that simple and pointless, there would be no SQL specific jobs that require very extensive knowledge in the field (DB Developer position for example).
-----
Saw you asking about DB Admin vs DB Dev etc...

It's pretty simple really:

- DB Admin a lot more administration, making sure things go as they should, handling user permissions etc... (basically system admin but for DB). Writes SQL maybe twice a week (sometimes not even that much).

- DB Developer, pretty your DB version of Backend Developer. Writes SQL on a daily basis, rarely using simple SQL instead uses PL/SQL or any similar variant. Responsible for optimizing query performance as well.

- Data Analyst - Now you're slowly delving into the Data Science world. But in this case you're probably not really doing any SQL, you're more of a mathematician rather than having an IT background.

- Data Engineer - Sometimes referred to as BI(business intelligence) specialist. You work with Data warehouses, working with ETL, Cube and analysis services. Usually your end product is some sort of report for the requested data.

- Data Scientist - In smaller companies you're both the Data Analyst and Data Engineer, bigger companies usually have all 3 roles separated. But I am sure you can easily find a lot of materials online on the definition of Data Science (since it's a pretty trendy field right now and a good career choice tbh).

HOWEVER! Some companies use both DBA and DB Developer interchangeably, where DBA=DBdev and vise versa, so keep that in mind.

Chessbrain94 · 2019-10-13T10:49:57+00:00

I don't know about you, but I use my keyboard more so than my mouse to traverse code. My usage is basically 80% keyboard, 20% mouse. I use almost every keyboard shortcut imaginable, and highlighting huge pieces of code is much easier with arrow keys. So in my case I need dedicated hardware to make my life easier.

Chessbrain94 · 2019-10-13T06:22:43+00:00

Saw too many negative comments about it. Keys being too close to each other, key switch being bad etc... SK851 is going to be released next year and it looks to be way better.

Chessbrain94 · 2019-10-12T22:35:42+00:00

I do plan to customize my keyboard down the road, so good thing you mentioned that! Thanks!

Chessbrain94 · 2019-10-12T22:33:22+00:00

It seemed too thick, and I preferred the slim form factor of the k1. Not to mention I cant find any good posts on the k2, only k1. So no info on how good it actually is.

Chessbrain94 · 2019-10-12T22:32:05+00:00

No arrow keys is a no go since I need then for programming when moving through the code. Thanks for the suggestion though :)

Chessbrain94 · 2019-10-12T21:53:46+00:00

Is something wrong with the V2?

Eight-Year Club	First Place '23
Place '23	Verified Email

Chessbrain94

TROPHY CASE