MariaDB Essentials

Author: Emilien Kenler,Federico Razzoli

Publisher: Packt Publishing Ltd

ISBN: 178398287X

Category: Computers

Page: 206

View: 8092

DOWNLOAD NOW »

Quickly get up to speed with MariaDB—the leading, drop-in replacement for MySQL, through this practical tutorial About This Book Get to know the basic SQL queries so you can quickly start using MariaDB Take control of your data through the advanced features of MariaDB Exploit the full potential of MariaDB's exclusive features through quick, practical examples Who This Book Is For If you don't know the SQL language, but you want to quickly jump into the SQL world and learn how to use MariaDB, or if you already know how to use MySQL but you want to go further, then this book is ideal for you. What You Will Learn Install and configure MariaDB Create databases, tables, and indexes Import and export data from and to external files Work with views and virtual columns Create, read, update, and delete records in your database Use dynamic columns Set up a powerful full-text search system Access your external data from MariaDB through the CONNECT engine In Detail This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB's advanced features. At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL. Moving on, you'll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you'll get to grips with full-text searches and queries in MariaDb. You'll also be familiarized with the CONNECT storage engine. At the end of the book, you'll be introduced to the community of MariaDB. Style and approach This is a complete guide that uses concrete examples to help you understand and exploit the full potential of MariaDB.
Release

Practical XMPP

Author: Lloyd Watkin,David Koelle

Publisher: Packt Publishing Ltd

ISBN: 1785282093

Category: Computers

Page: 248

View: 8850

DOWNLOAD NOW »

Unleash the power of XMPP in order to build exciting, real-time, federated applications based on open standards in a secure and highly scalable fashion About This Book Learn about the fundamentals of XMPP and be able to work with the core functionality both server-side and in the browser Build a simple 1-to-1 chat (the “Hello World” of XMPP), explore multi-user chat, publish subscribe systems, and work with a decentralized social network Author Lloyd Watkins is a member of the XMPP standards committee Who This Book Is For If you want to learn about the fundamentals of XMPP, be able to work with the core functionality both server-side and in the browser then this book is for you.No knowledge of XMPP is required, or of TCP/IP networking. It's important that you already know how to build applications of some form, and are looking get a better understanding of how to implement XMPP for one or more of its many uses. You should be interested in the decentralized web, know HTML, and likely know JavaScript and NodeJS. You will probably know JSON, and hopefully XML (this is the native output of XMPP). What You Will Learn Install and configure an XMPP server and use it to connect from a traditional desktop client and send a message Build a simple server-side application that will respond to messages from our logged in desktop client Install and run XMPP-FTW, connect to the server from the browser, and handle incoming/outgoing messages Connect to a multi-user chat room, send/receive stanzas, add a room password, join a protected room, set the room's subject, and change a user's affiliation Get to grips with the publish-subscribe extension of XMPP and use it to build a pusher system that can make any website real-time Build a simple XMPP component and create an extension for XMPP-FTW that allows you to use your own custom format Build an XMPP version of the classic game “Pong” In Detail XMPP (eXtensible Messaging and Presence Protocol) is a messaging protocol that enables communication between two or more devices via the Internet. With this book, developers will learn about the fundamentals of XMPP, be able to work with the core functionality both server-side and in the browser, as well as starting to explore several of the protocol extensions. You will not only have a solid grasp of XMPP and how it works, but will also be able to use the protocol to build real-world applications that utilize the power of XMPP. By the end of this book, you will know more about networking applications in general, and have a good understanding of how to extend XMPP, as well as using it in sample applications. Style and approach Through a number of hands-on projects, this book shows you how to build usable applications that highlights a feature of XMPP.
Release

Mastering Redis

Author: Jeremy Nelson

Publisher: Packt Publishing Ltd

ISBN: 1783988193

Category: Computers

Page: 366

View: 5681

DOWNLOAD NOW »

