Essential SQLAlchemy


Author: Jason Myers,Rick Copeland
Publisher: "O'Reilly Media, Inc."
ISBN: 1491916567
Category: Computers
Page: 208
View: 2871

Continue Reading →

Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata. SQL is a powerful language for querying and manipulating data, but it’s tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you’re an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference. Essential SQLAlchemy includes several sections: SQLAlchemy Core: Provide database services to your applications in a Pythonic way with the SQL Expression Language SQLAlchemy ORM: Use the object relational mapper to bind database schema and operations to data objects in your application Alembic: Use this lightweight database migration tool to handle changes to the database as your application evolves Cookbook: Learn how to use SQLAlchemy with web frameworks like Flask and libraries like SQLAcodegen

Flask Web Development

Developing Web Applications with Python
Author: Miguel Grinberg
Publisher: "O'Reilly Media, Inc."
ISBN: 1491991690
Category: Computers
Page: 316
View: 5511

Continue Reading →

Take full creative control of your web applications with Flask, the Python-based microframework. With the second edition of this hands-on book, you’ll learn the framework from the ground up by developing, step-by-step, a real-world project created by author Miguel Grinberg. This refreshed edition accounts for important technology changes that have occurred in the past three years. You’ll learn the framework’s core functionality, as well as how to extend applications with advanced web techniques such as database migration and web service communication. The first part of each chapter provides you with reference and background for the topic in question, while the second part guides you though a hands-on implementation of the topic. If you have Python experience, this book shows you how to take advantage of the creative freedom Flask provides.

SQLAlchemy

Database Access Using Python
Author: Mark Ramm,Michael Bayer
Publisher: Addison-Wesley Professional
ISBN: 9780132364676
Category: Computers
Page: 504
View: 6812

Continue Reading →

This book delivers insider knowledge of the entire SQLAlchemy feature set. Basic to advanced topics are covered.

Python Requests Essentials


Author: Rakesh Vidya Chandra,Bala Subrahmanyam Varanasi
Publisher: Packt Publishing Ltd
ISBN: 1784392316
Category: Computers
Page: 134
View: 7555

Continue Reading →

Python is one of the most popular programming languages of our era; the Python Requests library is one of the world's best clients, with the highest number of downloads. It allows hassle-free interactions with web applications using simple procedures. You will be shown how to mock HTTP Requests using HTTPretty, and will learn to interact with social media using Requests. This book will help you to grasp the art of web scraping with the BeautifulSoup and Python Requests libraries, and will then paddle you through Requests impressive ability to interact with APIs. It will empower you with the best practices for seamlessly drawing data from web apps. Last but not least, you will get the chance to polish your skills by implementing a RESTful Web API with Python and Flask!

Mastering Flask


Author: Jack Stouffer
Publisher: Packt Publishing Ltd
ISBN: 1784391921
Category: Computers
Page: 288
View: 9094

Continue Reading →

Gain expertise in Flask to create dynamic and powerful web applications About This Book Work with scalable Flask application structures to create complex web apps Discover the most powerful Flask extensions and learn how to create one Deploy your application to real-world platforms using this step-by-step guide Who This Book Is For If you are a Flask user who knows the basics of the library and how to create basic web pages with HTML and CSS, and you want to take your applications to the next level, this is the book for you. Harnessing the full power of Flask will allow you to create complex web applications with ease. What You Will Learn Set up a best practices Python environment Use SQLAlchemy to programmatically query a database Develop templates in Jinja Set up an MVC environment for Flask Discover NoSQL, when to use it, when not to, and how to use it Develop a custom Flask extension Use Celery to create asynchronous tasks In Detail Flask is a library that allows programmers to create web applications in Python. Flask is a micro-framework that boasts a low learning curve, a large community, and the power to create complex web apps. However, Flask is easy to learn but difficult to master. Starting from a simple Flask app, this book will walk through advanced topics while providing practical examples of the lessons learned. After building a simple Flask app, a proper app structure is demonstrated by transforming the app to use a Model-View-Controller (MVC) architecture. With a scalable structure in hand, the next chapters use Flask extensions to provide extra functionality to the app, including user login and registration, NoSQL querying, a REST API, an admin interface, and more. Next, you'll discover how to use unit testing to take the guesswork away from making sure the code is performing as it should. The book closes with a discussion of the different platforms that are available to deploy a Flask app on, the pros and cons of each one, and how to deploy on each one. Style and approach With plenty of useful examples, this guide introduces new concepts and then shows you how those concepts can be used in a real-world environment. Most sections are based around a single example app that is developed throughout the book.

Flask By Example


Author: Gareth Dwyer
Publisher: Packt Publishing Ltd
ISBN: 1785283480
Category: Computers
Page: 276
View: 8452

Continue Reading →

Unleash the full potential of the Flask web framework by creating simple yet powerful web applications About This Book The most up-to-date book on Flask on the market Create your own world-class applications and master the art of Flask by unravelling its enigma through this journey This step-by-step tutorial is packed with examples on blending different technologies with Flask to get you up and running Who This Book Is For Have you looked at PHP and hated the clunky bloated syntax? Or looked at .Net and wished it was more open and flexible? Maybe you've tried your hand at GUI libraries in Python and found them hard to use? If your answer to any one of these questions is a yes, then this is just the book for you. It is also intended for people who know the basics of Python and want to learn how to use it to build powerful solutions with a web front-end. What You Will Learn Build three web applications from the ground up using the powerful Python micro framework, Flask. Dynamically display data to your viewers, based on their requests Store user and static data in SQL and NoSQL databases and use this data to power your web applications Create a good user experience by combining HTML, CSS, and JavaScript Harness the convenience of freely available APIs, including OpenWeatherMap, Open Exchange Rates, and bitly Extend your applications to build advanced functionality, such as a user account control system using Flask-Login Learn about web application security and defend against common attacks, such as SQL injection and XSS In Detail This book will take you on a journey from learning about web development using Flask to building fully functional web applications. In the first major project, we develop a dynamic Headlines application that displays the latest news headlines along with up-to-date currency and weather information. In project two, we build a Crime Map application that is backed by a MySQL database, allowing users to submit information on and the location of crimes in order to plot danger zones and other crime trends within an area. In the final project, we combine Flask with more modern technologies, such as Twitter's Bootstrap and the NoSQL database MongoDB, to create a Waiter Caller application that allows restaurant patrons to easily call a waiter to their table. This pragmatic tutorial will keep you engaged as you learn the crux of Flask by working on challenging real-world applications. Style and approach This book will provide you with rich, practical experience of Flask. Every technology, that is employed along with Flask is comprehensively introduced, while the book focusses on developing web applications. Pointers to educational material are always given if you want to gain in-depth knowledge of the various technologies used.

Flask Framework Cookbook


Author: Shalabh Aggarwal
Publisher: Packt Publishing Ltd
ISBN: 1783983418
Category: Computers
Page: 258
View: 662

Continue Reading →

If you are a web developer who wants to learn more about developing applications in Flask and scale them with industry-standard practices, this is the book for you. This book will also act as a handy tool if you are aware of Flask's major extensions and want to make the best use of them. It is assumed that you have knowledge of Python and a basic understanding of Flask. If you are completely new to Flask, reading the book from the first chapter and going forward will help in getting acquainted with Flask as you go ahead.

PySide GUI Application Development


Author: Gopinath Jaganmohan,Venkateshwaran Loganathan
Publisher: Packt Publishing Ltd
ISBN: 1785280368
Category: Computers
Page: 144
View: 7324

Continue Reading →

Develop more dynamic and robust GUI applications using PySide, an open source cross-platform UI framework About This Book Designed for beginners to help you get started with GUI application development Develop your own applications by creating customized widgets and dialogs Written in a simple and elegant structure so you easily understand how to program various GUI components Who This Book Is For This book is written for Python programmers who want to learn about GUI programming. It is also suitable for those who are new to Python but are familiar with object-oriented programming. What You Will Learn Program GUI applications in an easy and efficient way Download and install PySide, a cross-platform GUI development toolkit for Python Create menus, toolbars, status bars, and child windows Develop a text editor application on your own Connect your GUI to a database and manage it Execute SQL queries by handling databases In Detail Elegantly-built GUI applications are always a massive hit among users. PySide is an open source software project that provides Python bindings for the Qt cross-platform UI framework. Combining the power of Qt and Python, PySide provides easy access to the Qt framework for Python developers and also acts as an excellent rapid application development platform. This book will take you through everything you need to know to develop UI applications. You will learn about installing and building PySide in various major operating systems as well as the basics of GUI programming. The book will then move on to discuss event management, signals and slots, and the widgets and dialogs available with PySide. Database interaction and manipulation is also covered. By the end of this book, you will be able to program GUI applications efficiently and master how to develop your own applications and how to run them across platforms. Style and approach This is an accessible and practical guide to developing GUIs for Python applications.

