List of Flask (Web-Framework) Books

0 Comments

Beginning Web Development with Python: from prototype to production with flask, tornado and nginx by Andrei Dan
Building Web Applications with Flask by Italo Maia
Data Visualization with Python and JavaScript: Scrape, Clean, Explore & Transform Your Data by Kyran Dale  
Flask Blueprints by Joel Perras
Flask By Example by Gareth Dwyer
Flask Framework Cookbook by Shalabh Aggarwal
Flask Web Development: Developing Web Applications with Python by Miguel Grinberg
Instant Flask Web Development by Ron DuPlain
Learning Flask Framework by Matt Copperwaite and Charles Leifer
Mastering Flask by Jack Stouffer
Python in 24 Hours,

…

Continue reading “List of Flask (Web-Framework) Books”

How Do You Troubleshoot a Syntax Error When Trying to Create a Table with a Primary Key in SQL?

0 Comments

Problem scenario
You are trying to create a table using SQL.  You use the keywords “CONSTRAINT” and “PRIMARY KEY.”  For example, your query (or SQL DML command) looks like this:

create table contint ( specialcode char(6) CONSTRAINT PRIMARY KEY, title varchar(40)) ;

When you run the SQL command you get the message ‘…syntax error at or near “PRIMARY” LINE…’  What should you do to fix this?

…

Continue reading “How Do You Troubleshoot a Syntax Error When Trying to Create a Table with a Primary Key in SQL?”

How Do You Fix The Ansible Error “Failed to connect to the host via ssh: OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013”?

0 Comments

Problem scenario
You are using Ansible, and you receive an error like this:

coolserver.com | UNREACHABLE! => {
    “changed”: false,
    “msg”: “Failed to connect to the host via ssh: OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013\r\ndebug1: Reading configuration data /etc/ssh/ssh_config\r\ndebug1: /etc/ssh/ssh_config line 56: Applying options for *\r\npercent_expand: unknown key %C\r\n”,
    “unreachable”: true

How do you fix this?

…

Continue reading “How Do You Fix The Ansible Error “Failed to connect to the host via ssh: OpenSSH_6.6.1, OpenSSL 1.0.1e-fips 11 Feb 2013”?”

How Do You Deploy LAPP with Frontend User Authentication?

0 Comments

Problem scenario
You want a web page that asks for a username and password (e.g., to log in).  The users will not know if the authentication is done via Apache or Postgres.  You happen want the authentication to be challenged against a Postgres database.  This way if you have backend access to the Postgres database, you can use “CREATE ROLE” or “CREATE ROLE jane PASSWORD ‘veryfun’ LOGIN” to create users.  

…

Continue reading “How Do You Deploy LAPP with Frontend User Authentication?”

A List of Git Books

0 Comments

19 Git Tips for Everyday Use by Alex Kras
The Beginner’s Guide to GitHub by Thomas Mailund
Building Tools with GitHub: Customize Your Workflow by Chris Dawson and Ben Straub
Distributed Version Control with Git: Mastering the Git Command Line – Third Edition (vogella Series) by Lars Vogel and Alex Blewitt
Dive into GIT by James Ware
Eclipse 4.5 Git Course for Java Eclipse Developers by John R.

…

Continue reading “A List of Git Books”

How Do You Create a Table in a Specific Database Using a SQL Front-End GUI Application?

0 Comments

Problem scenario
You are using a SQL front end to query a Postgres database.  (To view directions for installing a free front-end GUI application, click here.) You have run various commands to prove the connection to the database server works.  

Running this query

select version();

shows

“PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by …”

You have used CREATE DATABASE successfully. 

…

Continue reading “How Do You Create a Table in a Specific Database Using a SQL Front-End GUI Application?”

A List of Apache Tomcat Books

0 Comments

Apache Jakarta-Tomcat by James Goodwill
Apache Tomcat 7 by Aleksa Vukotic and James Goodwill
Apache Tomcat 7 Essentials by Tanuj Khare
Apache Tomcat 7 User Guide by Apache Software Foundation
Apache TomEE Cookbook: Apache TomEE Administrator Cookbook by Mr Gurkan Erdogdu 
Beginning JSP, JSF and Tomcat: Java Web Development (Expert’s Voice in Java) by Giulio Zambon
Connection Pooling in a Java Web Application with Tomcat and NetBeans by Arthur Buliva
Deploying with JRuby 9k: Deliver Scalable Web Apps Using the JVM by Joe Kutner
Developing a Java Web Application in a Day: Step by step explanations with Eclipse Mars,

…

Continue reading “A List of Apache Tomcat Books”

How Do You Troubleshoot the Postgres Message “ERROR: permission denied to create database”?

0 Comments

Problem scenario
From a SQL front end you are connected to a Postgres database as user jdoe.  You try to create a database with the “create database verycool” SQL command.  You get this message: “ERROR: permission denied to create database.”

You try to enter the database from the back end, but you get ‘psql: FATAL: role “root” does not exist.’   Or you may even get the error “psql: FATAL: 

…

Continue reading “How Do You Troubleshoot the Postgres Message “ERROR: permission denied to create database”?”