Software Developer by day, data miner when away but a geek all day!
Bengaluru, 🇮🇳
Joined August 2009
- Tweets2K
- Following191
- Followers668
- Likes269
Srinivas Iyengar retweeted
AI won’t replace you. Someone from this hackathon might.
Apply by March 24th: cred.club/rabbit-hole
Winner gets ₹50 lakh and a place in history.
@YottaInfra @AWSCloudIndia
Srinivas Iyengar retweeted
#Malleshwaram
For a Madras boy like me, it is the closest to finding a shade of Mylapore and T. Nagar in one locality. Ancient Shiva and Devi Temples, different mathas, a TTD temple, eateries, vendors selling things on the pavement.
Srinivas Iyengar retweeted
Met this 18 year old @rajasthanroyals leg spinning net bowler yesterday as we travelled to Chennai. I am 6ft 6 1/2inchs tall. And he has me covered so he is at least 6ft 6 inches tall. His name is Yash & he is from Bengaluru.
Srinivas Iyengar retweeted
Advice to young engineers: Read a lot of code. Several more times than you write. Ideally not the code internal to company. Go find where the state of the art is, study it.
Having worked in the docker codebase early in my career gave me a lot of skill boost long-term.
Srinivas Iyengar retweeted
Inflight wifi didn't work so of course I had to debug it. It appears the problem is lack of DHCP lease. The WiFi was using 8 hour leases, which was time enough for many planeloads of passengers to embark/disembark.
A quick ARP scan at the time showed there were 55 devices on the network, almost entirely mobile devices (which randomize their MAC addresses, whereas laptops don't).
Given the number of takeoffs and landings in the 8 hour period, the lease table can easily fill up.
The fun fact about DHCP is that when this condition happens, it sends no response to the client. In other words, when trying to diagnose why " the wifi isn't working", there's no difference between this cause and half a dozen other causes.
I have to guess this is the cause simply by looking at the fact lots of other people seem to have successfully gotten a DHCP response but I haven't.
I told the flight attendant "the WiFi isn't working". She then "reset the Internet", after which I could get a lease. Apparently in the front near the entrance/exit, there's a button simply labeled "INTERNET RESET" that she presses whenever a customer complains.
Obviously, one solution to the problem is that DHCP leases on planes should be drastically shorter, like at 1 hour intervals. Secondly, the number of leases should be drastically increased.
Srinivas Iyengar retweeted
You're woken up by a p90 latency-related alert.
This alert is for the main API service, so you start investigating right away.
Your first thought is: it was working well so far, what changed - deployment or config. Hours later, you'd find out that it was neither.
Storytime
Srinivas Iyengar retweeted
Indian Railways had a revenue of ₹2.4 lakh Cr in FY23!
In terms of profit, East Costal Railway was the most profitable railway network in India.
Let's understand how Railways earn?🧵
Srinivas Iyengar retweeted
The adoption of cellphones by Keralan fishermen is, I believe, the most stunning example of the contribution of information technology to market performance.
Take a look at this graph for background: in three different regions of Kerala, phones were adopted at different times.
Kozhikode got cellphones before Kannur, who got them before Kasaragod. Adoption by fishermen was fast when phones were finally introduced:
Now look at what happened to the price of fish after phones entered the scene:
The dispersion in prices virtually disappeared! The author of the study wrote about this that:
"Before any region had mobile phones, the degree of price dispersion across markets within a region on any given day is high, and there are many cases where the price is zero (i.e., waste). However, within a few weeks of mobile phones being introduced in Region I, there is a sharp and striking reduction in price dispersion. Prices across markets in the region rarely differ by more than a few rupees per kilogram on any day, compared to cases of as much as 10 Rs/kg prior to the introduction of mobile phones. In addition, the prices in the various markets rise and fall together and the week-to-week variability within each market is much smaller, since catchment zone-specific quantity shocks are now spread across markets via arbitrage. Further, there are no cases of waste in this region after phones are introduced.
"By contrast, price behavior in regions II and III appears largely unchanged after phones are introduced in region I. However, after mobile phones are introduced in region II, prices again become much less dispersed across markets on any given day, less variable within markets over time, and waste is ultimately eliminated, whereas region III again remains unchanged. Finally, the same pattern holds once region III adds phones."
Efficient information transmission enables efficient markets. It's amazing what technology can do.
Read the study here: jstor.org/stable/25098864
Srinivas Iyengar retweeted
Only 0.3% of Indians go to the gym.
— Streets not built for walking, and air quality is low
— Most food is unhealthy: fried, processed, low protein
— Social events are centered around food and drink
— Culturally, "life" > fitness
This drastically reduces our lifespan.
1/5
Srinivas Iyengar retweeted
Chandrayaan-3 Mission:
🇮🇳Vikram soft-landed on 🌖, again!
Vikram Lander exceeded its mission objectives. It successfully underwent a hop experiment.
On command, it fired the engines, elevated itself by about 40 cm as expected and landed safely at a distance of 30 – 40 cm away.
Importance?: This 'kick-start' enthuses future sample return and human missions!
All systems performed nominally and are healthy. Deployed Ramp, ChaSTE and ILSA were folded back and redeployed successfully after the experiment.
#Chandrayaan_3
#Ch3
Srinivas Iyengar retweeted
i used to think being "transparent" is about sharing facts.
now i know it's about sharing emotions.
real transparency is about helping others understand what's going on inside your head that's driving your decisions.
a huge part of what's inside your head are your emotions.
Srinivas Iyengar retweeted
Chandrayaan-3 Mission:
In-situ Scientific Experiments
Another instrument onboard the Rover confirms the presence of Sulphur (S) in the region, through another technique.
The Alpha Particle X-ray Spectroscope (APXS) has detected S, as well as other minor elements.
This finding by Ch-3 compels scientists to develop fresh explanations for the source of Sulphur (S) in the area: intrinsic?, volcanic?, meteoritic?,......?.
isro.gov.in/APXS.html
The video shows an automated hinge mechanism rotating the 18 cm tall APXS, aligning the detector head to be approximately 5 cm in proximity to the lunar surface.
PRL, Ahmedabad has developed APXS with support from PRL, Ahmedabad. URSC, Bengaluru has developed the deployment mechanism.
Srinivas Iyengar retweeted
Chandrayaan-3 Mission:
'India🇮🇳,
I reached my destination
and you too!'
: Chandrayaan-3
Chandrayaan-3 has successfully
soft-landed on the moon 🌖!.
Congratulations, India🇮🇳!
#Chandrayaan_3
#Ch3
Srinivas Iyengar retweeted
We just open-sourced SQL Coder, a 15B param text-to-SQL model that outperforms OpenAI's gpt-3.5! When fine-tuned on an individual schema, it outperforms gpt-4. github.com/defog-ai/sqlcoder
The model is small enough to run on a single A100 40GB in 16 bit floats, or on a single high-end consumer GPU (like RTX 3090/4090) with 8bit quantization.
We are also open-sourcing our framework for evaluating LLM-generated SQL. SQL can be tricky to evaluate (see here for why: nitter.gq/rishdotblog/stat…). With rigorous, open and reproducible testing, we hope to advance the frontier of OSS text-to-SQL solutions.
The model weights have a CC BY-SA 4.0 license. You can use and modify the model for any purpose – including commercial use. However, if you modify the weights (for example, by fine-tuning), you must open-source your modified weights under the same license terms.
There's an interactive demo + link to Colab if you would like to play around with it. I'm always hungry for feedback! :)
Working on this was intense (a lot of 3AM git commits 😅). So grateful for our amazing team. @JP_smasher, @manshar_, @medha_basu, and @wendyaww are incredible to work with!
Great question! We have a custom variant of Spider. Main issues with Spider were that it was SQLite only (which most people don't use in prod) – and a lot of the data was really messy to deal with
To address this, we ended up cleaning the Spider dataset, and ported the data + queries over to Postgres
Then other big thing is that two very different SQL queries can both be "correct". For the question, who are the 10 most recent users from Toronto, both of the following are correct in their own ways – so we had to build a "fuzzy matching" algorithm to evaluate query correctness
`SELECT userid, username, created_at from users where city='Toronto' order by created_at DESC LIMIT 10;`
`SELECT userid, firstname || ' ' || lastname, created_at from users where city='Toronto' order by created_at DESC LIMIT 10;`