sujeet-agrahari

<!DOCTYPE NETSCAPE-Bookmark-file-1>
<!-- This is an automatically generated file.
     It will be read and overwritten.
     DO NOT EDIT! -->
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<TITLE>Bookmarks</TITLE>
<H1>Bookmarks</H1>
<DL><p>
    <DT><H3 ADD_DATE="1707350400" LAST_MODIFIED="1707350400" PERSONAL_TOOLBAR_FOLDER="true">Tech Resources</H3>
    <DL><p>

sujeet-agrahari

GROKKING NOTES

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.

Pattern: Sliding Window

• https://leetcode.com/problems/maximum-subarray/ # Close enough
• https://leetcode.com/problems/minimum-size-subarray-sum/

sujeet-agrahari

vs Questions

---

1. http://stackoverflow.com/questions/804115 (rebase vs merge).
2. https://www.atlassian.com/git/tutorials/merging-vs-rebasing (rebase vs merge)
3. https://www.atlassian.com/git/tutorials/undoing-changes/ (reset vs checkout vs revert)
4. http://stackoverflow.com/questions/2221658 (HEAD^ vs HEAD~) (See git rev-parse)
5. http://stackoverflow.com/questions/292357 (pull vs fetch)
6. http://stackoverflow.com/questions/39651 (stash vs branch)
7. http://stackoverflow.com/questions/8358035 (reset vs checkout vs revert)

sujeet-agrahari

-- turn off paging (less/more)
psql> \pset pager off

/*
Pager usage is off.
*/

-- find an object name by id

SELECT OID, relname

sujeet-agrahari

WITH table_scans as (
    SELECT relid,
        tables.idx_scan + tables.seq_scan as all_scans,
        ( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
                pg_relation_size(relid) as table_size
        FROM pg_stat_user_tables as tables
),
all_writes as (
    SELECT sum(writes) as total_writes
    FROM table_scans

sujeet-agrahari

--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

------------
-- Basics --
------------

-- Get indexes of tables

sujeet-agrahari

echo-server-epoll
echo-server-poll
talk
talk.dSYM

sujeet-agrahari

reosurces: https://www.jsv9000.app/
http://latentflip.com/loupe/

Work as a browser engineer who is expert in creating web browsers. Who is also expert in javascript.  Validate and correct below statement and also answer the question:
There are three main components on browser side javascript runtime i.e. v8, web apis, and a event loop that watches on the callback queues and executes it. 
question1 : How many type of callback queues are there in this case? What are their priority and what type of tasks they hold?
question2: If there is an express ` a = a +1` does it go to event loop or executed on v8 right away?
ChatGPT
The statement you provided is mostly accurate. However, it's important to clarify a few points.

sujeet-agrahari

// MongoDB Playground
// Use Ctrl+Space inside a snippet or a string literal to trigger completions.

const database = 'ecommerce';

// The current database to use.
use(database);

// Create a new collection.
// db.createCollection(collection);

sujeet-agrahari

GET players/_search
{
  "track_total_hits": true
}

GET players/_search
{
  "query": {
    "range": {
      "@timestamp": {