PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

Оглавление⌄
CoverTable of ContentsChange HistoryBeta 9—June 9,....2021Beta 8—April 27,....2021Beta 7—March 11,....2021Beta 6—August 11,....2020Beta 5—June 5,....2020Beta 4—March 23,....2020Beta 3—February 9,....2020Beta 2—December 4,....2019Beta 1—October 30,....2019AcknowledgmentsSo You Want to Write Some Client-Side CodeBasic AssumptionsThe Tools We’ll UseHow This Book Is OrganizedLet’s Build an AppThe Sample CodePart I—Getting Started1. Getting Started with Client-Side RailsManaging State and Front-End DevelopmentConfiguring WebpackerUsing WebpackerWhat’s Next2. Hotwire and TurboThe Hotwire WayInstalling TurboWhat Is Turbo Drive?Adding Interactivity with Turbo FramesNavigating Outside a Turbo FrameExtending Our Page with Turbo StreamsTurbo Frames vs. Turbo StreamsLazy Loading a Turbo FrameWhat’s Next3. StimulusWhat Is Stimulus?Installing StimulusAdding Our First ControllerCreating an ActionAdding a TargetUsing ValuesAutomating Value ChangesStimulus Has ClassGoing GenericStimulus Quick ReferenceWhat’s Next4. ReactWhat Is React?Installing ReactAdding Our First ComponentComposing ComponentsConnecting to the PageInteractivity, State, and HooksSharing StateWhat’s Next5. Cascading Style SheetsBuilding CSS in webpackAdding CSS and Assets to webpackAnimating CSSAdding CSS TransitionsAnimating Turbo Streams with Animate.cssUsing CSS and React ComponentsWhat’s NextPart II—Going Deeper6. TypeScriptUsing TypeScriptUnderstanding Basic TypeScript TypesStatic vs. Dynamic TypingAdding Type Annotations to VariablesAdding Type Annotations to FunctionsAdding Type Annotations to ClassesDefining InterfacesType Checking Classes and InterfacesGetting Type Knowledge to TypeScriptWhat’s Next7. webpackUnderstanding Why webpack ExistsManaging Dependencies with YarnUnderstanding webpack ConfigurationWhat’s Next8. WebpackerWebpacker BasicsWriting Code Using WebpackerIntegrating Webpacker with FrameworksRunning webpackDeploying Webpacker in ProductionCustomizing WebpackerWhat’s NextPart III—Managing Servers and State9. Talking to the ServerUsing Stimulus to Manage FormsStimulus and AjaxUsing Data in StimulusAcquiring Data in React with useStateWhat’s Next10. Immediate Communication with ActionCableInstalling ActionCableTurbo Streams and ActionCableStimulus and ActionCableReact and ActionCableWhat’s Next11. Managing State in Stimulus CodeUsing Data Values for LogicObserving and Responding to DOM ChangesRendering CSS with Data AttributesWhat’s Next12. Managing State in ReactUsing ReducersUsing Context to Share StateAdding Asynchronous Events to ContextsWhat’s Next13. Using Redux to Manage StateInstalling and Using ReduxAdding Asynchronous Actions to ReduxWhat’s NextPart IV—Validating Your Code14. Validating Code with Advanced TypeScriptCreating Union TypesSpecifying Types with Literal TypesUsing Enums and Literal TypesBuilding Mapped Types and Utility TypesTypeScript Configuration OptionsDealing with StrictnessWhat’s Next15. Testing with CypressWhy Cypress?Installing CypressConfiguring Cypress and RailsWriting Our First TestUnderstanding How Cypress WorksWhat’s Next16. More Testing and TroubleshootingWriting More Cypress TestsTesting the Schedule FilterCypress and ReactCypress Utilities and APITroubleshootingWhat’s NextA1. Framework SwapThe All-Hotwire AppThe All-React AppComparisonIndex
Описание
Ниже — практический обзор по теме «queries».
This book helps you write queries that perform fast and deliver results on time. Write optimized queries. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. You will learn to look at the process of writing a query from the database engine’s point of view, and know how to think like the database optimizer. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries.
It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries.
What You Will LearnIdentify optimization goals in OLTP and OLAP systemsRead and understand PostgreSQL execution plansDistinguish between short queries and long queriesChoose the right optimization technique for each query typeIdentify indexes that will improve query performanceOptimize full table scansAvoid the pitfalls of object-relational mapping systemsOptimize the entire application rather than just database queriesWho This Book Is ForIT professionals working in PostgreSQL who want to develop performant and scalable applications, anyone whose job title contains the words “database developer” or “database administrator" or who is a backend developer charged with programming database calls, and system architects involved in the overall design of application systems running against a PostgreSQL database.
Файл доступен для загрузки ниже.
Поделиться
Частые вопросы
Можно ли скачать «PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries» бесплатно?
Да, «PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries» доступна для бесплатного скачивания на нашем сайте в формате PDF. Ссылка на файл находится на этой странице.
В каком формате и какого размера файл?
Книга предоставляется в формате PDF, размер файла 4,9 МБ.
Кто автор и когда вышла книга?
автор — Bailliekova Anna , Dombrovskaya Henrietta , Novikov Boris, издательство Apress Media, LLC., год выпуска 2021, 335 страниц.
О чём книга «PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries»?
Write optimized queries.