Take your knowledge of Redis to the next level to build enthralling applications with ease About This Book Detailed explanation on Data structure server with powerful strings, lists, sets, sorted-sets, and hashes Learn to Scale your data with Redis Cluster's distributed setup This is a fast paced practical guide full of screenshots and real work examples to help you get to grips with Redis in no time. Who This Book Is For If you are a software developer with some experience with Redis and would now like to elevate your Redis knowledge and skills even further, then this book is for you. What You Will Learn Choose the right Redis data structure for your problem Understand Redis event-loop and implement your own custom C commands Solve complex workflows with Redis server-side scripting with Lua Configure your Redis instance for optimal memory management Scale your data in a distributed manner with Redis Cluster Improve the stability of your Redis solution using Redis Sentinel Complement your existing database and NoSQL environment with Redis Exploit a wide range of features provided by Redis to become a DevOps expert. In Detail Redis is the most popular, open-source, key value data structure server that provides a wide range of capabilities on which multiple platforms can be be built. Its fast and flexible data structures give your existing applications an edge in the development environment. This book is a practical guide which aims to help you deep dive into the world of Redis data structure to exploit its excellent features. We start our journey by understanding the need of Redis in brief, followed by an explanation of Advanced key management. Next, you will learn about design patterns, best practices for using Redis in DevOps environment and Docker containerization paradigm in detail. After this, you will understand the concept of scaling with Redis cluster and Redis Sentinel , followed by a through explanation of incorporating Redis with NoSQL technologies such as Elasticsearch and MongoDB. At the end of this section, you will be able to develop competent applications using these technologies. You will then explore the message queuing and task management features of Redis and will be able to implement them in your applications. Finally, you will learn how Redis can be used to build real-time data analytic dashboards, for different disparate data streams. Style and approach This is a hands on guide full of easy-to-follow examples, that illustrate important concepts and techniques to solve complex problems with Redis.
Release

Learning MySQL and MariaDB

Heading in the Right Direction with MySQL and MariaDB

Author: Russell J.T. Dyer

Publisher: "O'Reilly Media, Inc."

ISBN: 1449362877

Category: Computers

Page: 408

View: 3144

DOWNLOAD NOW »

"With an easy, step-by-step approach, this guide shows beginners how to install, use, and maintain the world's most popular open source database: MySQL. You'll learn through real-world examples and many practical tips, including information on how to improve database performance. Database systems such as MySQL help data handling for organizations large and small handle data, providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. This book is also useful for web developers and programmers interested in adding MySQL to their skill sets. Topics include: Installation and basic administration ; Introduction to databases and SQL ; Functions, subqueries, and other query enhancements ; Improving database performance ; Accessing MySQL from popular languages" --
Release

Mastering MariaDB

Author: Federico Razzoli

Publisher: Packt Publishing Ltd

ISBN: 1783981555

Category: Computers

Page: 384

View: 9945

DOWNLOAD NOW »

This book is intended for intermediate users who want to learn how to administrate a MariaDB server or a set of servers. It is aimed at MariaDB users, and hence working knowledge of MariaDB is a prerequisite.
Release

Mariadb Complete Self-Assessment Guide

Author: Gerardus Blokdyk

Publisher: 5starcooks

ISBN: 9780655320678

Category:

Page: 268

View: 5997

DOWNLOAD NOW »