Python Cookbook


Author: Alex Martelli,Anna Ravenscroft,David Ascher
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596554743
Category: Computers
Page: 846
View: 8380

Continue Reading →

Portable, powerful, and a breeze to use, Python is the popular open source object-oriented programming language used for both standalone programs and scripting applications. It is now being used by an increasing number of major organizations, including NASA and Google.Updated for Python 2.4, The Python Cookbook, 2nd Edition offers a wealth of useful code for all Python programmers, not just advanced practitioners. Like its predecessor, the new edition provides solutions to problems that Python programmers face everyday.It now includes over 200 recipes that range from simple tasks, such as working with dictionaries and list comprehensions, to complex tasks, such as monitoring a network and building a templating system. This revised version also includes new chapters on topics such as time, money, and metaprogramming.Here's a list of additional topics covered: Manipulating text Searching and sorting Working with files and the filesystem Object-oriented programming Dealing with threads and processes System administration Interacting with databases Creating user interfaces Network and web programming Processing XML Distributed programming Debugging and testing Another advantage of The Python Cookbook, 2nd Edition is its trio of authors--three well-known Python programming experts, who are highly visible on email lists and in newsgroups, and speak often at Python conferences.With scores of practical examples and pertinent background information, The Python Cookbook, 2nd Edition is the one source you need if you're looking to build efficient, flexible, scalable, and well-integrated systems.

Introduction to Tornado

Modern Web Applications with Python
Author: Michael Dory,Allison Parrish,Brendan Berg
Publisher: "O'Reilly Media, Inc."
ISBN: 1449333974
Category: Computers
Page: 138
View: 9193

Continue Reading →

Walk through the basics of Tornado, the high-performance web server known for its speed, simplicity, and scalability on projects large and small. With this hands-on guide, you’ll learn how to use Tornado’s acclaimed features by working with several example applications. You also get best practices for using Tornado in the real world. Are you interested in creating a scalable social application, real-time analytics engine, or RESTful API—all with the power and simplicity of Python? This book shows you why Tornado is fantastic choice for writing powerful applications that are simple to create, extend, and deploy. Learn how to use Tornado’s lightweight and flexible templating language Extend templates to repurpose headers, footers, layout grids, and other content Use persistent storage like MongoDB to store, serve, and edit dynamic content Explore Tornado’s ability to make asynchronous web requests Secure your application against cookie and request vulnerabilities Authenticate with external services, using Tornado’s auth module Adopt deployment strategies that help harden your application and increase request throughput

CherryPy Essentials

Rapid Python Web Application Development : Design, Develop, Test, and Deploy Your Python Web Applications Easily
Author: Sylvain Hellegouarch
Publisher: Packt Pub Limited
ISBN: 9781904811848
Category: Computers
Page: 257
View: 7062

Continue Reading →

