practical-sql

practical-sql copied to clipboard

Over time, various distributions of PostgreSQL have modified the steps for installing PL/Python support. This issue will track updates (which are reflected in the [2nd Edition of Practical SQL](https://nostarch.com/practical-sql-2nd-edition/)). ###...

anthonydb

Chapter 15: Python program keeps closing database connection

3

Having trouble with data, code, or exercises in Practical SQL, 1st Edition? I'm glad to help. Please answer these questions, and I'll typically reply within one to two business days....

robml

Error in executing factorial part of listing 5-3

1

Having trouble with data, code, or exercises in Practical SQL? I'm glad to help. Please answer these questions, and I'll typically reply within one to two business days. Please include...

aman-313

"Chapter 4: COPY us_counties_2010 Permission Denied Question"

2

Having trouble with data, code, or exercises in Practical SQL? I'm glad to help. Please answer these questions, and I'll typically reply within one to two business days. Please include...

gobinaryn

Windows File/Folder Permissions for COPY

3

If you're a Windows 10 user, you may need to set permissions for the folder holding the code and data for the book. If you don't, you may see an...

anthonydb

CH 4 Try it Yourself #2

1

Hi! For #2 Try it yourself example in Chapter 4, what would be the statement to file the 20 counties in the United States that have the most housing units....

emiliemercier

Chapter 13 tsvector

5

Hi, I'm working on Win 10 I've installed PosgreSQL as described in book I'm using version 4.28 Yes, I did download it from GitHub When Running Listing 13-15 on page...

MatMel16

Chapter 4 csv usa_counties2010.csv

3

Having trouble with data, code, or exercises in Practical SQL? I'm glad to help. Please answer these questions, and I'll typically reply within one to two business days. Please include...

ki4111

Reference URL of page 256 is not working

1

Hi Just found that reference UR of page-256 (http://workshops.boundlessgeo.com/postgis-intro/knn.html) is not working with '403 Forbidden' and "Code: Access Denied' Seems this page turned to a part of a charged course...

bennybhlin

Regex match to newline characters on windows10

2

Hi Anthony, Thank you for the wonderful book. I'm working through Ch. 13 on regular expressions on Windows10 using postgreSQL10 in pgAdmin4 I was having trouble getting the regular expressions...

ChandlerLutz