Open in app

Sign In

Write

Sign In

Cing Sian Dal
Cing Sian Dal

61 Followers

Home

About

Pinned

Software Engineer Interview Prep

This is a personal note to prepare for Software Engineer position. Algorithm Array Stack Queue LinkedList HashMap Graph Tree Tries Dictionaries Heap Algorithm Analysis: Omicron— upper bound Theta — average bound Omega — lower bound Algorithm: Sorting Searching String manipulation Recursion and Backtracking Dynamic Programming Greedy Algorithm Links: Hacker Rank — Interview Preparation freeCodeCamp — Dynamic Programming

Algorithm Analysis

1 min read

Algorithm Analysis

1 min read


Nov 22, 2021

npm WARN npm npm does not support Node.js on Ubuntu

Normally you have tried: sudo apt remove nodejs sudo apt remove npm sudo apt install nodejs sudo apt install npm It didn’t work. You have also tried: npm install npm@latest -g It prompted the error again. You have also tried: curl https://www.npmjs.com/install.sh | sudo sh It didn’t work. Do this: curl -fsSL https://deb.nodesource.com/setup_lts.x | sudo -E bash - sudo apt-get install -y nodejs It will work.

Ubuntu

1 min read

Ubuntu

1 min read


Nov 12, 2021

Install Oracle Instant Client on Ubuntu

Here are instruction steps to install Oracle instant Client on Ubuntu Create a folder dedicated to Oracle. cd /opt/ sudo mkdir /opt/oracle 2. Download and unzip Oracle Instant Client at opt/oracle . sudo wget https://download.oracle.com/otn_software/linux/instantclient/214000/instantclient-basic-linux.x64-21.4.0.0.0dbru.zip sudo unzip instantclient_21_4 3. Install linux asynchronous I/O library called libaio .

Oracle Database

1 min read

Oracle Database

1 min read


Oct 12, 2021

pm2 start for next start with different port

If you want to run your server-side NextJS with pm2 and different port, run this: pm2 start npx --name "nextjs" -- next -p 3003

Nextjs

1 min read

Nextjs

1 min read


Jun 25, 2021

Notes on Database Systems

The fundamental concepts necessary for designing, using and implementing database systems. It includes the fundamentals of database modeling and design, relational theory and the Structured Query Language (SQL). Status: still writing…(will end on September, no longer working on it) Week 1 Relation: table Relational algebra is a set of operators to manipulate…

Database Systems

4 min read

Notes on Database Systems
Notes on Database Systems
Database Systems

4 min read


Jun 14, 2021

Material UI Data Grid Pagination onPageChange does not work

You only see the first page. Your state loads into the first page. But your new state does not load into Data Grid although the state has been updated. This is because you have to specify an attribute: paginationMode="server" In complete, <DataGrid paginationMode="server" /> You may think that you are…

Material Ui

1 min read

Material Ui

1 min read


Jun 14, 2021

Using Oracle SQL `offset fetch next rows only` for pagination

If you are using Oracle SQL offset :number fetch next :number rows only , you must know that offset does not represent page number. If you are trying to use it as page number, here is formula: offset : ( rowLimitPerPage * pageNumber ) - rowLimitPerPage In tech term, the OFFSET clause specifies the number of rows to skip before starting to return rows from the query. In simple term, the OFFSET clause is the starting point of row number, it is a variable to specific from which row you are going to query up to which row FETCH NEXT .

Oracle Database

1 min read

Using Oracle SQL `offset fetch next rows only` for pagination
Using Oracle SQL `offset fetch next rows only` for pagination
Oracle Database

1 min read


Jun 11, 2021

[Error: ORA-00933: SQL command not properly ended]

Most of this error is due to extra ; in your Oracle SQL statement. Remove ; in your SQL statement.

Oracle Database

1 min read

Oracle Database

1 min read


Jun 6, 2021

NodeJS express response cookie does not set cookie in client.

In your NodeJS, you declare to respond with a cookie in its header: response.cookie("accessToken", accessToken, { expires: new Date(Date.now() + 60_000), // 60 seconds } But the client does not save cookies from its reponse header because you must specify withCredential in your axio configuration: const instance = axios.create({ baseURL: 'http://www.google.com', withCredential: true });

Express

1 min read

Express

1 min read


May 19, 2021

oracle nodejs return empty rows

Check if your rows are already commited in your database. Use the COMMIT statement to end your current transaction and make permanent all changes performed in the transaction. A transaction is a sequence of SQL statements that Oracle Database treats as a single unit. This statement also erases all savepoints in the transaction and releases transaction locks. Until you commit a transaction: You can see any changes you have made during the transaction by querying the modified tables, but other users cannot see the changes. After you commit the transaction, the changes are visible to other users’ statements that execute after the commit.

Oracle Database

1 min read

Oracle Database

1 min read

Cing Sian Dal

Cing Sian Dal

61 Followers

Don’t follow me. I wrote junks here. Follow me on Twitter instead.

Following
  • Netflix Technology Blog

    Netflix Technology Blog

  • Win Htaik Aung @ميرزا البركل

    Win Htaik Aung @ميرزا البركل

  • CS50

    CS50

  • Mitchell Irvin

    Mitchell Irvin

  • Alfian Losari

    Alfian Losari

See all (37)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams