Design system component checklist
An open-source checklist to help you plan, build, and grow your design system. It covers design language, core components, and maintenance procedures.
designsystemchecklist.com
Test your SQL knowledge 👇
Is the index below a good fit for the query?
---
CREATE INDEX IX_Articles_DatePublished
ON Articles (DatePublished);
SELECT COUNT(*)
FROM Articles
WHERE DATEPART(YEAR, DatePublished) = 2023;
---
And the answer is:
- This isn't a good index for this…
When the database fetches a page and places it in the shared buffer pool, we gain access to all rows and columns within that page.
So, the question arises: if we have all the columns readily available in memory, why would SELECT * be slow and costly?
Is it really as slow as…
I created a bad Entity Framework query.
The Linkedin community started optimizing it yesterday.
Best result so far:
Non-optimized: 1036.467ms (~1s)
Optimized: 5.99ms
Can you do better?
Give it a try: github.com/StefanTheCode/…#Dotnet
Container queries in Tailwind CSS? 👀 Quick little demo @malfaitrobin and I cooked up this afternoon...
API and stuff definitely subject to change, but did this as a user-land plugin: play.tailwindcss.com/ExTUcVGb7k?siz…
I’ve come up with an interim solution to the queuing issue to see the Queen’s coffin in Westminster, let me know what you think, it’s not perfect but I don’t see anyone else coming up with anything
Entity Framework is fast ⚡
But you can make it even faster.
Here are 3 simple things you can do:
- Use AsNoTracking
- Try out AsSplitQuery
- Go Async
AsNoTracking - entities won't be tracked in the ChangeTracker
AsSplitQuery - useful when you have joins
Async - throughput
565K Followers 513 FollowingFounder of the world’s most read daily AI newsletter @therundownai. Sharing the latest developments in the world of artificial intelligence.
3.4M Followers 2K FollowingPosting interesting science, gadgets, history, art, and more. Subscribe for in-depth posts. As an Amazon Associate I earn from qualifying purchases.
14K Followers 5K FollowingAI/LLM Agents Team Lead at @nethermindeth • Pro .NET Memory book • .NET MVP • @crowdpub_org founder • one of @dotnetosorg • skeptical fan of web3 • AFOL
56K Followers 2K FollowingI make tv for developers at @codetv_dev
web dev can be fun. CodeTV is out to bring a little joy back into learning and building
email: [email protected]
55K Followers 5K Following@[email protected] - I like computers and think someday others will, too. PM on .NET Community Team. Work for Microsoft but speak for myself.
140K Followers 1K FollowingDistinguished Engineer at Microsoft on .NET, Creator of NuGet, SignalR, https://t.co/PiydKAsC8g Core, Aspire and Barbadian 🇧🇧, Tennis Player, Father, other half @symonefowler
1.1M Followers 20 FollowingLimitless innovation. ☁️ Follow along for the latest news and resources from the official #MicrosoftAzure team. For help, contact @AzureSupport.
508K Followers 15 FollowingWelcome to a community built for passionate developers. Microsoft Developer is your resource for tips, research and more to help you build apps that users love.
537K Followers 10 FollowingThe most comprehensive IDE for .NET and C++ devs on Windows. It's packed with a sweet array of tools to elevate every stage of software development.
1K Followers 64 FollowingBuild desktop, mobile, and WebAssembly apps with C# and Blazor using your favorite framework—Bootstrap, Fluent, or Material—all from one codebase.
2K Followers 36 FollowingBlazor Component Library based on Material design. The goal is to do more with Blazor, utilizing CSS and keeping Javascript to a bare minimum.
59K Followers 197 FollowingIndependent foundation fostering open development and collaboration around the growing collection of open source technologies for .NET.
337K Followers 855 FollowingFree. Cross-platform. Open source. A developer platform for building all your apps. Official handle of the .NET team at Microsoft.
151K Followers 2K FollowingThe most supportive community of programmers.
#CodeNewbie Podcast | @codelandconf | Part of the @forem & @thepracticaldev family 💜