PostgreSQL Development Essentials
PostgreSQL Development Essentials

Author: Manpreet Kaur

Publisher: Packt Publishing Ltd

Published: 2016-09-26

Total Pages: 205

ISBN-13: 1783989017

DOWNLOAD EBOOK

Develop programmatic functions to create powerful database applications About This Book Write complex SQL queries and design a robust database design that fits your application's need Improve database performance by indexing, partitioning tables, and query optimizing A comprehensive guide covering the advanced PostgreSQL concepts without any hassle Who This Book Is For If you are a PostgreSQL developer with a basic knowledge of PostgreSQL development and you're want deeper knowledge to develop applications, then this book is for you. As this book does not cover basic installation and configurations, you should have PostgreSQL installed on your machine as a prerequisite. What You Will Learn Write more complex queries with advanced SQL queries Design a database that works with the application exactly the way you want Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing Develop applications in other programming languages such as Java and PHP Use extensions to get extra benefits in terms of functionality and performance Build an application that does not get locked by data manipulation Explore in-built db functions and data type conversions In Detail PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it's difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database. The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts Style and approach Every chapter follows a step by step approach that first explains the concept , then shows you how to execute it practically so that you can implement them in your application.

PostgreSQL Administration Essentials
PostgreSQL Administration Essentials

Author: Hans-Jürgen Schönig

Publisher: Packt Publishing Ltd

Published: 2014-10-15

Total Pages: 212

ISBN-13: 1783988991

DOWNLOAD EBOOK

If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.

Odoo 12 Development Essentials
Odoo 12 Development Essentials

Author: Daniel Reis

Publisher: Packt Publishing Ltd

Published: 2018-12-28

Total Pages: 395

ISBN-13: 178953898X

DOWNLOAD EBOOK

Extend your skills with Odoo 12 to build resourceful and open source business applications Key FeaturesExplore Odoo 12 capabilities to develop business applicationsProgram business logic and manipulate data to implement specific business rules in your applicationsIntegrate Python APIs for building customizable and scalable business logicBook Description Odoo is one of the best platforms for open source ERP and CRM. Its latest version, Odoo 12, brings with it new features and updates in Python packages to develop more customizable applications with additional cloud capabilities. The book begins by covering the development essentials for building business applications. You will start your journey by learning how to install and configure Odoo, and then transition from having no specific knowledge of Odoo to being ready for application development. You will develop your first Odoo application and understand topics such as models and views. Odoo 12 Development Essentials will also guide you in using server APIs to add business logic, helping you lay a solid foundation for advanced topics. As you progress through the chapters, you will be equipped to build and customize your applications and explore the new features in Odoo 12, such as cloud integration, to scale your business applications. You will get insights into building business logic and integrating various APIs into your application. By the end of the book, you will be able to build a business application from scratch by using the latest version of Odoo. What you will learnManage Odoo server instancesCreate a new Odoo application from scratch using the most frequently used elementsDevelop new models and use inheritance to extend existing modelsUse ORM methods in the Odoo server and from external clientsCreate Kanban views using QWeb effectivelyBuild custom web and website CMS pagesUse external APIs to integrate Odoo with external applicationsAdd automated tests and techniques to debug module business logicWho this book is for If you are a developer familiar with Python and MVC design and want to build business applications using Odoo, this book is for you.

Clojure Web Development Essentials
Clojure Web Development Essentials

Author: Ryan Baldwin

Publisher: Packt Publishing Ltd

Published: 2015-02-24

Total Pages: 232

ISBN-13: 1784394874

DOWNLOAD EBOOK

This book is for anyone who's worked with Clojure and wants to use it to start developing applications for the Web. Experience or familiarity with basic Clojure syntax is a must, and exposure to Leiningen (or other similar build tools such as Maven) would be helpful.

Odoo 15 Development Essentials
Odoo 15 Development Essentials

Author: Daniel Reis

Publisher: Packt Publishing Ltd

Published: 2022-02-25

Total Pages: 548

ISBN-13: 180020308X

DOWNLOAD EBOOK

Become a proficient Odoo developer and increase your productivity while building Odoo business applications Key FeaturesSet up the Odoo development environment and learn how to test and debug your codeUse the ORM framework to work with data and implement business logic supporting business rulesDesign user interfaces, web pages, and business reports using the Odoo framework's web componentsBook Description Odoo is fast becoming the reference open source platform for business applications thanks to the fact that it provides the infrastructure needed for developers to deliver software solutions for any business process quickly. Odoo's layered module approach makes it particularly effective for combining and extending features. This updated fifth edition is a tutorial-style introduction to essential Odoo development topics. The book starts by covering the development essentials for building business applications and takes you through Odoo installation and configuration, gradually transitioning from having no specific knowledge of Odoo to being ready for application development. You'll then learn how to develop your first Odoo application, while covering topics such as models and views. Later chapters will get you up to speed with using server APIs to add business logic, helping you lay a solid foundation for advanced topics. As you progress, you'll get equipped to build and customize your applications and explore the new features available in Odoo 12 and beyond, such as in-memory ORM and computed writable fields. Finally, you'll gain insights into building business logic and using the Odoo API to integrate with various applications. By the end of this book, you'll be able to build business apps from scratch using the latest version of Odoo. What you will learnInstall Odoo from source and organize the development environmentCreate your first Odoo app from scratchUnderstand the application components available in OdooStructure the application's data model using ORM featuresUse the ORM API to implement the business logic layerDesign a graphical user interface (GUI) for the web client and websiteUse the Odoo External API to interface with external systemsDeploy and maintain your application in production environmentsWho this book is for This book is for developers who want to learn Odoo application development and quickly become productive while creating business applications. Teachers, trainers, and Odoo team managers will also find the book useful for helping their students or trainees to learn Odoo development skills. Basic knowledge of Python programming is required to get started with the book

