One needs to tell MySQL what kind of privileges to assign to it. MySQL supports a wide range of privileges. A user can only grant any privilege that they have themselves.
In this article, by Albert Lukaszewski, PhD, author of MySQL for Python, we will cover:
- Granting access in Python
- Removing privileges in MySQL
- Using REVOKE in Python
- Project: Web-based user administration
If you are using Moodle , you are likely to be delivering some form of course content or providing resources to others. This could be for supporting learning, training, or other educational activity. Many online courses, qualifications, or educational resources have a final goal which is likely to include required elements to be completed. The gradebook can be a valuable tool to help the teacher to manage the online course and track the progress of the student through the required elements. This article by Rebecca Barrington, author of Moodle Gradebook will introduce you to the gradebook and the key features it offers. It will outline the benefits of using the gradebook, the activities that can be graded and used within the gradebook, and the types of grades that can be used.Read Gradebook-An Introduction in full
In this article, we will learn about creating the home page of our application. The home page will include a banner at the top, a sidebar for navigation on the left-hand side, another sidebar on the right-hand side for showing dynamic content, a footer to show copyright and other information, and the main content at the center.
In this article by Shamsuddin Ahammad, author of Google Web Toolkit 2 Application Development Cookbook, we will cover:
- Creating the home page layout class
- Adding the banner
- Adding menus
- Creating the left-hand sidebar
- Creating the right-hand sidebar
- Creating the main content panel
- Creating the footer
- Using HomePage instance in EntryPoint
In this article by Hussain Pithawala, author of the book Learning Google Guice we will develop a web application in Java using servlets and JSPs, and will see how Guice makes it simple to wire dependencies and helps to achieve separation of concerns easily. It even provides a programmatic approach to confi gure routing to servlets and JSPs while avoiding declarative approach in web.xml. As part of our learning we will fit flight search functionality in a web application. It is assumed that the reader is familiar with JSP, servlet development, and knows how to deploy a WAR file to a web container. Use of Tomcat to deploy the examples is suggested. We also need an extension of Guice for web development, guice-servlet-3.0. As usual, the dependency for this has been declared in pom.xml and once packaged it would be available in WAR (web application archive) also.Read Google Guice in full
"Google Earth and Google Maps are two applications that allow each of us to assert our own place in the world and contribute our own unique perspective. I can think of no better way to accomplish this than by combining maps and photography."
This tutorial by Rob Reed shows you how to capitalize on the power of these two applications to "pin your photos" and provide an extra context to your memories in the photographs. There are two scripts available for download. They should help you accomplish this goal.Read Google Earth, Google Maps and Your Photos: a Tutorial in full
In this article by Ralph Roberts, author of Google App Inventor will show us how to use networks and the Internet to use the web and exchange data over the Internet. We will explore examples of:
- Browsing and using websites
- Fusion Tables, Google's free online data service
We start with browsing and how you can use the millions of dollars invested in constructing huge websites in your own apps.Read Google Apps: Surfing the Web in full
For GoboLinux, rules are meant to be broken!
There are all sorts of Linux distributions. Yet developers will always find a new reason to work on another one. As a wide-eyed free and open source software buff turned journalist, I've run into distros in many shapes and sizes that run on almost every piece of hardware I own, from a laptop to a gaming device, to a cell phone. GoboLinux is one distro that's fun enough to run once, educational enough to run twice, and useful enough to run as a regular easy to use desktop.Read GoboLinux: An Interview with Lucas Villa Real in full
GnuCash is a personal and small business bookkeeping and accounting software. Designed to be easy to use, yet powerful and flexible, GnuCash allows you to track bank accounts, income, and expenses. As quick and intuitive to use as a checkbook register, it is based on professional accounting principles to ensure balanced books and accurate reports.
In the previous article by Ashok Ramachandran, author of the book Gnucash 2.4 Small Business Accounting: Beginner's Guide, we took a look at why budgets are needed, how to create them, and how to create reports showing budget vs. actual comparison.
In this article we shall cover the following:
- Employees and payroll: GnuCash doesn't have a payroll module. However, we will show how to enter payroll data for employees. We will also cover employee expense voucher processing.
- Depreciation: We will recommend ways of setting up accounts for depreciation and making entries.
- Paying yourself (also known as owner's draw): We will walk through the steps involved in cash withdrawals by the owner.
Octave is an ideal tool to perform many different types of data analysis. The data can be generated by other programs or be collected from a database and then loaded into Octave's workspace. The data analysis tools in Octave are based on a truly impressive arsenal of different functions. In this article by Jesper Schmidt Hansen, author of GNU Octave Beginner's Guide, we will only discuss a few of them here, namely, how to perform the simplest statistical analysis and function fitting.
In brief terms, upon reading this article, you will learn:
- More about the ASCII file formats that can be loaded into Octave's workspace.
- How you can use Octave to perform simple descriptive statistics.
- About fitting different functions to data.
In GLSL, a subroutine is a mechanism for binding a function call to one of a set of possible function definitions based on the value of a variable. Subroutines therefore provide a way to select alternate implementations at runtime without swapping shader programs and/or recompiling, or using if statements along with a uniform variable.
In this article by David Wolff, author of OpenGL 4.0 Shading Language Cookbook, we'll demonstrate the use of subroutines by rendering a teapot twice. The first teapot will be rendered with the full ADS shading model described earlier. The second teapot will be rendered with diffuse shading only. A subroutine uniform will be used to choose between the two shading techniques.Read GLSL 4.0: Using Subroutines to Select Shader Functionality in full
Fragment shaders can make use of the discard keyword to "throw away" fragments. Use of this keyword causes the fragment shader to stop execution, without writing anything (including depth) to the output buffer. This provides a way to create holes in polygons without using blending. In fact, since fragments are completely discarded, there is no dependence on the order in which objects are drawn, saving us the trouble of doing any depth sorting that might have been necessary if blending was used. In this recipe by David Wolff, author of OpenGL 4.0 Shading Language Cookbook, we'll draw a teapot, and use the discard keyword to remove fragments selectively based on texture coordinates.Read GLSL 4.0: Discarding Fragments to Create a Perforated Look in full
This article by Dirk Manuel explains how to build and implement a Glossary.
A Glossary defines terms that are unique to a project or system, or new to your users. A Glossary typically consists of a number of term/description pairs. The added value that UPK provides is that instances of each term in exercises can be hyperlinked to the relevant entries in the Glossary.Read Glossary in UPK 3.5 in full
In this article by Mauricio Salatino, we will cover the main points that you need in order to start working with the jBPM framework.
This article will tackle, in a tutorial fashion, the first steps that you need to know in order to start using the framework with the right foot. We will follow a real example and transform the real situation into requirements for a real jBPM implementation.Read Getting Your Hands Dirty with jPDL: Part 1 in full
In this article by Brandon Ballentine, author of Desire2Learn for Higher Education Cookbook, we will cover the following recipes:
Copying course materials from a previous semester
Importing a publisher's course cartridge
Changing many due dates from one screen
Double-checking everything from the student view
Configuring your web browser
In this article by Douwe Pieter Van Den Bos, we will get ready for our Forms conversion and generation. In this part of our conversion project, we will investigate, analyze, and adjust some of the most important parts of our application. This means that we will set everything up for the generation of the application. We will discuss the following parts of the conversion project in this article:
- Investigating the components that will be generated
- Getting to know the database blocks in our Forms files
- Looking deeper into the block items inside our blocks and editing them
- Enhancing the queries on which our blocks are based
- Analyzing the triggers we have in the Forms XML files
- Massively changing the completeness and applicability of triggers or items
- Customizing the query that the blocks are based on in order to complete our generation
- Understanding the way our pages will be generated in APEX
- Editing the titles of our blocks and items
- Analyzing our business logic (probably the most important part)
There are, several ways to get MySQL for Python in a place such that your local Python installation can use it. Which one you use will depend as much on your familiarity with your operating system and with Python itself, as it will on which operating system and version of Python you are running.
In this article, by Albert Lukaszewski, PhD, author of MySQL for Python, we will cover the following:
- Where you can get MySQL for Python
- Installing MySQL for Python
- Importing the module into your programs
- Accessing online help about the MySQL for Python API and its accompanying modules
- How to connect to a database
- How to create a MySQL cursor proxy within your Python program
- How to close the database connection from Python
- How to access multiple databases within one program
A free and open-source Integrated Development Environment (IDE) for software developers. In this article by Atul Palandurkar, author of Instant NetBeans IDE How-to, you get all the tools you need to create professional applications with the Java platform such as follows :
- Desktop applications,
- Enterprise applications,
- Web applications, and
- Mobile applications,
In this article by Dr. Mark Alexander Bain, we will be dealing with building a Facebook application. However, before we jump into building a Facebook application, we need to spend some time looking at the Facebook platform, and by the end of this article you will:
- Understand what the Facebook Platform is, and how it relates to your application
- Know about the elements that make up the Facebook Platform, and how to test them without having to create an application
- Know how to set up the Facebook Platform, ready for your new application