linkjobai / Object-Oriented Design Interview: Parking Lot
0 likes
0 forks
1 files
Last active 1 day ago
Interview prep notes
Object-Oriented Design Interview: Parking Lot
"Design a parking lot" is the most common object-oriented design (OOD) question. The interviewer is checking whether you can turn vague requirements into clean classes and responsibilities, not whether you know a single right answer.
Clarify first
- Multiple floors? Spot sizes (motorcycle, compact, large, EV charging)?
- Entry and exit gates, tickets, payment (hourly rate, flat fee)?
- Should it show free spots per floor on a display board?
gaiety / update_with_from_join.sql
0 likes
0 forks
1 files
Last active 1 year ago
https://neon.com/postgresql/postgresql-tutorial/postgresql-update-join
| 1 | UPDATE table1 |
| 2 | SET table1.c1 = new_value |
| 3 | FROM table2 |
| 4 | WHERE table1.c2 = table2.c2; |
gaiety / Git Alias - Merge latest main
0 likes
0 forks
1 files
Last active 1 year ago
| 1 | [alias] |
| 2 | update = "!update() { git fetch && git merge main --no-edit; }; update" |
gaiety / Simple nginx static site docker compose
0 likes
0 forks
1 files
Last active 1 year ago
| 1 | name: nginx-static-site |
| 2 | services: |
| 3 | client: |
| 4 | image: nginx |
| 5 | ports: |
| 6 | - 80:80 |
| 7 | volumes: |
| 8 | - ./:/usr/share/nginx/html |
gaiety / ecto-migration-search-pg_trgm
0 likes
0 forks
1 files
Last active 1 year ago
| 1 | defmodule MyProject.Repo.Migrations.ItemsSearch do |
| 2 | use Ecto.Migration |
| 3 | |
| 4 | def up do |
| 5 | execute "CREATE EXTENSION IF NOT EXISTS pg_trgm;" |
| 6 | |
| 7 | execute """ |
| 8 | CREATE INDEX items_search_index |
| 9 | ON items |
| 10 | USING gin ((name) gin_trgm_ops); |
Newer
Older