Installing requirements.txt

I am new to the Wagtail cms and am taking over a friend's project for his site. I have downloaded his repo and am trying to get it to run locally. I have followed the steps on the wagtail documentation http://docs.wagtail.io/en/v1.12.1/getting_star...
more »

2017-09-18 15:09 (2) Answers

Postgres planner overcounts when joining 18 tables

Postgres Version: PostgreSQL 9.6.4 on x86_64-alpine-linux-musl, compiled by gcc (Alpine 6.3.0) 6.3.0, 64-bit We are having an issue with an INNER JOIN on 1 table with 18 others, and I would to get some pointers on where to look to fix it (we have ha...
more »

2017-09-11 14:09 (0) Answers

Parsing XML document in PostgreSQL using XPATH?

Is there a way to parse the following XML document in PostgreSQL using XPATH to obtain desired output as --Corrected required output promotion-id price new-promotion null new-promotion null new-promotion 300 for the price element. Curre...
more »

2017-09-11 04:09 (1) Answers

Django Migration Is Failing

I have a django/postgresql application. Whenever I run my latest migration, I receive the following error: ValueError: Found wrong number (0) of constraints for package(speciality, title) I believe I need to customize the migration, but what ch...
more »

2017-09-08 17:09 (1) Answers

How Set DateTimeField in django with postgres

i had in model DateTimeField and in postgres display 2017-08-18 00:00:00 i want to change it to 2017-08-18 models.py class sortiestk(models.Model): idsort=models.AutoField(primary_key=True) qtesrt = models.IntegerField(default=0) datesrt=models.Da...
more »

2017-09-06 14:09 (1) Answers

Docker Postgres extension

I'm trying to find documentation on how to add extensions to the official postgres image https://store.docker.com/images/postgres and https://docs.docker.com/engine/examples/postgresql_service/. I know that there is a ton of postgres extensions on Do...
more »

2017-09-04 11:09 (0) Answers

MySQL/PostgreSQL Column Sizes, Why?

I'm developing a program and ran into a bug where inserting a value in a tables column, that has the type int, and the value is larger than Integer.MAX_VALUE it spits out an error saying the number is too large. I read that the fix for this is to qui...
more »

2017-09-02 05:09 (3) Answers

How do I search an id in a string attribute (SQL)

In my chat app I want to calculate the response rate for student model. I track all conversations with a slug attribute. It's a string like this: 270-77, which means that this is a conversation between student 270 and recruiter 77. Now I want to c...
more »

2017-09-01 15:09 (2) Answers

valid UUID is not a valid UUID

I have a really weird problem were I'm getting that a valid UUID is not a valid UUID, for example: 'fd31b6b5-325d-4b65-b496-d7e4d16c8a93' is not a valid UUID. File "/opt/python/run/venv/lib/python3.4/site-packages/django/db/models/fields/__init__.p...
more »

2017-08-31 23:08 (0) Answers

PostgreSQL conditional where clause

In my Ruby on Rails app I'm using blazer(https://github.com/ankane/blazer) and I have the following sql query: SELECT * FROM survey_results sr LEFT JOIN clients c ON c.id = sr.client_id WHERE sr.client_id = {client_id} This query works really well...
more »

2017-08-29 13:08 (1) Answers

Postgres documentation in GNU Info format

Postgres is an open-source project and it has DocBook as default format for its documentation. At a first glance it looks like a tree of *.sgml files in the doc directory inside a repository. There are several pre-defined convertion output formats, ...
more »

2017-08-29 10:08 (1) Answers

How to Append to Array Field in Python Django

I am making an E commerce site, I want to store Cart elements in an integer Array Field. I am using PostGreSql as my database. I have created model for cart by extending Django User model. Here is my models class UserCart(models.Model): user=mod...
more »

2017-08-26 08:08 (2) Answers

Full text search(Postgres) Vs Elastic search

Read Query In Posgres, Full text indexing allows documents to be preprocessed and an index saved for later rapid searching. Preprocessing includes: Parsing documents into tokens. Converting tokens into lexemes. Storing preprocessed documents optim...
more »

2017-08-25 12:08 (1) Answers