I liked the way Grokking the coding interview organized problems into learnable patterns. However, the course is expensive and the majority of the time the problems are copy-pasted from leetcode. As the explanations on leetcode are usually just as good, the course really boils down to being a glorified curated list of leetcode problems.
So below I made a list of leetcode problems that are as close to grokking problems as possible.
| -- turn off paging (less/more) | |
| psql> \pset pager off | |
| /* | |
| Pager usage is off. | |
| */ | |
| -- find an object name by id | |
| SELECT OID, relname |
A non-exhaustive list of WebGL and WebGPU frameworks and libraries. It is mostly for learning purposes as some of the libraries listed are wip/outdated/not maintained anymore.
| Name | Stars | Last Commit | Description |
|---|---|---|---|
| three.js | 
Benchmarking. We take two competing pieces of code - could be as simpler as a one liner or as complex as an entire web framework. Then, we put them up against each other (iterations per second). At the end of the task, we come up with a single metric, a score. We use the score to compare the two competing options.
In Ruby, the Benchmark module provides methods to measure and report the time used to execute Ruby code. http://ruby-doc.org/stdlib-2.0.0/libdoc/benchmark/rdoc/Benchmark.html
Profiling. Profiling your program is a way to determining which methods are called and how long each method take to complete.
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
| ========================================================================================================== | |
| MySQL Guide - Basics | |
| ========================================================================================================== | |
| Connect/Disconnect from MySQL Server | |
| ---------------------------------------------------------------------------------------------------------- | |
| :~ sudo mysqld_safe //Turns on MySQL server | |
| :~ mysql -h host -u root -p //Connects to MySQL server: "no need to specify host on local" | |
| mysql> quit; //Disconnects from MySQL | |
| :~ mysqladmin -u root -p shutdown //Shuts down MySQL server | |
| ---------------------------------------------------------------------------------------------------------- |
Inspired by this article. Neat tricks for speeding up integer computations.
Note: cin.sync_with_stdio(false); disables synchronous IO and gives you a performance boost.
If used, you should only use cin for reading input
(don't use both cin and scanf when sync is disabled, for example)
or you will get unexpected results.
x = x << 1; // x = x * 2
