That would indicate that TNBDE is in fact still working properly. There's discussion a lot of the time about wether it's stopped collecting messages at one point or something like that.
@Pavel It was broken for a couple months at one point, IIRC. A server migration broke my old code, so I reworked it a bit to gather more data, which lead to encountering significant rate limits from SE, so I had to work around those and then collect all the data.
Traceback (most recent call last):
File "views.py", line 121, in _runcode
cur.execute(querystring)
psycopg2.DatabaseError: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
CMC: output the smallest bounding box that your code fits in, for example if your code was ab\nbcd\n\nf the box is 4 rows × 3 cols, so you have to output a 4×3 box, the border should consist of a different character than the inside of the box, your score is the area of the box
Polyglot in a box
polyglot code-challenge
Output the smallest bounding rectangle that fits around your code, with the border being of a different character than the inside.
For example, if your code is
ab
c d
e
then the smallest bounding box is 6x6 since the code fits right in
######
#ab...
hm, I've been thinking for some time that the Questions without an objective primary winning criterion are off-topic, as they make it impossible to indisputably decide which entry should win. off-topic reason should be replaced with just "unclear what you're asking"
@ngn popularity contests do have an objective winning criterion, although are often closed because of other ambiguities, and most often closed as "too broad" unless they are narrow enough
Inspired by The Great API Easter Egg Hunt!
Summary
Your task is to search for a predetermined integer in the "Collatz space" (to be explained later) using the fewest step possible.
Introduction
This challenge is based on the famous Collatz conjecture that hopefully everyone here at least hear...
I like two things myself:
programming
puzzles and quizes
But in particular I don't like code golf. (Oneliners in bizarre languages that look like Łą$ę%ó^ł&ć*ż[ź...)
So, to fix this thing I decided to develop my own programming puzzle!
The general aim is to write a code to reconstruct some p...
World Cup Sticker Album simulation
As the World Cup is due to kick off (pun intended), the inevitable sticker book comes along as well.
According to this BBC article , at a cost of £0.80 for a pack of 5 and with a total of 682 stickers needed to complete the book it could cost up to £700 or mor...
Left Turn at Eqreuqebla
Write a quine, according to the standard definition of a quine, that outputs itself when executed. However, when your code is reversed it should output each character of your source code separated by a newline instead.
Example
If your program was:
ABCDEFGHIJKLMNOP
...
SELECT U.latest_name, count(MSG.user_id) as Count
FROM "transcriptAnalyzer_message" MSG
INNER JOIN "transcriptAnalyzer_user" U on MSG.user_id = U.id
GROUP BY U.latest_name, MSG.user_id
ORDER BY Count DESC
there you go
of course it's slow as shit because of the INNER JOIN
@quartata I still have no idea how to alias table names. I'm not even sure it's possible. I think I looked it up at some point and didn't find anything useful. Would probably have to do a find-replace on the query and I would rather not do that.
@MagicOctopusUrn I was hired at Agora Games, now WB Games New York, December of 2016. WB Games in general certainly has a bunch of job openings. There's a few at WBNY specifically, though they're mostly for senior software engineers.
@totallyhuman if curiosity killed the cat, and a killed cat causes curiosity, doesn't that make the curiosity infinitely dangerous to all who observe it?
@DJMcMayhem I don't think I ever knew what they were looking for for sure. Having worked here for a bit though, I'd say prior work experience is the most influential, followed by experience with the technologies we use. That is, of course, if you don't submit a stupid offer (like "Hey, I want to work there. What do I do?" or whatever).
@El'endiaStarman Do they ever have open positions for people who love AI and have a "subjective minor" in it? AKA I took 10 classes but didn't get a legit one
@DJMcMayhem Languages: Python, TypeScript, Java, C++. Databases: Mongo, ElasticSearch, and a bit of Redis and SQLite3. Other techs: Git, Salt, Ruby/Rails.
@MagicOctopusUrn Server-side code. Our clients want to run custom code with the data we store and provide on the server instead of the device (console/mobile). I think it and Node (forgot to mention that one) was chosen largely because of the relative ease of sandboxing code. Not that our clients would write malicious code, but everyone writes bugs.
My now-boss was actually skeptical that I could do good work when we chatted on the phone (phone screen). He gave me the option of waiting six months and then reaching out again or taking a code test. He cautioned me that it's rare that the code test changes their mind, but it does happen. I chose to take the code test.
I had four or five days to write up pseudocode and such for how one would, essentially, make a product like our flagship product (Hydra Studio). Just simple stuff, nothing overly complex. I took the code I wrote for TNBDE and the Spacewar! King of the Hill on PPCG, smushed 'em together, and delivered a working product with playable game and query execution in six days.
@EriktheOutgolfer Yep. I got the interview as a result.
Interview went really well and I got an offer a few hours later.
@EriktheOutgolfer Probably a surprisingly high number, I'd bet.
Incidentally, I was working as a janitor at a grocery store for a couple months before that. My company cares more about what you can do than your credentials, I'd say. (Though the latter is somewhat correlated with the former.)
For instance joins may be confusing but they don't just make clear the relation, they drill into your head the work the DB is doing and most importanrly why it might be slow
@EriktheOutgolfer And the address is wrong too; that's the old office.
I think the website has been left to age because Agora Games used to sell (the use of) Hydra Studio to other game studios, effectively. WB bought them in 2016 and now our clients are other WB game studios, so there's no need for a public website.
@Downgoat My semi-boss (technical director) actually has said that the strength of Mongo is its sharding and he's had ideas of taking Mongo's sharding and combining it with another relational database engine for e.g. transactions and stuff.
Polyglot in a box
polyglot code-challenge
Output the smallest bounding rectangle that fits around your code, with the border being of a different character than the inside.
For example, if your code is
ab
c d
e
then the smallest bounding box is 6x6 since the code fits right in
######
#ab...
I like two things myself:
programming
puzzles and quizes
But in particular I don't like code golf. (Oneliners in bizarre languages that look like Łą$ę%ó^ł&ć*ż[ź...)
So, to fix this thing I decided to develop my own programming puzzle!
The general aim is to write a code to reconstruct some p...
World Cup Sticker Album simulation
As the World Cup is due to kick off (pun intended), the inevitable sticker book comes along as well.
According to this BBC article , at a cost of £0.80 for a pack of 5 and with a total of 682 stickers needed to complete the book it could cost up to £700 or mor...
Left Turn at Eqreuqebla
Write a quine, according to the standard definition of a quine, that outputs itself when executed. However, when your code is reversed it should output each character of your source code separated by a newline instead.
Example
If your program was:
ABCDEFGHIJKLMNOP
...
