Andre Alves Leocadio Hiweus

Fetch the last messages in each group by the attribute name

SELECT m1.*
FROM messages m1 LEFT JOIN messages m2
 ON (m1.name = m2.name AND m1.id < m2.id)
WHERE m2.id IS NULL;

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

Activate windows

Reference

Keys

Pro: W269N-WFGWX-YVC9B-4J6C9-T83GX
Pro N: MH37W-N47XK-V7XM9-C7227-GCQG9
Home: TX9XD-98N7V-6WMQ6-BX7FG-H8Q99
Home N: 3KHY7-WNT83-DGQKR-F7HPR-844BM

People

`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`
😚 `:kissing_closed_eyes:`	😳 `:flushed:`	😌 `:relieved:`
😆 `:satisfied:`	😁 `:grin:`	😉 `:wink:`
😜 `:stuck_out_tongue_winking_eye:`	😝 `:stuck_out_tongue_closed_eyes:`	😀 `:grinning:`
😗 `:kissing:`	😙 `:kissing_smiling_eyes:`	😛 `:stuck_out_tongue:`

Autocomplete

bash shell generally handle autocomplete using a specific function, example:

My function

function aa() {
  echo "$@";
 }

	/*
	* the first implementation is simpler but not much smart because, if a pattern long than value is passed
	* to function all remaining pattern will be write to outputValue and not crop immediately
	* for all purposes use second function, the first one is only a option more compact for understanding
	*/
	function makeString(value, pattern) {
	let position = 0
	return pattern.replace(/#/g, () => {
	if(position >= value.length) {
	return ''

	import { useState } from 'react'
	import { Button, Spinner } from 'react-bootstrap'

	function AsyncButton({ onClick, children, externalLoading = false, ...props }) {
	const [internalLoading, setInternalLoading] = useState(false)

	const handleClick = async () => {
	setInternalLoading(true)
	await onClick?.()
	setInternalLoading(false)

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Document</title>
	<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/leaflet.css"
	integrity="sha256-p4NxAoJBhIIN+hmNHrzRCf9tD/miZyoHS5obTRR9BMY="
	crossorigin=""/>
	<script src="https://unpkg.com/[email protected]/dist/leaflet.js"

	.card {
	background: red;
	color: white;
	font-weight: 500;
	display: flex;
	justify-content: space-between;
	align-items: center;
	width: 900px;
	}

	FROM busybox

	WORKDIR /app

	# Copy React build files
	COPY dist/ /app

	# Set up the httpd configuration
	# Http request will result in 404
	# But the response content will be the site, so will render anyway