This book covers the CherryPy library for Python web development from its history and installation through its main features and core concepts to its integration with Python and other products to construct, test, and deploy a sample photoblog application. The author Sylvain Hellegouarch is dedicated to the development of free software projects and has been coordinating and administrating the community efforts around the CherryPy project since 2004. The approach based on an example application introduces many other common Python libraries, providing transferable skills also relevant for non-web Python projects. CherryPy is a Python library for web development that allows developers to build web applications in the same way as any other object-oriented Python program. Enriched by several years of active development, it has become one of the most established toolkits for building solid and high-performance web applications in Python. CherryPy abstracts the complex low-level HTTP protocol into an easy-to-use interface that respects Python idioms. The library aims at being simple to learn for a beginner while offering the most advanced features to fluent Python developers. For these reasons CherryPy was chosen to be at the heart of the popular and feature-rich TurboGears web framework. CherryPy-powered web applications are stand-alone Python applications with their own embedded multi-threaded web server, but can also run behind Apache or IIS for scalability. .CherryPy installation using tarball, egg, and subversion .The CherryPy library in depth: its design and how to use it .Using CherryPy with common Python and non-Python products .Object Relational Mapping with SQLObject, SQLAlchemy, and Dejavu .Web Services via REST and the Atom Publishing Protocol .AJAX and client-side scripting via MochiKit .Unit, functional, and load testing .CherryPy, Apache, and lighttpd deployment solurions The book starts with two chapters dedicated to CherryPy itself, its history and installation. Then it moves through a gentle introduction to the main features and concepts of CherryPy to a thorough review of its core capabilities. After laying this foundation the book dives into a real-world example, detailing important steps in the creation of a photoblog application. These chapters cover database manipulation via Object Relational Mapping (ORM), using web services to enhance the application, and client-side scripting through AJAX. Finally, the book covers the need for unit, functional, and performance testing before closing with deployment solutions for a CherryPy-based application. Who this book is written for This book is principally geared towards Python web developers, who are looking to add the power of the CherryPy library to their existing Python skillset. It assumes a good working knowledge of Python . Although the CherryPy toolkit is at the core of the book, many other common libraries are introduced. TABLE OF CONTENTS SUMMARY 1.Introduction to CherryPy 2.Download and Install CherryPy 3.Overview of CherryPy 4.CherryPy in depth 5.A photoblog application 6.Web Services 7.The presentation layer 8.Ajax 9.Testing 10.Deployment

Qt5 Python GUI Programming Cookbook

Building responsive and powerful cross-platform applications with PyQt
Author: B.M. Harwani
Publisher: Packt Publishing Ltd
ISBN: 1788830466
Category: Computers
Page: 462
View: 4687

Continue Reading →

Over 60 recipes to help you design interactive, smart, and cross-platform GUI applications Key Features Get succinct QT solutions to pressing GUI programming problems in Python Learn how to effectively implement reactive programming Build customized applications that are robust and reliable Book Description PyQt is one of the best cross-platform interface toolkits currently available; it's stable, mature, and completely native. If you want control over all aspects of UI elements, PyQt is what you need. This book will guide you through every concept necessary to create fully functional GUI applications using PyQt, with only a few lines of code. As you expand your GUI using more widgets, you will cover networks, databases, and graphical libraries that greatly enhance its functionality. Next, the book guides you in using Qt Designer to design user interfaces and implementing and testing dialogs, events, the clipboard, and drag and drop functionality to customize your GUI. You will learn a variety of topics, such as look and feel customization, GUI animation, graphics rendering, implementing Google Maps, and more. Lastly, the book takes you through how Qt5 can help you to create cross-platform apps that are compatible with Android and iOS. You will be able to develop functional and appealing software using PyQt through interesting and fun recipes that will expand your knowledge of GUIs What you will learn Use basic Qt components, such as a radio button, combo box, and sliders Use QSpinBox and sliders to handle different signals generated on mouse clicks Work with different Qt layouts to meet user interface requirements Create custom widgets and set up customizations in your GUI Perform asynchronous I/O operations and thread handling in the Python GUI Employ network concepts, internet browsing, and Google Maps in UI Use graphics rendering and implement animation in your GUI Make your GUI application compatible with Android and iOS devices Who this book is for If you’re an intermediate Python programmer wishing to enhance your coding skills by writing powerful GUIs in Python using PyQT, this is the book for you.

Building RESTful Python Web Services


Author: Gaston C. Hillar
Publisher: Packt Publishing Ltd
ISBN: 178646425X
Category: Computers
Page: 418
View: 6161

Continue Reading →

