Skip to content

Content Tagged "db"

Page 1 of 1

Content Tagged "db"

Redis on Windows - Save RDB but Not Able to Persist

September 23, 2017Categories: IT, Tutorial
TL;DR : My windows service wasn't installed properly. Change the config file to point the DB to an accessible directory and reinstall the service. When trying to build a perioduc Celery task, I got the following error with Redis on Windows (running as a windows service): redis.exceptions…

Select Rows Where Value from One Column Matches Other Column

November 23, 2016Categories: Software, Tutorial
TL;DR: Use a JOIN . I've got a table representing a tree, using two columns: and I want to select all children for parents whose CLASS_ID have a certain value (e.g. abcd ). The way I could do it was via a JOIN statement: This will: Perform a join where child.parent_prop_id = parent.prop_id…

Change a django password manually

May 4, 2016Category: Software
The other day I've been confronted with a strange situation: I forgot the admin password for a django application. I was playing with installing my own pypi repository, I've configured and deployed a test application and, after a couple of weeks, I forgot the password. I tried several times bu I…

Add Primary Key Column to PostgreSQL Table

March 23, 2015Category: Software
The other day I got a question: How to add a numeric PK column to an already existent table? A quick look on the net showed that it is indeed possible to add an auto-incrementing PK to an already existing table ( if you don't have already a PK that is! ). The code is quite simple too! The statement…

Loading XSDs into Oracle through Python

April 2, 2014Category: Software
Following the previous incursions in Oracle and their own documentation, we decided it was useful to attach schemas to the inserted data, just because only XML with schemas attached can be indexed. When you have some million entries, indexing seems like a good idea (once you decide what to index…

MacPorts Berkley-DB 4 problem and work around

August 15, 2010
I've upgraded my MacPro's hardware a bit the other day and I've noticed that something went bye-bye when running eclipse . Namely eclipse itself wasn't working anymore. So I thought: What a great opportunity to do an update (eclipse, jdk...). And MacPorts . Because I wanted to upgrade my python to…

All tags