Mastering PostgreSQL 15. Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications - Fifth Edition

Hans-Jürgen Schönig

Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system.You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you’ll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.By the end of this PostgreSQL book, you’ll be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.

Julia 1.0 Programming Complete Reference Guide. Discover Julia, a high-performance language for technical computing

Ivo Balbaert, Adrian Salceanu

Julia offers the high productivity and ease of use of Python and R with the lightning-fast speed of C++. There’s never been a better time to learn this language, thanks to its large-scale adoption across a wide range of domains, including fintech, biotech and artificial intelligence (AI).You will begin by learning how to set up a running Julia platform, before exploring its various built-in types. This Learning Path walks you through two important collection types: arrays and matrices. You’ll be taken through how type conversions and promotions work, and in further chapters you'll study how Julia interacts with operating systems and other languages. You’ll also learn about the use of macros, what makes Julia suitable for numerical and scientific computing, and how to run external programs.Once you have grasped the basics, this Learning Path goes on to how to analyze the Iris dataset using DataFrames. While building a web scraper and a web app, you’ll explore the use of functions, methods, and multiple dispatches. In the final chapters, you'll delve into machine learning, where you'll build a book recommender system.By the end of this Learning Path, you’ll be well versed with Julia and have the skills you need to leverage its high speed and efficiency for your applications.This Learning Path includes content from the following Packt products:• Julia 1.0 Programming - Second Edition by Ivo Balbaert• Julia Programming Projects by Adrian Salceanu

Designing the Adobe InDesign Way. Explore 100+ recipes for creating stunning layouts with the leading desktop publishing software

Andy Gardiner

Adobe InDesign is the leading desktop publishing and layout software for producing brochures, magazines, flyers, books, posters, and a wide range of digital documents. It allows you to rapidly draft your documents with precise control over typography, images, positioning, alignment, color, and other interactive features. However, InDesign’s interface, tools, and workflows can be a bit challenging to get to grips with. This cookbook will assist you in building unparalleled InDesign workflows with tried and tested recipes.With Designing the Adobe InDesign Way, you’ll learn how to add and edit content, create color swatches, and use features such as tables, all while applying software best practices and techniques to ensure that your work is fast, efficient, and easily maintained. Additionally, you’ll explore advanced InDesign features such as text styles, parent pages, tables of contents, and pre-flighting. Finally, you’ll take a closer look at the many export options in InDesign and ways to truly maximize its capabilities.By the end of this book, you’ll be well equipped to draft and design your own projects while ensuring your work is compatible with industry standards for print and digital documents.

Magento 2 Development Essentials. Get up and running with Magento 2 to create custom solutions, themes, and extensions effectively

Fernando J Miguel

Magento is the e-commerce software and platform trusted by the world's leading brands. Used by thousands of merchants for their transactions worth billions, it provides the flexibility to customize the content and functionality of your website. By strengthening your fundamentals in Magento development, you can develop the best solutions and take advantage of the growing market.This fast-paced tutorial will provide you with skills you need to successfully create themes, extensions, and solutions to Magento 2 projects. This book begins by setting up Magento 2 before gradually moving onto setting the basic options of the Sell System. You will take advantage of Search Engine Optimization aspects, create design and customize theme layout, develop new extensions, and adjust the Magento System to achieve great performance. By sequentially working through the steps in each chapter, you will quickly explore all the features of Magento 2 to create a great solution.With ample examples and a practical approach, this book will ensure your success with this astonishing e-commerce management system.

Bioinformatics with Python Cookbook. Learn how to use modern Python bioinformatics libraries and applications to do cutting-edge research in computational biology

Tiago R Antao, Tiago Antao

FPGA Programming for Beginners. Bring your ideas to life by creating hardware designs and electronic circuits with SystemVerilog

Frank Bruno

Field Programmable Gate Arrays (FPGAs) have now become a core part of most modern electronic and computer systems. However, to implement your ideas in the real world, you need to get your head around the FPGA architecture, its toolset, and critical design considerations. FPGA Programming for Beginners will help you bring your ideas to life by guiding you through the entire process of programming FPGAs and designing hardware circuits using SystemVerilog.The book will introduce you to the FPGA and Xilinx architectures and show you how to work on your first project, which includes toggling an LED. You’ll then cover SystemVerilog RTL designs and their implementations. Next, you’ll get to grips with using the combinational Boolean logic design and work on several projects, such as creating a calculator and updating it using FPGA resources. Later, the book will take you through the advanced concepts of AXI and show you how to create a keyboard using PS/2. Finally, you’ll be able to consolidate all the projects in the book to create a unified output using a Video Graphics Array (VGA) controller that you’ll design.By the end of this SystemVerilog FPGA book, you’ll have learned how to work with FPGA systems and be able to design hardware circuits and boards using SystemVerilog programming.

Applied Computational Thinking with Python. Algorithm design for complex real-world problems - Second Edition

Sofía De Jesús, Dayrene Martinez

Computational thinking helps you to develop logical processing and algorithmic thinking while solving real-world problems across a wide range of domains. It's an essential skill that you should possess to keep ahead of the curve in this modern era of information technology. Developers can apply their knowledge of computational thinking to solve problems in multiple areas, including economics, mathematics, and artificial intelligence.This book begins by helping you get to grips with decomposition, pattern recognition, pattern generalization and abstraction, and algorithm design, along with teaching you how to apply these elements practically while designing solutions for challenging problems. You’ll then learn about various techniques involved in problem analysis, logical reasoning, algorithm design, clusters and classification, data analysis, and modeling, and understand how computational thinking elements can be used together with these aspects to design solutions. Toward the end, you will discover how to identify pitfalls in the solution design process and how to choose the right functionalities to create the best possible algorithmic solutions.By the end of this algorithm book, you will have gained the confidence to successfully apply computational thinking techniques to software development.

iOS 15 Programming for Beginners. Kickstart your mobile app development journey by building iOS apps with Swift 5.5 and Xcode 13 - Sixth Edition

Ahmad Sahar, Craig Clayton

With almost 2 million apps on the App Store, iOS mobile apps continue to be incredibly popular. Anyone can reach millions of customers around the world by publishing their apps on the App Store. iOS 15 Programming for Beginners is a comprehensive introduction for those who are new to iOS. It covers the entire process of learning the Swift language, writing your own app, and publishing it on the App Store.Complete with hands-on tutorials, projects, and self-assessment questions, this easy-to-follow guide will help you get well-versed with the Swift language to build your apps and introduce exciting new technologies that you can incorporate into your apps. You'll learn how to publish iOS apps and work with Mac Catalyst, SharePlay, SwiftUI, Swift concurrency, and much more.By the end of this iOS development book, you'll have the knowledge and skills to write and publish interesting apps, and more importantly, to use the online resources available to enhance your app development journey.