Mastering PostgreSQL in Application Development
Mastering PostgreSQL in Application Development

Author: Dimitri Fontaine

Publisher: Lulu.com

Published: 2017-11-05

Total Pages: 332

ISBN-13: 9780244945251

DOWNLOAD EBOOK

Mastering PostgreSQL in Application Development is intended for developers working on applications that use a database server. The book addresses specifically the PostgreSQL RDBMS: it actually is the world's most advanced Open Source database as said in its slogan on the official website. By the end of this book, you will know why, and agree!

Beginning Databases with PostgreSQL
Beginning Databases with PostgreSQL

Author: Richard Stones

Publisher: Apress

Published: 2006-11-03

Total Pages: 650

ISBN-13: 1430200189

DOWNLOAD EBOOK

*The most updated PostgreSQL book on the market, covering version 8.0 *Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java *This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL

Odoo 11 Development Essentials
Odoo 11 Development Essentials

Author: Daniel Reis

Publisher: Packt Publishing Ltd

Published: 2018-03-29

Total Pages: 328

ISBN-13: 1788476166

DOWNLOAD EBOOK

Fast track your development skills to build resourceful, open-source business applications with Odoo 11 Key Features Discover the latest technical capabilities in Odoo 11 while you build your own app Program business logic and manipulate data to implement specific business rules in your applications Implement automated tests to add modules and techniques and debug module business logic Book Description Odoo continues to gain worldwide momentum as the best platform for open source ERP installations. Now, with Odoo 11, you have access to an improved GUI, performance optimization, integrated in-app purchase features, and a fast-growing community to help transform and modernize your business. With this practical guide, you will cover all the new features that Odoo 11 has to offer to build and customize business applications, focusing on the publicly available community edition. We begin with setting up a development environment, and as you make your way through the chapters, you will learn to build feature-rich business applications. With the aim of jump-starting your Odoo proficiency level, from no specific knowledge to application development readiness, you will develop your first Odoo application. We then move on to topics such as models and views, and understand how to use server APIs to add business logic, helping to lay a solid foundation for advanced topics. The book concludes with Odoo interactions and how to use the Odoo API from other programs, all of which will enable you to efficiently integrate applications with other external systems. What you will learn Install Odoo from source Manage Odoo server instances Create a new Odoo application from scratch covering the most frequently used elements Develop new models and use inheritance to extend/modify existing models Use ORM methods, both in the Odoo server and from external clients Create Kanban views using QWeb effectively Develop custom web and website CMS pages Use external API to integrate Odoo with external applications Who this book is for Odoo 11 Development Essentials caters to developers who are familiar with Python and MVC design and now want to build effective business applications using Odoo.

Developing Modern Database Applications with PostgreSQL
Developing Modern Database Applications with PostgreSQL

Author: Dr. Quan Ha Le

Publisher: Packt Publishing Ltd

Published: 2021-08-13

Total Pages: 428

ISBN-13: 1838641068

DOWNLOAD EBOOK

Get up to speed with core PostgreSQL tasks such as database administration, application development, database performance monitoring, and database testing Key FeaturesBuild real-world enterprise database management systems using Postgres 12 featuresExplore the development, administrative and security aspects of PostgreSQL 12Implement best practices from industry experts to build powerful database applicationsBook Description PostgreSQL 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 learnSet up high availability PostgreSQL database clusters in the same containment, a cross-containment, and on the cloudMonitor the performance of a PostgreSQL databaseCreate automated unit tests and implement test-driven development for a PostgreSQL databaseDevelop PostgreSQL apps on cloud platforms using DevOps with Python and Node.jsWrite robust APIs for PostgreSQL databases using Python programming, Node.js, and PostgRESTCreate a geospatial database using PostGIS and PostgreSQLImplement automatic configuration by Ansible and Terraform for PostgresWho this book is for This 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.

Odoo 10 Development Essentials
Odoo 10 Development Essentials

Author: Daniel Reis

Publisher: Packt Publishing Ltd

Published: 2016-11-30

Total Pages: 289

ISBN-13: 1785887726

DOWNLOAD EBOOK

Fast-track your development skills to build powerful Odoo 10 business applications About This Book Get the most up-to-date guide on Odoo 10 and learn how to build excellent business applications with Odoo This example-rich, easy-to-follow guide enables you to build apps appropriate to your business needs Create solid business applications with the help of this precise, to-the-point guide Who This Book Is For This book caters to developers who are familiar with Python and MVC design and now want to build effective business applications using Odoo. What You Will Learn Install Odoo from source code and use all the basic techniques to setup and manage your Odoo server instances Create your first Odoo application Add Odoo's social and messaging features to your own modules Get to know the essentials of Models and Views Understand and use the server API to add business logic Use Qweb to create custom Reports Extend Odoo CMS features to create your own website controllers and pages Leverage Odoo Workflows on your applications Write module automated tests and debugging techniques Deploy your Odoo applications for production use In Detail Odoo is one of the fastest growing open source, business application development software products available. With announcement of Odoo 10, there are many new features added to Odoo and the face of business applications developed with Odoo has changed. This book will not only teach you how to build and customize business applications with Odoo, but it also covers all the new features that Odoo has to offer. This book is the latest resource on developing and customizing Odoo 10 applications. It comes packed with much more and refined content than its predecessor. It will start with building business applications from scratch and will cover topics such as module extensions, inheritance, working with data, user interfaces, and so on. The book also covers the latest features of Odoo 10, in addition to front end development, testing and debugging techniques. The book will also talk about Odoo Community and Odoo Enterprise. Style and approach This book follows a step-by-step practical approach where you will learn new concepts with every progressing chapter and create apps for business development.