وحید نصیری وحید نصیری
اشتراک‌ها
نگاهی به پشت صحنه‌ی طراحی و عملکرد بانک‌های اطلاعاتی
Things I Wished More Developers Knew About Databases

- You are lucky if 99.999% of the time network is not a problem.
- ACID has many meanings.
- Each database has different consistency and isolation capabilities.
- Optimistic locking is an option when you can’t hold a lock.
- There are anomalies other than dirty reads and data loss.
- My database and I don’t always agree on ordering.
- Application-level sharding can live outside the application.
- AUTOINCREMENT’ing can be harmful.
- Stale data can be useful and lock-free.
- Clock skews happen between any clock sources.
- Latency has many meanings.
- Evaluate performance requirements per transaction.
- Nested transactions can be harmful.
- Transactions shouldn’t maintain application state.
- Query planners can tell a lot about databases.
- Online migrations are complex but possible.
- Significant database growth introduces unpredictability.
نگاهی به پشت صحنه‌ی طراحی و عملکرد بانک‌های اطلاعاتی
‫۳ روز قبل، سه‌شنبه ۲۴ مهر ۱۴۰۳، ساعت ۰۷:۲۰
علیرضا آرانی علیرضا آرانی
اشتراک‌ها
درک مفهوم شردینگ دیتابیس

یک الگوی طراحی دیتابیس در حالت پارتیشن بندی افقی است. بیشتر برای زمانی مفید است که توسعه دیتابیس به صورت پویا مدنظر باشد.


Any application or website that sees significant growth will eventually need to scale in order to accommodate increases in traffic. For data-driven applications and websites, it's critical that scaling is done in a way that ensures the security and integrity of their data. It can be difficult to predict how popular a website or application will become or how long it will maintain that popularity, which is why some organizations choose a database architecture that allows them to scale their databases dynamically. 

درک مفهوم شردینگ دیتابیس
‫۵ سال و ۸ ماه قبل، یکشنبه ۲۱ بهمن ۱۳۹۷، ساعت ۱۲:۵۰
کوشککی کوشککی
اشتراک‌ها
با سی شارپ 8 از دست NullReferenceExceptions ها خلاص شوید

A .NET guideline specifies that an application should never throw a NullReferenceException. However, many applications and libraries do. The NullReferenceException is the most common exception happening. That’s why C# 8 tries to get rid of it. With C# 8, reference types are not null be default. This is a big change, and a great feature. However, what about all the legacy code? Can old libraries be used with C# 8 applications, and can C# 7 applications make use of C# 8 libraries?

This article demonstrates how C# 8 allows mixing old and new assemblies. 

با سی شارپ 8 از دست NullReferenceExceptions ها خلاص شوید
‫۶ سال و ۴ ماه قبل، پنجشنبه ۳۱ خرداد ۱۳۹۷، ساعت ۱۵:۴۸
وحید نصیری وحید نصیری
اشتراک‌ها
از Lucene.NET چه خبر؟

We are about to release Lucene.NET 4.8, and it's time to show what it can do, and how it can be done. 

از Lucene.NET چه خبر؟
‫۷ سال و ۱۰ ماه قبل، چهارشنبه ۲۴ آذر ۱۳۹۵، ساعت ۲۱:۵۳
وحید محمدطاهری وحید محمدطاهری
اشتراک‌ها
ReadyRoll محصول جدید شرکت Red-Gate

Develop and deploy databases in Visual Studio with migration scripts.

Want to work on databases in Visual Studio alongside your application? Feeling the pain of managing and deploying database changes manually? Then ReadyRoll's the tool for you.

It generates numerically ordered SQL migration scripts that sit inside your project and take your schema from one version to the next.

You can add them to version control, use them to build and release, and automate database and application deployments, all in one process.

ReadyRoll محصول جدید شرکت Red-Gate
‫۸ سال و ۷ ماه قبل، چهارشنبه ۱۱ فروردین ۱۳۹۵، ساعت ۱۳:۰۰
مهدی ملائیان مهدی ملائیان
اشتراک‌ها
کدام نسخه از sql server برای کار توسعه مناسب است ؟

You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edition has its pros and cons, and you need to consider Cloud-based resources, VMs and Containerised databases too. There is a whole range of alternatives and how you choose depends on the type of database you are developing, but for Ed, LocalDB gets the five-star accolade
 

کدام نسخه از sql server برای کار توسعه مناسب است ؟
‫۸ سال قبل، یکشنبه ۱۸ مهر ۱۳۹۵، ساعت ۱۵:۳۲
وحید نصیری وحید نصیری
پیشنهادها
async scripts؛ خوب یا بد؟
منابع پیشنهادی
HTML script async Attribute  
Load Non-blocking JavaScript with HTML5 Async and Defer 
Async Attribute and Scripts At The Bottom 
Script-injected "async scripts" considered harmful 
the underestimated problem about script async attribute 
Use Asynchronous Scripts 
Deep dive into the murky waters of script loading 
HTML5 Async Scripts 
Can I use async 
‫۱۰ سال و ۳ ماه قبل، شنبه ۴ مرداد ۱۳۹۳، ساعت ۱۷:۳۷
مهدی ملائیان مهدی ملائیان
اشتراک‌ها
هر برنامه نویس یک خود آموخته است

 There are many ways to become a programmer beside getting a computer science degree. If you’re on that less conventional path, you may be wondering what you should do to catch up to people who do have a degree. How can you compete with someone who spent many years in a classwork learning about computers and programming? 

هر برنامه نویس یک خود آموخته است
‫۸ سال و ۹ ماه قبل، جمعه ۲ بهمن ۱۳۹۴، ساعت ۲۰:۵۱