Jansen Abit

@Oblivious9021 concurrency

Interviewer: Your database query takes 50ms locally but 2000ms in production. Same schema. Same data volume. What's happening?

@PythonPr answer: D, append creates a list

Python Question / Quiz; What is the output of the following Python code, and why? Comment your answers below!

@brankopetric00 connection intent=read-only. Listener of load balancer should route the connection to read-only database.

AWS Bill Shock: 'EC2-Other' cost spiked by $2,000. Investigation shows it's 'Inter-Zone Data Transfer'. Architecture: - App Tier (AZ-A, AZ-B) - Database (AZ-A) The App in AZ-B is chatting heavily with the Database in AZ-A. You cannot move the App instances (you need high availability). What feature of the database driver or connection string can you configure to prefer connecting to a read-replica in the *same* Availability Zone?

@RealBenjizo A: a null returns a null

SQL question: Happy Monday. Go out and be great. What does this query output, and why?

@thesql_tribe B: where name like '%son' -- the % is a wildcard means whatever value before the word "son"

Do you really know SQL? 😊 Day 5/30 Which statement returns all customers whose name ends with “son”? A. SELECT * FROM Customers WHERE Name LIKE 'son%'; B. SELECT * FROM Customers WHERE Name LIKE '%son'; C. SELECT * FROM Customers WHERE Name = '%son';

@RealBenjizo D) both A & B -- the C is going nowhere

SQL Question: We have two tables: customers and orders Which query finds customers who have placed at least one order?

@elonmusk @ID_AA_Carmack Wonder if it's feasible to use a long fiber optic cable instead?

@ID_AA_Carmack A long chain of modified future generation Starlink satellites between 1 and 1.5 AU would do it

Someone should make a proxy system to simulate mars latency and projected bandwidth and start figuring out how to make effective use of the internet from mars. Good hobby project. Easy to imagine individual apps or sites optimized for offline use, but how do you take advantage of everything else? Assume you update a local cache with every incoming Starship, but any topical interaction eats the full latency, so you wind up sending a query to an AI on earth to batch up as much relevant data as possible for you to consider a half hour later. Figuring out how to make a heavily server based web site operate without the server is almost like the neural networks learning how to simulate games just by playing them. In a mature earth/mars environment you would have a fairly dense string of Starships in Hohmann transfer at once between earth and mars. Interesting to consider whether using them as a chain of point to point repeaters could be better than direct line of sight transmission between planets.

@Jam883 - nice playlist! PJ, Soundgarden and RageAgainstTheMachine! my genre. I'm enjoying listening from work. Thanks!