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 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

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!

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.

A hands-on solution provider to PostgreSQL. Expert advice by a highly respected author within the PostgreSQL user community, this book provides detailed, useable information in the popular Essential Reference format. Includes tables within each chapter that organize the material both alphabetically and by task so that readers will have two options for finding the information.

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.