i was listening to steve job’s speech he gave may be 40 years ago from now at a design conference, and he talks about google street maps in 1983. i was surprised. i use street view almost all the time whenever i open google maps, my jaw dropped when he described about the details of it, like the arrows to move through the streets and stuff.
https://youtu.be/t9HmOz8H0qI?si=Kx4kzStfp48xMmqX&t=814
i’ve been reading his biography written by walter isaacson.
purpose built databases
| RDBMS | NoSQL | search | graph | Data warehouse or MPP |
|---|---|---|---|---|
| oracle | mongoDB | elastic search | neo4j | snowflake |
| mysql | cassandra | solr | databricks | |
| ms sql server | teradata | |||
| sybase | gcp bigquery | |||
| postgres | aws redshift | |||
| synapse | ||||
| ^ mpp means massive parallel processing |
![[Pasted image 20260608142419.png]]
RDBMS are used for transactional problems
![[Pasted image 20260608142943.png]]
python glob module
update on the pomodoro app
coding, learning, reading, or writing. user should also be able to create their own session#python-project-1 in coding session, or #Fundamentals of Data Engineering in reading session.fruits = ['apple', 'banana']
fruits.append("orange")
print(fruits)
working on building a simple cli pomodoro app.
adding a new page to my site where i will publish documentation styled ‘how-to’ kind of tutorials.
and this will be completely raw, from my best knowledge, experience and research.
i will keep it as simple as i could with very much detail. and each of these how-to’s will be very long to work on, the first project will be linux, i will be explaining it from scratch, like the background of it, to how to set it up and use it.
done with the exams for a week may be. yeah i got one last exam but we still aren’t given a date yet, it’s supposed be to on the 28th but it’s been post poned without a date.
anyways i tried finding some audio dsp but i couldnt find one, it seems that windows and mac os don’t really like get anyone into the kernel level modifications. i miss linux, it can be flexible, let’s you do anything you want to. kernel level mods are just everyday activities on it.
been stuck in prepping for the exams lately. but i surely got some plans this week.
i want to create my self an app that runs on mac os, built with python and sql. the purpose is to keep track of daily youtube content consumption and visualize the distribution of type of content, number of creators, etc. the user has to put the youtube video’s link, the app has to fetch the youtube video’s thumbnail and duration and ask the user to give a tag to that video for example, education, or work etc. this app has to create an accountability and a sense of awareness of what information the user is feeding their brains. i might have not able clearly explained the entire thing but
nothing much, just exam prep for today
while setting up postgres on my computer, i learned that postgres/psql in the terminal does not behave like bash at all, it becomes a SQL editor, now you might laugh at this but… yeah just a new discovery for me. psql expects a ; at the end of the statement, if that is not put, it will keep listening for the statements, i think this is designed like this because… it needs indentation, which doesnt work in terminal. now i might be wrong so i asked gpt
You’re close, but the reason is slightly different.
The primary reason is not indentation. Terminals absolutely support multiline input.
The actual reason is: SQL statements are free-form and can span multiple lines, so PostgreSQL needs an explicit terminator to know when the statement ends.
So correction:
“psql keeps listening without `;` because SQL statements require an explicit terminator, not because terminals can’t handle indentation.”
i also did some tinkering around postgres
like \l lists the databases, \dt lists the tables \p for something related to buffer, \q for quitting.
after all this i began studying for the exams…
alright that’s it for the day, umm good start of a day but it went down by the evening after a nap lol… but hopelly its gonna improve, i will try to fix my focus.
09:50 Setup postgres for fcc @work 5m
09:57 FCC RDB : working with relational databases @work 60m
11:31 Banking Chapter 1 & 2 @study 180m
nothing new today, just prepping up for the next exam. and also kind of worried about falling behind on some things. let’s see.
first exam of the last semester went very very very well. good start i must say.
reverting back to sequoia tahoe.
list of apps to reinstall in sequoia
i should stop wasting money on things that i actually do not need. i noticed that my home server has gone broke, it needs repairs so i tried why not take a look inside and clean the cabinet. in the process i took out the hard disks and it struk me that i have 500gb of storage pool, and i was worrying about the space on my macbook, even tho i did not fill the storage, at that moment i thought lets make use of if and i began searching for a SATA to USB cable, at first i guessed that the cable might be around 200 or something but i didnt find one, instead i saw a case that that gives out type c output from harddisk. IT WAS 1000. even tho i had the money i was hesitant about making a purchase until late night when i finally put a cod order on it. when i woke up next morning i realized may be we could save up some more money and get an external SSD instead, which is easy to connect, lighter, even faster than this hard disk… then i immediately cancelled the order.
so i really need to think clearly when i make a purchase, this is a small purchase… but still
english exam tomorrow.
today, i got my last hall ticket for the 6th semester exam for by BBA Degree. Probably the last time i’ll ever be visiting that place.
anyways,
thats for the day bye !
just got a new macbook pro m1 pro, its got 32 gigs of ram, and 500gb ssd storage. setting up everything
while i was testing the github sync plugin, it did not work instantly. i did some workarounds like checking the repo url, verifying git installation etc everything was normal but the sync wasnt working. so i then saw an update for the plugin in the settings, i updated it hoping that would help but it didnt. i then found out that there were three issues here. fixed the issue via gemini cli
i hate college assignments
i have a game concept
the camera can be flexible based on speed and user’s input and the map too) 3d car driving simulator with realisitc physics (acceleration, deceleration, braking, drifting, tire grip, suspension, fuel capacity, mileage. map should be real satellite map. so it is just like microsoft flight simulator but we have a car instead of aircrafts. and its top down. how can i make it? the car has to be a realistic model, the physics should be realistic, car’s size should be same scale of the map’s roads so yeah. it has to be the best instead of
cleaned the home server today. there were multiple GUI related apps and services installed which were running in the background which were also making it run slow. so i had to remove all the gunk. and i want to install PostgreSQL from scratch and learn Bash from start.
woah, woke up early. stood up and started working already.
so today i made a big change in my room, i have put my setup on an elelvated space so i could stand instead of sitting all the time. since the last 5 years when i got my first pc i became addicted to spending a lot of time sitting infront of the computer, which i know is obviously unhealthy yet i did it because… idk it felt right.
but now for a change, i have decided to do something about this and decided to stand and move when i work, play or do whatever infront of the computer. by this way i beleive this would make my posture better and make me focus better instead of sitting like a bag of potatoes all day not moving an inch.
it’s been almost more than a month since i was productive at all. all this time no work at all.
it happens i guess, was a good reset time for me. made me clear my goals.
few things that i want to mention:
After almost half a month or more, i’m back on obsidian. sometimes i get over ambitious and start to procrastinate on things that i want to do in future and abandon the things that i have to do at that moment. what a shame. so im back today, let’s focus on what to do now. I got some work assigned by NSIC. Im 1 day past the deadline nobody cares anyway.
i was assigned with “The Study on Financial Health of the Company”. interesting, but i hate numbers. nevertheless i should start working
looks like i need to put my phone away when i sleep. i woke up and the next minute i start watching some yt shorts. its bad, need to change this. Anyways reached the center by 10 am. and everything looks good to me ahead.