Create web services that are lightweight, maintainable, scalable, and secure using the best tools and techniques designed for Python About This Book Develop RESTful Web Services using the most popular frameworks in Python Configure and fine-tune your APIs using the best tools and techniques available This practical guide will help you to implement complete REST-based APIs from scratch Who This Book Is For This book is for web developers who have working knowledge of Python and would like to build amazing web services by taking advantage of the various frameworks of Python. You should have some knowledge of RESTful APIs. What You Will Learn Develop complex RESTful APIs from scratch with Python combined with and without data sources Choose the most appropriate (micro) framework based on the specific requirements of a RESTful API / web service Debug, test, and profile RESTful APIs with each of the frameworks Develop a complex RESTful API that interacts with a PostgreSQL database Add authentication and permissions to a RESTful API built in each of the frameworks Map URL patterns to request handlers and check how the API works Profile an existing API and refactor it to take advantage of asynchronous code In Detail Python is the language of choice for millions of developers worldwide, due to its gentle learning curve as well as its vast applications in day-to-day programming. It serves the purpose of building great web services in the RESTful architecture. This book will show you the best tools you can use to build your own web services. Learn how to develop RESTful APIs using the popular Python frameworks and all the necessary stacks with Python, Django, Flask, and Tornado, combined with related libraries and tools. We will dive deep into each of these frameworks to build various web services, and will provide use cases and best practices on when to use a particular framework to get the best results. We will show you everything required to successfully develop RESTful APIs with the four frameworks such as request handling, URL mapping, serialization, validation, authentication, authorization, versioning, ORMs, databases, custom code for models and views, and asynchronous callbacks. At the end of each framework, we will add authentication and security to the RESTful APIs and prepare tests for it. By the end of the book, you will have a deep understanding of the stacks needed to build RESTful web services. Style and approach The book takes a straightforward approach, not spending time getting you started with RESTful APIs and web services. It will give you the best use cases for each framework to build great web services in Python.

Rapid Web Applications with TurboGears


Author: Mark Ramm,Kevin Dangoor,Gigi Sayfan
Publisher: Pearson Education
ISBN: 0132703084
Category: Computers
Page: 512
View: 6760

Continue Reading →

Master TurboGears: The Easy Python Framework for Rapid Web Development TurboGears harnesses the power of Python to provide a dynamic and easy-to-use Web development framework: one that dramatically increases developer productivity, and makes it far easier to create dynamic, user-friendly, Ajax-enabled Web applications. Now, for the first time, there’s a definitive guide to TurboGears–coauthored by its creator, Kevin Dangoor. This book will help experienced Web developers get productive with TurboGears–fast. You’ll quickly build your first TurboGears Web application–then extend it one step at a time, mastering the underlying libraries that make these enhancements possible. Next, the authors demonstrate TurboGears at work in a real-world application, by examining the code for “WhatWhat Status,” an open source project status tracking application. Finally, you’ll gain deep insight into the model, view, and controller technologies TurboGears is built upon: knowledge that will help you build far more robust and capable Python applications. Coverage includes Understanding the architecture of a TurboGears application Mastering SQLObject, customizing it, and using it with TurboGears models Utilizing TurboGears view technologies, including dynamic templates and MochiKit for Ajax Bringing CSS, XHTML, and JavaScript together in reusable components with TurboGears Widgets Using CherryPy and TurboGears controller technologies: from decorators to deployment Exploring the TurboGears toolbox Ensuring security and managing user access permissions in TurboGears applications

Python Unit Test Automation

Practical Techniques for Python Developers and Testers
Author: Ashwin Pajankar
Publisher: Apress
ISBN: 1484226771
Category: Computers
Page: 111
View: 912

Continue Reading →

Quickly learn how to automate unit testing of Python 3 code with Python 3 automation libraries, such as doctest, unittest, nose, nose2, and pytest. This book explores the important concepts in software testing and their implementation in Python 3 and shows you how to automate, organize, and execute unit tests for this language. This knowledge is often acquired by reading source code, manuals, and posting questions on community forums, which tends to be a slow and painful process. Python Unit Test Automation will allow you to quickly ramp up your understanding of unit test libraries for Python 3 through the practical use of code examples and exercises. All of which makes this book a great resource for software developers and testers who want to get started with unit test automation in Python 3 and compare the differences with Python 2. This short work is your must-have quick start guide to mastering the essential concepts of software testing in Python. What You'll Learn: Essential concepts in software testing Various test automation libraries for Python, such as doctest, unittest, nose, nose2, and pytest Test-driven development and best practices for test automation in Python Code examples and exercises Who This Book Is For: Python developers, software testers, open source enthusiasts, and contributors to the Python community

Test-Driven Development with Python

Obey the Testing Goat: Using Django, Selenium, and JavaScript
Author: Harry J.W. Percival
Publisher: "O'Reilly Media, Inc."
ISBN: 1491958650
Category: Computers
Page: 624
View: 8716

