[Book “Learn PostgreSQL”] I finished the chapter about postgres functions. I feel the syntax is quite cumbersome and I can’t find a good use-case for them now. I imagine they will come handy when combined with triggers or cron jobs. I am looking forward to next chapter about triggers.
[GADM-api] I refined how pagination parameters are parsed and standardized how headers are being set for /geojson
and /feature-collection
endpoints. I started working on endpoints for level 1 but before I can complete it I need to refine the way json properties are being generated in sql queries.
[Books backlog] The backlog of things I want to read is getting longer and longer. I stumbled upon several interesting books and I need to decide which one to pick up next. I am thinking about “Refactoring”, “Code Complete”, “The Staff Engineer’s Path” and “The Software Engineer’s Guidebook”. First two are kind of old and have mixed reviews – from being considered a “must read” or a “bible” to being “verbose” and “outdated”. I am a bit hesitant to pick up another 800 pages book. Perhaps I will go with one or both latter ones. A book about engineering career might be more refreshing .
This year I already read two books that looked on engineering from the perspective of a startup or organization (Lean Startup and Accelerate). It might be interesting to read something less technical after I finish the 7OO page Postgres book I am reading now.
[App Idea – “I-Queue” ] A chat app that let’s you talks with people waiting in the same queue as you do. Imagine a festival or hyped food track. Chat messages are being deleted after the queue is gone. Users are being matched by GPS location. Perhaps there is a limit on total number of messages in one queue – old messages are removed to save space (FIFO)
[App Idea – “Food Track QR”] Another food track idea – a ticket ordering system that leverages QR codes. Instead waiting for your order and listening when your number is being shouted by a cashier, you receive QR code together with your receipt. QR code is a link to a website that listens to status update on your order. When you order is ready cashier changes it’s status in the system and you receive a notification that your order is ready for pick up.