SqlZap (@sqlzap) header
SqlZap (@sqlzap) profile picture

Learn SQL with me. Made by @csaba_kissi

Joined November 2023
Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)Photo by SqlZap (@sqlzap)
So many nice animated react components on this site
This site contains hundreds of animated React components reactbits.dev
22
Replying to @csaba_kissi
There are a ton of great components
25
Good to know how caching strategies work
Caching Strategies Explained ⚡🗄️ Caching speeds up applications by reducing expensive database queries and repeated computations. But not all caching strategies work the same way. Here are 8 important concepts 👇 🔵 1. Cache-Aside - App checks the cache first, fetches missing data from the database, and stores the result. 🟠 2. Read-Through - The cache automatically loads missing data from the database. 🔵 3. Write-Through - Writes update the cache and database before being acknowledged. 🟠 4. Write-Behind - Writes go to the cache first and are persisted asynchronously. 🔵 5. Refresh-Ahead - Frequently accessed entries are refreshed before they expire. 🟠 6. Stale-While-Revalidate - Serve cached data immediately while refreshing it in the background. 🔵 7. Time-to-Live (TTL) - Automatically expire cached entries after a defined period. 🟠 8. Least Recently Used (LRU) - Evict the least recently accessed entries when the cache fills up. Why caching matters: ⚡ Faster response times 📉 Reduced database load 📈 Better scalability 💰 Lower infrastructure costs 💡 The biggest challenge isn't storing data in a cache. It's keeping that data fresh, consistent, and available when needed. Choose your strategy based on read/write patterns, freshness requirements, and acceptable trade-offs. 🚀
18
Replying to @csaba_kissi
Great collection
35
Replying to @csaba_kissi
AI agent + MCP server, it's what we will see more and more
1
1
45
Replying to @csaba_kissi
My activity..
2
40
I prefer available credits
The Mac app now allows you to switch between Used/Available limits
1
53
Replying to @csaba_kissi
Imagine paying this in API prices
1
2
35
Replying to @MentorWebDev
You should know what you're doing when you're launching rebase
1
2
77
Replying to @sevalla_hosting
I also prefer to cache queries on the DB layer
1
2
15
This is how the deployment flow should look like
CI/CD environment flow, explained clearly ⚙️🚀 Software usually doesn’t go straight from code to users. It moves through a series of environments first 👇 🔹 Development Where features are built, tested locally, and improved fast. 🔹 Testing Where CI runs automated checks to catch bugs early. 🔹 Staging A production-like space for final validation and review. 🔹 Production The live environment used by real customers. Why does this matter? 🛡️ It lowers risk, improves quality, and makes releases afer. Teams can validate changes step by step instead of guessing. Typical path: Code change → testing → staging → production A simple flow, but one of the biggest reasons modern teams ship reliably 📦
1
32
Replying to @csaba_kissi
Looks like the list today covers many topics, including code learning
1
2
42
Replying to @csaba_kissi
We need SQL stuff.
1
2
61
Replying to @sevalla_hosting
It's important to understand the difference between these terms
1
1
8
Replying to @sevalla_hosting
Choose REST when you want straightforward, predictable SQL access and a broadly compatible public API. And don't forget about the security
1
1
27
Replying to @csaba_kissi
It seems I have to create something to include on the list.
1
1
41
Replying to @csaba_kissi
The first one can do a ton of cool stuff. It's like an all-in-one scientific agent with special skills. But again... We really need something related to SQL 😀
1
3
64
Replying to @csaba_kissi
Astra only for planning now.
1
1
86
Replying to @MentorWebDev
Memory leaks can become super hard easily
1
26
Replying to @sevalla_hosting
And store all the information in SQL database like Postgres
1
1
26