suryapandian

Software Engineer: Cracking the coding interview for a product company

1. Create a github account in https://github.com/

2. Learn basic of git https://www.atlassian.com/git

   At the end of this course, you should be able to

a) create repository

suryapandian

For friends looking for jobs in India. Qube is a company that I worked for and had a great experience.

https://www.linkedin.com/company/qube-cinema-media-technologies-pvt-ltd/jobs/

Their questions for SE is open, or atleast it will be similar to these

• https://github.com/RealImage/challenge2015
• https://github.com/RealImage/challenge2016

suryapandian

How to see yourself as you really are?

1. misapprehension: a mistaken belief about or interpretation of something
2. imperial: relating to an empire or superior
3. affliction: a cause of persistent pain or distress.
4. tacit: understood without being openly expressed; implied
5. myriad: a countless or extremely great number of people or things.
6. pernicious: highly injurious or destructive
7. imbue: to spread through or influence deeply as if by dyeing

suryapandian

Two for:

Well done! We can avoid code repetition by assigning the value "you" to name in the if block and then returning after the if block. Short and simple code is more readable. Find the minimal condition to make the code DRY (Don't Repeat Yourself).

Difference:

The solution looks clean. However, instead of looping through the numbers, we could use existing mathematical formulas to compute square of sum and sum of squares for a given number n. Please try implementing this using the formulas.

suryapandian

Keybase proof

I hereby claim:

• I am suryapandian on github.
• I am suryapandian (https://keybase.io/suryapandian) on keybase.
• I have a public key ASBZR1zhsSl2dNitTX6lhX8y6pYdfqIPyknFITOMCNrOuAo

To claim this, I am signing this object:

suryapandian

--  get list queries and their running time
SELECT pid,query, age(clock_timestamp(), query_start), usename 
FROM pg_stat_activity
WHERE datname = 'database_name' 
ORDER BY query_start desc;

-- get rough count of records in table without actually running the count(*) query 
-- thanks to: https://www.cybertec-postgresql.com/en/postgresql-count-made-fast/

SELECT reltuples::bigint

suryapandian

Rust coding test

The motivation behind the coding test is the measurement of the qualification and testing the learning attitude of the candidate.

Task

Create a pseudorandom number generator based on Linear Congruential Generator algorithm. Pick one and use any of the following languages, and please do NOT use any library you can find on the internet.

• C
• C++

suryapandian

(This is a translation of the original article in Japanese by moratorium08.)

(UPDATE (22/3/2019): Added some corrections provided by the original author.)

Writing your own OS to run on a handmade CPU is a pretty ambitious project, but I've managed to get it working pretty well so I'm going to write some notes about how I did it.

suryapandian

1. Change your database RDS instance security group to allow your machine to access it.
   • Add your ip to the security group to acces the instance via Postgres.
2. Make a copy of the database using pg_dump
   • $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
   • you will be asked for postgressql password.
   • a dump file(.sql) will be created
3. Restore that dump file to your local database.
   • but you might need to drop the database and create it first
   • $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>

• the database is restored