My weekly newsletter is out!
This week: Open Source of the Week - The PandasAI project
New learning resources - Getting started with Docker Model Runner, MCP Dev days, context engineering, training Qwen 3 model, fine-tuning local LLMs
Book of the week - Learning SQL by Alan Beaulieu
Join 30k subscribers and subscribe for weekly updates.
https://ramikrispin.substack.com/p/the-pandasai-project-learning-sql
I'm already using SelectiveEquatable in tests and it's really nice especially when I'm in a situation where it is a pain in the butt to conform a type to Equatable.
https://dandylyons.net/posts/post-24/selective-equality-checking-in-swift/
But finally it dawned on me, maybe I can generalize selectivity to help make other problems nicer and... well I haven't found it yet.
In #SQL for example it's really easy to SELECT columns and make one-off tuples. Perhaps that might be helpful in Swift?
Once again I demonstrate that I do not know how to use social media, not even Mastodon. Let me try that again properly with the relevant metadata: I have done my first post-ZeroVer release of #DBXS, an #OpenSource #Python raw #SQL #database access library. If that collection of hashtags seems interesting to you, perhaps check it out!
can someone who knows how to make good databases can help me, i'm kinda stuck between those two designs for my website. i have no idea which is best since i only was taught how to use sql, not design databases.
#mariadb #databases #sql ? i guess
Me, sending my data-integration/reporting code to external collaborators: "Hopefully this doesn't set you back too far..."
SQL Noir
#learning #gamification #sql #sqlnoir
• SQL Noir - весьма интересное решение для изучения SQL в виде текстовой игры. По сюжету вы будете выступать в роли детектива, которому необходимо решить определённый пул задач, анализируя улики в базе данных.
• Задачи разделены на три уровня: для начинающих, продолжающих и продвинутых пользователей. Сейчас доступно четыре дела, которые предстоит раскрыть. Если получается найти решение, то вы получаете баллы, которые открывают доступ к более сложным задачам. К слову, на GitHub (https://github.com/hristo2612/SQLNoir) есть подробная инструкция для тех, кто хочет разработать и опубликовать собственную задачу.
Проект полностью бесплатный: https://www.sqlnoir.com
Today in MS Access I built a form to create an invoice. It presents a list of individuals to select from and other fields.
A button runs a private subroutine that takes that info and sends it to a public subroutine which then loads a SQL append query and feeds the info into the query's parameters, and runs it.
I've never written much Access VBA before. I had to reread a lot of the Access Bible to figure this out. Bleh.
Load Related Data with Entity Framework in C# Tip #146 #webdevelopment #learncoding #datascience #databases #linq #visualstudio #codingbasics #codingforbeginners #softwaredeveloper #sqlserver #codinglife #learntocode #visualstudiocode #softwareengineer #coding #sql #vscode #computerscience #dotnet #csharp
Navigating Relationships with Entity Framework in C# Tip #145 #dotnet #csharp #computerscience #vscode #sql #webdevelopment #learncoding #datascience #databases #coding #linq #visualstudio #codingbasics #codingforbeginners #softwaredeveloper #sqlserver #codinglife #learntocode #visualstudiocode #softwareengineer
Explanining ICollection with Entity Framework in C# Tip #144#visualstudio #databases #coding #linq #dotnet #csharp #computerscience #vscode #sql #webdevelopment #learncoding #datascience #codingbasics #codingforbeginners #softwaredeveloper #sqlserver #codinglife #softwareengineer #learntocode #visualstudiocode
Pinterest is hiring Business Intelligence Analyst II
#sql
Remote; San Francisco, California
Full-time
Pinterest
Job details https://jobsfordevelopers.com/jobs/business-intelligence-analyst-ii-at-pinterest-com-aug-1-2025-a160b5?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Stack Overflow's 2025 Annual Developer Survey results are published, and #PostgreSQL once takes the top spot as Most Desired & Most Admired #database.
Factors like incredibly diverse data types and a thriving #OpenSource community has led to sustained levels of success for years.
Read more (& find the link to the survey) in our latest blogpost:
Managing relationships with Entity Framework in C# Tip #143 #codinglife #softwareengineer #learntocode #visualstudiocode #visualstudio #databases #coding #linq #dotnet #csharp #computerscience #vscode #sql #webdevelopment #learncoding #datascience #codingbasics #codingforbeginners #softwaredeveloper #sqlserver
Delete a Record with Entity Framework in C# Tip #142#softwaredeveloper #codingforbeginners #sqlserver #codingbasics #codinglife #softwareengineer #learntocode #visualstudiocode #visualstudio #databases #coding #linq #dotnet #csharp #computerscience #vscode #sql #webdevelopment #learncoding #datascience
Updating Record with Entity Framework in C# Tip #141 #datascience #learncoding #webdevelopment #softwaredeveloper #codingforbeginners #sqlserver #codingbasics #sql #codinglife #softwareengineer #learntocode #visualstudiocode #visualstudio #databases #coding #linq #dotnet #csharp #computerscience #vscode
FindAsync vs FirstOrDefaultAsync with Entity Framework in C# Tip #140 #computerscience #vscode #codinglife #sqlserver #datascience #learncoding #webdevelopment #softwaredeveloper #codingforbeginners #sql #codingbasics #softwareengineer #learntocode #visualstudiocode #visualstudio #databases #coding #linq #dotnet #csharp
Async Methods with Entity Framework in C# Tip #139 #csharp #dotnet #coding #databases #computerscience #visualstudio #vscode #codinglife #sqlserver #datascience #learncoding #linq #webdevelopment #softwaredeveloper #codingforbeginners #sql #codingbasics #softwareengineer #learntocode #visualstudiocode