Tech Tips, Tricks & Trivia

A good way to understand commercial software products is to check features for its different pricing plans.  Here is the list of the 50+ GitHub Copilot features from its Pricing page - Chat Messages and interactions Access to OpenAI GPT-4o [Preview] Access to OpenAI GPT-4.5 [Preview] Access to Anthropic Claude 3.5 Sonnet [Preview] Access to Anthropic Claude 3.7 Sonnet [Preview] Access to OpenAI o1 [Preview] Access to OpenAI o3-mini [Preview] Access to Google Gemini 2.0 Flash Context-aware coding support and explanations Debugging and security remediation assistance Access to knowledge from top open source repositories Generate tests, docs, and more with slash commands Answers about issues, PRs, discussions, files, commits, etc. Web search powered by Bing [Preview] Explain failed Actions jobs [Preview] Multi-file editing in VS Code [Preview] Switch between models [Preview] Add images to prompts Code completion Real-time code suggestions [Preview] Next edit suggestions Comments to c...

Can you imagine sharing a CSV file as URL and letting the recipients view the data through just their browser? Guess what, you can do that & more with  Datasette . Click on this link to see a table showing shelf life of some perishable food items Datasette is a tool created by Simon Willison for exploring and publishing data .  It's a web application that provides a  user interface (UI) for browsing, viewing,  faceting, filtering,  sharing and exploring data .  Datasette allows you to convert CSV files into a database table . Datasette runs on top of SQLite , which is a fast, widely used database where each database is a single file that's easy to copy and back up. Datasette is designed for read-only data, meaning you can't make changes to the data through the Datasette interface. You can run your own SQL queries against the data, which is usually risky for web applications but safe in Datasette because it uses a read-only database. Datasette's JSO...

This Week I Learned -  * Message queues (Kafka, RabbitMQ, SQS) solve problems but also introduce new ones (ordering, deduplication, backpressure). Nothing is more abused than Redis as a primary database. Understand trade-offs .  *  Roboflow provides the means to label, train, and deploy computer vision solutions. It offers a Free Plan with 15 credits per month to try it and get started. * Currently 45+ services are available in the AWS Free Tier  to both existing and new AWS customers indefinitely unlike some others that are free for the first 12 months. * Skype Joins Windows Phone in Microsoft's Graveyard of Forgotten Innovations -Founded in 2003, Skype’s cheap audio and video calls quickly disrupted the landline industry in the early 2000s. Microsoft bought Skype in 2011 for $8.5 billion after outbidding Google and Facebook. Microsoft will retire the two-decade-old internet calling service in May 2025. * Dark Patterns & Dirty Tricks in Smartphone Apps - The Di...

The two islands,  Little Diomede (Yesterday Island, USA) and Big Diomede (Tomorrow Island, Russia) are a mere three miles apart. Yet, they lie on opposite sides of the International Date Line, creating a remarkable 21-hour time difference! This means that when it's noon on Big Diomede, it's 3 AM the previous day on Little Diomede. This unique situation makes the islands seem like two different worlds, despite their close proximity.  Imagine being able to celebrate your birthday twice or experience two different days within a short trip.  This geographical anomaly is a fascinating example of how time can be bent by the International Date Line. See more of my AI co-creations