Is MariaDB Required? What are the expected benefits of MariaDB to the business? Will team members regularly document their MariaDB work? What other organizational variables, such as reward systems or communication systems, affect the performance of this MariaDB process? How will variation in the actual durations of each activity be dealt with to ensure that the expected MariaDB results are met? This valuable MariaDB self-assessment will make you the entrusted MariaDB domain auditor by revealing just what you need to know to be fluent and ready for any MariaDB challenge. How do I reduce the effort in the MariaDB work to be done to get problems solved? How can I ensure that plans of action include every MariaDB task and that every MariaDB outcome is in place? How will I save time investigating strategic and tactical options and ensuring MariaDB costs are low? How can I deliver tailored MariaDB advice instantly with structured going-forward plans? There's no better guide through these mind-expanding questions than acclaimed best-selling author Gerard Blokdyk. Blokdyk ensures all MariaDB essentials are covered, from every angle: the MariaDB self-assessment shows succinctly and clearly that what needs to be clarified to organize the required activities and processes so that MariaDB outcomes are achieved. Contains extensive criteria grounded in past and current successful projects and activities by experienced MariaDB practitioners. Their mastery, combined with the easy elegance of the self-assessment, provides its superior value to you in knowing how to ensure the outcome of any efforts in MariaDB are maximized with professional results. Your purchase includes access details to the MariaDB self-assessment dashboard download which gives you your dynamically prioritized projects-ready tool and shows you exactly what to do next. Your exclusive instant access details can be found in your book. You will receive the following contents with New and Updated specific criteria: - The latest quick edition of the book in PDF - The latest complete edition of the book in PDF, which criteria correspond to the criteria in... - The Self-Assessment Excel Dashboard, and... - Example pre-filled Self-Assessment Excel Dashboard to get familiar with results generation ...plus an extra, special, resource that helps you with project managing. INCLUDES LIFETIME SELF ASSESSMENT UPDATES Every self assessment comes with Lifetime Updates and Lifetime Free Updated Books. Lifetime Updates is an industry-first feature which allows you to receive verified self assessment updates, ensuring you always have the most accurate information at your fingertips.
Release

MariaDB Crash Course

Author: Ben Forta

Publisher: Addison-Wesley Professional

ISBN: 0132842351

Category: Computers

Page: 304

View: 4501

DOWNLOAD NOW »

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control
Release

Building a Web Application with PHP and MariaDB: A Reference Guide

Author: Sai Srinivas Sriparasa

Publisher: Packt Publishing Ltd

ISBN: 1783981636

Category: Computers

Page: 200

View: 1513

DOWNLOAD NOW »

This is a step-by-step, tutorial guide designed to help readers transition from beginners to more experienced developers using clear explanations. The variety of examples will help readers build, secure, and host real-time web applications. If you are a developer who wants to use PHP and MariaDB to build web applications, this book is ideal for you. Beginners can use this book to start with the basics and learn how to build and host web applications. Seasoned PHP Developers can use this book to get familiar with the new features of PHP 5.4 and 5.5, unit testing, caching, security, and performance optimization.
Release

Vagrant Virtual Development Environment Cookbook

Author: Chad Thompson

Publisher: Packt Publishing Ltd

ISBN: 1784391085

Category: Computers

Page: 250

View: 4976

DOWNLOAD NOW »

If you are a software developer or administrator who wishes to create simple, reusable environments using Vagrant, this book is the perfect choice for you. Whether you are a system administrator with extensive experience in virtualization or a developer wishing to create development scripts for cloud deployment, you will find easy-to-follow recipes and techniques in this book that will allow you to create robust and reproducible virtual environments.
Release

LPI Linux Essentials Certification All-in-One Exam Guide

Author: Robb Tracy

Publisher: McGraw Hill Professional

ISBN: 0071811001

Category: Computers

Page: 656

View: 2045

DOWNLOAD NOW »

Complete coverage of the newest exam release from the Linux Professional Institute, and the first step toward LPIC-1 and CompTIA Linux+ Linux Essentials All-in-One Exam Guide covers this "first-of-its-kind" program intended for the academic sector, aspiring IT professionals, and anyone new to the world of Linux and open source technology. This comprehensive, classroom-based reference offers 100% coverage of all exam objectives for the Linux Essentials exam. The book includes expert discussion sidebars to convey in-depth information. Tip, Caution, and Note icons highlight key topics; end-of-chapter quizzes test retention and exam readiness; and Exam Tips guide you through tough technical topics that may be tricky come exam day. The All-in-One also includes hands-on examples and exercises that reinforce practical learning for real-world applicability. Electronic content includes a practice exam (Windows based).
Release