Continue Reading →

By taking you through the development of a real web application from beginning to end, the second edition of this hands-on guide demonstrates the practical advantages of test-driven development (TDD) with Python. You’ll learn how to write and run tests before building each part of your app, and then develop the minimum amount of code required to pass those tests. The result? Clean code that works. In the process, you’ll learn the basics of Django, Selenium, Git, jQuery, and Mock, along with current web development techniques. If you’re ready to take your Python skills to the next level, this book—updated for Python 3.6—clearly demonstrates how TDD encourages simple designs and inspires confidence. Dive into the TDD workflow, including the unit test/code cycle and refactoring Use unit tests for classes and functions, and functional tests for user interactions within the browser Learn when and how to use mock objects, and the pros and cons of isolated vs. integrated tests Test and automate your deployments with a staging server Apply tests to the third-party plugins you integrate into your site Run tests automatically by using a Continuous Integration environment Use TDD to build a REST API with a front-end Ajax interface

Mastering Python High Performance


Author: Fernando Doglio
Publisher: Packt Publishing Ltd
ISBN: 1783989319
Category: Computers
Page: 260
View: 5578

Continue Reading →

Measure, optimize, and improve the performance of your Python code with this easy-to-follow guide About This Book Master the do's and don'ts of Python performance programming Learn how to use exiting new tools that will help you improve your scripts A step-by-step, conceptual guide to teach you how to optimize and fine-tune your critical pieces of code Who This Book Is For If you're a Python developer looking to improve the speed of your scripts or simply wanting to take your skills to the next level, then this book is perfect for you. What You Will Learn Master code optimization step-by-step and learn how to use different tools Understand what a profiler is and how to read its output Interpret visual output from profiling tools and improve the performance of your script Use Cython to create fast applications using Python and C Take advantage of PyPy to improve performance of Python code Optimize number-crunching code with NumPy, Numba, Parakeet, and Pandas In Detail Simply knowing how to code is not enough; on mission-critical pieces of code, every bit of memory and every CPU cycle counts, and knowing how to squish every bit of processing power out of your code is a crucial and sought-after skill. Nowadays, Python is used for many scientific projects, and sometimes the calculations done in those projects require some serious fine-tuning. Profilers are tools designed to help you measure the performance of your code and help you during the optimization process, so knowing how to use them and read their output is very handy. This book starts from the basics and progressively moves on to more advanced topics. You'll learn everything from profiling all the way up to writing a real-life application and applying a full set of tools designed to improve it in different ways. In the middle, you'll stop to learn about the major profilers used in Python and about some graphic tools to help you make sense of their output. You'll then move from generic optimization techniques onto Python-specific ones, going over the main constructs of the language that will help you improve your speed without much of a change. Finally, the book covers some number-crunching-specific libraries and how to use them properly to get the best speed out of them. After reading this book, you will know how to take any Python code, profile it, find out where the bottlenecks are, and apply different techniques to remove them. Style and approach This easy-to-follow, practical guide will help you enhance your optimization skills by improving real-world code.

MongoDB Applied Design Patterns

Practical Use Cases with the Leading NoSQL Database
Author: Rick Copeland
Publisher: "O'Reilly Media, Inc."
ISBN: 1449340075
Category: Computers
Page: 176
View: 3257

Continue Reading →

Whether you’re building a social media site or an internal-use enterprise application, this hands-on guide shows you the connection between MongoDB and the business problems it’s designed to solve. You’ll learn how to apply MongoDB design patterns to several challenging domains, such as ecommerce, content management, and online gaming. Using Python and JavaScript code examples, you’ll discover how MongoDB lets you scale your data model while simplifying the development process. Many businesses launch NoSQL databases without understanding the techniques for using their features most effectively. This book demonstrates the benefits of document embedding, polymorphic schemas, and other MongoDB patterns for tackling specific big data use cases, including: Operational intelligence: Perform real-time analytics of business data Ecommerce: Use MongoDB as a product catalog master or inventory management system Content management: Learn methods for storing content nodes, binary assets, and discussions Online advertising networks: Apply techniques for frequency capping ad impressions, and keyword targeting and bidding Social networking: Learn how to store a complex social graph, modeled after Google+ Online gaming: Provide concurrent access to character and world data for a multiplayer role-playing game

