![Developing Modern Database Applications with PostgreSQL](https://img.perlego.com/book-covers/2832131/9781838641061_300_450.webp)
Developing Modern Database Applications with PostgreSQL
Dr. Quan Ha Le, Marcelo Diaz
- 440 pages
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
Developing Modern Database Applications with PostgreSQL
Dr. Quan Ha Le, Marcelo Diaz
Ă propos de ce livre
Get up to speed with core PostgreSQL tasks such as database administration, application development, database performance monitoring, and database testingKey Featuresâą Build real-world enterprise database management systems using Postgres 12 featuresâą Explore the development, administrative and security aspects of PostgreSQL 12âą Implement best practices from industry experts to build powerful database applicationsBook DescriptionPostgreSQL is an open-source object-relational database management system (DBMS) that provides enterprise-level services, including high performance and scalability. This book is a collection of unique projects providing you with a wealth of information relating to administering, monitoring, and testing PostgreSQL. The focus of each project is on both the development and the administrative aspects of PostgreSQL.Starting by exploring development aspects such as database design and its implementation, you'll then cover PostgreSQL administration by understanding PostgreSQL architecture, PostgreSQL performance, and high-availability clusters. Various PostgreSQL projects are explained through current technologies such as DevOps and cloud platforms using programming languages like Python and Node.js. Later, you'll get to grips with the well-known database API tool, PostgREST, before learning how to use popular PostgreSQL database testing frameworks. The book is also packed with essential tips and tricks and common patterns for working seamlessly in a production environment. All the chapters will be explained with the help of a real-world case study on a small banking application for managing ATM locations in a city.By the end of this DBMS book, you'll be proficient in building reliable database solutions as per your organization's needs.What you will learnâą Set up high availability PostgreSQL database clusters in the same containment, a cross-containment, and on the cloudâą Monitor the performance of a PostgreSQL databaseâą Create automated unit tests and implement test-driven development for a PostgreSQL databaseâą Develop PostgreSQL apps on cloud platforms using DevOps with Python and Node.jsâą Write robust APIs for PostgreSQL databases using Python programming, Node.js, and PostgRESTâą Create a geospatial database using PostGIS and PostgreSQLâą Implement automatic configuration by Ansible and Terraform for PostgresWho this book is forThis PostgreSQL book is for database developers, database administrators, data architects, or anyone who wants to build end-to-end database projects using Postgres. This book will also appeal to software engineers, IT technicians, computer science researchers, and university students who are interested in database development and administration. Some familiarity with PostgreSQL and Linux is required to grasp the concepts covered in the book effectively.
Foire aux questions
Informations
- Chapter 1, Introduction to PostgreSQL Development and Administration
- An overview of PostgreSQL development
- An overview of PostgreSQL administration
An overview of PostgreSQL development
- The increased performance of standard B-tree indexes and also the reduction of the index size for B-tree indexes.
- The ability to rebuild indexes concurrently so that a REINDEX operation will not block any index writes; the parallel indexes introduced from PostgreSQL 10 now get more benefits with the new REINDEX CONCURRENTLY statement.
- The efficient capabilities regarding partitioning performance so that developers can now process (that is, query or alter) thousands of partitions simultaneously without blocking, and they can use foreign keys to reference partitioned tables.
- The most common value statistics for the CREATE STATISTICS command, leading to improved query plans.
- The common table expressions using WITH queries can now be inlined for quicker queries.
- The INCLUDE clause for generalized search tree (GiST) indexes is an extensible data structure that allows you to develop indices over any kind of data.
- The reduction of write-ahead log (WAL) overheads generated from a GiST, GIN, or SP-GiST index.
- The checksum control ability via the pg checksums statement (which used to be pg_verify_checksums) so that developers can enable or disable an offline cluster without dumping and reloading data (note that online checksum enablement is still in progress and not yet available in PostgreSQL 12).
What is DBaaS?
The development of PostgreSQL by various environments
Features of PostgreSQL with NodeJS
- NodeJS is an open source cross-platform that is built on the V8 JavaScript runtime of Chrome.
- NodeJS is ideal for data-intensive, real-time applications, and it enables event-driven programming.
- NodeJS is also a super-fast JavaScript interpreter because it works on a non-blocking I/O model.
- Outperforming conventional web servers, NodeJS has been a viable option for Yahoo, eBay, and Walmart.
- NodeJS employs push technology.
- It is also a lightweight web server in terms of memory usage.
- NodeJS can be a good solution for data-dense, real-time web applications across multiple devices.
- The super-fast web server: NodeJS operates at a very high speed by using a single-threaded event loop model to process all of its asynchronous I/O operations. Therefore, any major actions can be performed quickly with NodeJS, such as network connections, filesystems, and reading/writing to databases. NodeJS supports developers by allowing them to create quick and robust network applications and offers parallel connections to increase throughput.
- The JavaScript web server: The NodeJS suite is a JavaScript runtime environment, and developers can now write JavaScript not only in the browser but also on the server. When the browser code and the server code are created in a similar manner, it is convenient to transport data between the server and the client. NodeJS fills the gap between the frontend and backend skills, and full stack developers can use JavaScript for both. The fact that all NodeJS programs are made using JavaScript increases the effectiveness of the web development process.
- Real-time data streaming: NodeJS considers both HTTP requests and responses as data streams. Hence, when data comes in the form of streams, the overall processing time can be reduced because NodeJS can process files and upload files at the same time. Developers can choose NodeJS for real-time video or audio recording.
- Real-time web applications: Because NodeJS is very fast, it is obviously a winner for games and chat apps as well as any other multi-user real-time web apps. The synchronization process is fast and orderly due to the event-driven architecture of NodeJS, and the event loop of NodeJS through the web socket protocol handles the multi-user function.
- Node Package Manager (NPM): NodeJS is an open source suite with more than 60,000 modules in the NPM.
- A good solution for synchronization: NodeJS is very efficient in its ability to solve common network development problems because it manages asynchronous I/O very well with its single-threaded event loop. In order to handle many clients, all I/O tasks are...
Table des matiĂšres
- Title Page
- Copyright
- Contributors
- About Packt
- Preface
- Section 1 - Introducing PostgreSQL Development and Administration
- Introduction to PostgreSQL Development and Administration
- Section 2 - Development in PostgreSQL
- Setting Up a PostgreSQL RDS for ATMs
- Using PostgreSQL and Node.js for Banking Transactions
- Managing Bank ATM Locations Using PostgreSQL and Django
- Creating a Geospatial Database Using PostGIS and PostgreSQL
- Managing Banking Transactions using PostgREST
- Section 3 - Administration in PostgreSQL
- PostgreSQL with DevOps for Continuous Delivery
- PostgreSQL High Availability Clusters
- High-Performance Team Dashboards Using PostgreSQL and New Relic
- Testing the Performance of Our Banking App with PGBench and JMeter
- Test Frameworks for PostgreSQL
- APPENDIX - PostgreSQL among the Other Current Clouds
- Other Books You May Enjoy