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.

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.

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.

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

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.

The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.

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.