Learning PostgreSQL 10 - Second Edition


Author: Salahaldin Juba,Andrey Volkov
Publisher: N.A
ISBN: 9781788392013
Category: Database management
Page: 488
View: 5699

Continue Reading →

Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications.About This Book* Be introduced to the concept of relational databases and PostgreSQL, one of the fastest growing open source databases in the world* Learn client-side and server-side programming in PostgreSQL, and how to administer PostgreSQL databases* Discover tips on implementing efficient database solutions with PostgreSQL 10Who This Book Is ForIf you're interested in learning more about PostgreSQL - one of the most popular relational databases in the world, then this book is for you. Those looking to build solid database or data warehousing applications with PostgreSQL 10 will also find this book a useful resource. No prior knowledge of database programming or administration is required to get started with this book.What You Will Learn* Understand the fundamentals of relational databases, relational algebra, and data modeling* Install a PostgreSQL cluster, create a database, and implement your data model* Create tables and views, define indexes, and implement triggers, stored procedures, and other schema objects* Use the Structured Query Language (SQL) to manipulate data in the database* Implement business logic on the server side with triggers and stored procedures using PL/pgSQL* Make use of advanced data types supported by PostgreSQL 10: Arrays, hstore, JSONB, and others* Develop OLAP database solutions using the most recent features of PostgreSQL 10* Connect your Python applications to a PostgreSQL database and work with the data efficiently* Test your database code, find bottlenecks, improve performance, and enhance the reliability of the database applicationsIn DetailPostgreSQL is one of the most popular open source databases in the world, and supports the most advanced features included in SQL standards and beyond. This book will familiarize you with the latest new features released in PostgreSQL 10, and get you up and running with building efficient PostgreSQL database solutions from scratch.We'll start with the concepts of relational databases and their core principles. Then you'll get a thorough introduction to PostgreSQL and the new features introduced in PostgreSQL 10. We'll cover the Data Definition Language (DDL) with an emphasis on PostgreSQL, and the common DDL commands supported by ANSI SQL. You'll learn to create tables, define integrity constraints, build indexes, and set up views and other schema objects.Moving on, you'll get to know the concepts of Data Manipulation Language (DML) and PostgreSQL server-side programming capabilities using PL/pgSQL. This will give you a very robust background to develop, tune, test, and troubleshoot your database application. We'll also explore the NoSQL capabilities of PostgreSQL and connect to your PostgreSQL database to manipulate data objects.By the end of this book, you'll have a thorough understanding of the basics of PostgreSQL 10 and will have the necessary skills to build efficient database solutions.Style and approachThis book is a comprehensive beginner level tutorial on PostgreSQL and introduces the features of the newest version 10, along with explanation of concepts in a very easy to understand manner. Practical tips and examples are provided at every step to ensure you are able to grasp each topic as quickly as possible.

Fluent Python

Clear, Concise, and Effective Programming
Author: Luciano Ramalho
Publisher: "O'Reilly Media, Inc."
ISBN: 1491946253
Category: Computers
Page: 792
View: 9997

Continue Reading →

Python’s simplicity lets you become productive quickly, but this often means you aren’t using everything it has to offer. With this hands-on guide, you’ll learn how to write effective, idiomatic Python code by leveraging its best—and possibly most neglected—features. Author Luciano Ramalho takes you through Python’s core language features and libraries, and shows you how to make your code shorter, faster, and more readable at the same time. Many experienced programmers try to bend Python to fit patterns they learned from other languages, and never discover Python features outside of their experience. With this book, those Python programmers will thoroughly learn how to become proficient in Python 3. This book covers: Python data model: understand how special methods are the key to the consistent behavior of objects Data structures: take full advantage of built-in types, and understand the text vs bytes duality in the Unicode age Functions as objects: view Python functions as first-class objects, and understand how this affects popular design patterns Object-oriented idioms: build classes by learning about references, mutability, interfaces, operator overloading, and multiple inheritance Control flow: leverage context managers, generators, coroutines, and concurrency with the concurrent.futures and asyncio packages Metaprogramming: understand how properties, attribute descriptors, class decorators, and metaclasses work