Where can I get good literature on designing web applications (sites)?

Question

ruby

Are you familiar with the book, which covers in detail:
- designing sites for high load
- the best algorithms for optimizing bottlenecks, including tips for optimizing database queries
- security (sql inj, xss)
- routing
- interaction with the server and advice on where to apply for the purpose of optimization
- caching in detail and without embellishment (affecting security aspects)
So:
1) maybe I'm a perfectionist and I'm looking for something that no one has written
2) I know about tons of articles on these topics, but I'm looking for a handbook with structured information written in a single language without contradictions, by a professional practitioner with experience in the industry who worked on real projects.
3) no one canceled the articles, therefore I’m looking for a book not as a “do it like this” manual, but as a work describing the fundamental principles of designing web applications
4) I think it’s not so important what I write on, but if I’m wrong, then: php + mysql

Answer 1

Recommendations for the most demanding habrahabr.ru/post/77179
Security

Answer 2

"Learning PHP and MySQL" Michelle E. Davies and John A. Phillips
"PHP Programming Recipes" Adam Trachtenberg, David Sklyar
"Developing Web Applications with PHP and MySQL" Luke Welling, Laura Thomson - I really liked this one, the most complete meets all your requirements

Answer 3

rutracker.org/forum/viewtopic.php?t=373656
Read books by Kuznetsov

Answer 4

> - Designing sites for high load
The bottleneck in the operation of any site is the database. There is a great book for this - MySQL. Performance optimization (Baron Schwartz). You will learn a lot of information about optimization for high loads. Excellent work on this subject. Understand what is written in the book - you will be able to create high-load projects. This book is a table book.
> - the best algorithms for optimizing bottlenecks, including tips for optimizing queries to the database
The same book.
> - security (sql inj, xss)
Courses from the center Specialist (Web site security design and effective protection against attacks)
- routing
It's just to take some framework and figure out how it works. There are no dogmas here. The books don't talk about it. Routing is a logical part of a web application. Therefore, only frameworks and lessons on creating a site from scratch.
- interaction with the server and advice on where to use it for optimization purposes
Where is it better to use what?
- caching in detail and without embellishment (affecting security aspects)
What kind of caching are you interested in?