n0tme

Free Software is not about price.

I would say not. For example, I have been doing oracle database administration work for many years. Even though I'm also good with a lot of other technologies, like Linux, programming in many languages, other databases. But no one will consider me for jobs other than oracle DBA/developer for the salary I know have. So it is kind of a trap. And it is super hard to accept a junior job offer when you are approaching forties.

Hey. I am 37 and a week ago started to learn to touch type the proper way. It's not a problem for me to touch type, but I did it with like 4-5 fingers and Never could get past 80 wpm. Now I started to learn the 10 fingers method and I feel like I miss almost every stroke. So frustrating

It's funny how the author only concerned about YOUNG programmers worrying.

Am I the only person in the world who just can't stand fixed headers, be it a table header or a website top menu?

I am talking about INDEX FAST FULL SCAN (Oracle) for example. If you do 'select distinct last_name from users;' and you have an index on users (last_name) you do not need to read the table at all. It is enough to read the index.

Otherwise it does not matter how many columns you select, because you will have to read all the columns for every row anyway.

It's not about choosing the right index. The point here is that the database can only read the index (without going into the table) if all the columns you need and use in where clause are in the index. Usually index segments are smaller, so it could be faster. I am talking from the Oracle perspective, but I believe PostgreSQL would work in a similar way.

We go to bars and drink with strangers.

How do you know that it's 80% though, if there's no final state?

- Can you duck it for me? - Go duck yourself!

Read the comments to the article on medium.

Hey, guys, thanks for answers. Didn't think anyone would even notice my comment! I really like the idea of helping the community even for free. The problem here is I have no idea how to start. For me to dig deeper (and I am working with Oracle on a daily basis) the problem has to occure and be repetable, so how can I get into fixing problems if I am not even using PG? I could, probably, install it on my PC/notebook, but it won't be a production use, so I probably won't face any problems.. It's always been a puzzle for me: how do people start with open source projects.

I am 35 and I am lonely and it's not getting any better + my job is getting boring (DBA), since I am pretty familiar with everything, and there's no chance for me to switch to programming, even though I know JS and many other languages, but my resume says: 10+ years DBA.

Wow. This is some perfect alignment.

Of course they can't, they don't speak.

So many gotos..

I hate the fact that I stuck in Russia. It seems that the upcoming 6 years are gonna be tough.

Bottom line: I am so fucked

Can't talk about MySQL or PostgreSQL, but with Oracle I am pretty sure you can get very much close to this result with cached data. And this is without using the in-memory option. However, talking about it withouth any experiments to prove a point is just speculation. Memory vs Disks changes a lot performance-wise.

If all this data just fits in memory then what is surprising about the speed?

Did they use these historical artifacts for a photo shoot in the sand?

Location: Moscow, Russia

Remote: Yes

Willing to relocate: Very much so

Technologies: Oracle, MySQL, PostgreSQL, SQL, PL/SQL, Linux, Shell, Python, JavaScript, PHP

Résumé/CV: upon request

Email: mutant59@protonmail.com

Huge experience with Oracle databases (10+ years), can solve almost any problem, answer any question (with tests, examples and everything) related to them, can write effective SQL queries, do performance tuning. This experience could be applied to any other RDBMS, not just Oracle.

Besides databases I do some JavaScript (mostly graphs, simple UIs) and PHP programming, would love to switch to working with web-technologies full time one day.

Very good with Linux/Unix and shell.

I have kind of the same experience being a database administrator. In so many cases programmers have no clue what is actually happening behind their queries. The worst thing is that they think they know or just don't pay attention! :D

I think that removing this chat box from the website completely will greatly improve it and solve this problem. Just have a page with a feedback form somewhere, so people who realy want to leave a feedback or a question could contact you. Stop annoying your users and random visitors!

I doubt it will last more than one winter due to weather conditions.

You know what hostile design is? It's the design of sites like hackernoon and others built with its engine. 40% of vertical space is consumed by useless menus. I usually remove them using "inspect element" feature of chrome or Firefox. So I could read articles with comfort. I am not mentioning useless social networks menu, since they are taking horizonal space, but sometime I remove then also.

I also feel like I made some wrong turns in my life and turn in the right direction is almost impossible now: career- and, what is the saddest part, family-wise. It just feels like it's too late for everything to get back on track. Damn. I'll be 35 in a couple of months :(

As much as I hate Russian government, I can't believe the mh17 was shot on purpose. It was probably a mistake. Probably some people were in power where they should never be. Unfortunately, it looks like the next 6 years there wouldn't be any significant change in Russian government.

Let us know of the visitors spike you'll get after this plug.

It makes me so freaking sad to see it like this.