- Postgres – INSERT, UPDATE, DELETE and Upsert
Writing data, including the parts SQL tutorials skip. RETURNING so you do not need a second round trip for the generated id, ON CONFLICT DO UPDATE for a real upsert and the unique index it requires, UPDATE ... FROM and DELETE ... USING for joining in the rows you are changing, COPY for bulk loads, and why a soft delete is a column and not a DELETE.
- Docker Guide
What is docker? Getting Started Download docker and install it on your computer Link to developer guide – https://docs.docker.com/ee/ Select the docker option based on your operation system. In my case, I selected Docker for desktop mac. Then from there should be a link to download the docker…
- Terminate process(PID) command
If you ever run multiple java projects (microservices) on eclipse. Most of the time you want to start them up all at the same time and luckily eclipse has this feature. Unfortunately what Eclipse doesn’t have is a way to stop or kill all of you java projects(processes) all at the same time. This […]
- Postgres – Window Functions
An aggregate collapses rows; a window function keeps them and adds a column. OVER and PARTITION BY, row_number versus rank versus dense_rank and which one you meant, running totals with a frame clause, lag and lead for comparing a row to the one before it, and top-N-per-group — the query that is ugly with a subquery and three lines with a window.
- Negotiating Salary
Few skills will impact your lifetime earnings as a software engineer more than knowing how to negotiate your salary. A single negotiation can mean tens of thousands of dollars per year — and that compounds over your career. Yet most developers accept the first offer they receive, leaving…