The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
1answer
39 views

Postgresql tables seem duplicated (with suffixes such us pkey, hashes, etc)

due to some problems I came to check the state of my current database in production and I found that some tables are "duplicated". By duplicated I mean that there appear to be some clones of the ...
1
vote
0answers
11 views

Great slowdown of Django object list retrieval after moving from sqlite3 to mySQL on Amazon RDS

Be warned, there will be some Python programming stuff; my problem is tightly connected to database engine differences though - or at least I think so. tl;dr: Querying for list of items and all ...
0
votes
1answer
47 views

Database in postgresql with missing rows, how to fill the missing rows with a backup copy?

I have a big problem and I'm not that good with postgresql since I use Django to make queries and I only have the basics of sql for querys. My problem is that there was a problem where a super user ...
0
votes
0answers
19 views

Database design for user info [on hold]

I am working on a django app and would love so help on a design issue I cant seem to wrap my head around. Basic Info The landing page of my app will show a table of all registered users which will ...
0
votes
1answer
19 views

Make a boolean false after every n number of minutes in MySQL

I have a table with a boolean value, if that value is not explicitly set to anything in the database for a few minutes by the back-end (django) then it must automatically be set to false. How do I do ...
0
votes
0answers
30 views

MongoDB avoid $sort + $limit optimization

In my Django app using mongoengine I've got such code: art_cursor = Articles.objects.aggregate({'$match': {'ntype': {'$in': [1,6]}}}, {'$group': {'_id': {'title': '$title'}}}, {'$sort': {'_id....
0
votes
0answers
15 views

Django Auth user as well as custom users table?

So we've been using djangos database authentication for a while now and have recently decided we want to implement a completely new login system for our website. We are keeping the django ORM as we ...
0
votes
0answers
45 views

Order by in json field in Postgres and using django

I am using django 1.9 with Postgres 9.3. I am executing a query to search from json data, but the problem I am facing is that I can't use ORDER BY clause if I am using JSON. The json is: { "...