A beginner’s guide to SQL database design [closed]

I started with this book: Relational Database Design Clearly Explained (The Morgan Kaufmann Series in Data Management Systems) (Paperback) by Jan L. Harrington and found it very clear and helpful and as you get up to speed this one was good too Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science … Read more

What is a “feature flag”?

A ‘feature flag’ (or Feature Toggle) is the ability to turn features (sub-sections) of your application on/off at easily: perhaps via a re-deploy, or some internal page where pages/features can be toggled live. I guess the example there was that it’s handy to have the control to reduce the feature-set somewhat if you need to, … Read more

WebRTC – scalable live stream broadcasting / multicasting

As it was pretty much covered here, what you are trying to do here is not possible with plain, old-fashionned WebRTC (strictly peer-to-peer). Because as it was said earlier, WebRTC connections renegotiate encryption keys to encrypt data, for each session. So your broadcaster (B) will indeed need to upload its stream as many times as … Read more

How to write a scalable TCP/IP based server

I’ve written something similar to this in the past. From my research years ago showed that writing your own socket implementation was the best bet, using the asynchronous sockets. This meant that clients not really doing anything actually required relatively few resources. Anything that does occur is handled by the .NET thread pool. I wrote … Read more

What is considered a good response time for a dynamic, personalized web application? [closed]

There’s a great deal of research on this. Here’s a quick summary. Response Times: The 3 Important Limits by Jakob Nielsen on January 1, 1993 Summary: There are 3 main time limits (which are determined by human perceptual abilities) to keep in mind when optimizing web and application performance. Excerpt from Chapter 5 in my … Read more

How Scalable is SQLite? [closed]

Yesterday I released a small site* to track your rep that used a shared SQLite database for all visitors. Unfortunately, even with the modest load that it put on my host it ran quite slowly. This is because the entire database was locked every time someone viewed the page because it contained updates/inserts. I soon … Read more

Difference between scaling horizontally and vertically for databases [closed]

Horizontal scaling means that you scale by adding more machines into your pool of resources whereas Vertical scaling means that you scale by adding more power (CPU, RAM) to an existing machine. An easy way to remember this is to think of a machine on a server rack, we add more machines across the horizontal … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)